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 ...
- 10.4k
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 ...
- 3,359
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 ...
- 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 ...
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 ...
- 18.1k
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 ...
- 9,606
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 - ...
- 5,653
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 ...
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 ...
- 1,201
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 ...
- 1,201
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 ...
- 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 ...
- 226
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.
...
- 2,938
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.
...
- 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 ...
- 2,668
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/...
- 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/...
- 5,098
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: ...
- 19.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 ...
- 2,198
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 ...
- 9,606
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 ...
- 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 ...
- 12.6k
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 ...
- 13.8k
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 ...
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 ...
- 4,304
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)
<...
- 3,130
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 ...
- 5,382
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: ...
- 607
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 ...
- 1,201
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 ...
- 2,996
Only top scored, non community-wiki answers of a minimum length are eligible