Analytics Database

Analytics Database

Sitecore Analytics Database Manager Module

  • Sitecore shared source module distributed as a standard Sitecore package
  • Adds 'Analytics Database Manager' to the Analytics section of the Sitecore Control Panel
  • Displays an Analytics Database Manager window with 7 options
    • Clean All Analytics Data is used to remove test data before going live
    • Clean Analytics Data by the Specified Data is used to remove data based on a specified filter 
    • Remove all BOTs Sessions is used to remove data if the VisitorClassification is greater than 900
    • Rebuild Index runs a SQL script and is used to improve performance
    • Create Backup of Analytics Database should be used before other commands for data recovery
    • Synchronize Analytics Definitions is used to populate a clean or broken Anaytics database with Analytics definition items from the master database
  • Can be used to remove data from the Sitecore Analytics database that is not valuable
    • Remove IP addresses and related data for visitors with a low number of sessions
    • Remove sessions and related data where there is only one page visited during the session
    • Remove sessions and related data where the session is classified as a robot
  • Requires Sitecore CMS 6.2 – 6.4 and Sitecore OMS for SQL Server

Sources