Template result: data schema of the table for the CMO Dashboard – OWOX Help Center

Overview

This is a schema for the final table, that should be connected to the dashboard.

Field name	Type	Description
`date`	DATE	Session date.
`landingPage`	STRING	Page, from which the session had started.
`clientId`	STRING	ID of the session.
`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.
`deviceCategory`	STRING	The type of the user's device: - tv; - game console; - robot; - set-top box; - robot mobile; - unknown; - hacker; - virtual reality; - anonymizer; Full list and definitions
`browser`	STRING	The browser used.
`browserVersion`	STRING	The version of the browser used.
`country`	STRING	The country from which the session originated.
`region`	STRING	The region from which the session originated.
`city`	STRING	The region from which the session originated.
`sessions`	INTEGER	Number of sessions in this source/medium.
`bounceSessions`	INTEGER	Number of sessions with only one interaction with your website (one pageview).
`pageviews`	INTEGER	Number of pageviews in this source/medium.
`adImpressions`	FLOAT	Number of impressions.
`adClicks`	FLOAT	Number of clicks.
`adCost`	FLOAT	Number of advertisement costs.
`conversions`	INTEGER	Number of conversions.
`revenue`	FLOAT	Number of revenue.