Introduction

Datasources and destinations

Fields listing for StackAdapt

Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Advertiser ID
The unique identifier of the advertiser that owns the campaign.
Field IDadvertiser.id
TypeTEXT
Data Typedimension
Advertiser Name
The name of the advertiser that owns the campaign.
Field IDadvertiser.name
TypeTEXT
Data Typedimension
Budget Rollover
Indicates whether campaign budget rolls over to the next period.
Field IDcampaign.budgetRollover
TypeBOOLEAN
Data Typedimension
Campaign State
The high-level campaign state (active, paused, etc.).
Field IDcampaign.campaignStatus.state
TypeTEXT
Data Typedimension
Campaign Status
The detailed campaign status (pending, approved, disapproved, etc.).
Field IDcampaign.campaignStatus.status
TypeTEXT
Data Typedimension
Channel Name
The channel type of the campaign.
Field IDcampaign.channelType
TypeTEXT
Data Typedimension
Campaign Created At
The date and time when the campaign was created.
Field IDcampaign.createdAt
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Creative Tactic Fallback
Fallback tactic used when no other creative tactic applies.
Field IDcampaign.creativeTacticFallback
TypeTEXT
Data Typedimension
Creative Tactic Fallback IDs
Fallback tactic IDs used for creative fallback.
Field IDcampaign.creativeTacticFallbackIds
TypeTEXT
Data Typedimension
Frequency Cap Expiry
Frequency capping expiration date or setting.
Field IDcampaign.freqCapExpiry
TypeTEXT
Data Typedimension
Frequency Cap Limit
Maximum frequency cap limit for impressions or clicks per user.
Field IDcampaign.freqCapLimit
TypeNUMBER
Data Typedimension
Campaign ID
The unique identifier of the campaign.
Field IDcampaign.id
TypeTEXT
Data Typedimension
Is Archived
Indicates if the campaign is archived.
Field IDcampaign.isArchived
TypeBOOLEAN
Data Typedimension
Is Draft
Indicates if the campaign is still a draft.
Field IDcampaign.isDraft
TypeBOOLEAN
Data Typedimension
Campaign Name
The name of the campaign.
Field IDcampaign.name
TypeTEXT
Data Typedimension
Channel SubType Name
The channel subtype type of the campaign.
Field IDcampaign.subtype
TypeTEXT
Data Typedimension
Timezone
Timezone in which the campaign operates.
Field IDcampaign.timezone
TypeTEXT
Data Typedimension
Campaign Updated At
The date and time when the campaign was last updated.
Field IDcampaign.updatedAt
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign Group ID
The unique identifier of the campaign group.
Field IDcampaignGroup.id
TypeTEXT
Data Typedimension
Campaign Group Name
The name of the campaign group this campaign belongs to.
Field IDcampaignGroup.name
TypeTEXT
Data Typedimension
Atos
Atos metric from StackAdapt
Field IDmetrics.atos
TypeNUMBER
Data Typemetric
Audio Completion Rate
Audio Completion Rate
Field IDmetrics.audioCompletionRate
TypePERCENT
Data Typemetric
Audio Completions
Audio Completions
Field IDmetrics.audioCompletions
TypeNUMBER
Data Typemetric
Audio Q1 Playbacks
Audio Q1 Playbacks
Field IDmetrics.audioQ1Playbacks
TypeNUMBER
Data Typemetric
Audio Q2 Playbacks
Audio Q2 Playbacks
Field IDmetrics.audioQ2Playbacks
TypeNUMBER
Data Typemetric
Audio Q3 Playbacks
Audio Q3 Playbacks
Field IDmetrics.audioQ3Playbacks
TypeNUMBER
Data Typemetric
Audio Starts
Audio Starts
Field IDmetrics.audioStarts
TypeNUMBER
Data Typemetric
Average Impression Time
Average Impression Time
Field IDmetrics.averageImpressionTime
TypeNUMBER
Data Typemetric
Click Conversion Rate
Click Conversion Rate
Field IDmetrics.clickConversionRate
TypePERCENT
Data Typemetric
Click Conversions
Click Conversions
Field IDmetrics.clickConversions
TypeNUMBER
Data Typemetric
Click Secondary Conversions
Click Secondary Conversions
Field IDmetrics.clickSecondaryConversions
TypeNUMBER
Data Typemetric
Clicks
Number of Clicks
Field IDmetrics.clicks
TypeNUMBER
Data Typemetric
Conversion Revenue
Conversion Revenue
Field IDmetrics.conversionRevenue
TypeNUMBER
Data Typemetric
Conversion Revenue %
Conversion Revenue Percentage
Field IDmetrics.conversionRevenuePercentage
TypePERCENT
Data Typemetric
Conversions
Conversions
Field IDmetrics.conversions
TypeNUMBER
Data Typemetric
Cookie Conversions
Cookie Conversions
Field IDmetrics.cookieConversions
TypeNUMBER
Data Typemetric
Cost
Cost
Field IDmetrics.cost
TypeNUMBER
Data Typemetric
Cost %
Cost Percentage
Field IDmetrics.costPercentage
TypePERCENT
Data Typemetric
CTR
Click Through Rate
Field IDmetrics.ctr
TypePERCENT
Data Typemetric
CVR
Conversion Rate
Field IDmetrics.cvr
TypePERCENT
Data Typemetric
eCPA
eCPA
Field IDmetrics.ecpa
TypeNUMBER
Data Typemetric
eCPC
eCPC
Field IDmetrics.ecpc
TypeNUMBER
Data Typemetric
eCPCL
eCPCL
Field IDmetrics.ecpcl
TypeNUMBER
Data Typemetric
eCPCV
eCPCV
Field IDmetrics.ecpcv
TypeNUMBER
Data Typemetric
eCPE
eCPE
Field IDmetrics.ecpe
TypeNUMBER
Data Typemetric
eCPM
eCPM
Field IDmetrics.ecpm
TypeNUMBER
Data Typemetric
Engagement Rate
Engagement Rate
Field IDmetrics.engagementRate
TypePERCENT
Data Typemetric
Engagements
Engagements
Field IDmetrics.engagements
TypeNUMBER
Data Typemetric
Frequency
Ad Frequency
Field IDmetrics.frequency
TypeNUMBER
Data Typemetric
Impression Conversion Rate
Impression Conversion Rate
Field IDmetrics.impressionConversionRate
TypePERCENT
Data Typemetric
Impression Conversions
Impression Conversions
Field IDmetrics.impressionConversions
TypeNUMBER
Data Typemetric
Impression Secondary Conversions
Impression Secondary Conversions
Field IDmetrics.impressionSecondaryConversions
TypeNUMBER
Data Typemetric
Impressions
Impressions
Field IDmetrics.impressions
TypeNUMBER
Data Typemetric
Impressions %
Impressions Percentage
Field IDmetrics.impressionsPercentage
TypePERCENT
Data Typemetric
Page Starts
Page Starts
Field IDmetrics.pageStarts
TypeNUMBER
Data Typemetric
Profit
Profit
Field IDmetrics.profit
TypeNUMBER
Data Typemetric
Profit %
Profit Percentage
Field IDmetrics.profitPercentage
TypePERCENT
Data Typemetric
rCPA
rCPA
Field IDmetrics.rcpa
TypeNUMBER
Data Typemetric
Third-party CPC cost
Third-party CPC cost
Field IDmetrics.rcpc
TypeNUMBER
Data Typemetric
rCPCL
rCPCL
Field IDmetrics.rcpcl
TypeNUMBER
Data Typemetric
rCPE
rCPE
Field IDmetrics.rcpe
TypeNUMBER
Data Typemetric
Third-party CPM cost
Third-party CPM cost
Field IDmetrics.rcpm
TypeNUMBER
Data Typemetric
Revenue
Revenue
Field IDmetrics.revenue
TypeNUMBER
Data Typemetric
Revenue %
Revenue Percentage
Field IDmetrics.revenuePercentage
TypePERCENT
Data Typemetric
ROAS
Return on Ad Spend
Field IDmetrics.roas
TypeNUMBER
Data Typemetric
Secondary Conversions
Secondary Conversions
Field IDmetrics.secondaryConversions
TypeNUMBER
Data Typemetric
Total Time
Total Time
Field IDmetrics.totalTime
TypeNUMBER
Data Typemetric
Unique Impressions
Unique Impressions
Field IDmetrics.uniqueImpressions
TypeNUMBER
Data Typemetric
Video Completion Rate
Video Completion Rate
Field IDmetrics.videoCompletionRate
TypePERCENT
Data Typemetric
Video Completions
Video Completions
Field IDmetrics.videoCompletions
TypeNUMBER
Data Typemetric
Video Q1 Playbacks
Video Q1 Playbacks
Field IDmetrics.videoQ1Playbacks
TypeNUMBER
Data Typemetric
Video Q2 Playbacks
Video Q2 Playbacks
Field IDmetrics.videoQ2Playbacks
TypeNUMBER
Data Typemetric
Video Q3 Playbacks
Video Q3 Playbacks
Field IDmetrics.videoQ3Playbacks
TypeNUMBER
Data Typemetric
Video Starts
Video Starts
Field IDmetrics.videoStarts
TypeNUMBER
Data Typemetric
View Rate
View Rate
Field IDmetrics.viewRate
TypePERCENT
Data Typemetric
Views
Views
Field IDmetrics.views
TypeNUMBER
Data Typemetric