In this article I’m going to explain how to convert .mrt reports from the Sitecore Online Marketing Suite (Sitecore 6.4) to the Sitecore Digital Marketing System (Sitecore 6.5).
Report related changes between OMS and DMS
Both the OMS and the DMS use .mrt reports for Analitics reporting. There are two mayor changes between the OMS and DMS reporting; a full redesign of the datamodel and the location of the SQL query for the report data.
Mapping the datamodel of the OMS with the DMS
If you compare the datamodel of the OMS to the DMS datamodel you will see that it’s completely different. But the main concept of both datamodels is almost the same.
|OMS table||DMS Table||Description|
|GlobalSession||Vistors||Contains the Visitor information.|
|Session||Visits||Contains the information of all the visits. A visits is underneed a Visitors.|
|Page||Pages||Contains all pages that are visited and are connected to a Session.|
The following drawing will show the relation of Visitor->Sessions->Pages.
In this example we have a Continue reading “Converting .mrt reports from OMS to DMS”