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.
advertisement
The advertisement object.
attribution
The attribution object.
attributionCheck
The table with data about attribution checking.
attributionFunnelBasedActions
The FBA actions object.
attributionFunnelBasedProbabilities
The FBA probabilities object.
attributionFunnelBasedValues
The FBA values object.
costAttributionCheck
The cost attribution check object.
crm
The table with the data from the client's CRM.
This table doesn't work from the box: in this table we aggregate data from different tables in one. As soon as we don't know the client's CRM structure, the code here should be written from scratch.
crmStandart
The table with the standardized data from the client's CRM.
This table doesn't work from the box: in this table we collecting aggregated and standardized data. As soon as we don't know the client's CRM structure, the code here should be written according to client's CRM data structure.
crmTransactions
The table with matched data from CRM and Streaming.
device
The object contains device information.
ecommerceAction
The e-commerce action object.
event
The event object.
eventInfo
The event information object.
firstCustomerSession
The first customer's session object.
firstVisitorSession
The first visitor's session object.
geo
The geo dictionary contains information for decoding geographic data.
hitsLibraries
The hit object.
page
The page object.
pageview
The pageview object.
product
The product object.
productInAction
The product in action object.
productInTransaction
The product in transaction object.
profilizationCheck
Collected amount of data in the profile id table.
sessionLibraries
Intermediate table with the session-level libraries
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.
sessionsAttributes
The session attributes object.
standardAttributions
The table with data about updated attributions: First Click, Linear, Time Decay, Position Based
streamingSessions
The table, which contains information about the sessions from the streaming.
trafficSource
The trafficSource reference provides decoding information about traffic sources. It helps determine where the traffic is coming from.
eventInfo
The eventInfo reference provides information for deciphering event-related data. This reference facilitates the understanding of event characteristics and details.
transaction
The transactions table is periodic and partitioned by transaction date. It holds information about WEB and CRM transactions.
transactionCheck
The table with data about transactions comparing between CRM and WEB transactions.
user
The user reference holds information for decoding user-related data.
0 Comments