With the StackAdapt data source connector, you can report your basic ad metrics and identify which campaigns are working best. Compare results between video ads and other media types to see what format drives the strongest performance for your campaigns.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our StackAdapt connection guide.
Available metrics and dimensions: Find the full list of fields in our StackAdapt field documentation.
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
Review campaign cost and impression performance last month
See media cost, impressions, unique impressions, CPC, and CPM at the campaign group level for last month — useful for comparing cost efficiency and reach across your campaign groups.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Media cost, CPC, CPM, Impressions, Unique impressions |
Dimensions | Campaign group |
Suggested visualization | Table or bar chart |
Understanding the data
Media cost: The total budget spent on the campaign.
CPC: Cost per click — the media cost divided by total clicks.
CPM: Cost per mille — the media cost divided by impressions, multiplied by 1,000.
Impressions: The total number of impressions served within the reporting period.
Unique impressions: The total number of unique people who were shown an ad.
Campaign group: The name of the campaign group, used to compare performance across groups.
Track monthly ad budget spend year to date
See how your total media cost has varied from month to month this year — useful for monitoring budget pacing and identifying months with higher or lower than expected spend.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Year to date |
Metrics | Media cost |
Dimensions | Year & month |
Suggested visualization | Time series or line chart |
Understanding the data
Media cost: The total budget spent on the campaign.
Year & month: Splits results by month so you can compare spend trends across the year.
Analyze cost, clicks, and impressions by advertiser
Get a detailed breakdown of cost, click, and impression performance for each advertiser over the last 28 days — useful for comparing efficiency across advertisers and informing budget allocation decisions.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last 28 days |
Metrics | Clicks, Media cost, CPC, CPM, CTR, Impressions, Unique impressions |
Dimensions | Advertiser |
Suggested visualization | Table |
Understanding the data
Clicks: The total number of clicks registered within the reporting period.
Media cost: The total budget spent on the campaign.
CPC: Cost per click — the media cost divided by total clicks.
CPM: Cost per mille — the media cost divided by impressions, multiplied by 1,000.
CTR: Click-through rate — clicks divided by impressions.
Impressions: The total number of impressions served within the reporting period.
Unique impressions: The total number of unique people who were shown an ad.
Advertiser: Splits results by advertiser for side-by-side performance comparison.
More resources
See the Supermetrics blog for tips for improving your StackAdapt reporting.
You might also be interested in: