15 votes

How to find out what's pending to be published

I would go with Sitecore PowerShell Extensions. It supports your version as well. My idea is to run query and process all items you want to check. In the past I used something like this to compare ...
Alan Płócieniak's user avatar
14 votes
Accepted

When rebuilding the reporting database stuck on StoppingDataRecording

I figured out the problem. Turns out I had Sitecore.Analytics.Processing.Aggregation.Services.config and Sitecore.Analytics.Processing.Services.config files disabled. I had disabled them during the ...
Corey Burnett's user avatar
9 votes
Accepted

XDB Continuous Update for Reporting

Continuous Updating is automatically configured. It is the process of xDB which takes interactions that have just ended, out of shared session, into the repository, and then processed and aggregated ...
Pete Navarra's user avatar
  • 14.6k
7 votes
Accepted

Clean Analytics in Sitecore 8

First Method (recommended): Install the Analytics Database Manager version 3.0 When Analytics Database Manager is installed, access the application from the Sitecore launchpad. Go on the "REMOVE OLD ...
Frédérick Fournel's user avatar
6 votes

Experience Analytics Entry/Exit pages display [unknown page]

The [Unknown page] entries may appear due to following reasons: Items may have been deleted which were already tracked. Pages are opened and tracked which are not Sitecore items e.g. You created a ...
Vlad Iobagiu's user avatar
  • 18.5k
6 votes
Accepted

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

To be able to insert new fields into the analytics index, you should have the following: Custom Crawler Index Aggregator Pipeline The crawler inherits from the ObserverCrawler<T> type. The ...
Hishaam Namooya's user avatar
6 votes
Accepted

Can I safely remove Report.ashx file?

The Report.ashx file is no longer used and can safely be removed. This file was used to drive the Executive Insight Dashboard that was deprecated in 8.0 Initial Release. For Sitecore XP 8.0.0 - ...
Tamas Varga Sitecore's user avatar
5 votes

Report database Rebuild ridiculously slow

I have applied the hotfix as instructed by George Tucker and increased the number of history workers as instructed by Chris Auer, in my case I have raised from 1 to 500. I'm getting much better speed ...
Anderson Fortaleza's user avatar
5 votes
Accepted

How to set a goal in Content hub

There are some reporting events that get initiated automatically in the Content Hub. For example, you will be interested in an asset.download.completed event. Whenever an asset is downloaded, a log ...
Kate Orlova's user avatar
  • 1,269
5 votes
Accepted

Speed up Rebuilding Reporting Database

I beleive that before starting the rebuild you have successfully configured the secondary Reporting database and updated the connection strings accordingly as this is a must-to-have step, see more ...
Kate Orlova's user avatar
  • 1,269
4 votes

How to find out what's pending to be published

This is very nice solution that I implemented in my project: In the content editor the left margin of the content tree is known as gutter. In this area we can show a icon that can be used to display ...
Sandeep's user avatar
  • 785
4 votes

How to find out what's pending to be published

It might be worth having a look into the publishing queue. This is the piece that keeps track of every change made in Sitecore and is used by the "Incremental Publish" option. There is even an API to ...
Alistair Deneys's user avatar
4 votes

When rebuilding the reporting database stuck on StoppingDataRecording

According to the Official Sitecore Documentation, there is a note that reads You can only run the RebuildReportingDB.aspx and RedeployMarketingData.aspx pages from a content management server. ...
Keith VanderVeen's user avatar
4 votes
Accepted

Where to find Visit Duration and Latest Date Visited in Code Behind

That data is in the sitecore_analytics_index. It is not in the analytics model for you to pull from. You are going to have to make a call into the index to get that data for each of your contacts. ...
Chris Auer's user avatar
  • 13.1k
4 votes
Accepted

How to visualize the results from A/B testing as soon as possible in the reporting?

These reports are made from the aggregated xdb data. You can tweak the aggregation and processing intervals to make sure your data is put to the reporting database more frequently. You need to alter ...
Andrey Bobrov's user avatar
4 votes

What are the drawbacks of Rebuild Reporting Database?

I've followed this process a number of times and haven't hit any ongoing issues yet. https://doc.sitecore.net/sitecore_experience_platform/81/setting_up_and_maintaining/xdb/server_considerations/...
Ben Scott's user avatar
  • 389
4 votes

Sitecore Log reports an issue: Error during Aggregation

There is KB article for similar problem, The may occur when a contact submits a particular web form created using the WFFM module two or more times. Please see below link - https://kb.sitecore.net/...
Mahendra Shekhawat's user avatar
4 votes
Accepted

Logs are flooded with requests to reporting server for POST /~/v75/reporting/remotedatasourceproxy/

Apparently the requests come from the sitecore_suggested_test_index. With the correct filter on the logs we could see that the start of the calls was always preceded by Job started: ...
Gatogordo's user avatar
  • 20.1k
3 votes

Rebuild Reporting Database procedure fails with "Aggregation task not found" error

Brief Problem Description When data have been captured in the MongoDB, on session end, data will be aggregated to the reporting database through Aggregation Pipelines. Issue Your issue is with the ...
Hishaam Namooya's user avatar
3 votes

Clean Analytics in Sitecore 8

The quick and dirty way that I do it in dev on a regular basis is to: Replace your reporting database with a new DB from the sitecore zip file /databases. Using robomongo, log into Mongo and delete ...
Chris Auer's user avatar
  • 13.1k
3 votes

Experience Analytics Entry/Exit pages display [unknown page]

Tracked pages have an ItemId field that is saved to the Collection database. During the generation of reports, all information about the page will be fetched from the corresponding Sitecore item. In ...
Dmytro Shevchenko's user avatar
3 votes
Accepted

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

In the SQL based versions of Sitecore (i.e. 7.2 and lower) the Dropout reports were available from the WFFM Form Reports section. Unfortunately on the xDB/Mongo verions of Sitecore (7.5 onwards) this ...
jammykam's user avatar
  • 13.8k
3 votes

Custom Report from xDB (MongoDB) based in Geo Ips

Sitecore itself stores the raw analytics data in Mongo, then continually processes the data into a SQL database to make it easier to report on. You can do the same thing, depending on how fresh you ...
Richard Hauer's user avatar
3 votes
Accepted

Experience Profile custom facet retrieval error

Go to your Azure Sitecore Reporting instance and select "Application settings" under the Settings menu. Under "Application settings" on the right, add a new "APP SETTING NAME" called ...
Navneet Pisharodi's user avatar
3 votes
Accepted

How to sort Sitecore items by popularity

You will want to use Fact_PageViews in the Reporting database, which should contain an Item Id, representing the page that someone has visited. Keeping in mind that this data will always be old and ...
Dylan Young's user avatar
  • 4,314
3 votes

All Goals trigger through programmatically are visible in Experience Profile but not in Experience Analytics report

If your interaction doesn`t have WebVisit it is invisible in Experience Analytics by default. You can change you goal to a web interaction as @Chris Auer mentioned or remove(patch) <...
x3mxray's user avatar
  • 3,150
3 votes

Where are Page Events that have not yet been aggregated in the Reporting Database stored?

Page Event Definitions These are stored under /sitecore/system/Marketing Control Panel/Events When you say "Custom Page Events" you would be talking about custom ones that exist here. There ...
Mark Gibbons's user avatar
  • 5,582
3 votes
Accepted

Reporting database stopped collecting data after certain date

This issue is finally resolved with the help of sitecore support! The root cause was this error - ERROR Could not update device detection database Exception: System.NullReferenceException Message: ...
NewbieHere's user avatar
3 votes

What is the meaning of some Tables in the Reporting database?

The Reporting database contains aggregated data from the xDB.Collection database. This statistical data generated by the aggregation pipeline and used by Sitecore Reporting applications is stored in ...
Kate Orlova's user avatar
  • 1,269
2 votes

What are the consequences of disabling the analytics index?

Content delivery should be unaffected, as you stated, unless you're doing something custom and accessing analytics data from front-end code. Reporting could be extremely slow, depending on the ...
Ed Schwehm's user avatar
  • 3,036

Only top scored, non community-wiki answers of a minimum length are eligible