If you worked with Sitecore Analytics before, you must have come across Top downloads report under behavior tab, this report shows the assets that your contacts have downloaded the most from your website. but sometimes you may get a request from your client to get more information and control over this report, like as example, sort, filter, or maybe show all assets not only the top ones. In this case you would need to go with a custom approach, either built a custom analytics report or why not to export the report into a CSV and give your client a full control over it. In this post, I'll walk you through a step by step approach to pull these information from Analytics database into a csv format. excited?! keep reading!
Insights, Features, Solutions, and Tips for Sitecore Enthusiasts!
Showing posts with label Sitecore Analytics. Show all posts
Showing posts with label Sitecore Analytics. Show all posts
Thursday, 15 July 2021
Monday, 1 January 2018
Sitecore Experience Profile And The “Anonymous” Records Problem - Part 1
In a recent
project I worked on a question came from client is why we see “Anonymous”
records when we open experience profile from the launch pad? So, I started to
dig into this and I found a lot of useful information, none of them was a
complete solution to my problem, so after completing this I thought I should share
a full package that contains the problem and the solution.
Tuesday, 1 August 2017
Sitecore Experience Analytics - A Deep Dive To Sub-sites Filter
If you ever checked Sitecore experience analytics reports you will definitely notice the all sites filter on the top right corner of the screen? do you ever though how this filter pull items? or how you can control the items "sub-sites" that appear in this filter? In this blog post I will share with you my experience with this filter.
Sunday, 16 July 2017
Saturday, 29 April 2017
Building Custom Analytics Report – Part5 – Experience Analytics custom Filter
In previous posts in this series we discussed the business needs for
custom analytics report, I explained how to collect data, how to save them and
how to aggregate the data into reporting databases and how you can display them
as a SPEAK report, in this part I will show you how you can create new filter in
other words how you can extend the current existing filters.
Wednesday, 1 March 2017
Building Custom Analytics Report – Part 4 – Experience Analytics New Menu.
In
previous posts in this series we discussed the business needs for custom
analytics report, I explained how to collect data, how to save them and how to aggregate
the data into reporting databases and how you can display them as a SPEAK
report, in this part I will show you how you can add the created report as one
of the reports in the experience analytics.
Thursday, 16 February 2017
Build Custom Analytics Report - Part 2 – Storing and Retrieving Data
In part
1 of this blog posts series I discussed the business needs for building a
custom analytics report, In this part I will show you how you can save your
analytics data to MongoDB using the analytics tracker, then how you can
aggregate this data into reporting SQL server database, in future blogs posts
will show you how we can build SPEAK application to display the data and how
you can extend the analytics filters based on your report needs
Monday, 30 January 2017
Building Custom Analytics Report – Part1 – Introduction
In this
blog series will show you how you can build a custom analytics report from A to
Z, I will start by explaining business needs for the report then I will discuss
how you can store data, how you can retrieve the data, how you can display the
data and how you can add this report to the collection of sitecore experience
analytics report and finally how you can extend the default sitecore analytics
filters.






