Use the Yahoo DSP data source connector to pull your basic ad metrics — including conversion details and engagement data — to your destination of choice. Combine Yahoo DSP data with other paid media sources to get a full understanding of which campaigns and content work best.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Yahoo DSP connection guide.
Available metrics and dimensions: Find the full list of fields in our Yahoo DSP 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 clicks, impressions, conversions, and cost last month
Get a comprehensive view of last month's ad performance — combining clicks, conversions, cost, impressions, and viewable impressions by ad, campaign, and date — so you can evaluate delivery and efficiency across your campaigns.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Clicks, Conversions, Cost, Impressions, Viewable impressions |
Dimensions | Ad, Campaign, Date |
Suggested visualization | Table |
Understanding the data
Clicks: The number of times an ad was clicked within the reporting period.
Conversions: The total number of conversions attributed to the ad within the reporting period.
Cost: The total cost of the ads within the reporting period.
Impressions: The total number of times an ad was displayed.
Viewable impressions: The total number of times an ad was displayed while in view.
Ad: The name of the individual ad, used to compare performance at the ad level.
Campaign: The name of the campaign the ad belongs to.
Date: Splits results by day for granular trend analysis.
Analyze clicks, impressions, and CTR by line and creative
See how many clicks and impressions your ads received over the last 7 days, broken down by ad, line, and creative — useful for identifying which creative formats and line items are driving the strongest engagement.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last 7 days |
Metrics | Clicks, Impressions, CTR |
Dimensions | Ad, Line, Creative |
Suggested visualization | Table |
Understanding the data
Clicks: The number of times an ad was clicked within the reporting period.
Impressions: The total number of times an ad was displayed.
CTR: Click-through rate — clicks divided by impressions.
Ad: The name of the individual ad.
Line: The line item associated with the ad.
Creative: The creative used in the ad, used to compare performance across different creative formats.
Track detailed campaign cost and performance year to date
See a full performance breakdown by campaign for the year — covering clicks, conversions, cost, impressions, CPC, CPM, and CTR — so you can evaluate efficiency trends and identify your strongest and weakest campaigns.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Year to date |
Metrics | Clicks, Conversions, Cost, Impressions, CPC, CPM, CTR |
Dimensions | Campaign, Date |
Suggested visualization | Table |
Understanding the data
Clicks: The number of times an ad was clicked within the reporting period.
Conversions: The total number of conversions attributed to the campaign.
Cost: The total cost of the ads within the reporting period.
Impressions: The total number of times an ad was displayed.
CPC: Cost per click — total cost divided by total clicks.
CPM: Cost per mille — total cost divided by impressions, multiplied by 1,000.
CTR: Click-through rate — clicks divided by impressions.
Campaign: Splits results by campaign for side-by-side performance comparison.
Date: Splits results by day for granular trend analysis.
More resources
You might also be interested in: