Template result: data schema of final destination tables



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. 

 

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.