With the StackAdapt data source, you can report your basic ad metrics and create reports to see which campaign is working the best. Compare results between video ads and other media ads to see if video, photo, or written text works the best for your campaign.
For a full list of metrics and dimensions available in our StackAdapt data source connector, take a look at our StackAdapt documentation.
Once you've connected to StackAdapt, you're ready to create your first queries!
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See media cost along with click and impression data for your campaigns
Take a look at your campaign costs and the impressions your campaigns gained last month. In this example, we view the data from last month on the campaign group level.
The "Media cost" metric shows the total budget spent on the campaign.
The "CPC" metric shows the cost divided by clicks.
The "CPM" metric shows the cost per mille, or the cost divided by impressions x 1000.
The "Impressions" metric shows the total number of impressions served and the "Unique impressions" metrics show the total number of unique people who were shown an ad.
For best results in Looker Studio, use the table or bar chart type.
- Set the date range to Last month.
- Select the Media cost, CPC, CPM, Impressions, and Unique impressions metrics.
- Select the Campaign group dimension to split the query results by the name of the campaign group.
See your ad campaign budget for the year
See data on how much your total budget spent on the campaign has varied from month to month. In this example, we take a look at the data for the ongoing year.
The "Media cost" metric shows the total budget spent on the campaign.
For best results in Looker Studio, use the time series chart type.
- Set the date range to Year to date.
- Select the Media cost metric.
- Select the Year & month dimension.
See cost, click, and impression data by advertiser
Fetch data for each advertiser using various cost, click, and impression metrics. In this example, we take a look at the data for the last 28 days.
The "Clicks" metric shows the total number of clicks registered.
The "Media cost" metric shows the total budget spent on the campaign.
The "CPC" metric shows the cost divided by clicks.
The "CPM" metric shows the cost per mille, or the cost divided by impressions x 1000.
The "CTR" metric shows the click-through rate, which is clicks divided by impressions.
The "Impressions" metric shows the total number of impressions served and the "Unique impressions" metrics show the total number of unique people who were shown an ad.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 28 days.
- Select the Clicks, Media cost, CPC, CPM, CTR, Impressions, and Unique impressions metrics.
- Select the Advertiser dimension to split the query results by advertiser.
More resources
See the Supermetrics blog for tips for improving your StackAdapt reporting.
You might also be interested in: