Overview
An 'Ecom Data Model' template is used to prepare the standard Ecommerce model for the CMO Dashboard with CRM Data (eCommerce).
This transformation uses the data that is a result of Sessionization template and BlendedAdSpend template work. Additionally, it uses the CRM data, that should be prepared in this structure. The output is several tables: dictionaries and partitioned tables.
Note:Letters at the beginning of the name of each operation define, in all, what this operation does:
D (DELETE) - operation with the main task of data deletion;
O (OVERWRITE) - operation, the result of which is overwriting of some table;
A (APPEND) - operation, that adds new data to the table.
[P] - D - STG_Objects
This operation is responsible for the precleansing of STG_objects for the refreshing date range.
[P] - A - STG_Objects
The operation creates a temporary table with Ecommerce objects, like product, transactions, etc.
[P] - D - Sessions
The operation, responsible for precleansing of Sessions object for the refreshing date range.
[P] - A - Sessions
The operation, that creates a Session object for Data Mart.
[P] - D - Event
The operation, responsible for precleansing of the Event object for the refreshing date range.
[P] - A - Event
The operation, that creates an Event object for Data Mart.
[R] - A - EventInfo
The operation, that appends all EventInfo objects.
[R] - O - EventInfo
The operation that takes all EventInfo objects for future table.
[R] - A - TrafficSource
The operation, that appends all TrafficSouce objects.
[R] - O - TrafficSource
The operation, that takes all TrafficSource objects for future table.
[R] - A - Geo
The operation, that adds all Geo objects.
[R] - O - Geo
The operation, that takes all Geo objects for future table.
[R] - A - Device
The operation, that appends all Device objects.
[R] - O - Device
The operation, that takes all Device objects for future table.
[R] - A - User
The operation, that adds all User objects.
[R] - O - User
The operation, that takes all User objects.
[R] - A - ProductsInTransactions
The operation, that adds all ProductsInTransactions objects.
[R] - O - ProductsInTransactions
The operation, that takes all ProductsInTransactions objects for future table.
[R] - A - Product
The operation, that adds all Products objects.
[R] - O - Product
The operation, that takes all Products objects for future table.
[P] - A - WEB Transaction
The operation, that adds all WEB Transaction objects.
[P] - O - WEB Transaction
The operation, that takes all WEB Transaction for future table.
[P] - O - CRM Transaction
The operation, that takes all CRM Transaction objects for future table. These objects are taken from your own CRM table.
[P] - D - Transaction
The operation, responsible for precleansing of Transaction object for refreshing date range.
[P] - A - Transaction
The operation, that appends Transaction for the final Data Mart Table.
After this operation ends, you will get prepared Ecommerce Data Model! 🎉
0 Comments