StackAdapt | Ad Standard Dataset – ChannelMix

Below are the fields ChannelMix considers standard for the StackAdapt Ad dataset. The daily schedule for the ad performance data (clicks, impressions, cost, etc.) pulls the last 7 days previous to today's date at 2:30 AM CT. The daily schedule for the conversion data pulls the last 30 days previous to today's date at 2:30 AM CT.

This dataset can be automatically activated without a ticket through Dataset Activation.

Field Name	Type	Description
Report Date	Date	The date the activity occurred.
Advertiser ID	String	The StackAdapt ID for the advertiser.
Advertiser Name	String	The StackAdapt name for the advertiser.
Campaign Group ID	String	The StackAdapt ID for the campaign group.
Campaign Group Name	String	The StackAdapt name for the campaign group.
Campaign ID	String	The StackAdapt ID for the campaign.
Campaign Name	String	The StackAdapt name for the campaign.
Ad ID	String	The StackAdapt ID for the ad.
Ad Name	String	The StackAdapt name for the ad.
Is Archived?	Boolean	True if the ad has been archived, false otherwise.
Is Draft?	Boolean	True if the ad is a draft, false otherwise.
Is Paused?	Boolean	True if the ad is paused, false otherwise.
Reject Reason	String	Reason ad was rejected by StackAdapt.
Ad Type	String	StackAdapt ad type (usually one of AudioAd, CtvAd, DisplayAd, DoohAd, NativeAd, ProgrammaticLinearTvAd, VideoAd).
Conversion Pixel ID	String	The ID of the pixel.
Conversion Pixel Name	String	The name of the pixel.
Conversion Pixel Description	String	The description of the pixel.
Conversion Type	String	The specific method used to track and record the actions a user takes after clicking on an ad that leads to a conversion such as a click or an impression.
Conversion Device	String	The device and operating system on which the pixel fire occurred.
Conversion URL	String	The URL where the pixel fire occurred.
Impressions	Decimal	Total ad impressions.
Unique Impressions	Decimal	Total unique ad impressions.
Clicks	Decimal	Total ad clicks.
Cost	Decimal	Total media cost.
Third Party CPM Cost	Decimal	Total third-party CPM cost.
Third Party CPC Cost	Decimal	Total third-party CPC cost.
Ad Spend	Decimal	Total revenue fee.
Tech Fee	Decimal	Total tech fee.
Revenue	Decimal	Total revenue.
Profit	Decimal	Total profit.
Video Starts	Decimal	Total video starts.
Video Q1 Playbacks	Decimal	Total 25% video completions.
Video Q2 Playbacks	Decimal	Total 50% video completions.
Video Q3 Playbacks	Decimal	Total 75% video completions.
Video Completions	Decimal	Total 95% video completions.
Video Completion Rate	Decimal	Total video completions per video start.
Audio Completion Rate	Decimal	Total listen through rate, audio completions per audio starts.
Conversions	Decimal	Total conversions.
Secondary Conversions	Decimal	Total secondary conversions (conversion actions that are used for observation only and not for bidding).
Conversions per Pixel	Decimal	ChannelMix calculated field. Count of conversion pixel IDs.
Unique Conversions	Decimal	Total unique conversions
Conversion Revenue	Decimal	Total conversion revenue.
Impression Conversions	Decimal	Total impression conversions (aka view-through conversions).
Impression Secondary Conversions	Decimal	Total secondary impression conversions (aka view-through conversion actions that are used for observation only and not for bidding).
Impression View Rate	Decimal	Total viewed impressions per measurable impression.
Click Conversions	Decimal	Total click conversions (aka click-through conversions).
Click Secondary Conversions	Decimal	Total secondary click conversions (aka click-through conversion actions that are used for observation only and not for bidding).
CTR	Decimal	Total click-through rate.
Cookie Conversions	Decimal	Cookie conversions are a way to track how well a landing page is performing in a campaign by dividing the number of conversions by the total number of visitors who clicked through to the landing page.
IP Conversions	Decimal	Total conversions as a result of using IP addresses for retargeting audiences.
CVR	Decimal	Total conversion rate.
Engagements	Decimal	Total number of times 15 seconds was spent on the landing page.
Engagement Rate	Decimal	Total engagements per impression.
Frequency	Decimal	Total impressions per unique impression.
ECPC	Decimal	Total effective cost per click.
ECPA	Decimal	Total effective cost per action
ECPCL	Decimal	Total effective cost per completed listen.
ECPE	Decimal	Total effective cost per engagement.
ECPM	Decimal	Total effective cost per thousand impressions.
ECPV	Decimal	Total effective cost per view.
RCPC	Decimal	Total revenue cost per acquisition.
RCPCL	Decimal	Total revenue cost per completed listen.
RCPE	Decimal	Total revenue cost per engagement.
RCPA	Decimal	Total revenue cost per acquisition.
RCPM	Decimal	Total revenue cost per mile.
ROAS	Decimal	Total return on ad spend.
ATOS Units	Decimal	Total ATOS in readable units.
ATOS	Decimal	Average time on site (seconds).
Total Time on Page (Seconds)	Decimal	Total time spent on the page (seconds).
GA4 Bounce Rate	Decimal	GA4 Bounce Rate.
Page Starts	Decimal	Total number of times page was loaded.
GA4 Avg Session Duration	Decimal	GA4 Average Session Duration.
Page Time	Decimal	Page time in readable units.
GA4 Engaged Sessions	Decimal	GA4 Engaged Sessions.
GA4 Sessions	Decimal	GA4 Sessions.
GA4 Total Users	Decimal	GA4 Unique Visits.
Advertiser Deal IDs	String (List)	One or more deal IDs. Deal IDs are established between advertisers and publishers.
Advertiser Domain Exclusions	String (List)	The domains that the advertisers want to exclude from their campaigns.
Insert Date	Timestamp	Internal use: when the row was inserted in the table
ChannelMix Profile	String	When needed, distinguishes between TikTok accounts (contents defined by ChannelMix).

In this Article