About 'Ecom Data Model' template

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 - OWOX BI Events Streaming 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.

Below, you'll find a handy list of operations in the transformation template, each briefly described for your convenience. However, if you're eager to get started, feel free to jump into the "How to start" article.

[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! 🎉

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.