Adobe Analytics (Legacy) data warehouse table groups

Search fields

Table: TRAFFIC_GEO

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

geoCity

Display name	City
Description	City (information from Digital Envoy)
Field type	dimension
Data type	string.geo.city

geoCountry

Display name	Country
Description	Country (information from Digital Envoy)
Field type	dimension
Data type	string.geo.country

geoDMA

Display name	Designated market area
Field type	dimension
Data type	string.text.value

geoRegion

Display name	Region
Description	Region / State (information from Digital Envoy)
Field type	dimension
Data type	string.geo.region

instances

Display name	Instances
Field type	metric
Data type	int.number.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

visitors

Display name	Unique visitors
Description	Unique visitors represent the number of de-duplicated (counted only once) visitors to your website over the course of a specified time period. A unique visitor is determined with cookies. Unique visitors are calculated based on the selected reporting period. Any visitor during that reporting period will be counted only once
Field type	metric
Data type	int.number.value

visits

Display name	Visits
Field type	metric
Data type	int.number.value

Table: TRAFFIC_BROWSER

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

browser

Display name	Browser
Description	The types and versions of browsers that visitors use
Field type	dimension
Data type	string.text.value

browserType

Display name	Browser type
Description	The major browser families, such as Microsoft and Google, that visitors use
Field type	dimension
Data type	string.text.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

instances

Display name	Instances
Field type	metric
Data type	int.number.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

visitors

Display name	Unique visitors
Description	Unique visitors represent the number of de-duplicated (counted only once) visitors to your website over the course of a specified time period. A unique visitor is determined with cookies. Unique visitors are calculated based on the selected reporting period. Any visitor during that reporting period will be counted only once
Field type	metric
Data type	int.number.value

visits

Display name	Visits
Field type	metric
Data type	int.number.value

Table: TRAFFIC_PAID_SEARCH

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

instances

Display name	Instances
Field type	metric
Data type	int.number.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

revenue

Display name	Revenue
Field type	metric
Data type	float.currency.value

searchEngine

Display name	Search engine
Description	Which search engines that people are using to find your web page
Field type	dimension
Data type	string.text.value

searchEnginePaid

Display name	Search Engine paid
Description	Which paid-keyword search engines that people are using to find your web page
Field type	dimension
Data type	string.text.value

searchEnginePaidKeyword

Display name	Search engine paid keyword
Description	A breakdown of paid search keywords that have been used to find your site
Field type	dimension
Data type	string.text.value

visitors

Display name	Unique visitors
Description	Unique visitors represent the number of de-duplicated (counted only once) visitors to your website over the course of a specified time period. A unique visitor is determined with cookies. Unique visitors are calculated based on the selected reporting period. Any visitor during that reporting period will be counted only once
Field type	metric
Data type	int.number.value

visits

Display name	Visits
Field type	metric
Data type	int.number.value

Table: TRAFFIC_SYSTEM

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

browser

Display name	Browser
Description	The types and versions of browsers that visitors use
Field type	dimension
Data type	string.text.value

browserType

Display name	Browser type
Description	The major browser families, such as Microsoft and Google, that visitors use
Field type	dimension
Data type	string.text.value

connectionType

Display name	Connection type
Description	The Internet connection speed that visitors to your site have, for example, modem, LAN, mobile traffic, and so forth
Field type	dimension
Data type	string.text.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

instances

Display name	Instances
Field type	metric
Data type	int.number.value

operatingSystem

Display name	Operating system
Description	The operating systems that visitors use
Field type	dimension
Data type	string.text.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

visitors

Display name	Unique visitors
Description	Unique visitors represent the number of de-duplicated (counted only once) visitors to your website over the course of a specified time period. A unique visitor is determined with cookies. Unique visitors are calculated based on the selected reporting period. Any visitor during that reporting period will be counted only once
Field type	metric
Data type	int.number.value

visits

Display name	Visits
Field type	metric
Data type	int.number.value

Table: LANDING_PAGE

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

entries

Display name	Entries
Field type	metric
Data type	int.number.value

exits

Display name	Exits
Field type	metric
Data type	int.number.value

Table: PAGE

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

entries

Display name	Entries
Field type	metric
Data type	int.number.value

exits

Display name	Exits
Field type	metric
Data type	int.number.value

page

Display name	Page
Description	The pages on your site
Field type	dimension
Data type	string.text.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

siteSection

Display name	Site section
Description	The site sections of your web site that are being tracked
Field type	dimension
Data type	string.text.value

Table: ECOMMERCE

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

Table: VISIT

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

instances

Display name	Instances
Field type	metric
Data type	int.number.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

revenue

Display name	Revenue
Field type	metric
Data type	float.currency.value

timePrior

Display name	Time prior
Description	The amount of time that passes before a selected conversion event occurs in a visit
Field type	dimension
Data type	string.text.value

timeVisit

Display name	Time visit
Field type	dimension
Data type	string.text.value

visitNumber

Display name	Visit number
Description	The visit number for each visitor that comes to your site
Field type	dimension
Data type	int.number.value

visitors

Display name	Unique visitors
Description	Unique visitors represent the number of de-duplicated (counted only once) visitors to your website over the course of a specified time period. A unique visitor is determined with cookies. Unique visitors are calculated based on the selected reporting period. Any visitor during that reporting period will be counted only once
Field type	metric
Data type	int.number.value

visits

Display name	Visits
Field type	metric
Data type	int.number.value

Table: TRAFFIC_SOURCE

account

Display name	Account
Field type	dimension
Data type	string.text.value

account_id

Display name	Account ID
Field type	dimension
Data type	string.text.value

bounces

Display name	Bounces
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

date

Display name	Date
Field type	dimension
Data type	string.time.date

instances

Display name	Instances
Field type	metric
Data type	int.number.value

pageViews

Display name	Page views
Field type	metric
Data type	int.number.value

referrer

Display name	Referrer
Description	The domain or URL where your visitors came from before they arrived at your site
Field type	dimension
Data type	string.text.url

referrerType

Display name	Referrer type
Description	Hard drive referrers are recorded when visitors click a link in an HTML document located on their own hard drive and arrive at your site as a result. Other website referrers are recorded when visitors click a link located on a page on another website (not defined as part of your site) and arrive at your website. Search engine referrers are recorded when visitors use a search engine to access your site
Field type	dimension
Data type	string.text.value

referringDomain

Display name	Referrer domain
Description	The base domain, without the query string or subdirectories, where your visitors came from before they arrived at your site
Field type	dimension
Data type	string.text.value

totalTimeSpent

Display name	Total time spent
Field type	metric
Data type	int.number.value

visitors

Display name	Unique visitors
Description	Unique visitors represent the number of de-duplicated (counted only once) visitors to your website over the course of a specified time period. A unique visitor is determined with cookies. Unique visitors are calculated based on the selected reporting period. Any visitor during that reporting period will be counted only once
Field type	metric
Data type	int.number.value

visits

Display name	Visits
Field type	metric
Data type	int.number.value

Documentation Index

Adobe Analytics (Legacy) data warehouse table groups

Table: TRAFFIC_GEO

Table: TRAFFIC_BROWSER

Table: TRAFFIC_PAID_SEARCH

Table: TRAFFIC_SYSTEM

Table: LANDING_PAGE

Table: PAGE

Table: ECOMMERCE

Table: VISIT

Table: TRAFFIC_SOURCE