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.
71
questions
0
votes
0
answers
27
views
Content Hub search reports?
We want to see what people are searching for in Content Hub. I couldn't find any Search Reports in the documenation or blogs, or any search events in the logs. I'd prefer a dashboard or download, ...
- 101
3
votes
2
answers
120
views
Speed up Rebuilding Reporting Database
Analytics data since September 1 is missing for a Sitecore customer. We are trying to rebuild the reporting database in Production (Sitecore 10.2). There are approximately 60+ Lacs of data. The ...
- 790
2
votes
1
answer
68
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,713
0
votes
1
answer
60
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.
- 199
1
vote
2
answers
74
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 ...
- 13
3
votes
3
answers
260
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 ...
- 577
0
votes
1
answer
165
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
448
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?
- 5,603
2
votes
0
answers
53
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 ...
- 9,051
1
vote
1
answer
195
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 ...
- 21
2
votes
0
answers
136
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
50
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 ...
- 261
4
votes
1
answer
619
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.6k
3
votes
1
answer
799
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 ...
- 31
1
vote
0
answers
51
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 ...
- 453
0
votes
1
answer
87
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
2
votes
1
answer
464
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,248
2
votes
0
answers
165
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, ...
- 933
2
votes
1
answer
82
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
243
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
583
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 ...
- 21
1
vote
0
answers
224
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?
- 358
0
votes
1
answer
398
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 ...
- 209
11
votes
1
answer
730
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
377
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 ...
- 209
1
vote
0
answers
200
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
286
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 ...
- 2,044
1
vote
3
answers
755
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 ...
- 153
0
votes
1
answer
53
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,713
0
votes
1
answer
99
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,713
1
vote
1
answer
64
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,713
0
votes
1
answer
492
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 ...
- 12.6k
1
vote
1
answer
202
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
4
votes
1
answer
253
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
...
- 191
5
votes
1
answer
267
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,727
2
votes
1
answer
449
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 ...
- 223
5
votes
2
answers
716
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
440
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, ...
- 101
5
votes
1
answer
293
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 ...
- 101
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:
- 1,360
5
votes
3
answers
368
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
893
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 ...
- 275
5
votes
0
answers
215
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 ...
- 243
4
votes
1
answer
261
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,082
2
votes
1
answer
656
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 ...
- 755
6
votes
1
answer
448
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,601
1
vote
2
answers
490
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/...
- 145
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