We’re rewarding the question askers & reputations are being recalculated! Read more.

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
1answer
89 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 ...
2
votes
0answers
39 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
92 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
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
1answer
60 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 ...
0
votes
0answers
67 views

Sitecore Reporting Server high CPU usage

This particular dev branch is on Sitecore XP 9.1. My reporting (dev) server is often at very high CPU usage, completely saturating my machine's processing power, for about 20 minutes typically after ...
2
votes
2answers
96 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 ...
0
votes
0answers
25 views

Issue in Custom report migration from 8.2 to 9.1

We are migrating our custom report code from 8.2 to 9.1 , In 8.2 we are using public class PageEventProcessor : AggregationProcessor { protected override void OnProcess(AggregationPipelineArgs ...
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
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?
0
votes
1answer
104 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 ...
10
votes
1answer
340 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
182 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
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
280 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
28 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
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 ...
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 ...
0
votes
1answer
142 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
128 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 ...
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 ...
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 ...
1
vote
1answer
277 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
2answers
537 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
280 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
180 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
54 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
315 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
502 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
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
1answer
178 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
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 ...
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 ...
1
vote
2answers
324 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
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
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
104 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 ...
7
votes
0answers
356 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 ...
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 ...
2
votes
0answers
52 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
200 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
929 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
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 ...
2
votes
0answers
237 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
484 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
203 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
567 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 ...
9
votes
0answers
265 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
362 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 ...