Adform data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

bounces
Display name Bounces
Description This metric shows the number of bounces for the selected dimension. Bounces are such visits on a advertiser's website, when only one tracked page is visited during the entire visit (session)
Field type metric
Data type int.number.value
campaign
Display name Campaign
Description This dimension shows and groups information by campaign
Field type dimension
Data type string.text.value
campaignID
Display name Campaign ID
Description This dimension groups data by Adform campaign ID
Field type dimension
Data type string.text.value
campaignType
Display name Campaign type
Description This dimension groups information by campaign type
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description This metric shows the number of clicks for the selected dimension. A click occurs when a user interacts with the advertisement by engaging a mouse button (usually the left) while the mouse pointer is hovering over the advertisement
Field type metric
Data type int.number.value
client
Display name Client
Description Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc
Field type dimension
Data type string.text.value
clientID
Display name Client ID
Description This dimension groups data by Adform client ID
Field type dimension
Data type string.text.value
conversions
Display name Conversions
Description A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews, displayed as a sum for all tracked conversion pages. It has predefined Uniqueness of 'No Repeat', which means that Conversion pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type int.number.value
cost
Display name Cost
Description This metric shows the cost value for the selected dimension (usually on a media, placement (line item) level)
Field type metric
Data type float.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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
engagements
Display name Engagements
Description This metric shows the count of user interactions with a banner. User interactions are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc. Not user-initiated banner events are not included into this metric, except for auto-expand event. Examples of not user-initiated banner event are Floating Banner Shown, 25% of Video Play, etc
Field type metric
Data type int.number.value
engagingImpressions
Display name Engaging impressions
Description This metric shows the sum of impressions, where at least one engagement occurred during each impression. Engagements are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc
Field type metric
Data type int.number.value
entrances
Display name Entrances
Description This metric shows the number of session entries for the selected dimension. A session entry occurs when a user enters a website and starts browsing
Field type metric
Data type int.number.value
exits
Display name Exits
Description This metric shows the number of session exits for the selected dimension. A session exit occurs when a user leaves a website (either due to literally leaving the site or due to the session time-out)
Field type metric
Data type int.number.value
impressions
Display name Tracked ads
Description This metric shows the number of tracked ads (formerly known as impressions) and includes both rendered and served-but-not-rendered ads
Field type metric
Data type int.number.value
impressionsBannerUnique
Display name Impressions banner unique
Field type metric
Data type int.number.value
lineItem
Display name Line item
Description This dimension groups information by Line Item. Line Item is an advertisement spot on a media/publisher
Field type dimension
Data type string.text.value
lineItemID
Display name Line item ID
Description This dimension groups data by Adform Line Item ID
Field type dimension
Data type string.text.value
measurableImpressions
Display name Measurable impressions
Description This metric shows the number of eligible impressions that were measured for viewability. This metric has been accredited by the Media Rating Council (MRC)
Field type metric
Data type int.number.value
media
Display name Media
Description Media/publisher is the provider of online advertising space, such as an online newspaper, social network site or other
Field type dimension
Data type string.text.value
mouseovers
Display name Mouse overs
Description This metric shows the number of mouse overs on banner. Only mouse overs, which lasted 1 second or more, are registered
Field type metric
Data type int.number.value
nonViewableImpressions
Display name Non-viewable impressions
Description This metric shows the number of rendered impressions that were not in the users' screens
Field type metric
Data type int.number.value
pageviews
Display name Unique pageviews
Description This metric shows the number of all tracked pages (tracking points) pageviews, displayed as a sum for all tracked pages. It has predefined Uniqueness of 'No Repeat', which means that pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type int.number.value
pageviewsPostClick
Display name Unique pageviews post click
Field type metric
Data type int.number.value
renderedImpressions
Display name Rendered impressions
Description The number of times that an advertisement was rendered anywhere in a user's browser. This metric has been accredited by the Media Rating Council (MRC)
Field type metric
Data type int.number.value
rtbBids
Display name RTB bids
Description This metric shows the number of offers done by Adform in attempt to win an impression on an ad exchange auction
Field type metric
Data type int.number.value
sales
Display name Sales
Description This metric shows the sales value collected from all visits on tracked pages. Collected only if variable is implemented in Tracking points. It has predefined Uniqueness of 'No Repeat', which means that sales value form pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type float.number.value
undeterminedImpressions
Display name Undetermined impressions
Description This metric shows the number of rendered impressions that could not be measured for viewability. This metric has been accredited by the Media Rating Council (MRC)
Field type metric
Data type int.number.value
videoEvents
Display name Video events
Description This metric shows the interactions with video banners, where banner events are implemented. Interactions such as Play, Pause, Stop, Sound On, and others can be reported
Field type metric
Data type int.number.value
videoEventsPlayTime_100
Display name Video events (Play time, 100%)
Field type metric
Data type float.number.percentage
videoEventsPlayTime_25
Display name Video events (Play time, 25%)
Field type metric
Data type float.number.percentage
videoEventsPlayTime_50
Display name Video events (Play time, 50%)
Field type metric
Data type float.number.percentage
videoEventsPlayTime_75
Display name Video events (Play time, 75%)
Field type metric
Data type float.number.percentage
viewImpressions
Display name Viewable impressions
Description This metric shows the number of rendered impressions that were actually in the users' screens
Field type metric
Data type int.number.value
visitors
Display name Visitors
Description Shows the number of unique visitors in advertiser's website for the selected tracking setup
Field type metric
Data type int.number.value
visitorsPostClick
Display name Visitors post click
Field type metric
Data type int.number.value
visits
Display name Visits
Description Shows the number of visits in advertiser's website for the selected tracking setup
Field type metric
Data type int.number.value

Table: SITE_TRACKING

adInteractionType
Display name Ad interaction type
Description This dimension can be used to group view-through and click-through activity e.g. conversions, orders etc
Field type dimension
Data type string.text.value
bounces
Display name Bounces
Description This metric shows the number of bounces for the selected dimension. Bounces are such visits on a advertiser's website, when only one tracked page is visited during the entire visit (session)
Field type metric
Data type int.number.value
bouncesPostClick
Display name Bounces post click
Field type metric
Data type int.number.value
bouncesPostImpression
Display name Bounces post impression
Field type metric
Data type int.number.value
campaignID
Display name Campaign ID
Description This dimension groups data by Adform campaign ID
Field type dimension
Data type string.text.value
client
Display name Client
Description Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc
Field type dimension
Data type string.text.value
clientID
Display name Client ID
Description This dimension groups data by Adform client 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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
entrances
Display name Entrances
Description This metric shows the number of session entries for the selected dimension. A session entry occurs when a user enters a website and starts browsing
Field type metric
Data type int.number.value
exits
Display name Exits
Description This metric shows the number of session exits for the selected dimension. A session exit occurs when a user leaves a website (either due to literally leaving the site or due to the session time-out)
Field type metric
Data type int.number.value
page
Display name Tracking Point
Description Website tracking dimension. Page is a definable content unit in advertiser's site. Usually one tracking point is implemented per page
Field type dimension
Data type string.text.value
pageviews
Display name Unique pageviews
Description This metric shows the number of all tracked pages (tracking points) pageviews, displayed as a sum for all tracked pages. It has predefined Uniqueness of 'No Repeat', which means that pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type int.number.value
referrerType
Display name Referrer type
Description Website tracking dimension, groups information by referrer type, such as "Direct Traffic", "Referring Site" or "Natural Search"
Field type dimension
Data type string.text.value
sales
Display name Sales
Description This metric shows the sales value collected from all visits on tracked pages. Collected only if variable is implemented in Tracking points. It has predefined Uniqueness of 'No Repeat', which means that sales value form pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type float.number.value
visitors
Display name Visitors
Description Shows the number of unique visitors in advertiser's website for the selected tracking setup
Field type metric
Data type int.number.value
visits
Display name Visits
Description Shows the number of visits in advertiser's website for the selected tracking setup
Field type metric
Data type int.number.value
websiteSection
Display name Website section
Description Website tracking dimension, groups information by tracking section. Tracking section can hold a group of tracking points assigned to a certain campaign, or a group of tracking points implemented on one section of client's website and used for many different campaigns
Field type dimension
Data type string.text.value

Table: GEO

city
Display name City
Description Geographical dimension, groups information by visitor's city, e.g. Copenhagen, Oslo, Stockholm, London etc
Field type dimension
Data type string.geo.city
clicks
Display name Clicks
Description This metric shows the number of clicks for the selected dimension. A click occurs when a user interacts with the advertisement by engaging a mouse button (usually the left) while the mouse pointer is hovering over the advertisement
Field type metric
Data type int.number.value
client
Display name Client
Description Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc
Field type dimension
Data type string.text.value
clientID
Display name Client ID
Description This dimension groups data by Adform client ID
Field type dimension
Data type string.text.value
continent
Display name Continent
Description Geographical dimension, groups information by visitor's continent, e.g. Australia, Europe, etc
Field type dimension
Data type string.geo.continent
conversions
Display name Conversions
Description A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews, displayed as a sum for all tracked conversion pages. It has predefined Uniqueness of 'No Repeat', which means that Conversion pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type int.number.value
country
Display name Country
Description Geographical dimension, groups information by visitor's country e.g. Denmark, UK, USA, etc
Field type dimension
Data type string.geo.country
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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Tracked ads
Description This metric shows the number of tracked ads (formerly known as impressions) and includes both rendered and served-but-not-rendered ads
Field type metric
Data type int.number.value
region
Display name Region
Description Geographical dimension, shows visitor related information grouped by region
Field type dimension
Data type string.geo.region
sales
Display name Sales
Description This metric shows the sales value collected from all visits on tracked pages. Collected only if variable is implemented in Tracking points. It has predefined Uniqueness of 'No Repeat', which means that sales value form pageviews, generated by the same user within 15 minutes, are excluded
Field type metric
Data type float.number.value

Table: MEDIA_PLAN

booked
Display name Booked
Description This metric shows the number of booked units for a media placement (line item)
Field type metric
Data type float.number.value
bookedClicks
Display name Booked clicks
Description This metric shows the number of booked clicks for a media placement. Clicking means interacting with an advertisement by engaging a mouse button (usually the left) while the mouse pointer is hovering over the advertisement
Field type metric
Data type float.number.value
bookedConversions
Display name Booked conversions
Description This metric shows the number of booked conversions for the selected dimension
Field type metric
Data type float.number.value
bookedImpressions
Display name Booked impressions
Description This metric shows the number of booked impressions for the selected dimension. An impression occurs when a user is exposed to an advertisement
Field type metric
Data type float.number.value
bookedTime
Display name Booked time
Description This metric shows the number of booked time units for the selected dimension
Field type metric
Data type float.number.value
clicksMediaUnique
Display name Clicks media unique
Field type metric
Data type int.number.value
client
Display name Client
Description Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc
Field type dimension
Data type string.text.value
clientID
Display name Client ID
Description This dimension groups data by Adform client 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
impressions
Display name Tracked ads
Description This metric shows the number of tracked ads (formerly known as impressions) and includes both rendered and served-but-not-rendered ads
Field type metric
Data type int.number.value
impressionsMediaUnique
Display name Impressions media unique
Field type metric
Data type int.number.value
media
Display name Media
Description Media/publisher is the provider of online advertising space, such as an online newspaper, social network site or other
Field type dimension
Data type string.text.value
mediaCountry
Display name Media country
Description This dimension indicates media/publisher country, where the selected media is located
Field type dimension
Data type string.geo.country
mediaGlobal
Display name Media global
Description Groups information by media, automatically synchronized with the global media database
Field type dimension
Data type string.text.value
mediaID
Display name Media ID
Description This dimension groups data by Adform media ID
Field type dimension
Data type string.text.value
mediaLineItem
Display name Media line item
Description A joint dimension to list Media:Line Item combination as one dimension values
Field type dimension
Data type string.text.value
mediaSection
Display name Media section
Description This dimension groups information by media section
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: BANNER

banner
Display name Banner/Adgroups
Description This dimension lists paid search keywords that visitors used to reach advertiser's website
Field type dimension
Data type string.text.value
bannerFormat
Display name Banner format
Description This dimension indicates the format of the banner, such as "Skyscraper", "Advertorials", etc
Field type dimension
Data type string.text.value
bannerID
Display name Banner ID
Description This dimension groups data by Adform banner ID
Field type dimension
Data type string.text.value
bannerSize
Display name Banner size
Description This dimension groups information by banner size. Banner size is shown as "width x height" in pixels, e.g. 300 x 250
Field type dimension
Data type string.text.value
bannerType
Display name Banner type
Description This dimension groups information by creative material type
Field type dimension
Data type string.text.value
clickDetail
Display name Click detail
Description This dimension groups information by banner click details. Click details allow seperating clicks on back-up and flash banners, and clicks on different clickable areas defined by different click-tags implemented in the banners
Field type dimension
Data type string.text.value
clicksBannerUnique
Display name Clicks banner unique
Field type metric
Data type int.number.value
client
Display name Client
Description Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc
Field type dimension
Data type string.text.value
clientID
Display name Client ID
Description This dimension groups data by Adform client 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
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressionsBannerUnique
Display name Impressions banner unique
Field type metric
Data type int.number.value
lineItemID
Display name Line item ID
Description This dimension groups data by Adform Line Item ID
Field type dimension
Data type string.text.value