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
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 ...
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
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 ...
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 ...
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
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
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
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 ...
0
votes
0answers
63 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 ...
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
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 ...
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 ...
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 ...
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?
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 ...
0
votes
1answer
103 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 ...
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. ...
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
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 ...
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 ...
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
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 ...
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 ...
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
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 ...
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
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 ...
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 ...
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 ...
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-...
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, ...
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 ...
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
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) ...
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
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. ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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]: ...
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 ...