Data reference - Adriel Knowledge Base

Introduction

StackAdapt is a multi-channel programmatic advertising platform (DSP) supporting native, display, video, audio, and CTV inventory across the open web. The connector pulls campaign architecture and performance from StackAdapt’s GraphQL API for the advertisers selected during connection setup. As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration.

New connections use the StackAdapt GraphQL variant documented here. The legacy StackAdapt REST connector is deprecated; existing REST widgets continue to function but appear with a “(deprecated)” suffix in the connector picker.

To connect this data source, see How to connect StackAdapt to Adriel.

Data refresh strategy

Architecture data

Architecture covers advertisers, campaigns, ad groups, and creatives. It refreshes twice daily at 4:00 PM UTC and 5:00 AM UTC.

Reports data

Reports include daily performance for advertisers, campaigns, ad groups, and creatives. Real-time. Report data is fetched from StackAdapt’s GraphQL API on demand when a dashboard loads, so the latest values are always visible. On top of that, scheduled cache refreshes keep historical data consistent across multiple time windows. Refresh schedule. Reports refresh on three overlapping schedules:

5:00 PM UTC daily — syncs the last 9 days for ad account, campaign, ad set, and ad
11:40 PM and 6:40 AM UTC daily — syncs the last 3 days for ad account, campaign, ad set, and ad
7:30 AM UTC on the 1st and 15th of each month — syncs the last 30 days for ad account, campaign, ad set, and ad

Architecture levels

Advertiser → Campaign → Ad group → Creative

Date range limits

Breakdown	Max range
Daily	93 days
Weekly	1 year

Data requested outside a breakdown’s maximum range may be truncated. Longer historical ranges remain available through the monthly, quarterly, and yearly breakdowns.

Metrics

How to read the columnsData type uses Adriel’s vocabulary — Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. API Key in code style like metrics.impressionsBigint is the literal StackAdapt GraphQL response field; where the same raw field name is shared across objects (StackAdapt returns name for the advertiser, campaign, ad group, and creative), it’s shown qualified as object.field (for example account.name) so each row stays unique; italic marks a value Adriel computes or derives. Currency values are reported in each advertiser’s configured currency, defaulting to USD when StackAdapt omits it.

Basic

Metric	Description	Data type	API Key
Creative Image	Hash of the creative image used to group visually identical creatives.	Text	Adriel-derived
Creative Type	The format of the ad creative, such as display, CTV, native, video, or audio.	Text	`__typename`
Lifetime Budget	The lifetime budget amount for the selected campaign flight.	Currency	`flights.nodes.lifetimeBudget`
Result Indicator	The metric used to represent the result for the campaign objective.	Text	Adriel-derived
Results	The number of results for the campaign’s configured objective.	Number	Adriel-derived

Campaign Attributes

Metric	Description	Data type	API Key
Ad Account Name	The ad account name.	Text	`account.name`
Ad Name	The ad name.	Text	`ad.name`
Ad Set Name	The ad set name.	Text	`adset.name`
Ad Spend	Media cost.	Currency	`metrics.cost`
Bid Cap	Maximum bid amount configured for the campaign or ad group when bid caps are used.	Currency	Adriel-side
Bid Strategy	Bid strategy configured for the campaign or ad group.	Text	Adriel-side
Budget	The configured budget details for the selected campaign.	Text	`flights.nodes.lifetimeBudget`, `flights.nodes.dailyBudget`
Campaign Name	The campaign name.	Text	`campaign.name`
Creative URL	The creative asset URLs available for the ad.	URL	`creativesConnection.nodes.s3Url`, `creativesConnection.nodes.thumbS3Url`
Daily Budget	The daily budget amount for the selected campaign flight.	Currency	`flights.nodes.dailyBudget`
Ends	The scheduled end date of the campaign flight used for the selected object, when one is set.	Date	`flights.nodes.endTime`
Is Active	Whether the campaign, ad group, or ad is currently active.	Text	Adriel-side
Landing URL	The landing page URLs used by the ad.	Array	`clickUrl`
Objective	Advertising objective configured for the campaign.	Text	Adriel-side
Starts	The scheduled start date of the campaign flight used for the selected object.	Date	`flights.nodes.startTime`
Status	The current delivery status of the selected ad account, campaign, ad set, or ad.	Text	`isArchived`, `campaignGroupStatus.status`, `campaignStatus.status`, `creativeStatus.status`
Status Text	Text label describing the delivery status of the campaign, ad group, or ad.	Text	Adriel-side
UTM Campaign	The UTM campaign values used in the ad landing URLs.	Array	`clickUrl`
UTM Content	The UTM content values used in the ad landing URLs.	Array	`clickUrl`
UTM Medium	The UTM medium values used in the ad landing URLs.	Array	`clickUrl`
UTM Source	The UTM source values used in the ad landing URLs.	Array	`clickUrl`
UTM Term	The UTM term values used in the ad landing URLs.	Array	`clickUrl`

UTM values are parsed by Adriel. Adriel reads the UTM query parameters from each ad’s landing URL (clickUrl) and exposes them as both metrics (for rollup) and breakdowns (for grouping).

Campaign Structure

Metric	Description	Data type	API Key
Ad Account ID	The ad account ID in StackAdapt.	Text	`id`, `advertiser.id`, `campaignGroup.advertiser.id`, `campaign.campaignGroup.advertiser.id`, `ad.campaign.campaignGroup.advertiser.id`
Ad ID	The ad ID in StackAdapt.	Text	`id`, `ad.id`
Ad Set ID	The ad set ID in StackAdapt.	Text	`id`, `campaign.id`, `ad.campaign.id`
Campaign ID	The campaign ID in StackAdapt.	Text	`id`, `campaignGroup.id`, `campaign.campaignGroup.id`, `ad.campaign.campaignGroup.id`
Channel	The connector sub-channel labels associated with the selected object.	Array	Adriel-derived

Computed Metric

These are calculated by Adriel from other metrics; they have no single underlying StackAdapt field.

Metric	Description	Data type	API Key
Frequency	Impressions divided by unique impressions.	Ratio	Adriel-computed
ROAS	Return on ad spend — conversion value divided by spend.	Ratio	Adriel-computed

Conversion Performance

Metric	Description	Data type	API Key
Conversion Value	Revenue reported for the selected conversions, using revenue or conversion revenue when available.	Currency	`metrics.revenue`, `metrics.conversionRevenue`
Conversions	Conversions.	Number	`metrics.conversionsBigint`
Revenue	Revenue reported for the selected data, using revenue or conversion revenue when available.	Currency	`metrics.revenue`, `metrics.conversionRevenue`

Conversion events come from your StackAdapt pixel. For each conversion goal tracked by the pixel, a count metric is imported and derived efficiency metrics (Conversion Rate, CPA, ROAS) are generated. Events only appear when the underlying goal is active in the account. Examples of events imported when present (an account may have more custom conversions): conv, conv_cookie, conv_imp_derived, conv_imp_time_avg, page_start, page_time, page_time_15s, page_time_units, profit, s_conv, unique_conv, unique_imp.

Engagement

Metric	Description	Data type	API Key
Engagement	Number of times 15 seconds was spent on the landing page.	Number	`metrics.engagementsBigint`

Impression Click Performance

Metric	Description	Data type	API Key
Clicks (All)	Total clicks.	Number	`metrics.clicksBigint`
CPC	Cost per click.	Currency	Adriel-computed
CPM	Cost per thousand impressions.	Currency	Adriel-computed
CTR	Click-through rate — clicks divided by impressions.	Percentage	Adriel-computed
Impressions	Impressions.	Number	`metrics.impressionsBigint`
Link Clicks	Clicks.	Number	`metrics.clicksBigint`
Reach	Unique impressions.	Number	`metrics.uniqueImpressionsBigint`

Video Performance

Metric	Description	Data type	API Key
Video Play	Viewed impressions.	Number	`metrics.viewedMeasuredImpressionsBigint`
Video Played To 100% (Views)	100% video completions.	Number	`metrics.videoCompletionsBigint`
Video Played To 25% (Views)	25% video completions.	Number	`metrics.videoQ1PlaybacksBigint`
Video Played To 50% (Views)	50% video completions.	Number	`metrics.videoQ2PlaybacksBigint`
Video Played To 75% (Views)	75% video completions.	Number	`metrics.videoQ3PlaybacksBigint`
Views	Video starts.	Number	`metrics.videoStartsBigint`

StackAdapt-specific

These metrics exist only for StackAdapt and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Metric	Description	Data type	API Key
ChatGPT Cost	OpenAI cost for delivering ChatGPT Ads.	Currency	`stats.total.oaRevenue`
ChatGPT eCPC	OpenAI effective cost per click for ChatGPT Ads.	Currency	`stats.total.oaCpc`
ChatGPT eCPM	OpenAI effective cost per thousand impressions for ChatGPT Ads.	Currency	`stats.total.oaCpm`
Clicks Bigint	Clicks.	Number	`metrics.clicksBigint`
Conversion Revenue	Conversion revenue.	Currency	`metrics.conversionRevenue`
Conversions	Conversions.	Number	`metrics.conversionsBigint`
Conversions Bigint	Conversions.	Number	`metrics.conversionsBigint`
Conversions: Conversion Value	Revenue reported for the selected conversions, using revenue or conversion revenue when available.	Currency	`metrics.revenue`, `metrics.conversionRevenue`
Conversions: CPA	Average media cost for each conversion.	Currency	Adriel-computed
Conversions: CVR	Conversion rate, conversions per click.	Percentage	Adriel-computed
Conversions: ROAS	Return on ad spend.	Ratio	Adriel-computed
Engagements Bigint	Number of times 15 seconds was spent on the landing page.	Number	`metrics.engagementsBigint`
Frequency	Impressions per unique impression.	Ratio	`metrics.frequency`
Impressions Bigint	Impressions.	Number	`metrics.impressionsBigint`
Revenue	Revenue.	Currency	`metrics.revenue`
StackAdapt Fee	StackAdapt fee charged for ChatGPT Ads delivery.	Currency	`stats.total.markupAmount`
Unique Impressions	Unique impressions.	Number	Adriel-derived
Unique Impressions Bigint	Unique impressions.	Number	`metrics.uniqueImpressionsBigint`
Video Average Play Time	Video completion rate, measured as video completions per video start.	Number	`metrics.videoCompletionRate`
Video Completed	100% video completions.	Number	`metrics.videoCompletionsBigint`
Video Completed Rate	Video completions per video start.	Percentage	`metrics.videoCompletionRate`
Video Completions Bigint	100% video completions.	Number	`metrics.videoCompletionsBigint`
Video Play 25%	25% video completions.	Number	`metrics.videoQ1PlaybacksBigint`
Video Play 50%	50% video completions.	Number	`metrics.videoQ2PlaybacksBigint`
Video Play 75%	75% video completions.	Number	`metrics.videoQ3PlaybacksBigint`
Video Q1Playbacks Bigint	25% video completions.	Number	`metrics.videoQ1PlaybacksBigint`
Video Q2Playbacks Bigint	50% video completions.	Number	`metrics.videoQ2PlaybacksBigint`
Video Q3Playbacks Bigint	75% video completions.	Number	`metrics.videoQ3PlaybacksBigint`
Video Starts	Video starts.	Number	`metrics.videoStartsBigint`
Video Starts Bigint	Video starts.	Number	`metrics.videoStartsBigint`
Viewed Measurable Impressions	Viewed impressions.	Number	`metrics.viewedMeasuredImpressionsBigint`
Viewed Measured Impressions Bigint	Viewed impressions.	Number	`metrics.viewedMeasuredImpressionsBigint`

Breakdowns

Basic

Breakdown	Description	API Key
Channel	The advertising channel.	Adriel-assigned

Campaign Structure

Breakdown	Description	API Key
Ad Name	Groups results by ad name.	Adriel-derived
Ad Set Name	Groups results by ad set name.	Adriel-derived
Campaign Name	Groups results by campaign name.	Adriel-derived
Platform	Groups results by the platform on which the ads were shown.	Adriel-derived
Status	The current delivery status of the selected ad account, campaign, ad set, or ad.	`isArchived`, `campaignGroupStatus.status`, `campaignStatus.status`, `creativeStatus.status`

Creatives

Adriel post-processes ad creatives to generate these breakdowns.

Breakdown	Description	API Key
Ad Copy	Words detected in the creative text or assets.	Adriel-side
Color Clustering	Dominant color cluster detected in the creative assets.	Adriel-side
Creative Image	Hash value of the creative image.	Adriel-side
Emoji Analysis	Emoji detected in the creative text or assets.	Adriel-side

Date

StackAdapt returns daily records; all time-grouping breakdowns are Adriel-side aggregations of the same underlying daily data.

Breakdown	Description	API Key
Auto Time Breakdown	Groups data by an automatically selected time interval based on the date range.	Adriel-side
Daily Breakdown	Groups data by day.	Adriel-side
Monthly Breakdown	Groups data by month.	Adriel-side
Quarterly Breakdown	Groups results by calendar quarter.	Adriel-side
Week Date Breakdown	Groups results by the date representing each reporting week.	Adriel-side
Week Number Breakdown (W#)	Groups results by week number in the year.	Adriel-side
Weekly Breakdown (Start: Mon)	Groups data by week.	Adriel-side
Weekly Breakdown (Start: Sun)	Groups results into weeks running from Sunday through Saturday.	Adriel-side
Yearly Breakdown	Groups results by calendar year.	Adriel-side

Others

Breakdown	Description	API Key
No Grouping	Groups all selected data into a single bucket.	Adriel-side

StackAdapt-specific

These breakdowns exist only for StackAdapt and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Breakdown	Description	API Key
Ad	The ad name.	`ad.name`
Ad Account	The ad account name.	`account.name`
Ad Set	The ad set name.	`adset.name`
Campaign	The campaign name.	`campaign.name`
Campaign Type	ChatGPT Ads campaign type, such as STANDARD or PRODUCT_FEED.	`campaignType`
Country	Country from the insight breakdown.	`COUNTRY`
Creative Description	ChatGPT Ads creative body copy.	`creative.body`
Creative Headline	ChatGPT Ads creative title.	`creative.title`
Zip Code	ZIP code from the insight breakdown.	`ZIP_CODE`

Limitations

GraphQL credentials are separate from REST — a StackAdapt REST key will not authenticate against the GraphQL endpoint. GraphQL access must be requested directly from StackAdapt support.
Static API key, no rotation — the key is not rotated automatically. If StackAdapt revokes the key on their side, the connection must be re-established with a fresh key.
One advertiser per data source — when a single API key grants access to multiple advertisers, each selected advertiser creates its own data source. Cross-advertiser rollups happen at the dashboard layer.
Currency defaults to USD — StackAdapt does not always provide currency metadata; when it is absent, USD is used as the default. Spend totals should be reviewed when working with non-USD advertisers.
Legacy REST connector deprecated — the older StackAdapt REST connector is deprecated in favor of the GraphQL variant; new connections should use the GraphQL connector documented here.

API references

StackAdapt GraphQL API endpoint: https://api.stackadapt.com/graphql
StackAdapt developer documentation

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Basic

​Campaign Attributes

​Campaign Structure

​Computed Metric

​Conversion Performance

​Engagement

​Impression Click Performance

​Video Performance

​StackAdapt-specific

​Breakdowns

​Basic

​Campaign Structure

​Creatives

​Date

​Others

​StackAdapt-specific

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Basic

Campaign Attributes

Campaign Structure

Computed Metric

Conversion Performance

Engagement

Impression Click Performance

Video Performance

StackAdapt-specific

Breakdowns

Basic

Campaign Structure

Creatives

Date

Others

StackAdapt-specific

Limitations

API references

See also