This transformation generates several tables, that would be used for CMO Dashboard Model Based transformation.
There is no reason to describe these tables fully, so we provide short descriptions of each table.
STG_Object
STG_Object serves as an intermediate table designed to optimize data processing.
sessions
The sessions table represents a periodic structure partitioned by session date. It contains information about user sessions, enabling the analysis and assessment of user activities over different time periods.
event
The event table is also periodic and partitioned by event date. It holds data about events, allowing for a more detailed study of interactions and activities within the system.
eventInfo
The eventInfo reference provides information for deciphering event-related data. This reference facilitates the understanding of event characteristics and details.
trafficSource
The trafficSource reference provides decoding information about traffic sources. It helps determine where the traffic is coming from.
geo
The geo dictionary contains information for decoding geographic data.
device
The device reference offers data for deciphering device-related information.
user
The user reference holds information for decoding user-related data.
productInTransactions
The productInTransactions reference provides data for deciphering information about products within transactions. Planned to be optimized in future.
product
The product reference contains information for deciphering data about products.
web_transactions
The web_transactions table serves as an intermediate periodic structure partitioned by transaction date. It contains data about WEB transactions, excluding duplicated records.
crm_transactions
The crm_transactions table, also intermediate and periodic, partitioned by transaction date, contains data about CRM transactions in "Completed" and "Refunded" statuses, excluding duplicated records. (ADD LINK TO INSTRUCTION ON WEBSSITE)
transactions
The transactions table is periodic and partitioned by transaction date. It holds information about WEB and CRM transactions.
0 Comments