Outbrain DSP (Zemanta) data warehouse table groups

Search fields

Table: PUBLISHER

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

performance__account

Display name	Account
Description	The name of your account
Field type	dimension
Data type	string.text.value

performance__account_id

Display name	Account ID
Description	ID of the account
Field type	dimension
Data type	string.text.value

performance__ad_group

Display name	Ad group
Description	Name of the ad group
Field type	dimension
Data type	string.text.value

performance__ad_group_id

Display name	Ad group ID
Description	ID of the ad group
Field type	dimension
Data type	string.text.value

performance__agency

Display name	Agency
Description	Name of the agency
Field type	dimension
Data type	string.text.value

performance__agency_id

Display name	Agency ID
Description	ID of the agency
Field type	dimension
Data type	string.text.value

performance__batch_name

Display name	Batch Name
Description	The name of the upload batch
Field type	dimension
Data type	string.text.value

performance__bid

Display name	Bid
Description	Bid amount
Field type	dimension
Data type	float.currency.value

performance__bidding_type

Display name	Bidding Type
Description	Bidding Type
Field type	dimension
Data type	string.text.value

performance__bounced_visits

Display name	Bounced Visits
Description	Number of visitors that didn't navigate to more than one page on the site
Field type	metric
Data type	int.number.value

performance__brand_name

Display name	Brand name
Description	Advertiser's brand name
Field type	dimension
Data type	string.text.value

performance__call_to_action

Display name	Call to action
Description	Call to action text
Field type	dimension
Data type	string.text.value

performance__campaign

Display name	Campaign
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

performance__campaign_id

Display name	Campaign ID
Description	ID of the campaign
Field type	dimension
Data type	string.text.value

performance__clicks

Display name	Clicks
Description	The amount of clicks
Field type	metric
Data type	int.number.value

performance__content_ad

Display name	Ad name
Description	Name of the content ad
Field type	dimension
Data type	string.text.value

performance__content_ad_id

Display name	Ad ID
Description	ID of the content ad
Field type	dimension
Data type	string.text.value

performance__creative

Display name	Creative
Description	The creative title/name/headline
Field type	dimension
Data type	string.text.value

performance__creative_id

Display name	Creative ID
Description	The creative ID
Field type	dimension
Data type	string.text.value

performance__currency

Display name	Currency
Description	The currency
Field type	dimension
Data type	string.text.value

performance__daily_budget

Display name	Daily budget
Description	Maximum daily budget
Field type	dimension
Data type	float.currency.value

performance__data_cost

Display name	Data cost
Description	Cost of data usage from various data providers
Field type	metric
Data type	float.currency.value

performance__date

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

performance__description

Display name	Description
Description	Description of the ad
Field type	dimension
Data type	string.text.value

performance__display_url

Display name	Display URL
Description	Advertiser's display url
Field type	dimension
Data type	string.text.url

performance__image_hash

Display name	Image hash
Description	Image hash
Field type	dimension
Data type	string.text.value

performance__image_url

Display name	Image URL
Description	Url of the image
Field type	dimension
Data type	string.text.url

performance__impressions

Display name	Impressions
Description	Impressions
Field type	metric
Data type	int.number.value

performance__license_fee

Display name	License Fee
Description	Outbrain DSP (Zemanta)'s license fee
Field type	metric
Data type	float.currency.value

performance__margin

Display name	Margin
Description	A percentage representing the profit margin
Field type	metric
Data type	float.number.percentage

performance__measurable_impressions

Display name	Native Measurable Impressions
Description	Impressions for which we measured viewability
Field type	metric
Data type	int.number.value

performance__media_source

Display name	Media source
Description	Media source where the content is being promoted
Field type	dimension
Data type	string.text.value

performance__media_source_id

Display name	Media source ID
Description	ID of the media source. Can only be included with 'Media source' breakdown
Field type	dimension
Data type	string.text.value

performance__media_source_slug

Display name	Media source slug
Description	Slug of the media source. Can only be included with 'Media source' breakdown
Field type	dimension
Data type	string.text.value

performance__media_spend

Display name	Media Spend
Description	Cost of buying media
Field type	metric
Data type	float.currency.value

performance__non_bounced_visits

Display name	Non-Bounced Visits
Description	Number of visitors that navigated to than one page on the site
Field type	metric
Data type	int.number.value

performance__pageviews

Display name	Pageviews
Description	Total number of pageviews made during the selected date range
Field type	metric
Data type	int.number.value

performance__publishers

Display name	Publishers
Description	Publisher where the content is being promoted
Field type	dimension
Data type	string.text.url

performance__spend

Display name	Spend
Description	Sum of media spend, data spend, license fee and margin
Field type	metric
Data type	float.currency.value

performance__spend_eur

Display name	Spend (EUR)
Description	Sum of media spend, data spend, license fee and margin
Field type	metric
Data type	float.currency.value

performance__spend_gbp

Display name	Spend (GBP)
Description	Sum of media spend, data spend, license fee and margin
Field type	metric
Data type	float.currency.value

performance__spend_usd

Display name	Spend (USD)
Description	Sum of media spend, data spend, license fee and margin
Field type	metric
Data type	float.currency.value

performance__time_on_site

Display name	Time on Site
Description	Total time spend on site
Field type	metric
Data type	int.number.value

performance__total_minutes

Display name	Total minute
Description	Total minutes spend on site
Field type	metric
Data type	float.number.value

performance__total_seconds

Display name	Total Seconds
Description	Total seconds spend on site
Field type	metric
Data type	int.number.value

performance__uploaded

Display name	Uploaded
Description	The time when the ad was uploaded
Field type	dimension
Data type	string.time.datetime

performance__uploaded_date

Display name	Uploaded date
Description	The date when the ad was uploaded
Field type	dimension
Data type	string.time.date

performance__url

Display name	URL
Description	Web address of the ad
Field type	dimension
Data type	string.text.url

performance__video_complete

Display name	Video Complete
Description	Number of video ads start to play through to completion
Field type	metric
Data type	int.number.value

performance__video_first_quartile

Display name	Video 25%
Description	Number of video ads start to play through 25% of their duration
Field type	metric
Data type	int.number.value

performance__video_midpoint

Display name	Video 50%
Description	Number of video ads start to play through 50% of their duration
Field type	metric
Data type	int.number.value

performance__video_progress_3s

Display name	Video Progress 3s
Description	Video progress 3s
Field type	metric
Data type	int.number.value

performance__video_start

Display name	Video Start
Description	Number of video ads start to play
Field type	metric
Data type	int.number.value

performance__video_third_quartile

Display name	Video 75%
Description	Number of video ads start to play through 75% of their duration
Field type	metric
Data type	int.number.value

performance__viewable_impressions

Display name	Native Viewable Impressions
Description	Number of impressions that were viewed by a person. Impression is counted as viewed when 50% of the ad is in view for 1 second
Field type	metric
Data type	int.number.value

performance__visits

Display name	Visits
Description	Total number of sessions within a date range
Field type	metric
Data type	int.number.value

Table: AD