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
2 votes
1 answer
373 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?
user avatar
0 votes
0 answers
23 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 ...
user avatar
  • 1
2 votes
0 answers
30 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 ...
user avatar
0 votes
0 answers
22 views

SC 10 Experience Analytics custom report based off user profile fields

Is it possible to customize a report on let's say user profile fields, for example if users have an organization field or company field? If I wanted to create a report that displayed number of page ...
user avatar
  • 1
1 vote
1 answer
163 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 ...
user avatar
2 votes
0 answers
108 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....
user avatar
  • 71
1 vote
0 answers
42 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 ...
user avatar
4 votes
1 answer
515 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. ...
user avatar
  • 19.1k
2 votes
1 answer
636 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 ...
user avatar
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 ...
user avatar
  • 443
0 votes
1 answer
61 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 ...
user avatar
1 vote
1 answer
387 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 ...
user avatar
  • 1,086
2 votes
0 answers
150 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, ...
user avatar
2 votes
1 answer
75 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 ...
user avatar
  • 1,049
2 votes
1 answer
228 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 ...
user avatar
2 votes
2 answers
528 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 ...
user avatar
1 vote
0 answers
214 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,...
user avatar
  • 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?
user avatar
0 votes
1 answer
362 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 ...
user avatar
11 votes
1 answer
654 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 ...
user avatar
3 votes
1 answer
343 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 ...
user avatar
1 vote
0 answers
186 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. ...
user avatar
1 vote
0 answers
272 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 ...
user avatar
1 vote
3 answers
711 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 ...
user avatar
0 votes
1 answer
48 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 ...
user avatar
  • 2,573
0 votes
1 answer
93 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 ...
user avatar
  • 2,573
1 vote
1 answer
62 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 ...
user avatar
  • 2,573
0 votes
1 answer
424 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 ...
user avatar
1 vote
1 answer
198 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 ...
user avatar
  • 80
3 votes
1 answer
227 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 ...
user avatar
  • 181
5 votes
1 answer
245 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 ...
user avatar
  • 3,687
2 votes
1 answer
409 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 ...
user avatar
5 votes
2 answers
710 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 ...
user avatar
1 vote
1 answer
419 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, ...
user avatar
  • 91
5 votes
1 answer
284 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 ...
user avatar
  • 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:
user avatar
5 votes
3 answers
365 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) ...
user avatar
  • 2,534
2 votes
2 answers
821 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 ...
user avatar
5 votes
0 answers
213 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 ...
user avatar
4 votes
1 answer
259 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-...
user avatar
  • 5,040
2 votes
1 answer
607 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 ...
user avatar
  • 695
6 votes
1 answer
425 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 ...
user avatar
  • 1,591
1 vote
2 answers
465 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/...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1,007
0 votes
1 answer
124 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 ...
user avatar
  • 1,007
7 votes
0 answers
447 views

Custom PageEvent processed, visible in xDB; yet not showing up in reports after rebuilding database

I have done the following: I created a new Dimension and Segment; I created a class inheriting from PageEventDimensionBase: public class ByProfilesEdited : PageEventDimensionBase { public ...
user avatar
1 vote
1 answer
160 views

Where can I find Developer Resources for Sitecore Analytics?

My company decided to get more involved with Sitecore Analytics, with the goal of Personalization in mind. I have a good understanding of Sitecore in general, but I never prepared a custom report or ...
user avatar
2 votes
0 answers
58 views

Reports date axes is null

I've rebuild reporting database. After that all reports had been appeared. But reports which are based on Date has empty date axes: Also I have an error in logs: ERROR [Experience Analytics]: ...
user avatar
  • 1,410
6 votes
1 answer
286 views

Custom AggregationProcessor : PageEventsProcessor not getting called

We have created a custom, PageEventsProcessor in Aggregation interaction Pipeline. I have added a lot of logs in that processor. That processor does not seem to be called. And there is no data in my ...
user avatar
  • 185