Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
19 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
1answer
42 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
1answer
62 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 ...
9
votes
1answer
120 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
1answer
72 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
0answers
52 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
66 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
2answers
137 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
21 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 ...
0
votes
1answer
47 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 ...
1
vote
1answer
19 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 ...
0
votes
1answer
69 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
1answer
97 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 ...
2
votes
0answers
66 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 ...
5
votes
1answer
90 views

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

I'm trying to create a report on sitecore analytics to display Assets downloaded per contact. Currently there is a report to show downloaded assets but it doesn't display how downloaded those assets....
1
vote
1answer
220 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
votes
0answers
68 views

Can access to Web Forms for Marketers reports be restricted individually?

We have a need to allow some users to access their own Web Forms for Marketers form reports without giving them access to ALL of the reports, but is this even doable without custom development? I can ...
5
votes
2answers
436 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
1answer
212 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, ...
5
votes
1answer
128 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 ...
0
votes
0answers
50 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
3answers
273 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
votes
2answers
406 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
0answers
145 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
1answer
145 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-...
2
votes
1answer
357 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 ...
5
votes
1answer
257 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
vote
2answers
226 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
1answer
982 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
1answer
1k 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 ...
0
votes
1answer
96 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 ...
8
votes
0answers
299 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 ...
0
votes
1answer
129 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 ...
2
votes
0answers
48 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]: ...
6
votes
1answer
181 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 ...
7
votes
2answers
816 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?
5
votes
2answers
401 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 ...
2
votes
0answers
217 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. ...
3
votes
1answer
407 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 ...
2
votes
1answer
148 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 ...
2
votes
0answers
485 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 ...
10
votes
0answers
228 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 ...
1
vote
1answer
347 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 ...
4
votes
1answer
204 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
2answers
495 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 ...
5
votes
2answers
972 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 ...
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 /...
2
votes
1answer
236 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 ...
5
votes
1answer
163 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 ...
10
votes
4answers
3k 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 ...