Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Field list for The Trade Desk

111 metrics and 151 dimensions available

CategoryFieldCodeTypeDescription
TIMEYearyeardim
Year of week (Sun-Sat)yearOfWeekdim
Year of week (Mon-Sun)yearOfWeekIsodim
Year & monthyearMonthdim
Monthmonthdim
Year & week (Sun-Sat)yearWeekdim
Year & week (Mon-Sun)yearWeekIsodim
Week (Sun-Sat)weekdim
Week (Mon-Sun)weekIsodim
Day of monthdayOfMonthdim
Day of week (Sun-Sat)dayOfWeekNamedim
Day of week (Mon-Sun)dayOfWeekNameIsodim
Datedatedim
Time zonetimeZonedim
PARTNERPartner IDPartnerIddimID of the partner
Partner currency codePartnerCurrencyCodedimCode of the partner currency
ADVERTISERAdvertiser IDAdvertiserIddimID of the advertiser
Advertiser nameAdvertiserNamedimName of the advertiser
Advertiser descriptionAdvertiserDescriptiondimDescription of the advertiser
Advertiser currency codeAdvertiserCurrencyCodedimThree-letter currency code of the advertiser
Advertiser keywordsAdvertiserKeywordsdimKeywords that classify the advertiser
Advertiser availabilityAdvertiserAvailabilitydimAvailability state of the advertiser
Advertiser logo URLAdvertiserLogoUrldimURL for the Advertiser's logo or brand image
Advertiser domain addressAdvertiserDomainAddressdimThe domain address (including http:// or https://) for the advertiser
Advertiser dimensional bidding supportedAdvertiserIsDimensionalBiddingModeSupporteddimWhether or not dimensional bidding mode (Megagon) mode is supported for the advertiser
Advertiser's referral URL ignored in conversionAdvertiserIgnoreReferralUrlInConversiondimWhether or not conversions with deduplication key different only in referral url are considered duplicates for the advertiser
DEALDeal IDDealIddimID of the deal
CAMPAIGNCampaign IDCampaignIddimID of the campaign
Campaign nameCampaignNamedimName of the campaign
Campaign typeCampaignTypedimType of the campaign
Campaign availabilityCampaignAvailabilitydimAvailability of the campaign
Campaign descriptionCampaignDescriptiondimDescription of the campaign
Campaign budget amountCampaignBudgetAmountdimThe maximum amount the campaign may spend
Campaign budget currencyCampaignBudgetCurrencydimBudget currency of the campaign
Campaign budget in impressionsCampaignBudgetInImpressionsdimThe maximum amount of impressions the campaign should buy
Campaign daily budget amountCampaignDailyBudgetAmountdimThe total amount the campaign should spend in a single day, if able
Campaign daily budget currencyCampaignDailyBudgetCurrencydimDaily budget currency of the campaign
Campaign daily budget in impressionsCampaignDailyBudgetInImpressionsdimThe total number of impressions the campaign should buy in a single day, if able
Campaign start dateCampaignStartdimThe date that the campaign should start spending
Campaign end dateCampaignEnddimThe date that the campaign should stop spending if it has not yet exhausted its budget
Campaign start date and timeCampaignStartDatetimedimThe date and time (in UTC) that the campaign should start spending
Campaign end date and timeCampaignEndDatetimedimThe date and time (in UTC) that the campaign should stop spending if it has not yet exhausted its budget
Campaign created dateCampaignCreateddimThe date the campaign was created
Campaign updated dateCampaignUpdateddimThe date the campaign was last updated
Campaign auto allocator enabledCampaignAutoAllocatorEnableddimWhether auto allocator is enabled or not
Campaign auto prioritization enabledCampaignAutoPrioritizationEnableddimFlag that allows the system to auto prioritize ad groups when AutoAllocatorâ„¢ is turned on
Campaign minimum ad group spend in advertiser currencyCampaignMinimumAdGroupSpendInAdvertiserCurrencydimEach ad group in the campaign will spend this minimum amount daily (if there's enough spend potential)
Campaign pacing modeCampaignPacingModedimPacing mode of the campaign
Campaign labelsCampaignCustomLabelsdimCustom labels assigned to this campaign
Campaign CPA click weightCampaignCustomCPAClickWeightdimWeight to assign to click through pixels when calculating custom CPA
Campaign CPA view weightCampaignCustomCPAViewthroughWeightdimWeight to assign to view pixels when calculating custom CPA
Campaign CTV targeting/attributionCampaignCtvTargetingAndAttributiondimFlag that extends audience to include Connected TV (CTV) devices and include CTV in standard attribution
AD GROUPAd group IDAdGroupIddimID of the ad group
Ad group nameAdGroupNamedimName of the ad group
Ad group descriptionAdGroupDescriptiondimDescription of the ad group
Ad group enabledAdGroupIsEnableddimWhether the ad group is enabled to spend
Ad group is high fill rateAdGroupIsHighFillRatedimWhether the ad group is a high fill rate ad group
Ad group availabilityAdGroupAvailabilitydimWhether the ad group is active and available for normal operation or archived and hidden from normal view
Ad group created dateAdGroupCreateddimThe date the ad group was created
Ad group updated dateAdGroupUpdateddimThe date the ad group was last updated
Ad group labelsAdGroupCustomLabelsdimCustom labels assigned to this ad group
Ad group is classicAdGroupIsClassicdimIf true, this ad group's settings will be shown using the Classic UI instead of the Megagon UI
Ad group Koa features enabledAdGroupAreFutureKoaFeaturesEnableddimWhether future Koa features will be enabled for this Ad Group automatically
Ad group predictive clearingAdGroupPredictiveClearingEnableddimWhether predictive clearing is enabled/disabled for this ad group
Ad group identity allianceAdGroupUseIdentityAlliancedimWhether the selection of the cross device graphs used to extend the ad group's targeting is controlled by the system
Ad group budget in impressionsAdGroupBudgetInImpressionsdimAd group budget in impressions
Ad group budget (adv currency)AdGroupBudgetAdvCurrencydimAd group budget in advertiser's currency
Ad group daily cap in impressionsAdGroupDailyCapInImpressionsdimAd group daily cap in impressions
Ad group daily target in impressionsAdGroupDailyTargetInImpressionsdimAd group daily target in impressions
Ad group daily cap (adv currency)AdGroupDailyCapAdvCurrencydimAd group daily cap in advertiser's currency
Ad group daily target (adv currency)AdGroupDailyTargetAdvCurrencydimAd group daily target in advertiser's currency
Ad group base bid CPM (adv currency)AdGroupBaseBidCpmAdvCurrencydimAd group base bid clicks per thousand impressions in advertiser's currency
ADCreative IDCreativeIddimID of the creative
Creative nameCreativeNamedimName of the creative
Creative descriptionCreativeDescriptiondimDescription of the creative
Creative typeCreativeTypedimType of the creative
Creative availabilityCreativeAvailabilitydimIndicates whether the creative is available for use or archived and hidden from views
Creative imageCreativeImagedimCreative image of the ad
Creative image URLCreativeImageUrldimThe URL where The Trade Desk has stored the image file for ad serving
Creative image landing URLCreativeImageLandingPageUrldimLanding page URL of the creative image
Creative flight startCreativeFlightStartdimThe flight start date (without the time zone) for the creative
Creative flight end dateCreativeFlightEnddimThe flight end date (without the time zone) for the creative
Creative flight start date and timeCreativeFlightStartDatetimedimThe flight start date and time in UTC (without the time zone) for the creative
Creative flight end date and timeCreativeFlightEndDatetimedimThe flight end date and time in UTC (without the time zone) for the creative
Creative created dateCreativeCreateddimThe date the creative was created
Creative updated dateCreativeUpdateddimThe date the creative was last updated
Creative share linkCreativeShareLinkdimShare link to allow anyone to preview this creative
Creative served in ChinaCreativeServedInChinadimFlag to indicate this creative will be served in China or not
Ad server creative placement IDAdServerCreativePlacementIDdimPlacement ID of the creative on ad server
Ad server nameAdServerNamedimName of the ad server
Ad formatAdFormatdimAd format (width x height)
FrequencyFrequencydimHow frequently an ad was shown to a single use, bucketed by frequency within the past 24 hours. "0" means that one ad was shown
AUDIENCEAudience IDAudienceIDdimID of the audience
Audience nameAudienceNamedimName of the audience
Audience descriptionAudienceDescriptiondimDescription of the audience
Audience auto generatedAudienceIsAutoGenerateddimIndicates if this audience was automatically generated by The Trade Desk platform
Audience geo for countsAudienceGeoForCountsdimThe geo (country or continent) that the counts for this audience should be filtered to
Audience unique user countAudienceUniqueUserCountdimThe number of devices/browsers in the audience
Audience persons countAudiencePersonsCountdimThe number of persons in the audience
Audience household countAudienceHouseholdCountdimThe number of households in this audience
CATEGORYCategory nameCategoryNamedimName of the category
Industry category IDIndustryCategoryIddimID of the industry category
Industry category nameIndustryCategoryNamedimName of the industry category
Industry category pathIndustryCategoryPathdimPath of the industry category
Industry category parent IDIndustryCategoryParentIddimParent ID of the industry category
SUPPLY VENDORSupply vendor integer IDSupplyVendorIntegerIDdimID (integer) of the supply vendor
Supply vendorSupplyVendordimName of the supply vendor
INVENTORYSiteSitedimName of the site
Site/category bid factorSiteCategoryBidFactordimBid factor of the site/category
FoldFolddim
Fold bid factorFoldBidFactordimFactor of the fold bid
LanguageLanguagedimLanguage of the inventory
PLATFORMDevice typeDeviceTypedimType of the device
Operating system versionOperatingSystemVersiondimOperating system version of the device
Operating systemOperatingSystemdimOperating system family of the device
BrowserBrowserdimThe name of used browser
RECENCYRecency groupRecencyGroupdimRecency group
Recency group startRecencyGroupStartdimRecency group start in minutes
Recency group endRecencyGroupEnddimRecency group end in minutes
DATA ELEMENTData elementDataElementdimData element
1st party data ID1stPartyDataIDdimID of the 1st party data
3rd party data ID3rdPartyDataIDdimID of the 3rd party data
3rd party data brand ID3rdPartyDataBrandIDdimBrand ID of the 3rd party data
3rd party data brand3rdPartyDataBranddimBrand of the 3rd party data
GEOCountryCountrydimCountry
Country codeCountryCodedimTwo-letter country code
RegionRegiondimRegion
MetroMetrodimMetro
CityCitydimCity
CONVERSIONSClick conversion currency 01ClickConversionCurrency01dim01 - currency of the click conversion
Click conversion currency 02ClickConversionCurrency02dim02 - currency of the click conversion
Click conversion currency 03ClickConversionCurrency03dim03 - currency of the click conversion
Click conversion currency 04ClickConversionCurrency04dim04 - currency of the click conversion
Click conversion currency 05ClickConversionCurrency05dim05 - currency of the click conversion
Click conversion currency 06ClickConversionCurrency06dim06 - currency of the click conversion
View through conversion currency 01ViewThroughConversionCurrency01dim01 - currency of the view through conversion
View through conversion currency 02ViewThroughConversionCurrency02dim02 - currency of the view through conversion
View through conversion currency 03ViewThroughConversionCurrency03dim03 - currency of the view through conversion
View through conversion currency 04ViewThroughConversionCurrency04dim04 - currency of the view through conversion
View through conversion currency 05ViewThroughConversionCurrency05dim05 - currency of the view through conversion
View through conversion currency 06ViewThroughConversionCurrency06dim06 - currency of the view through conversion
DEPRECATEDSite list permissionsSiteListPermissionsdimPermissions of the site list. Please note that this field will be removed on 2021-03-31
Site list IDSiteListIDdimID of the site list. Please note that this field will be removed on 2021-03-31
Site list nameSiteListNamedimName of the site list. Please note that this field will be removed on 2021-03-31
Creative integer IDCreativeIntegerIDdimID (integer) of the creative. Please note that this field will be removed on 2021-10-19
AppAppdimName of the app. Please note that this field will be removed on 2021-10-19
Ad group integer IDAdGroupIntegerIDdimID (integer) of the ad group. Please note that this field will be removed on 2021-10-19
Campaign integer IDCampaignIntegerIDdimID (integer) of the campaign. Please note that this field will be removed on 2021-10-19
Advertiser integer IDAdvertiserIntegerIDdimID (integer) of the advertiser. Please note that this field will be removed on 2021-10-19
Partner integer IDPartnerIntegerIDdimID (integer) of the partner. Please note that this field will be removed on 2021-10-19
Site list descriptionSiteListDescriptiondimDescription of the site list. Please note that this field will be removed on 2021-03-31
PERFORMANCEImpressionsImpressionsmetNumber of impressions
ClicksClicksmetNumber of clicks
CTRCtrmetClick-through ratio
CPMCpmmetCost per 1000 impressions. Calculated from Advertiser cost in Advertiser currency
CPCCpcmetCost per click. Calculated from Advertiser cost in Advertiser currency
Total conversion 01TotalConversion01metTotal conversion combining click conversion and view through conversion from 01 conversion pixel
Total conversion 01 revenueTotalConversionRevenue01metTotal conversion revenue combining click conversion and view through conversion revenues from 01 conversion pixel
Total conversion 02TotalConversion02metTotal conversion combining click conversion and view through conversion from 02 conversion pixel
Total conversion 02 revenueTotalConversionRevenue02metTotal conversion revenue combining click conversion and view through conversion revenues from 02 conversion pixel
Total conversion 03TotalConversion03metTotal conversion combining click conversion and view through conversion from 03 conversion pixel
Total conversion 03 revenueTotalConversionRevenue03metTotal conversion revenue combining click conversion and view through conversion revenues from 03 conversion pixel
Total conversion 04TotalConversion04metTotal conversion combining click conversion and view through conversion from 04 conversion pixel
Total conversion 04 revenueTotalConversionRevenue04metTotal conversion revenue combining click conversion and view through conversion revenues from 04 conversion pixel
Total conversion 05TotalConversion05metTotal conversion combining click conversion and view through conversion from 05 conversion pixel
Total conversion 05 revenueTotalConversionRevenue05metTotal conversion revenue combining click conversion and view through conversion revenues from 05 conversion pixel
Total conversion 06TotalConversion06metTotal conversion combining click conversion and view through conversion from 06 conversion pixel
Total conversion 06 revenueTotalConversionRevenue06metTotal conversion revenue combining click conversion and view through conversion revenues from 06 conversion pixel
Click conversionsTotalClickConversionsmetTotal click conversions combining click conversions from 01-06 conversion pixels
Cost per click conversionCpaClickmetCost per click conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Click conversion revenueTotalClickConversionRevenuemetTotal click conversion revenue combining click conversion revenue from 01-06 conversion pixels
View-through conversionsTotalViewThroughConversionsmetTotal view-through conversions combining view-through conversions from 01-06 conversion pixels
Cost per view-through conversionCpaViewmetCost per view-through conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
View-through conversion revenueTotalViewThroughConversionRevenuemetTotal view-through conversion revenue combining view-through conversion revenue from 01-06 conversion pixels
Touch conversionsTotalConversionTouchmetTotal touch conversions combining touch conversions from 01-06 conversion pixels
Cost per touch conversionCpaTouchmetCost per touch conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Touch conversion revenueTotalConversionTouchRevenuemetTotal touch conversion revenue combining touch conversion revenue from 01-06 conversion pixels
Time-weighted decay conversionsTotalTimeWeightedDecayConversionsmetTotal time-weighted decay conversions combining time-weighted decay conversions from 01-06 conversion pixels
Cost per time-weighted decay conversionCpaTimeWeightedDecaymetCost per time-weighted decay conversion from conversion pixels 01-06. Calculated from advertiser cost in advertiser currency
Time-weighted decay conversion revenueTotalTimeWeightedDecayConversionRevenuemetTotal time-weighted decay conversion revenue combining time-weighted decay conversion revenue from 01-06 conversion pixels
Sampled tracked impressionsSampledTrackedImpressionsmetNumber of sampled tracked impressions
Sampled viewed impressionsSampledViewedImpressionsmetNumber of sampled viewed impressions
BidsBidsmetNumber of bids
Total bid amount (USD)TotalBidAmountUsdmetTotal bid amount in USD
Total bid amount (adv currency)TotalBidAmountAdvCurrencymetTotal bid amount in advertiser's currency
Total bid amount (partner currency)TotalBidAmountPartnerCurrencymetTotal bid amount in partner's currency
CONVERSIONSClick conversion 01ClickConversion01met01 - click conversion
Click conversion 02ClickConversion02met02 - click conversion
Click conversion 03ClickConversion03met03 - click conversion
Click conversion 04ClickConversion04met04 - click conversion
Click conversion 05ClickConversion05met05 - click conversion
Click conversion 06ClickConversion06met06 - click conversion
Click conversion 01 revenueClickConversion01Revenuemet01 - revenue of the click conversion
Click conversion 02 revenueClickConversion02Revenuemet02 - revenue of the click conversion
Click conversion 03 revenueClickConversion03Revenuemet03 - revenue of the click conversion
Click conversion 04 revenueClickConversion04Revenuemet04 - revenue of the click conversion
Click conversion 05 revenueClickConversion05Revenuemet05 - revenue of the click conversion
Click conversion 06 revenueClickConversion06Revenuemet06 - revenue of the click conversion
View through conversion 01ViewThroughConversion01met01 - view through conversion
View through conversion 02ViewThroughConversion02met02 - view through conversion
View through conversion 03ViewThroughConversion03met03 - view through conversion
View through conversion 04ViewThroughConversion04met04 - view through conversion
View through conversion 05ViewThroughConversion05met05 - view through conversion
View through conversion 06ViewThroughConversion06met06 - view through conversion
View through conversion 01 revenueViewThroughConversion01Revenuemet01 - view-through conversion revenue
View through conversion 02 revenueViewThroughConversion02Revenuemet02 - revenue of the view through conversion
View through conversion 03 revenueViewThroughConversion03Revenuemet03 - revenue of the view through conversion
View through conversion 04 revenueViewThroughConversion04Revenuemet04 - revenue of the view through conversion
View through conversion 05 revenueViewThroughConversion05Revenuemet05 - view-through conversion revenue
View through conversion 06 revenueViewThroughConversion06Revenuemet06 - view-through conversion revenue
Conversion touch 01ConversionTouch01met01 - conversion touch
Conversion touch 02ConversionTouch02met02 - conversion touch
Conversion touch 03ConversionTouch03met03 - conversion touch
Conversion touch 04ConversionTouch04met04 - conversion touch
Conversion touch 05ConversionTouch05met05 - conversion touch
Conversion touch 06ConversionTouch06met06 - conversion touch
Conversion touch 01 revenueConversionTouch01Revenuemet01 - conversion touch revenue
Conversion touch 02 revenueConversionTouch02Revenuemet02 - conversion touch revenue
Conversion touch 03 revenueConversionTouch03Revenuemet03 - conversion touch revenue
Conversion touch 04 revenueConversionTouch04Revenuemet04 - conversion touch revenue
Conversion touch 05 revenueConversionTouch05Revenuemet05 - conversion touch revenue
Conversion touch 06 revenueConversionTouch06Revenuemet06 - conversion touch revenue
Time weighted decay conversion 01TimeWeightedDecayConversion01met01 - time weighted decay conversion
Time weighted decay conversion 02TimeWeightedDecayConversion02met02 - time weighted decay conversion
Time weighted decay conversion 03TimeWeightedDecayConversion03met03 - time weighted decay conversion
Time weighted decay conversion 04TimeWeightedDecayConversion04met04 - time weighted decay conversion
Time weighted decay conversion 05TimeWeightedDecayConversion05met05 - time weighted decay conversion
Time weighted decay conversion 06TimeWeightedDecayConversion06met06 - time weighted decay conversion
Time weighted decay conversion 01 revenueTimeWeightedDecayConversion01Revenuemet01 - time weighted decay conversion revenue
Time weighted decay conversion 02 revenueTimeWeightedDecayConversion02Revenuemet02 - time weighted decay conversion revenue
Time weighted decay conversion 03 revenueTimeWeightedDecayConversion03Revenuemet03 - time weighted decay conversion revenue
Time weighted decay conversion 04 revenueTimeWeightedDecayConversion04Revenuemet04 - time weighted decay conversion revenue
Time weighted decay conversion 05 revenueTimeWeightedDecayConversion05Revenuemet05 - time weighted decay conversion revenue
Time weighted decay conversion 06 revenueTimeWeightedDecayConversion06Revenuemet06 - time weighted decay conversion revenue
PLAYERPlayer viewsPlayerViewsmetNumber of views in player
Player engaged viewsPlayerEngagedViewsmetNumber of player engaged views
Player completed viewsPlayerCompletedViewsmetPlayer completed views
Player startsPlayerStartsmetNumber of starts in player
Player mutePlayerMutemetNumber of times player muted
Player unmutePlayerUnmutemetNumber of times player unmuted
Player pausePlayerPausemetNumber of times player paused
Player resumePlayerResumemetNumber of times player resumed
Player full screenPlayerFullscreenmetNumber of times player switched fullscreen
Player errorsPlayerErrorsmetNumber of player errors
Player skipPlayerSkipmetNumber of times player skiped
Player rewindPlayerRewindmetNumber of times player rewind
Player expansionPlayerExpansionmetNumber of times player expanded
Player collapsePlayerCollapsemetNumber of times player collapsed
Player closePlayerClosemetNumber of times player closed
Player invitation acceptPlayerInvitationAcceptmetNumber of times player invitation accepted
Player 25% completePlayer25CompletemetPlayer 25% complete views
Player 50% completePlayer50CompletemetPlayer 50% complete views
Player 75% completePlayer75CompletemetPlayer 75% complete views
COSTTTD cost (USD)TtdCostUsdmetThe Trade Desk cost in USD
TTD cost (adv currency)TtdCostAdvCurrencymetThe Trade Desk cost in advertiser's currency
TTD cost (partner currency)TtdCostPartnerCurrencymetThe Trade Desk cost in partner's currency
Partner cost (USD)PartnerCostUsdmetPartner cost in USD
Partner cost (adv currency)PartnerCostAdvCurrencymetPartner cost in advertiser's currency
Partner cost (partner currency)PartnerCostPartnerCurrencymetPartner cost in partner's currency
Advertiser cost (USD)AdvertiserCostUSDmetAdvertiser cost in USD
Advertiser cost (adv currency)AdvertiserCostAdvCurrencymetAdvertiser cost in advertiser's currency
Advertiser cost (partner currency)AdvertiserCostPartnerCurrencymetAdvertiser cost in partner's currency