The Trade Desk fields

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

Supermetrics brings all your The Trade Desk data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

111 metrics163 dimensions

AD

CreativeId
Field label Creative ID
Description ID of the creative
Field type dimension
Data type string.text.value
CreativeName
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
CreativeDescription
Field label Creative description
Description Description of the creative
Field type dimension
Data type string.text.value
CreativeType
Field label Creative type
Description Type of the creative
Field type dimension
Data type string.text.value
CreativeAvailability
Field label Creative availability
Description Indicates whether the creative is available for use or archived and hidden from views
Field type dimension
Data type string.text.value
CreativeImage
Field label Creative image
Description Creative image of the ad
Field type dimension
Data type string.text.formula
Destinations Google Sheets
CreativeImageUrl
Field label Creative image URL
Description The URL where The Trade Desk has stored the image file for ad serving
Field type dimension
Data type string.text.url
CreativeImageLandingPageUrl
Field label Creative image landing URL
Description Landing page URL of the creative image
Field type dimension
Data type string.text.url
CreativeFlightStart
Field label Creative flight start
Description The flight start date (without the time zone) for the creative
Field type dimension
Data type string.time.date
CreativeFlightEnd
Field label Creative flight end date
Description The flight end date (without the time zone) for the creative
Field type dimension
Data type string.time.date
CreativeFlightStartDatetime
Field label Creative flight start date and time
Description The flight start date and time in UTC (without the time zone) for the creative
Field type dimension
Data type string.time.datetime
CreativeFlightEndDatetime
Field label Creative flight end date and time
Description The flight end date and time in UTC (without the time zone) for the creative
Field type dimension
Data type string.time.datetime
CreativeCreated
Field label Creative created date
Description The date the creative was created
Field type dimension
Data type string.time.date
CreativeUpdated
Field label Creative updated date
Description The date the creative was last updated
Field type dimension
Data type string.time.date
CreativeServedInChina
Field label Creative served in China
Description Flag to indicate this creative will be served in China or not
Field type dimension
Data type bool
AdServerCreativePlacementID
Field label Ad server creative placement ID
Description Placement ID of the creative on ad server
Field type dimension
Data type int.number.value
AdServerName
Field label Ad server name
Description Name of the ad server
Field type dimension
Data type string.text.value
AdFormat
Field label Ad format
Description Ad format (width x height)
Field type dimension
Data type string.text.value
Frequency
Field label Frequency
Description How frequently an ad was shown to a single use, bucketed by frequency within the past 24 hours. "0" means that one ad was shown
Field type dimension
Data type int.number.value

AD GROUP

AdGroupId
Field label Ad group ID
Description ID of the ad group
Field type dimension
Data type string.text.value
AdGroupName
Field label Ad group name
Description Name of the ad group
Field type dimension
Data type string.text.value
AdGroupDescription
Field label Ad group description
Description Description of the ad group
Field type dimension
Data type string.text.value
AdGroupIsEnabled
Field label Ad group enabled
Description Whether the ad group is enabled to spend
Field type dimension
Data type bool
AdGroupIsHighFillRate
Field label Ad group is high fill rate
Description Whether the ad group is a high fill rate ad group
Field type dimension
Data type bool
AdGroupAvailability
Field label Ad group availability
Description Whether the ad group is active and available for normal operation or archived and hidden from normal view
Field type dimension
Data type string.text.value
AdGroupCreated
Field label Ad group created date
Description The date the ad group was created
Field type dimension
Data type string.time.date
AdGroupUpdated
Field label Ad group updated date
Description The date the ad group was last updated
Field type dimension
Data type string.time.date
AdGroupCustomLabels
Field label Ad group labels
Description Custom labels assigned to this ad group
Field type dimension
Data type string.text.value
AdGroupIsClassic
Field label Ad group is classic
Description If true, this ad group's settings will be shown using the Classic UI instead of the Megagon UI
Field type dimension
Data type bool
AdGroupAreFutureKoaFeaturesEnabled
Field label Ad group Koa features enabled
Description Whether future Koa features will be enabled for this Ad Group automatically
Field type dimension
Data type bool
AdGroupPredictiveClearingEnabled
Field label Ad group predictive clearing
Description Whether predictive clearing is enabled/disabled for this ad group
Field type dimension
Data type bool
AdGroupUseIdentityAlliance
Field label Ad group identity alliance
Description Whether the selection of the cross device graphs used to extend the ad group's targeting is controlled by the system
Field type dimension
Data type bool
AdGroupBudgetInImpressions
Field label Ad group budget in impressions
Description Ad group budget in impressions
Field type dimension
Data type int.number.value
AdGroupBudgetAdvCurrency
Field label Ad group budget (adv currency)
Description Ad group budget in advertiser's currency
Field type dimension
Data type float.currency.value
AdGroupDailyCapInImpressions
Field label Ad group daily cap in impressions
Description Ad group daily cap in impressions
Field type dimension
Data type int.number.value
AdGroupDailyTargetInImpressions
Field label Ad group daily target in impressions
Description Ad group daily target in impressions
Field type dimension
Data type int.number.value
AdGroupDailyCapAdvCurrency
Field label Ad group daily cap (adv currency)
Description Ad group daily cap in advertiser's currency
Field type dimension
Data type float.currency.value
AdGroupDailyTargetAdvCurrency
Field label Ad group daily target (adv currency)
Description Ad group daily target in advertiser's currency
Field type dimension
Data type float.currency.value
AdGroupBaseBidCpmAdvCurrency
Field label Ad group base bid CPM (adv currency)
Description Ad group base bid clicks per thousand impressions in advertiser's currency
Field type dimension
Data type float.currency.value

ADVERTISER

AdvertiserId
Field label Advertiser ID
Description ID of the advertiser
Field type dimension
Data type string.text.value
AdvertiserName
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
AdvertiserDescription
Field label Advertiser description
Description Description of the advertiser
Field type dimension
Data type string.text.value
AdvertiserCurrencyCode
Field label Advertiser currency code
Description Three-letter currency code of the advertiser
Field type dimension
Data type string.currency.code
AdvertiserKeywords
Field label Advertiser keywords
Description Keywords that classify the advertiser
Field type dimension
Data type string.text.value
AdvertiserAvailability
Field label Advertiser availability
Description Availability state of the advertiser
Field type dimension
Data type string.text.value
AdvertiserLogoUrl
Field label Advertiser logo URL
Description URL for the Advertiser's logo or brand image
Field type dimension
Data type string.text.url
AdvertiserDomainAddress
Field label Advertiser domain address
Description The domain address (including http:// or https://) for the advertiser
Field type dimension
Data type string.text.url
AdvertiserIsDimensionalBiddingModeSupported
Field label Advertiser dimensional bidding supported
Description Whether or not dimensional bidding mode (Megagon) mode is supported for the advertiser
Field type dimension
Data type bool
AdvertiserIgnoreReferralUrlInConversion
Field label Advertiser's referral URL ignored in conversion
Description Whether or not conversions with deduplication key different only in referral url are considered duplicates for the advertiser
Field type dimension
Data type bool

AUDIENCE

AudienceID
Field label Audience ID
Description ID of the audience
Field type dimension
Data type string.text.value
AudienceName
Field label Audience name
Description Name of the audience
Field type dimension
Data type string.text.value
AudienceDescription
Field label Audience description
Description Description of the audience
Field type dimension
Data type string.text.value
AudienceIsAutoGenerated
Field label Audience auto generated
Description Indicates if this audience was automatically generated by The Trade Desk platform
Field type dimension
Data type bool
AudienceGeoForCounts
Field label Audience geo for counts
Description The geo (country or continent) that the counts for this audience should be filtered to
Field type dimension
Data type string.text.value
AudienceUniqueUserCount
Field label Audience unique user count
Description The number of devices/browsers in the audience
Field type dimension
Data type string.text.value
AudiencePersonsCount
Field label Audience persons count
Description The number of persons in the audience
Field type dimension
Data type string.text.value
AudienceHouseholdCount
Field label Audience household count
Description The number of households in this audience
Field type dimension
Data type string.text.value

CAMPAIGN

CampaignId
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
CampaignName
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
CampaignType
Field label Campaign type
Description Type of the campaign
Field type dimension
Data type string.text.value
CampaignAvailability
Field label Campaign availability
Description Availability of the campaign
Field type dimension
Data type string.text.value
CampaignDescription
Field label Campaign description
Description Description of the campaign
Field type dimension
Data type string.text.value
CampaignBudgetAmount
Field label Campaign budget amount
Description The maximum amount the campaign may spend
Field type dimension
Data type float.currency.value
CampaignBudgetCurrency
Field label Campaign budget currency
Description Budget currency of the campaign
Field type dimension
Data type string.currency.code
CampaignBudgetInImpressions
Field label Campaign budget in impressions
Description The maximum amount of impressions the campaign should buy
Field type dimension
Data type string.text.value
CampaignDailyBudgetAmount
Field label Campaign daily budget amount
Description The total amount the campaign should spend in a single day, if able
Field type dimension
Data type float.currency.value
CampaignDailyBudgetCurrency
Field label Campaign daily budget currency
Description Daily budget currency of the campaign
Field type dimension
Data type string.currency.code
CampaignDailyBudgetInImpressions
Field label Campaign daily budget in impressions
Description The total number of impressions the campaign should buy in a single day, if able
Field type dimension
Data type string.text.value
CampaignStart
Field label Campaign start date
Description The date that the campaign should start spending
Field type dimension
Data type string.time.date
CampaignEnd
Field label Campaign end date
Description The date that the campaign should stop spending if it has not yet exhausted its budget
Field type dimension
Data type string.time.date
CampaignStartDatetime
Field label Campaign start date and time
Description The date and time (in UTC) that the campaign should start spending
Field type dimension
Data type string.time.datetime
CampaignEndDatetime
Field label Campaign end date and time
Description The date and time (in UTC) that the campaign should stop spending if it has not yet exhausted its budget
Field type dimension
Data type string.time.datetime
CampaignCreated
Field label Campaign created date
Description The date the campaign was created
Field type dimension
Data type string.time.date
CampaignUpdated
Field label Campaign updated date
Description The date the campaign was last updated
Field type dimension
Data type string.time.date
CampaignAutoAllocatorEnabled
Field label Campaign auto allocator enabled
Description Whether auto allocator is enabled or not
Field type dimension
Data type bool
CampaignAutoPrioritizationEnabled
Field label Campaign auto prioritization enabled
Description Flag that allows the system to auto prioritize ad groups when AutoAllocator™ is turned on
Field type dimension
Data type bool
CampaignMinimumAdGroupSpendInAdvertiserCurrency
Field label Campaign minimum ad group spend in advertiser currency
Description Each ad group in the campaign will spend this minimum amount daily (if there's enough spend potential)
Field type dimension
Data type float.currency.value
CampaignPacingMode
Field label Campaign pacing mode
Description Pacing mode of the campaign
Field type dimension
Data type string.text.value
CampaignCustomLabels
Field label Campaign labels
Description Custom labels assigned to this campaign
Field type dimension
Data type string.text.value
CampaignCustomCPAClickWeight
Field label Campaign CPA click weight
Description Weight to assign to click through pixels when calculating custom CPA
Field type dimension
Data type string.text.value
CampaignCustomCPAViewthroughWeight
Field label Campaign CPA view weight
Description Weight to assign to view pixels when calculating custom CPA
Field type dimension
Data type string.text.value
CampaignCtvTargetingAndAttribution
Field label Campaign CTV targeting/attribution
Description Flag that extends audience to include Connected TV (CTV) devices and include CTV in standard attribution
Field type dimension
Data type bool

CATEGORY

CategoryName
Field label Category name
Description Name of the category
Field type dimension
Data type string.text.value
IndustryCategoryId
Field label Industry category ID
Description ID of the industry category
Field type dimension
Data type string.text.value
IndustryCategoryName
Field label Industry category name
Description Name of the industry category
Field type dimension
Data type string.text.value
IndustryCategoryPath
Field label Industry category path
Description Path of the industry category
Field type dimension
Data type string.text.value
IndustryCategoryParentId
Field label Industry category parent ID
Description Parent ID of the industry category
Field type dimension
Data type string.text.value

CONVERSIONS

ClickConversionCurrency01
Field label Click conversion currency 01
Description 01 - currency of the click conversion
Field type dimension
Data type string.currency.code
ClickConversionCurrency02
Field label Click conversion currency 02
Description 02 - currency of the click conversion
Field type dimension
Data type string.currency.code
ClickConversionCurrency03
Field label Click conversion currency 03
Description 03 - currency of the click conversion
Field type dimension
Data type string.currency.code
ClickConversionCurrency04
Field label Click conversion currency 04
Description 04 - currency of the click conversion
Field type dimension
Data type string.currency.code
ClickConversionCurrency05
Field label Click conversion currency 05
Description 05 - currency of the click conversion
Field type dimension
Data type string.currency.code
ClickConversionCurrency06
Field label Click conversion currency 06
Description 06 - currency of the click conversion
Field type dimension
Data type string.currency.code
ViewThroughConversionCurrency01
Field label View through conversion currency 01
Description 01 - currency of the view through conversion
Field type dimension
Data type string.currency.code
ViewThroughConversionCurrency02
Field label View through conversion currency 02
Description 02 - currency of the view through conversion
Field type dimension
Data type string.currency.code
ViewThroughConversionCurrency03
Field label View through conversion currency 03
Description 03 - currency of the view through conversion
Field type dimension
Data type string.currency.code
ViewThroughConversionCurrency04
Field label View through conversion currency 04
Description 04 - currency of the view through conversion
Field type dimension
Data type string.currency.code
ViewThroughConversionCurrency05
Field label View through conversion currency 05
Description 05 - currency of the view through conversion
Field type dimension
Data type string.currency.code
ViewThroughConversionCurrency06
Field label View through conversion currency 06
Description 06 - currency of the view through conversion
Field type dimension
Data type string.currency.code
ClickConversion01
Field label Click conversion 01
Description 01 - click conversion
Field type metric
Data type int.number.value
ClickConversion02
Field label Click conversion 02
Description 02 - click conversion
Field type metric
Data type int.number.value
ClickConversion03
Field label Click conversion 03
Description 03 - click conversion
Field type metric
Data type int.number.value
ClickConversion04
Field label Click conversion 04
Description 04 - click conversion
Field type metric
Data type int.number.value
ClickConversion05
Field label Click conversion 05
Description 05 - click conversion
Field type metric
Data type int.number.value
ClickConversion06
Field label Click conversion 06
Description 06 - click conversion
Field type metric
Data type int.number.value
ClickConversion01Revenue
Field label Click conversion 01 revenue
Description 01 - revenue of the click conversion
Field type metric
Data type float.currency.value
ClickConversion02Revenue
Field label Click conversion 02 revenue
Description 02 - revenue of the click conversion
Field type metric
Data type float.currency.value
ClickConversion03Revenue
Field label Click conversion 03 revenue
Description 03 - revenue of the click conversion
Field type metric
Data type float.currency.value
ClickConversion04Revenue
Field label Click conversion 04 revenue
Description 04 - revenue of the click conversion
Field type metric
Data type float.currency.value
ClickConversion05Revenue
Field label Click conversion 05 revenue
Description 05 - revenue of the click conversion
Field type metric
Data type float.currency.value
ClickConversion06Revenue
Field label Click conversion 06 revenue
Description 06 - revenue of the click conversion
Field type metric
Data type float.currency.value
ViewThroughConversion01
Field label View through conversion 01
Description 01 - view through conversion
Field type metric
Data type int.number.value
ViewThroughConversion02
Field label View through conversion 02
Description 02 - view through conversion
Field type metric
Data type int.number.value
ViewThroughConversion03
Field label View through conversion 03
Description 03 - view through conversion
Field type metric
Data type int.number.value
ViewThroughConversion04
Field label View through conversion 04
Description 04 - view through conversion
Field type metric
Data type int.number.value
ViewThroughConversion05
Field label View through conversion 05
Description 05 - view through conversion
Field type metric
Data type int.number.value
ViewThroughConversion06
Field label View through conversion 06
Description 06 - view through conversion
Field type metric
Data type int.number.value
ViewThroughConversion01Revenue
Field label View through conversion 01 revenue
Description 01 - view-through conversion revenue
Field type metric
Data type float.currency.value
ViewThroughConversion02Revenue
Field label View through conversion 02 revenue
Description 02 - revenue of the view through conversion
Field type metric
Data type float.currency.value
ViewThroughConversion03Revenue
Field label View through conversion 03 revenue
Description 03 - revenue of the view through conversion
Field type metric
Data type float.currency.value
ViewThroughConversion04Revenue
Field label View through conversion 04 revenue
Description 04 - revenue of the view through conversion
Field type metric
Data type float.currency.value
ViewThroughConversion05Revenue
Field label View through conversion 05 revenue
Description 05 - view-through conversion revenue
Field type metric
Data type float.currency.value
ViewThroughConversion06Revenue
Field label View through conversion 06 revenue
Description 06 - view-through conversion revenue
Field type metric
Data type float.currency.value
ConversionTouch01
Field label Conversion touch 01
Description 01 - conversion touch
Field type metric
Data type int.number.value
ConversionTouch02
Field label Conversion touch 02
Description 02 - conversion touch
Field type metric
Data type int.number.value
ConversionTouch03
Field label Conversion touch 03
Description 03 - conversion touch
Field type metric
Data type int.number.value
ConversionTouch04
Field label Conversion touch 04
Description 04 - conversion touch
Field type metric
Data type int.number.value
ConversionTouch05
Field label Conversion touch 05
Description 05 - conversion touch
Field type metric
Data type int.number.value
ConversionTouch06
Field label Conversion touch 06
Description 06 - conversion touch
Field type metric
Data type int.number.value
ConversionTouch01Revenue
Field label Conversion touch 01 revenue
Description 01 - conversion touch revenue
Field type metric
Data type float.currency.value
ConversionTouch02Revenue
Field label Conversion touch 02 revenue
Description 02 - conversion touch revenue
Field type metric
Data type float.currency.value
ConversionTouch03Revenue
Field label Conversion touch 03 revenue
Description 03 - conversion touch revenue
Field type metric
Data type float.currency.value
ConversionTouch04Revenue
Field label Conversion touch 04 revenue
Description 04 - conversion touch revenue
Field type metric
Data type float.currency.value
ConversionTouch05Revenue
Field label Conversion touch 05 revenue
Description 05 - conversion touch revenue
Field type metric
Data type float.currency.value
ConversionTouch06Revenue
Field label Conversion touch 06 revenue
Description 06 - conversion touch revenue
Field type metric
Data type float.currency.value
TimeWeightedDecayConversion01
Field label Time weighted decay conversion 01
Description 01 - time weighted decay conversion
Field type metric
Data type int.number.value
TimeWeightedDecayConversion02
Field label Time weighted decay conversion 02
Description 02 - time weighted decay conversion
Field type metric
Data type int.number.value
TimeWeightedDecayConversion03
Field label Time weighted decay conversion 03
Description 03 - time weighted decay conversion
Field type metric
Data type int.number.value
TimeWeightedDecayConversion04
Field label Time weighted decay conversion 04
Description 04 - time weighted decay conversion
Field type metric
Data type int.number.value
TimeWeightedDecayConversion05
Field label Time weighted decay conversion 05
Description 05 - time weighted decay conversion
Field type metric
Data type int.number.value
TimeWeightedDecayConversion06
Field label Time weighted decay conversion 06
Description 06 - time weighted decay conversion
Field type metric
Data type int.number.value
TimeWeightedDecayConversion01Revenue
Field label Time weighted decay conversion 01 revenue
Description 01 - time weighted decay conversion revenue
Field type metric
Data type float.currency.value
TimeWeightedDecayConversion02Revenue
Field label Time weighted decay conversion 02 revenue
Description 02 - time weighted decay conversion revenue
Field type metric
Data type float.currency.value
TimeWeightedDecayConversion03Revenue
Field label Time weighted decay conversion 03 revenue
Description 03 - time weighted decay conversion revenue
Field type metric
Data type float.currency.value
TimeWeightedDecayConversion04Revenue
Field label Time weighted decay conversion 04 revenue
Description 04 - time weighted decay conversion revenue
Field type metric
Data type float.currency.value
TimeWeightedDecayConversion05Revenue
Field label Time weighted decay conversion 05 revenue
Description 05 - time weighted decay conversion revenue
Field type metric
Data type float.currency.value
TimeWeightedDecayConversion06Revenue
Field label Time weighted decay conversion 06 revenue
Description 06 - time weighted decay conversion revenue
Field type metric
Data type float.currency.value

COST

TtdCostUsd
Field label TTD cost (USD)
Description The Trade Desk cost in USD
Field type metric
Data type float.currency.value
TtdCostAdvCurrency
Field label TTD cost (adv currency)
Description The Trade Desk cost in advertiser's currency
Field type metric
Data type float.currency.value
TtdCostPartnerCurrency
Field label TTD cost (partner currency)
Description The Trade Desk cost in partner's currency
Field type metric
Data type float.currency.value
PartnerCostUsd
Field label Partner cost (USD)
Description Partner cost in USD
Field type metric
Data type float.currency.value
PartnerCostAdvCurrency
Field label Partner cost (adv currency)
Description Partner cost in advertiser's currency
Field type metric
Data type float.currency.value
PartnerCostPartnerCurrency
Field label Partner cost (partner currency)
Description Partner cost in partner's currency
Field type metric
Data type float.currency.value
AdvertiserCostUSD
Field label Advertiser cost (USD)
Description Advertiser cost in USD
Field type metric
Data type float.currency.value
AdvertiserCostAdvCurrency
Field label Advertiser cost (adv currency)
Description Advertiser cost in advertiser's currency
Field type metric
Data type float.currency.value
AdvertiserCostPartnerCurrency
Field label Advertiser cost (partner currency)
Description Advertiser cost in partner's currency
Field type metric
Data type float.currency.value

DATA ELEMENT

DataElement
Field label Data element
Description Data element
Field type dimension
Data type string.text.value
1stPartyDataID
Field label 1st party data ID
Description ID of the 1st party data
Field type dimension
Data type string.text.value
3rdPartyDataID
Field label 3rd party data ID
Description ID of the 3rd party data
Field type dimension
Data type string.text.value
3rdPartyDataBrandID
Field label 3rd party data brand ID
Description Brand ID of the 3rd party data
Field type dimension
Data type string.text.value
3rdPartyDataBrand
Field label 3rd party data brand
Description Brand of the 3rd party data
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEAL

DealId
Field label Deal ID
Description ID of the deal
Field type dimension
Data type string.text.value

DEPRECATED

SiteListPermissions
Field label Site list permissions
Description Permissions of the site list.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-03-31
SiteListID
Field label Site list ID
Description ID of the site list.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-03-31
SiteListName
Field label Site list name
Description Name of the site list.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-03-31
CreativeIntegerID
Field label Creative integer ID
Description ID (integer) of the creative.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-10-19
App
Field label App
Description Name of the app.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-10-19
AdGroupIntegerID
Field label Ad group integer ID
Description ID (integer) of the ad group.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-10-19
CampaignIntegerID
Field label Campaign integer ID
Description ID (integer) of the campaign.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-10-19
AdvertiserIntegerID
Field label Advertiser integer ID
Description ID (integer) of the advertiser.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-10-19
PartnerIntegerID
Field label Partner integer ID
Description ID (integer) of the partner.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-10-19
SiteListDescription
Field label Site list description
Description Description of the site list.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2021-03-31

GEO

Country
Field label Country
Description Country
Field type dimension
Data type string.geo.country
CountryCode
Field label Country code
Description Two-letter country code
Field type dimension
Data type string.geo.country.twolettercode
Region
Field label Region
Description Region
Field type dimension
Data type string.text.value
Metro
Field label Metro
Description Metro
Field type dimension
Data type string.text.value
City
Field label City
Description City
Field type dimension
Data type string.text.value

INVENTORY

Site
Field label Site
Description Name of the site
Field type dimension
Data type string.text.value
SiteCategoryBidFactor
Field label Site/category bid factor
Description Bid factor of the site/category
Field type dimension
Data type string.text.value
Fold
Field label Fold
Field type dimension
Data type string.text.value
FoldBidFactor
Field label Fold bid factor
Description Factor of the fold bid
Field type dimension
Data type string.text.value
Language
Field label Language
Description Language of the inventory
Field type dimension
Data type string.text.value

PARTNER

PartnerId
Field label Partner ID
Description ID of the partner
Field type dimension
Data type string.text.value
PartnerCurrencyCode
Field label Partner currency code
Description Code of the partner currency
Field type dimension
Data type string.currency.code

PERFORMANCE

Impressions
Field label Impressions
Description Number of impressions
Field type metric
Data type int.number.value
Clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
Ctr
Field label CTR
Description Click-through ratio
Field type metric
Data type float.number.ratio
Cpm
Field label CPM
Description Cost per 1000 impressions. Calculated from Advertiser cost in Advertiser currency
Field type metric
Data type float.currency.value
Cpc
Field label CPC
Description Cost per click. Calculated from Advertiser cost in Advertiser currency
Field type metric
Data type float.currency.value
TotalConversion01
Field label Total conversion 01
Description Total conversion combining click conversion and view through conversion from 01 conversion pixel
Field type metric
Data type int.number.value
TotalConversionRevenue01
Field label Total conversion 01 revenue
Description Total conversion revenue combining click conversion and view through conversion revenues from 01 conversion pixel
Field type metric
Data type float.currency.value
TotalConversion02
Field label Total conversion 02
Description Total conversion combining click conversion and view through conversion from 02 conversion pixel
Field type metric
Data type int.number.value
TotalConversionRevenue02
Field label Total conversion 02 revenue
Description Total conversion revenue combining click conversion and view through conversion revenues from 02 conversion pixel
Field type metric
Data type float.currency.value
TotalConversion03
Field label Total conversion 03
Description Total conversion combining click conversion and view through conversion from 03 conversion pixel
Field type metric
Data type int.number.value
TotalConversionRevenue03
Field label Total conversion 03 revenue
Description Total conversion revenue combining click conversion and view through conversion revenues from 03 conversion pixel
Field type metric
Data type float.currency.value
TotalConversion04
Field label Total conversion 04
Description Total conversion combining click conversion and view through conversion from 04 conversion pixel
Field type metric
Data type int.number.value
TotalConversionRevenue04
Field label Total conversion 04 revenue
Description Total conversion revenue combining click conversion and view through conversion revenues from 04 conversion pixel
Field type metric
Data type float.currency.value
TotalConversion05
Field label Total conversion 05
Description Total conversion combining click conversion and view through conversion from 05 conversion pixel
Field type metric
Data type int.number.value
TotalConversionRevenue05
Field label Total conversion 05 revenue
Description Total conversion revenue combining click conversion and view through conversion revenues from 05 conversion pixel
Field type metric
Data type float.currency.value
TotalConversion06
Field label Total conversion 06
Description Total conversion combining click conversion and view through conversion from 06 conversion pixel
Field type metric
Data type int.number.value
TotalConversionRevenue06
Field label Total conversion 06 revenue
Description Total conversion revenue combining click conversion and view through conversion revenues from 06 conversion pixel
Field type metric
Data type float.currency.value
TotalClickConversions
Field label Click conversions
Description Total click conversions combining click conversions from 01-06 conversion pixels
Field type metric
Data type int.number.value
CpaClick
Field label Cost per click conversion
Description Cost per click conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Field type metric
Data type float.currency.value
TotalClickConversionRevenue
Field label Click conversion revenue
Description Total click conversion revenue combining click conversion revenue from 01-06 conversion pixels
Field type metric
Data type float.currency.value
TotalViewThroughConversions
Field label View-through conversions
Description Total view-through conversions combining view-through conversions from 01-06 conversion pixels
Field type metric
Data type int.number.value
CpaView
Field label Cost per view-through conversion
Description Cost per view-through conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Field type metric
Data type float.currency.value
TotalViewThroughConversionRevenue
Field label View-through conversion revenue
Description Total view-through conversion revenue combining view-through conversion revenue from 01-06 conversion pixels
Field type metric
Data type float.currency.value
TotalConversionTouch
Field label Touch conversions
Description Total touch conversions combining touch conversions from 01-06 conversion pixels
Field type metric
Data type int.number.value
CpaTouch
Field label Cost per touch conversion
Description Cost per touch conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Field type metric
Data type float.currency.value
TotalConversionTouchRevenue
Field label Touch conversion revenue
Description Total touch conversion revenue combining touch conversion revenue from 01-06 conversion pixels
Field type metric
Data type float.currency.value
TotalTimeWeightedDecayConversions
Field label Time-weighted decay conversions
Description Total time-weighted decay conversions combining time-weighted decay conversions from 01-06 conversion pixels
Field type metric
Data type int.number.value
CpaTimeWeightedDecay
Field label Cost per time-weighted decay conversion
Description Cost per time-weighted decay conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Field type metric
Data type float.currency.value
TotalTimeWeightedDecayConversionRevenue
Field label Time-weighted decay conversion revenue
Description Total time-weighted decay conversion revenue combining time-weighted decay conversion revenue from 01-06 conversion pixels
Field type metric
Data type float.currency.value
SampledTrackedImpressions
Field label Sampled tracked impressions
Description Number of sampled tracked impressions
Field type metric
Data type int.number.value
SampledViewedImpressions
Field label Sampled viewed impressions
Description Number of sampled viewed impressions
Field type metric
Data type int.number.value
Bids
Field label Bids
Description Number of bids
Field type metric
Data type int.number.value
TotalBidAmountUsd
Field label Total bid amount (USD)
Description Total bid amount in USD
Field type metric
Data type float.currency.value
TotalBidAmountAdvCurrency
Field label Total bid amount (adv currency)
Description Total bid amount in advertiser's currency
Field type metric
Data type float.currency.value
TotalBidAmountPartnerCurrency
Field label Total bid amount (partner currency)
Description Total bid amount in partner's currency
Field type metric
Data type float.currency.value

PLATFORM

DeviceType
Field label Device type
Description Type of the device
Field type dimension
Data type string.text.value
OperatingSystemVersion
Field label Operating system version
Description Operating system version of the device
Field type dimension
Data type string.text.value
OperatingSystem
Field label Operating system
Description Operating system family of the device
Field type dimension
Data type string.text.value
Browser
Field label Browser
Description The name of used browser
Field type dimension
Data type string.text.value

PLAYER

PlayerViews
Field label Player views
Description Number of views in player
Field type metric
Data type int.number.value
PlayerEngagedViews
Field label Player engaged views
Description Number of player engaged views
Field type metric
Data type int.number.value
PlayerCompletedViews
Field label Player completed views
Description Player completed views
Field type metric
Data type int.number.value
PlayerStarts
Field label Player starts
Description Number of starts in player
Field type metric
Data type int.number.value
PlayerMute
Field label Player mute
Description Number of times player muted
Field type metric
Data type int.number.value
PlayerUnmute
Field label Player unmute
Description Number of times player unmuted
Field type metric
Data type int.number.value
PlayerPause
Field label Player pause
Description Number of times player paused
Field type metric
Data type int.number.value
PlayerResume
Field label Player resume
Description Number of times player resumed
Field type metric
Data type int.number.value
PlayerFullscreen
Field label Player full screen
Description Number of times player switched fullscreen
Field type metric
Data type int.number.value
PlayerErrors
Field label Player errors
Description Number of player errors
Field type metric
Data type int.number.value
PlayerSkip
Field label Player skip
Description Number of times player skiped
Field type metric
Data type int.number.value
PlayerRewind
Field label Player rewind
Description Number of times player rewind
Field type metric
Data type int.number.value
PlayerExpansion
Field label Player expansion
Description Number of times player expanded
Field type metric
Data type int.number.value
PlayerCollapse
Field label Player collapse
Description Number of times player collapsed
Field type metric
Data type int.number.value
PlayerClose
Field label Player close
Description Number of times player closed
Field type metric
Data type int.number.value
PlayerInvitationAccept
Field label Player invitation accept
Description Number of times player invitation accepted
Field type metric
Data type int.number.value
Player25Complete
Field label Player 25% complete
Description Player 25% complete views
Field type metric
Data type int.number.value
Player50Complete
Field label Player 50% complete
Description Player 50% complete views
Field type metric
Data type int.number.value
Player75Complete
Field label Player 75% complete
Description Player 75% complete views
Field type metric
Data type int.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

RECENCY

RecencyGroup
Field label Recency group
Description Recency group
Field type dimension
Data type string.text.value
RecencyGroupStart
Field label Recency group start
Description Recency group start in minutes
Field type dimension
Data type int.number.value
RecencyGroupEnd
Field label Recency group end
Description Recency group end in minutes
Field type dimension
Data type int.number.value

SUPPLY VENDOR

SupplyVendorIntegerID
Field label Supply vendor integer ID
Description ID (integer) of the supply vendor
Field type dimension
Data type string.text.value
SupplyVendor
Field label Supply vendor
Description Name of the supply vendor
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
yearOfWeek
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
yearOfWeekIso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
yearMonth
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
yearWeek
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
yearWeekIso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
weekIso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
dayOfMonth
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
dayOfWeekName
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
dayOfWeekNameIso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
timeZone
Field label Time zone
Field type dimension
Data type string.time.timezone