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
12
votes
4answers
4k views

How to find out what's pending to be published

I need to do a full site publish but there could be content, without workflow with changes that can't be published. How could I build a "report" with the list of items with changes that would be ...
11
votes
2answers
2k views

When rebuilding the reporting database stuck on StoppingDataRecording

I am doing an upgrade from 7.5 to 8.1-Update 3. I have gotten to the end and just finished the final upgrade to get to 8.1-Update 3. Now I am trying to rebuild the reporting database. I open the /...
10
votes
1answer
332 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 ...
9
votes
0answers
262 views

Custom WFFM Speak Reporting Page

I am trying to display submitted form records in a custom SPEAK reporting page. I can use the "FormResponsesDataSource" rendering to get the submitted records related to a given form. Now I need to ...
8
votes
1answer
496 views

WFFM Analytics - is it possible to report on dropouts by field?

I know that WFFM captures form dropout data to some extent and there's a Dropouts count in the out-of-the-box Form reports. Is it possible to use the data that's already captured to report on dropouts ...
7
votes
2answers
925 views

Clean Analytics in Sitecore 8

I need to do a clean test in Sitecore Analytics. I have cleaned all Analytics but if I remount the path Analyser all results are brought back. What is the best way to do this?
7
votes
0answers
354 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 ...
5
votes
1answer
130 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 ...
5
votes
3answers
314 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) ...
5
votes
1answer
176 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 ...
5
votes
1answer
325 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 ...
5
votes
2answers
449 views

Rebuilding Reporting DB with multiple processing servers

We need to rebuild our reporting database with over a year of data and don't want it to take a week to finish so we want to optimize this process. We currently have a standalone processing server for ...
5
votes
2answers
1k views

How can I create a custom Page Events report in Sitecore 8?

I wanted to create a report on particular page events. In Sitecore 7.2 we had a PageEvents table; in Sitecore 8 xDB, this table seems to be missing from the Reporting DB. I checked the Interactions ...
5
votes
1answer
198 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 ...
5
votes
1answer
176 views

Filter analytics goal report by device

Is it possible to share an analytics goal and then filter by device when viewing the report? We are programmatically registering a goal from the website (through webapi) and it's working fine. We ...
5
votes
2answers
533 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 ...
5
votes
0answers
168 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
2answers
584 views

Experience Analytics Entry/Exit pages display [unknown page]

Can anyone shed some light on why I am seeing numerous entries for [unknown page] in the Experience Analytics -> Behavior -> Pages -> Entry pages/Exit Pages reports? I need to track down what is ...
4
votes
1answer
249 views

Sitecore 404 reporting in 8.2

Before, we would use the site health in the analytics area to check 404 error reports. This has been removed in 8.2, so what is the expected way to get this information?
4
votes
1answer
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 ...
4
votes
1answer
177 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-...
3
votes
1answer
481 views

XDB Continuous Update for Reporting

I see in this Sitecore Documentation they mention Continuous Update as a type of processing for reporting. I can't find any documentation on this. What are the steps and configuration required to set ...
3
votes
1answer
177 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 ...
3
votes
1answer
201 views

Sitecore Reporting Service How to validate setup

I have completed the Sitecore Configuration for remote Sitecore Reporting Service for my CM server. How do I validate that its correctly configured? Is there something/anything on the CM server what ...
3
votes
1answer
125 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 ...
2
votes
1answer
57 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
2answers
95 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 ...
2
votes
2answers
501 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 ...
2
votes
1answer
441 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 ...
2
votes
1answer
266 views

What are the consequences of disabling the analytics index?

If I were to delete the data from the analytics index, and then disable the observables declared in the in the crawlers defined here, Sitecore.ContentSearch.Lucene.Index.Analytics.config <index ...
2
votes
1answer
37 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 ...
2
votes
0answers
36 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
2answers
87 views

GeoIP Location data not coming in database and interaction object?

I am trying to implement geo-location-based personalization for my website and for this, I would like to test the data locally. I have enabled geolocation services from app-center and tested with the ...
2
votes
0answers
51 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]: ...
2
votes
0answers
236 views

Analytics Custom Report of pages with most goals recorded has no data

I'm trying to make a list of the "most favorited" pages, but no data is coming out in the finished report. When the user clicks a favorite button, it triggers the built-in "Like" goal for that page. ...
2
votes
0answers
566 views

Why are contacts not showing up in analytics index after rebuilding reporting database?

I have a Sitecore 8.1-3 instance using Solr 4.10. I just finished rebuilding the reporting database following the Sitecore instructions. I am noticing that there are contacts that I know are in ...
1
vote
1answer
278 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, ...
1
vote
1answer
126 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 ...
1
vote
2answers
322 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/...
1
vote
1answer
141 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 ...
1
vote
1answer
361 views

RequiredObjectIsNullException while rebuilding the reporting database - RebuildTaskDataProvider

I have setup secondary analytics db and trying to rebuild reporting database by going to "sitecore/admin/RebuildReportingDB.aspx". However when I open "RebuildReportingDB.aspx" I am getting below ...
1
vote
1answer
50 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?
1
vote
1answer
42 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 ...
1
vote
1answer
275 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 ...
1
vote
1answer
87 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
vote
0answers
82 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,...
1
vote
0answers
99 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
0answers
154 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
3answers
271 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
1answer
79 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 ...