

Jun 11, 2019
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Jun 11, 2019
I was recently given the task of digging into Sitecore Experience Analytics. After spending some time working on it, I found myself needing to create my own report. The documentation outlines how to create a report from scratch, but I had a few challenges while following it. I hope that sharing my experience can help others trying to customize their Sitecore reporting.
You must use Visual Studio and Sitecore Rocks to create a new report, so that was my first stop. Installing the tool was fairly easy. Just a note: make sure you choose the "Hard Rock Web Service" as Data Provider while configuring your connection. The Good Old Web Service, although "good", only shows raw values :) .
Sitecore Rocks Connection
So, you have installed Sitecore Rocks and successfully connected to your site. That means you are ready to follow Sitecore's user guide to create a new report.
In my particular case, I intend to add a new report to the Dashboard to track offline interactions. This report will help me visualize how many visitors come to my website after receiving a postcard with a short URL to a Campaign landing page. In addition to the number of visits I would also like to view the value per visit, conversion rate, and bounce rate on the report. The end result should be a report very alike the online interactions report - but for offline.
Sitecore Experience Analytics Dashboard Online interactions report
Since the report I wanted to create was very similar to an existing report, I decided to copy the existing one instead of creating it from scratch:
Navigated to the existing report
core/sitecore/client/Applications/ExperienceAnalytics/Dashboard/PageSettings/Online interactions
Right clicked the Online interactions report and selected Duplicate.
3. Entered the name of my new report
After my previous steps, I had a duplicate of the online interactions report. Because I intend to get a pretty similar report (but to track offline instead of online), I don't need to modify any of the Metrics or the Segment on the report.
What I need to change in this case is the report key from online to offline.
Sitecore Experience Analytics Report Configuration
To find my new key, I navigated to my Sitecore instance Marketing Control Panel and looked for channels taxonomy. I copied the Offline channel "Item ID", made it all lower case, and removed the dashes.
Offline channel item in marketing control panel taxonomy
Back to Visual Studio to replace the key value and save my changes.
Next, I needed to figure out how to display the report on the dashboard, so I went back to Sitecore's user guide and followed the steps to Add a chart component to a report. Again, because the report I needed was very similar to the online interactions report, I used that one as reference. So instead of adding a new rendering from scratch, I just duplicated the OnlineInteractions one.
Sitecore Experience Analytics Item Options
I saved my changes and went straight to Sitecore to check my Experience Analytics dashboard.
Sitecore Experience Analytics Dashboard with custom report
Good news! The report was there, but the presentation wasn't what I wanted; it was showing on the Online interactions section report. I couldn't find anything on the documentation about creating sections, so I had to figure it out by looking at the existing reports.
After a second look, I realized that there are RowPanel and ColumnPanel renderings on the reports layout controlling how the reports display.
Sitecore Experience Analytics Dashboard layout
So I added a section to hold my report:
Finally, I was able to see my report the way I expected it to display.
Sitecore Experience Analytics Dashboard with custom report in separate section
Next, I'll be testing my report by hitting that short URL I mentioned at the beginning.
AEM is built on Adobe Cloud Technology, which means easier access for both you and your assets from anywhere. You don't have to worry about the final content presentation on each platform or device.
Through modules for website creation, forms, mobile applications, communities, and assets, AEM streamlines web content management and delivery. When taken as a whole, these modules make AEM a fantastic CMS tool. With the help of the AEM CMS module, the business can create and manage websites from a single location.