Extract data from earlier versions of EXM to create historical reports

Abstract

Extract Email Engagement Plan data from previous versions of EXM to use for historical reports.

The Email Experience Manager (EXM) generates the email campaign reports based on the email channel interactions that are stored in the Sitecore xDB Interactions registry.

However, to extract the data manually for historical reports using the analytics data from earlier versions of EXM, where the data was not stored in the xDB Interactions registry:

  1. Create a copy of the following tables located in the Reporting database and move them to a separate database.

    • LandingPageDetails

    • Fact_LandingPages

    • Fact_VisitsByMessage

    • Fact_AbnVisitsByMessage

    • Fact_AutomationStatesStatisticsByMessage

    • Fact_AutomationStatesStatisticsByAbnMessage

  2. Extract the data from these tables to use in your own third-party business intelligence tool.

Note

The accuracy of the EXM analytics data that is collected in Sitecore xDB is considerably greater than the historical data collected in the Email Engagement Plan.