Introduction

Datasources and destinations

Fields listing for The Trade Desk

Advertiser Brand Owner
Field IDadvertiser.brandOwner
TypeTEXT
Data Typedimension
Advertiser Channel Count
Field IDadvertiser.channelCount
TypeNUMBER
Data Typedimension
Advertiser Click Dedupe Window In Seconds
Field IDadvertiser.clickDedupeWindowInSeconds
TypeTEXT
Data Typedimension
Advertiser Conversion De Dupe Window In Seconds
Field IDadvertiser.conversionDeDupeWindowInSeconds
TypeTEXT
Data Typedimension
Advertiser Has Available Seed Pixels
Field IDadvertiser.hasAvailableSeedPixels
TypeBOOLEAN
Data Typedimension
Advertiser Id
Field IDadvertiser.id
TypeTEXT
Data Typedimension
Advertiser Ignore Referral Url In Conversion
Field IDadvertiser.ignoreReferralUrlInConversion
TypeTEXT
Data Typedimension
Advertiser Is Archived
Field IDadvertiser.isArchived
TypeBOOLEAN
Data Typedimension
Advertiser Is Blocked From Hh Solution
Field IDadvertiser.isBlockedFromHhSolution
TypeBOOLEAN
Data Typedimension
Advertiser Is Favorite For User
Field IDadvertiser.isFavoriteForUser
TypeBOOLEAN
Data Typedimension
Advertiser Is Hec Auto Exempt
Field IDadvertiser.isHecAutoExempt
TypeBOOLEAN
Data Typedimension
Advertisers Is Marketplace Enabled By Default
Field IDadvertiser.isMarketplaceEnabledByDefault
TypeBOOLEAN
Data Typedimension
Advertisers Is Restricted For Distributed Algos
Field IDadvertiser.isRestrictedForDistributedAlgos
TypeBOOLEAN
Data Typedimension
Advertisers Is With Campaigns At Risk
Field IDadvertiser.isWithCampaignsAtRisk
TypeBOOLEAN
Data Typedimension
Advertisers Is With Live Campaigns
Field IDadvertiser.isWithLiveCampaigns
TypeBOOLEAN
Data Typedimension
Advertisers Keywords
Field IDadvertiser.keywords
TypeTEXT
Data Typedimension
Advertisers Logo
Field IDadvertiser.logo
TypeTEXT
Data Typedimension
Advertisers Name Dsa
Field IDadvertiser.nameDSA
TypeTEXT
Data Typedimension
Advertisers Name
Field IDadvertiser.name
TypeTEXT
Data Typedimension
Advertisers Payer Name Dsa
Field IDadvertiser.payerNameDSA
TypeTEXT
Data Typedimension
Advertisers Secret Key
Field IDadvertiser.secretKey
TypeTEXT
Data Typedimension
Advertisers Suggested Measurement Provider Categories
Field IDadvertiser.suggestedMeasurementProviderCategories
TypeTEXT
Data Typedimension
Advertisers Total Campaign Channel Count
Field IDadvertiser.totalCampaignChannelCount
TypeNUMBER
Data Typedimension
Advertisers Total Funnel Location Count
Field IDadvertiser.totalFunnelLocationCount
TypeNUMBER
Data Typedimension
Advertisers Use Impressions Only Budgeting
Field IDadvertiser.useImpressionsOnlyBudgeting
TypeBOOLEAN
Data Typedimension
Advertisers Use Media Cost Basis For Campaign Fees
Field IDadvertiser.useMediaCostBasisForCampaignFees
TypeBOOLEAN
Data Typedimension
Advertisers Vetting Status
Field IDadvertiser.vettingStatus
TypeTEXT
Data Typedimension
Campaigns Active Ad Group Count
Field IDadvertiser.campaigns.activeAdGroupCount
TypeNUMBER
Data Typedimension
Campaigns Auto Allocator Enabled
Field IDadvertiser.campaigns.autoAllocatorEnabled
TypeBOOLEAN
Data Typedimension
Campaigns Auto Campaign Cap Enabled
Field IDadvertiser.campaigns.autoCampaignCapEnabled
TypeBOOLEAN
Data Typedimension
Campaigns Auto Prioritization Enabled
Field IDadvertiser.campaigns.autoPrioritizationEnabled
TypeBOOLEAN
Data Typedimension
Campaigns Budget In Impressions
Field IDadvertiser.campaigns.budgetInImpressions
TypeNUMBER
Data Typedimension
Campaigns Channel Type
Field IDadvertiser.campaigns.channelType
TypeTEXT
Data Typedimension
Campaigns Created At
Field IDadvertiser.campaigns.createdAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Campaigns Created At Utc
Field IDadvertiser.campaigns.createdAtUtc
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Campaigns Custom Cpa Click Weight
Field IDadvertiser.campaigns.customCPAClickWeight
TypeNUMBER
Data Typedimension
Campaigns Custom Cpa Type
Field IDadvertiser.campaigns.customCPAType
TypeTEXT
Data Typedimension
Campaigns Custom Cpa Viewthrough Weight
Field IDadvertiser.campaigns.customCPAViewthroughWeight
TypeNUMBER
Data Typedimension
Campaigns Custom Roas Type
Field IDadvertiser.campaigns.customROASType
TypeTEXT
Data Typedimension
Campaigns Description
Field IDadvertiser.campaigns.description
TypeTEXT
Data Typedimension
Campaigns End Date
Field IDadvertiser.campaigns.endDate
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Campaigns Funnel Location Count
Field IDadvertiser.campaigns.funnelLocationCount
TypeNUMBER
Data Typedimension
Campaigns Funnel Locations
Field IDadvertiser.campaigns.funnelLocations
TypeTEXT
Data Typedimension
Campaigns Id
Field IDadvertiser.campaigns.id
TypeTEXT
Data Typedimension
Campaigns Impressions Only Budgeting Cpm
Field IDadvertiser.campaigns.impressionsOnlyBudgetingCPM
TypeNUMBER
Data Typedimension
Campaigns Io Contract Id
Field IDadvertiser.campaigns.ioContractId
TypeTEXT
Data Typedimension
Campaigns Is Archived
Field IDadvertiser.campaigns.isArchived
TypeBOOLEAN
Data Typedimension
Campaigns Is I Spot Enabled
Field IDadvertiser.campaigns.isISpotEnabled
TypeBOOLEAN
Data Typedimension
Campaigns Is Managed By Ttd
Field IDadvertiser.campaigns.isManagedByTTD
TypeBOOLEAN
Data Typedimension
Campaigns Is Migrated To Kokai
Field IDadvertiser.campaigns.isMigratedToKokai
TypeBOOLEAN
Data Typedimension
Campaigns Is Programmatic Guaranteed
Field IDadvertiser.campaigns.isProgrammaticGuaranteed
TypeBOOLEAN
Data Typedimension
Campaigns Is Template
Field IDadvertiser.campaigns.isTemplate
TypeBOOLEAN
Data Typedimension
Campaigns Is Tv Squared Enabled
Field IDadvertiser.campaigns.isTvSquaredEnabled
TypeBOOLEAN
Data Typedimension
Campaigns Last Touch Attribution Measured By The Trade Desk
Field IDadvertiser.campaigns.lastTouchAttributionMeasuredByTheTradeDesk
TypeTEXT
Data Typedimension
Campaigns Last Updated
Field IDadvertiser.campaigns.lastUpdated
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Campaigns Last Updated At Utc
Field IDadvertiser.campaigns.lastUpdatedAtUtc
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Campaigns Minimum Ad Group Spend In Advertiser Currency
Field IDadvertiser.campaigns.minimumAdGroupSpendInAdvertiserCurrency
TypeNUMBER
Data Typedimension
Campaigns Name
Field IDadvertiser.campaigns.name
TypeTEXT
Data Typedimension
Campaigns Objective
Field IDadvertiser.campaigns.objective
TypeTEXT
Data Typedimension
Campaigns Pacing Mode
Field IDadvertiser.campaigns.pacingMode
TypeTEXT
Data Typedimension
Campaigns Pacing To End Of Flight Daily Rate
Field IDadvertiser.campaigns.pacingToEndOfFlightDailyRate
TypeNUMBER
Data Typedimension
Campaigns Partner Cost Percentage Fee
Field IDadvertiser.campaigns.partnerCostPercentageFee
TypeNUMBER
Data Typedimension
Campaigns Purchase Order Number
Field IDadvertiser.campaigns.purchaseOrderNumber
TypeTEXT
Data Typedimension
Campaigns Share Type
Field IDadvertiser.campaigns.shareType
TypeTEXT
Data Typedimension
Campaigns Site Url
Field IDadvertiser.campaigns.siteUrl
TypeTEXT
Data Typedimension
Campaigns Start Date
Field IDadvertiser.campaigns.startDate
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Campaigns Status
Field IDadvertiser.campaigns.status
TypeTEXT
Data Typedimension
Campaigns Time Zone
Field IDadvertiser.campaigns.timeZone
TypeTEXT
Data Typedimension
Campaigns Time Zone Iana
Field IDadvertiser.campaigns.timeZoneIANA
TypeTEXT
Data Typedimension
Campaigns Total Ad Group Count
Field IDadvertiser.campaigns.totalAdGroupCount
TypeNUMBER
Data Typedimension
Campaigns Trading Mode
Field IDadvertiser.campaigns.tradingMode
TypeTEXT
Data Typedimension
Campaigns Type
Field IDadvertiser.campaigns.type
TypeTEXT
Data Typedimension
Campaigns Value Added Providers
Field IDadvertiser.campaigns.valueAddedProviders
TypeTEXT
Data Typedimension
Campaigns Version
Field IDadvertiser.campaigns.version
TypeTEXT
Data Typedimension
Ad Groups Applied Dimensions
Field IDadvertiser.campaigns.adGroups.appliedDimensions
TypeTEXT
Data Typedimension
Ad Groups Base Bid Cpm In Advertiser Currency
Field IDadvertiser.campaigns.adGroups.baseBidCPMInAdvertiserCurrency
TypeNUMBER
Data Typedimension
Ad Groups Budget In Advertiser Currency
Field IDadvertiser.campaigns.adGroups.budgetInAdvertiserCurrency
TypeNUMBER
Data Typedimension
Ad Groups Budget In Impressions
Field IDadvertiser.campaigns.adGroups.budgetInImpressions
TypeNUMBER
Data Typedimension
Ad Groups Campaign Stack Rank
Field IDadvertiser.campaigns.adGroups.campaignStackRank
TypeNUMBER
Data Typedimension
Ad Groups Channel
Field IDadvertiser.campaigns.adGroups.channel
TypeTEXT
Data Typedimension
Ad Groups Contract Floor Price As Base Bid Adjustment
Field IDadvertiser.campaigns.adGroups.contractFloorPriceAsBaseBidAdjustment
TypeTEXT
Data Typedimension
Ad Groups Created At
Field IDadvertiser.campaigns.adGroups.createdAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Ad Groups Deals Present
Field IDadvertiser.campaigns.adGroups.dealsPresent
TypeBOOLEAN
Data Typedimension
Ad Groups Description
Field IDadvertiser.campaigns.adGroups.description
TypeTEXT
Data Typedimension
Ad Groups Display Viewability Standard Integral
Field IDadvertiser.campaigns.adGroups.displayViewabilityStandardIntegral
TypeTEXT
Data Typedimension
Ad Groups Funnel Location
Field IDadvertiser.campaigns.adGroups.funnelLocation
TypeTEXT
Data Typedimension
Ad Groups Id
Field IDadvertiser.campaigns.adGroups.id
TypeTEXT
Data Typedimension
Ad Groups Is Archived
Field IDadvertiser.campaigns.adGroups.isArchived
TypeBOOLEAN
Data Typedimension
Ad Groups Is Dimensional Bidding Mode
Field IDadvertiser.campaigns.adGroups.isDimensionalBiddingMode
TypeBOOLEAN
Data Typedimension
Ad Groups Is Enabled
Field IDadvertiser.campaigns.adGroups.isEnabled
TypeBOOLEAN
Data Typedimension
Ad Groups Is High Fill Rate
Field IDadvertiser.campaigns.adGroups.isHighFillRate
TypeBOOLEAN
Data Typedimension
Ad Groups Is News Navigator Enabled
Field IDadvertiser.campaigns.adGroups.isNewsNavigatorEnabled
TypeBOOLEAN
Data Typedimension
Ad Groups Is Non Decisioned
Field IDadvertiser.campaigns.adGroups.isNonDecisioned
TypeBOOLEAN
Data Typedimension
Ad Groups Is Programmatic Guaranteed
Field IDadvertiser.campaigns.adGroups.isProgrammaticGuaranteed
TypeBOOLEAN
Data Typedimension
Ad Groups Is Quality Alliance Suite Enabled
Field IDadvertiser.campaigns.adGroups.isQualityAllianceSuiteEnabled
TypeBOOLEAN
Data Typedimension
Ad Groups Is Targeting Default On Endeavors
Field IDadvertiser.campaigns.adGroups.isTargetingDefaultOnEndeavors
TypeBOOLEAN
Data Typedimension
Ad Groups Is Targeting Deprecated Library Deals
Field IDadvertiser.campaigns.adGroups.isTargetingDeprecatedLibraryDeals
TypeBOOLEAN
Data Typedimension
Ad Groups Is Template
Field IDadvertiser.campaigns.adGroups.isTemplate
TypeBOOLEAN
Data Typedimension
Ad Groups Last Updated
Field IDadvertiser.campaigns.adGroups.lastUpdated
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Ad Groups Market Type
Field IDadvertiser.campaigns.adGroups.marketType
TypeTEXT
Data Typedimension
Ad Groups Max Bid Cpm In Advertiser Currency
Field IDadvertiser.campaigns.adGroups.maxBidCPMInAdvertiserCurrency
TypeNUMBER
Data Typedimension
Ad Groups Name
Field IDadvertiser.campaigns.adGroups.name
TypeTEXT
Data Typedimension
Ad Groups Pacing Grain Id
Field IDadvertiser.campaigns.adGroups.pacingGrainId
TypeTEXT
Data Typedimension
Ad Groups Private Contract Default Adjustment
Field IDadvertiser.campaigns.adGroups.privateContractDefaultAdjustment
TypeTEXT
Data Typedimension
Ad Groups Quality Alliance Viewability Profile
Field IDadvertiser.campaigns.adGroups.qualityAllianceViewabilityProfile
TypeTEXT
Data Typedimension
Ad Groups Status
Field IDadvertiser.campaigns.adGroups.status
TypeTEXT
Data Typedimension
Ad Groups Use Multiple Cross Device Vendors
Field IDadvertiser.campaigns.adGroups.useMultipleCrossDeviceVendors
TypeBOOLEAN
Data Typedimension
Ad Groups Value Added Providers
Field IDadvertiser.campaigns.adGroups.valueAddedProviders
TypeTEXT
Data Typedimension
Ad Groups Video Viewability Standard Integral
Field IDadvertiser.campaigns.adGroups.videoViewabilityStandardIntegral
TypeTEXT
Data Typedimension
Ad Groups Viewability Profile
Field IDadvertiser.campaigns.adGroups.viewabilityProfile
TypeTEXT
Data Typedimension
Creatives Ad Server Name
Field IDadvertiser.campaigns.adGroups.creatives.adServerName
TypeTEXT
Data Typedimension
Ad Format Display Name
Field IDadvertiser.campaigns.adGroups.creatives.adFormat.displayName
TypeTEXT
Data Typedimension
Ad Format Id
Field IDadvertiser.campaigns.adGroups.creatives.adFormat.id
TypeTEXT
Data Typedimension
Creatives Ad Server Creative Id
Field IDadvertiser.campaigns.adGroups.creatives.adServerCreativeId
TypeTEXT
Data Typedimension
Creatives Approved By
Field IDadvertiser.campaigns.adGroups.creatives.approvedBy
TypeTEXT
Data Typedimension
Creatives Created At
Field IDadvertiser.campaigns.adGroups.creatives.createdAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Creatives Description
Field IDadvertiser.campaigns.adGroups.creatives.description
TypeTEXT
Data Typedimension
Creatives Flight End
Field IDadvertiser.campaigns.adGroups.creatives.flightEnd
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Creatives Flight End Date Utc
Field IDadvertiser.campaigns.adGroups.creatives.flightEndDateUTC
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Creatives Flight Start
Field IDadvertiser.campaigns.adGroups.creatives.flightStart
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Creatives Flight Start Date Utc
Field IDadvertiser.campaigns.adGroups.creatives.flightStartDateUTC
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Creatives Flight Time Zone
Field IDadvertiser.campaigns.adGroups.creatives.flightTimeZone
TypeTEXT
Data Typedimension
Creatives Flight Time Zone Iana
Field IDadvertiser.campaigns.adGroups.creatives.flightTimeZoneIANA
TypeTEXT
Data Typedimension
Creatives Id
Field IDadvertiser.campaigns.adGroups.creatives.id
TypeTEXT
Data Typedimension
Creatives Id Integer
Field IDadvertiser.campaigns.adGroups.creatives.idInteger
TypeNUMBER
Data Typedimension
Creatives Interstitial Support Id
Field IDadvertiser.campaigns.adGroups.creatives.interstitialSupportId
TypeTEXT
Data Typedimension
Creatives Is Archived
Field IDadvertiser.campaigns.adGroups.creatives.isArchived
TypeBOOLEAN
Data Typedimension
Creatives Is Click Tracking Successful
Field IDadvertiser.campaigns.adGroups.creatives.isClickTrackingSuccessful
TypeBOOLEAN
Data Typedimension
Creatives Labels
Field IDadvertiser.campaigns.adGroups.creatives.labels
TypeTEXT
Data Typedimension
Creatives Last Updated At
Field IDadvertiser.campaigns.adGroups.creatives.lastUpdatedAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Creatives Name
Field IDadvertiser.campaigns.adGroups.creatives.name
TypeTEXT
Data Typedimension
Creatives Share Link
Field IDadvertiser.campaigns.adGroups.creatives.shareLink
TypeTEXT
Data Typedimension
Creatives Tag Type
Field IDadvertiser.campaigns.adGroups.creatives.tagType
TypeTEXT
Data Typedimension
Creatives Tag Type Enum
Field IDadvertiser.campaigns.adGroups.creatives.tagTypeEnum
TypeTEXT
Data Typedimension
Creatives Third Party Click Tracking Url
Field IDadvertiser.campaigns.adGroups.creatives.thirdPartyClickTrackingUrl
TypeTEXT
Data Typedimension
Creatives Type
Field IDadvertiser.campaigns.adGroups.creatives.type
TypeTEXT
Data Typedimension
Currency Id
Field IDadvertiser.currency.id
TypeTEXT
Data Typedimension
Currency Name
Field IDadvertiser.currency.name
TypeTEXT
Data Typedimension
Audiences Id
Field IDadvertiser.audiences.id
TypeTEXT
Data Typedimension
Audiences Name
Field IDadvertiser.audiences.name
TypeTEXT
Data Typedimension
Audiences Created At
Field IDadvertiser.audiences.createdAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Active Unique Active Uniques Household Count
Field IDadvertiser.audiences.activeUniques.householdCount
TypeNUMBER
Data Typedimension
Active Unique Active Uniques Ids Connected Tv Count
Field IDadvertiser.audiences.activeUniques.idsConnectedTvCount
TypeNUMBER
Data Typedimension
Active Unique Active Uniques Ids Count
Field IDadvertiser.audiences.activeUniques.idsCount
TypeNUMBER
Data Typedimension
Active Unique Active Uniques Ids In App Count
Field IDadvertiser.audiences.activeUniques.idsInAppCount
TypeNUMBER
Data Typedimension
Active Unique Active Uniques Ids Web Count
Field IDadvertiser.audiences.activeUniques.idsWebCount
TypeNUMBER
Data Typedimension
Active Unique Active Uniques Last Updated
Field IDadvertiser.audiences.activeUniques.lastUpdated
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Active Unique Active Uniques Persons Count
Field IDadvertiser.audiences.activeUniques.personsCount
TypeNUMBER
Data Typedimension
Active Unique Active Uniques Third Party Data Overlap Count
Field IDadvertiser.audiences.activeUniques.thirdPartyDataOverlapCount
TypeNUMBER
Data Typedimension
Audiences Is Auto Generated
Field IDadvertiser.audiences.isAutoGenerated
TypeBOOLEAN
Data Typedimension
Audiences Last Updated At
Field IDadvertiser.audiences.lastUpdatedAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Audiences Target Everyone
Field IDadvertiser.audiences.targetEveryone
TypeTEXT
Data Typedimension
Targeting Data Groups Description
Field IDadvertiser.audiences.targetingDataGroups.description
TypeTEXT
Data Typedimension
First Party Data Active Unique Active Uniques Household Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.householdCount
TypeNUMBER
Data Typedimension
First Party Data Active Unique Active Uniques Ids Connected Tv Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.idsConnectedTvCount
TypeNUMBER
Data Typedimension
First Party Data Active Unique Active Uniques Ids Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.idsCount
TypeNUMBER
Data Typedimension
First Party Data Active Unique Active Uniques Ids In App Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.idsInAppCount
TypeNUMBER
Data Typedimension
First Party Data Active Unique Active Uniques Ids Web Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.idsWebCount
TypeNUMBER
Data Typedimension
First Party Data Active Unique Active Uniques Last Updated
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.lastUpdated
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
First Party Data Active Unique Active Uniques Persons Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.personsCount
TypeNUMBER
Data Typedimension
First Party Data Active Unique Active Uniques Third Party Data Overlap Count
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.activeUniques.thirdPartyDataOverlapCount
TypeNUMBER
Data Typedimension
First Party Data Id
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.id
TypeTEXT
Data Typedimension
First Party Data Name
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.name
TypeTEXT
Data Typedimension
Targeting Data Id
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.id
TypeTEXT
Data Typedimension
Targeting Data Always Show But Ignore Uniques
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.alwaysShowButIgnoreUniques
TypeTEXT
Data Typedimension
Targeting Data Created At
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.createdAt
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Targeting Data Creative Id
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.creativeId
TypeTEXT
Data Typedimension
Targeting Data Data Event Type
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.dataEventType
TypeTEXT
Data Typedimension
Targeting Data Data Name
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.dataName
TypeTEXT
Data Typedimension
Targeting Data Data Owner Id
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.dataOwnerId
TypeTEXT
Data Typedimension
Targeting Data Data Owner Type
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.dataOwnerType
TypeTEXT
Data Typedimension
Targeting Data Data Type
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.dataType
TypeTEXT
Data Typedimension
Targeting Data Display Name Override
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.displayNameOverride
TypeTEXT
Data Typedimension
Targeting Data Do Not Update Uniques
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.doNotUpdateUniques
TypeTEXT
Data Typedimension
Targeting Data Importance Rank
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.importanceRank
TypeNUMBER
Data Typedimension
Targeting Data Is Legacy Tracking Tag
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.isLegacyTrackingTag
TypeBOOLEAN
Data Typedimension
Targeting Data Recency Is Externally Managed
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.recencyIsExternallyManaged
TypeBOOLEAN
Data Typedimension
Targeting Data Should Track Original Id
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.shouldTrackOriginalId
TypeTEXT
Data Typedimension
Targeting Data Supply Vendor Id
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.supplyVendorId
TypeTEXT
Data Typedimension
Targeting Data Test Importance Rank
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.testImportanceRank
TypeNUMBER
Data Typedimension
Targeting Data Used For Feature Targeting
Field IDadvertiser.audiences.targetingDataGroups.firstPartyData.targetingData.usedForFeatureTargeting
TypeTEXT
Data Typedimension
Targeting Data Groups Id
Field IDadvertiser.audiences.targetingDataGroups.id
TypeTEXT
Data Typedimension
Targeting Data Groups Name
Field IDadvertiser.audiences.targetingDataGroups.name
TypeTEXT
Data Typedimension
Third Party Data Id
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.id
TypeTEXT
Data Typedimension
Third Party Data Hierarchy String
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.hierarchyString
TypeTEXT
Data Typedimension
Third Party Data General Population Overlap Last Updated
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.generalPopulationOverlapLastUpdated
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Third Party Data Full Path
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.fullPath
TypeTEXT
Data Typedimension
Third Party Data Description
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.description
TypeTEXT
Data Typedimension
Third Party Data Default Sort Score
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.defaultSortScore
TypeNUMBER
Data Typedimension
Third Party Data Data Alliance Excluded
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.dataAllianceExcluded
TypeTEXT
Data Typedimension
Third Party Data Buyable
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.buyable
TypeTEXT
Data Typedimension
Third Party Data Audience Size
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.audienceSize
TypeNUMBER
Data Typedimension
Third Party Data Allow Custom Full Path
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.allowCustomFullPath
TypeTEXT
Data Typedimension
Third Party Data Active Unique Active Uniques Household Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.householdCount
TypeNUMBER
Data Typedimension
Third Party Data Active Unique Active Uniques Ids Connected Tv Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.idsConnectedTvCount
TypeNUMBER
Data Typedimension
Third Party Data Active Unique Active Uniques Ids Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.idsCount
TypeNUMBER
Data Typedimension
Third Party Data Active Unique Active Uniques Ids In App Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.idsInAppCount
TypeNUMBER
Data Typedimension
Third Party Data Active Unique Active Uniques Ids Web Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.idsWebCount
TypeNUMBER
Data Typedimension
Third Party Data Active Unique Active Uniques Last Updated
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.lastUpdated
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Third Party Data Active Unique Active Uniques Persons Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.personsCount
TypeNUMBER
Data Typedimension
Third Party Data Active Unique Active Uniques Third Party Data Overlap Count
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.activeUniques.thirdPartyDataOverlapCount
TypeNUMBER
Data Typedimension
Third Party Data Import Enabled
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.importEnabled
TypeBOOLEAN
Data Typedimension
Third Party Data Is Planner Only
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.isPlannerOnly
TypeBOOLEAN
Data Typedimension
Third Party Data Name
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.name
TypeTEXT
Data Typedimension
Third Party Data Parent Id
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.parentId
TypeTEXT
Data Typedimension
Third Party Data Provider Element Id
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.providerElementId
TypeTEXT
Data Typedimension
Third Party Data Provider Id
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.providerId
TypeTEXT
Data Typedimension
Third Party Data Targeting Data Id
Field IDadvertiser.audiences.targetingDataGroups.thirdPartyData.targetingDataId
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Date and Hour
Year Month Day Hour
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Date
Year month and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field IDweek
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Bid CPM
The bid CPM, calculated by dividing the total bid amount in the auction by the total number of bids, then multiplying the result by 1,000.
Field IDbidCpm
TypeNUMBER
Data Typemetric
Bids
The total number of times an offer was made in an auction for an impression.
Field IDbids
TypeNUMBER
Data Typemetric
Clicks
The number of times a user interacted with an ad by clicking it.
Field IDclicks
TypeNUMBER
Data Typemetric
Conversions
The number of times a user engaged with an ad and completed an action.
Field IDconversions
TypeNUMBER
Data Typemetric
CPA
The cost per acquisition (CPA), calculated by dividing the total spend by the total number of acquisitions or conversions.
Field IDcpa
TypeNUMBER
Data Typemetric
CPCV (Advertiser Currency)
The cost per completed view, calculated by dividing the total spend by the total number of times a video ad was viewed in its entirety.
Field IDcpcv.advertiserCurrency
TypeNUMBER
Data Typemetric
CPCV (Partner Currency)
The cost per completed view, calculated by dividing the total spend by the total number of times a video ad was viewed in its entirety.
Field IDcpcv.partnerCurrency
TypeNUMBER
Data Typemetric
CPCV (USD)
The cost per completed view, calculated by dividing the total spend by the total number of times a video ad was viewed in its entirety.
Field IDcpcv.usd
TypeNUMBER
Data Typemetric
CPC (Advertiser Currency)
The cost per completed view, calculated by dividing the total spend by the total number of times a video ad was viewed in its entirety.
Field IDcpc.advertiserCurrency
TypeNUMBER
Data Typemetric
CPC (Partner Currency)
The cost per completed view, calculated by dividing the total spend by the total number of times a video ad was viewed in its entirety.
Field IDcpc.partnerCurrency
TypeNUMBER
Data Typemetric
CPC (USD)
The cost per completed view, calculated by dividing the total spend by the total number of times a video ad was viewed in its entirety.
Field IDcpc.usd
TypeNUMBER
Data Typemetric
CPM (Advertiser Currency)
The cost per mille, calculated by dividing the total spend by the number of impressions, and then multiplying that value by 1,000.
Field IDcpm.advertiserCurrency
TypeNUMBER
Data Typemetric
CPM (Partner Currency)
The cost per mille, calculated by dividing the total spend by the number of impressions, and then multiplying that value by 1,000.
Field IDcpm.partnerCurrency
TypeNUMBER
Data Typemetric
CPM (USD)
The cost per mille, calculated by dividing the total spend by the number of impressions, and then multiplying that value by 1,000.
Field IDcpm.usd
TypeNUMBER
Data Typemetric
CTR
The click-through rate (CTR), calculated by dividing the number of clicks by the number of ad impressions. CTR shows how often users who see an ad click it.
Field IDctr
TypeNUMBER
Data Typemetric
Custom CPA
The weighted cost per acquisition, calculated by dividing the total spend by the total weighted number of acquisitions, or conversions.
Field IDcustomCpa
TypeNUMBER
Data Typemetric
Custom ROAS
The weighted return on ad spend, calculated by dividing the total custom revenue by the total ad spend.
Field IDcustomRoas
TypeNUMBER
Data Typemetric
Impressions
The total number of times an ad was served. For digital out-of-home (DOOH), each ad play is multiplied by the expected reach of the ad play to calculate the number of impressions. For other channels, each ad play counts as one impression.
Field IDimpressions
TypeNUMBER
Data Typemetric
Media Cost
The total cost from SSPs or exchanges for impressions.
Field IDmediaCost
TypeNUMBER
Data Typemetric
Media CPM
The media cost per mille, calculated by dividing the total media cost by the number of impressions, then multiplying the result by 1,000.
Field IDmediaCpm
TypeNUMBER
Data Typemetric
Nielsen OTP
Nielsen OnTarget percentage. Currently not supported for campaign flights or ad group flights.
Field IDnielsenOtp
TypeNUMBER
Data Typemetric
Revenue
The total revenue generated from ad spend. You can pass specific revenue amounts to the platform in pixels.
Field IDrevenue
TypeNUMBER
Data Typemetric
ROAS
The return on ad spend, calculated by dividing the total revenue by the total ad spend.
Field IDroas
TypeNUMBER
Data Typemetric
Spend
The total amount of money spent on advertising efforts in The Trade Desk platform.
Field IDspend
TypeNUMBER
Data Typemetric
TV Quality CPM
The TV quality CPM, calculated by dividing the CPM by the TV quality index, and then multiplying that value by 100.
Field IDtvQualityCpm
TypeNUMBER
Data Typemetric
TV Quality Index
The quality of inventory run, on a scale of 1 - 100. TVQI is an aggregate of the weighted scores for eight criteria (content, addressability, playback type, device type, content duration, production quality, content signal transparency, and market type) across three pillars of quality (content, ad experience, and signals).
Field IDtvQualityIndex
TypeNUMBER
Data Typemetric
InView Rate
the proportion of impressions when an ad was in view for a certain period of time.
Field IDinViewRate
TypeNUMBER
Data Typemetric
vCPM
The viewable cost per mille, calculated by dividing the total spend by the total number of impressions that were in-view, and then multiplying that value by 1,000.
Field IDvCpm
TypeNUMBER
Data Typemetric
vCPM (Advertiser Currency)
The cost per mille, calculated by dividing the total spend by the number of impressions, and then multiplying that value by 1,000.
Field IDvCpm.advertiserCurrency
TypeNUMBER
Data Typemetric
VCPM (Partner Currency)
The cost per mille, calculated by dividing the total spend by the number of impressions, and then multiplying that value by 1,000.
Field IDvCpm.partnerCurrency
TypeNUMBER
Data Typemetric
VCPM (USD)
The cost per mille, calculated by dividing the total spend by the number of impressions, and then multiplying that value by 1,000.
Field IDvCpm.usd
TypeNUMBER
Data Typemetric
Video Completion Rate
The proportion of ads that are fully viewed, played, or heard out of the total number of ads served. Format is decimal form.
Field IDvideoCompletionRate
TypeNUMBER
Data Typemetric
Completion Rate
The completion rate.
Field IDcompletionRate
TypeNUMBER
Data Typemetric
Viewability
The total number of viewed impressions divided by the total number of tracked impressions. Viewability measures whether an ad has been viewed by a user (rather than only served on a webpage and not viewed).
Field IDviewability
TypeNUMBER
Data Typemetric
Win Rate
The total number of ad plays won divided by the total number of bids.
Field IDwinRate
TypeNUMBER
Data Typemetric
Ad Plays
.
Field IDadPlays
TypeNUMBER
Data Typemetric
Matched Household Impressions
.
Field IDmatchedHouseholdImpressions
TypeNUMBER
Data Typemetric
Matched Person Impressions
.
Field IDmatchedPersonImpressions
TypeNUMBER
Data Typemetric
Households (unique)
.
Field IDuniqueHouseholds
TypeNUMBER
Data Typemetric
Persons (unique)
.
Field IDuniquePersons
TypeNUMBER
Data Typemetric
City Name
.
Field IDgeoReporting.geo.GeoReportingCity.cityName
TypeTEXT
Data Typedimension
Country Name
.
Field IDgeoReporting.geo.GeoReportingCountry.countryName
TypeTEXT
Data Typedimension
Metro Code
.
Field IDgeoReporting.geo.GeoReportingMetro.metroCode
TypeTEXT
Data Typedimension
Region Name
.
Field IDgeoReporting.geo.GeoReportingRegion.regionName
TypeTEXT
Data Typedimension
Zip Code
.
Field IDgeoReporting.geo.GeoReportingZipCode.zipCode
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension