Adobe Analytics data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

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
category
Display name Category
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
orders
Display name Orders
Field type metric
Data type int.number.value
product
Display name Product
Field type dimension
Data type string.text.value
revenue
Display name Revenue
Field type metric
Data type float.currency.value
units
Display name Units
Field type metric
Data type int.number.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