Template result: data schema of the final destination table – 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.
`landingHost`	STRING	Host, from which the session had started.
`landingPage`	STRING	Page, from which the session had started.
`userId`	STRING	ID of user on website.
`userEmail`	STRING	The user's email.
`userPhone`	STRING	The user's phone.
`clientId`	STRING	ClientId anonymously identifies a particular user, device, or browser instance.
`customerId`	STRING	Customer ID from CRM.
`visitNumber`	INTEGER	The session number of this user over the last six months. If it is the first session, then this field is set to 1.
`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.
`adGroup`	STRING	AdGroup of the session.
`channelGroup1`	STRING	First channel group.
`channelGroup2`	STRING	Second channel group.
`channelGroup3`	STRING	Third channel group.
`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.
`operatingSystem`	STRING	The operation system used.
`operatingSystemVersion`	STRING	The version of the operation system used.
`country`	STRING	The country from which the session originated.
`region`	STRING	The region from which the session originated.
`city`	STRING	The city from which the session originated.
`time`	FLOAT	The time from which the session started.
`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.
`step_1`	INTEGER	First step of the transaction.
`step_2`	INTEGER	Second step of the transaction.
`conversions`	INTEGER	Number of conversions.
`revenue`	FLOAT	Number of revenue.
`products`	INTEGER	Number of products.
`conversions_crm`	INTEGER	Number of conversions from CRM.
`revenue_crm`	FLOAT	Number of revenue from CRM.
`products_crm`	INTEGER	Number of products from CRM.
`conversions_refunded`	INTEGER	Number of refunded conversions.
`revenue_refunded`	FLOAT	Number of refunded revenue.
`products_refunded`	INTEGER	Number of refunded products.

Overview

0 Comments

Related articles