Extracting data from earlier versions of EXM to create historical reports

Current version: 10.0

From Email Experience Manager version 3.4, the email campaign reports are generated based on the email channel interactions that are stored in the Sitecore xDB Interactions registry.

However, you can 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.

To extract data from an earlier version of EXM to create historical reports:

  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 collected in Sitecore xDB is considerably greater than the historical data collected in the Email Engagement Plan. Email Engagement Plans are deprecated from EXM version 3.5.

Do you have some feedback for us?

If you have suggestions for improving this article,