Template result: data schema of the table for Data Mart – OWOX Help Center

Overview

This is a schema for the final table, that can be used for Data Mart, it is perfect for seeing the distribution of costs for sessions.

Field name	Type	Description
`Date`	DATE	Session date.
`DataSource`	STRING	The data source of the visit.
`SessionID`	STRING	ID of the session.
`Sessions`	INTEGER	Amount of sessions in this source/medium.
`Source`	STRING	Source of the session.
`Medium`	STRING	Medium of the session.
`Campaign`	STRING	Campaign of the session.
`Keyword`	STRING	Keyword of the session.
`AdContent`	STRING	AdContent of the session.
`Impressions`	FLOAT	Amount of impressions.
`Clicks`	FLOAT	Amount of clicks.
`AdCost`	FLOAT	Amount of costs.
`CostM5`	FLOAT	Amount of attributed costs, where all five markups match.
`CostM4`	FLOAT	Amount of attributed costs, where four markups match.
`CostM3`	FLOAT	Amount of attributed costs, where three markups match.
`CostM2`	FLOAT	Amount of attributed costs, where only two markups (source and medium) match.
`AttributedAdCost`	FLOAT	Amount of attributed ad cost to one session.
`AdGroup`	STRING	AdGroup of the session.
`AdAccount`	STRING	Number of the account, from which data comes.
`DataSourceCode`	STRING	Source, from which data originated.
`CampaignType`	STRING	Type of campaign, if specified.
`CampaignId`	STRING	Id of the campaign, if specified.
`CampaignName`	STRING	Name of campaign, if specified.
`AdGroupId`	STRING	Id of advertisement group, if specified.
`AdGroupName`	STRING	Name of advertisement group, if specified.
`AdSource`	STRING	Source of advertisement.
`PipelineId`	STRING	Id of the pipeline, from which data was taken.