Questions tagged [reporting]

For questions related to Sitecore's Reporting feature, wherein tracking and contact info sent to the collections database, including the process, functionality, architecture, server-role, etc.

Filter by
Sorted by
Tagged with
1 vote
1 answer
37 views

How to set a goal in Content hub

In Sitecore, we can set a goal when a user downloads a media item. Is it possible OOB to do the same in Content Hub? There is no Sitecore integration for this project, just the Content Hub. This is to ...
  • 2,535
0 votes
0 answers
28 views

500 error in Sitecore RebuildReportingDB.aspx

We are getting the 500 error in rebuild reporting database page /sitecore/admin/RebuildReportingDB.aspx and our Sitecore version is 10.2 What we need to check to fix the issue.
  • 153
1 vote
2 answers
55 views

What is the meaning of some Tables in the Reporting database?

I am working with Sitecore Reporting Database to analyze the website, but I don't know the purpose of each tables and their relationship. It would be great help if someone share some documents around ...
1 vote
2 answers
112 views

Reporting database stopped collecting data after certain date

We are working on Sitecore 9.3. I see that the data in reporting database tables are present only till date - 27 May 2022. After that, no data has been collected. In the experience profile, latest ...
0 votes
1 answer
83 views

SPE reports - CSV download doesn't work

We have built a powershell report which is working great. However none of the download buttons work. There is no error in browser nor sitecore logs. it just doesn't download the file. I've tried in ...
  • 3
2 votes
1 answer
397 views

Can I safely remove Report.ashx file?

I am on Sitecore XP 8.0.0 and found Report.ashx file in the /sitecore/shell/ClientBin/Reporting/ folder. Can I safely remove it?
0 votes
0 answers
25 views

SEO Reports and Branded Location Searches

I use SEMRush for keyword position tracking, but need something to help the below searches in some other type of report. Our company has multiple locations in the US, and as the company grows and more ...
  • 1
2 votes
0 answers
43 views

How to filter Experience Analytics for Sitecore goals by page

We are using Sitecore 9.3 and are triggering goals using the sc_trk param on clicks of links/buttons. We would like to be able to have a Filter dropdown of Sitecore Pages within the Goals report in ...
1 vote
1 answer
178 views

No Data collected in the sitecore Reporting Database

I can see the users are being added in the Experience profile but my analytics chart doesn't show any data. I checked the reporting database and it is empty. I have spent more time in ...
2 votes
0 answers
116 views

Getting exception while running the reporting database rebuild tool

I am trying to rebuild the reporting database using the URL, https://abc.com/sitecore/admin/RebuildReportingDB.aspx but every time getting the below error. The version of Sitecore we are using is 9.0....
  • 71
1 vote
0 answers
45 views

Rebulding Database not showing previous analytics after upgrade

I have upgraded from Sitecore 9 to 9.2 recently. Looking into the database I see all interactions being written to xDB. But from the date of upgrade, the UI has not been updated on Experience ...
4 votes
1 answer
574 views

Logs are flooded with requests to reporting server for POST /~/v75/reporting/remotedatasourceproxy/

We installed a new 9.2 solution on PAAS (including SXA 1.9 - although that does not seem to be relevant). This is a clean solution that will be filled with content -and code- from an upgraded version. ...
  • 19.3k
2 votes
1 answer
721 views

Use Sitecore Analytics to show most viewed pages

I have a requirement to track the most viewed pages in last month in our Sitecore 9.0.1. I have followed the answer here https://theroks.com/use-sitecore-analytics-show-number-pageviews/ and tried to ...
1 vote
0 answers
46 views

How to expose Sitecore Analytics Reports Data to outside system

I need to expose Page Views data for different pages for each channels to an outside non-sitecore system through an API. I checked the ReportingAPI documentation shows how to query the reporting ...
  • 443
0 votes
1 answer
74 views

Rebuild Reporting DB in scaled environment takes moretime

I have rebuilt the reporting DB in sitecore 9.1,For 60000 records it takes more than one-day,Which was not accepted by client. Please let me the process how could I improve the performance of ...
1 vote
1 answer
419 views

EXM Report | Data is not getting aggregated

Environment details: Sitecore 9.0.2 Scaled in PAAS model What is happening: We have deployed a set of e-mail campaigns, both regular and automated in the environment. The mails are getting triggered ...
  • 1,158
2 votes
0 answers
160 views

Sitecore Custom Analytics Report

I know that Sitecore provides an option to offer custom analytics report to the clients. I successfully created a new report page following the steps given in the official Sitecore documentation page, ...
2 votes
1 answer
78 views

How can I read the analytics of triggered goals?

I am trying to trigger a goal from the client side following the below link https://ggullentops.blogspot.com/2016/02/integrating-addthis-with-sitecore-goals.html Now I would like to generate a ...
  • 1,059
2 votes
1 answer
236 views

Where are Page Events that have not yet been aggregated in the Reporting Database stored?

When I was using MongoDB on Sitecore 8.1, Page Events were stored in the Interactions collection; I could query them this way: `db.getCollection('Interactions').find({ "Pages.PageEvents" : { $size: 1 ...
2 votes
2 answers
550 views

All Goals trigger through programmatically are visible in Experience Profile but not in Experience Analytics report

All Goals trigger through programmatically are visible in the Experience Profile > Goal Report but not in Experience Analytics Report. We have triggered goal programmatically and attached with a ...
1 vote
0 answers
218 views

Experience Analytics Report display off by 1 day

I am seeing a different report based on the computer that I am logged in to for the Sitecore Anayltics Reports. I am running on Sitecore v9.0.2, we have one Server which is running the CM, Processing,...
  • 121
1 vote
1 answer
66 views

Does enabling of historical reaggregation rebuild the reporting database?

Can I temporarily enable the historical reaggregation, in order to rebuild the reporting database, instead of going through this guide?
0 votes
1 answer
382 views

How to sort Sitecore items by popularity

I'm using Sitecore 9 update 1 and SXA 1.7, I want to sort Sitecore pages by popularity, I opened the Reporting database and found many tables like Fact_Visits, Fact_PageViewsMetrics and ...
11 votes
1 answer
686 views

Report database Rebuild ridiculously slow

I'm running Sitecore 9.0.1 and trying to rebuild a reporting database. The problem is that the process is ridiculously slow. How slow? Here's a screenshot: After 26 hours 127 items were processed of ...
3 votes
1 answer
362 views

How are search keywords saved?

I'm using Sitecore 9 update 1, I'm trying to get the top trending search keywords by users for my website. I discovered that the local search keywords are stored at table DimensionKeys in the ...
1 vote
0 answers
193 views

Gauging the progress of Rebuild Reporting Database job, and troubleshooting issues

I am using Sitecore 8.1 with Mongo and Lucene indexes. I rebuilt the Reporting Database before - it never took more than 10 hours. This time, my PC has been running it for more than 3 days straight. ...
1 vote
0 answers
277 views

How to track Page Visit with Query String in Sitecore 9 Analytics?

I am using Sitecore 9.0 update 2, and want to track the Page visits with query string. Currently all pages are tracked without query string and my requirement is to track page visit as new page, if it ...
1 vote
3 answers
734 views

EXM report is empty (data is not being captured) in scaled environment

I am working with Sitecore 9.0 update 2 on Azure. Server is scale out : 1CM and 3CD. After email campaign is run, we can receive email but reporting is not working. It doesn't have any data is as ...
0 votes
1 answer
50 views

Offline channel reports not working

In the Experience Analytics, none of the "Offline Channel" reports are showing any graphs for our site. All the reports show - "No data to display". Aquisition - Channels - Offline - Offline ...
  • 2,535
0 votes
1 answer
94 views

Paid keyword reports not displaying any graphs

In the Experience Analytics, none of the Paid Keyword reports are showing any graphs for our site. All the reports show - "No data to display". e.g: Aquisition - Keywords - Top paid keywords ...
  • 2,535
1 vote
1 answer
63 views

Top exit pages by conversions - No data displayed

The following two reports in Experience Analytics do not display any graph and show "No data to display". Behavior - Pages - Exit pages - Top exit pages by conversions Behavior - Page URLs - Exit ...
  • 2,535
0 votes
1 answer
454 views

How do I solve Reporting role log errors related to reference data?

I use SIF to install XP1 packages for all Sitecore 9.0.2 server roles. When I look in the logs of the Reporting instance, I see exceptions, such as: Dependency injection can't find an implementation ...
1 vote
1 answer
199 views

Experience Profile custom facet retrieval error

I was trying to create custom facets in Sitecore 9.0 Update 1. I was able to create one and add a custom tab in experience profile. I fill the custom facet data with the help of a WFFM form. I see the ...
  • 80
3 votes
1 answer
237 views

"ConcurrentlyModifiedException Message: Routine caused exception: History_UpdateCursorProgress." when rebuilding reporting database

I followed below document to set up multiple processing server (i created 3 processing server) https://doc.sitecore.net/developers/server-role-configuration-reference/core-roles/processing/index.html ...
  • 181
5 votes
1 answer
257 views

How to create a new Sitecore Analytics report to show assets download per contact

I'm trying to create a custom report on sitecore analytics to display Assets downloaded per contact. Currently there is a report to show downloaded assets but it doesn't display who has downloaded ...
  • 3,707
2 votes
1 answer
428 views

Sitecore Azure WebApp and TLS 1.2

I want to use the most secure TLS 1.2 on Sitecore Azure Web apps for all 4 roles - CD, CM, PRC and REP. I did not do any changes in Analytics processing and reporting - so, I do not deploy my code to ...
5 votes
2 answers
712 views

Detailed Reports tab in form report is showing blank in WFFM

I have configured Sitecore 8.2 update 4 into CMS only mode and configured WFFM with SQL databases. When I submit a form and open form report it is showing the data into Summary tab but "Detailed ...
1 vote
1 answer
431 views

Sitecore Log reports an issue: Error during Aggregation

Sitecore log recently reported an error during aggregation. While going through the log file, found an exception below: Exception: System.Data.SqlClient.SqlException Message: T-SQL ERROR 242, ...
  • 91
5 votes
1 answer
288 views

What are the drawbacks of Rebuild Reporting Database?

I tried to rebuild reporting database but it goes on for indefinite time. In the Rebuild Reporting database page it's showing (Waiting to receive to data status) According to a blog, I need to ...
  • 91
0 votes
0 answers
58 views

Sitecore IP Geo location service lookups report

I would like to know where the following report read its content from, I have a data that doesn't make sense and I am trying to trouble shoot:
5 votes
3 answers
366 views

Custom Report from xDB (MongoDB) based in Geo Ips

We are on Sitecore 8.2 rev. 170614 (8.2 Update-4) using MongoDB On-Premise mode with custom SSL Setup. Need to submit a custom report to business based on various logins (and related data) ...
  • 2,534
2 votes
2 answers
838 views

Rebuild Reporting Database procedure fails with "Aggregation task not found" error

We're attempting to rebuild our reporting database in order process historical data from Mongo. This has failed on us several times. This time we were able to catch the error message: ERROR Failed ...
5 votes
0 answers
214 views

Sitecore 8.2 using analytics data in code

I have followed the answer here But I get a null reference exception if I do not create an instance of the ReportDataProvider. And when I do create an instance I am getting an error in the ...
4 votes
1 answer
260 views

WFFM 500 errors

This is a Sitecore 8.1 Update 2 installation. I'm getting the errors that are described in this blog post when I try to view the form reports: http://blog.ryanbailey.co.nz/2017/09/sitecore-wffm-form-...
  • 5,052
2 votes
1 answer
623 views

Where to find Visit Duration and Latest Date Visited in Code Behind

I am creating a process that reads in the Sitecore analytics contact collection and gets information needed for a report. It is read and inserted in SQL Server. Not sure how to get some of the fields ...
  • 705
6 votes
1 answer
433 views

How to visualize the results from A/B testing as soon as possible in the reporting?

I'm setting up some local development tests to properly validate the functionality of AB Page- and Component tests. I'm using the /admin/kill.aspx page to succesfully kill a session. I can see data ...
  • 1,591
1 vote
2 answers
473 views

System requests on Experience Analytics reports

On an 8.2 new installation I am getting a few Entry and Exit page URL entries on the Experience Analytics reports which I would not expect: /api/sitecore/settings/setuserprofilekey /sitecore/...
4 votes
1 answer
1k views

How to set up Sitecore Experience Analytics?

On my sitecore Azure environment, I already have a working xDB collecting data about visitors. Now I want to display graphs to see for instance, with what frequency goals were registered. I tried ...
0 votes
1 answer
2k views

Error - SegmentProcessor failed to process interaction [closed]

We are facing a strange issue on Sitecore 8.1 Update-1 environment. While rebuilding Reporting database, we always find below error. 10528 09:55:18 ERROR [Experience Analytics]: SegmentProcessor ...
  • 1,007
0 votes
1 answer
127 views

All Marketing Definitions get deleted from Secondary reporting database after rebuilding Reporting DB

When I run the rebuildreportingdb.aspx tool, it deletes all existing marketing definitions (Segments, GoalDefinitions, etc. tables) from secondary reporting database. I came to know about this after ...
  • 1,007