Stay on top of your ad spend, conversions, and other metrics across all your Google Ads campaigns. Create an overall view of what gets the attention of your audience — so you can focus on what matters.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Google Ads connection guide.
Available metrics and dimensions: Find the full list of fields in our Google Ads 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.
Track monthly ad spend this year
See how much you've spent on ads each month year to date, so you can monitor budget pacing and spot months where spend was higher or lower than expected.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This year to date |
Metrics | Cost |
Dimensions | Year & month |
Suggested visualization | Bar chart |
Understanding the data
Cost: The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during the reporting period.
Year & month: Splits results by month so you can compare spend across the year.
Note
Cost is given in the currency used by your Google Ads data source. You can convert the currency to other currencies in Google Sheets and Looker Studio. Learn more about currency conversion.
Compare impressions, clicks, and cost by campaign
See how many times your ads were seen and clicked last month, broken down by campaign alongside cost — useful for identifying which campaigns are delivering the most efficient traffic.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Impressions, Clicks, Cost |
Dimensions | Campaign name |
Suggested visualization | Table |
Understanding the data
Impressions: The number of times your ad appeared on a search results page or website on the Google Network.
Clicks: The number of times people clicked on the link in your ad.
Cost: The sum of your CPC and CPM costs during the reporting period.
Campaign name: Splits results by campaign for side-by-side performance comparison.
Monitor conversions over time
Track the number of conversions generated by your ads each day last month — useful for spotting patterns in when desired actions occur and evaluating the impact of campaign changes.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | Last month |
Metrics | Conversions |
Dimensions | Date |
Suggested visualization | Time series chart |
Understanding the data
Conversions: The number of times people performed a desired action after clicking your ad, such as a newsletter signup, purchase, or app installation.
Date: Splits results by day to track how conversions fluctuate over time.
Analyze clicks, conversions, and cost this month
Get a daily view of clicks, conversions, and cost for the current month in one query — useful for spotting days where spend and performance are out of balance.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Date range | This month to date |
Metrics | Clicks, Conversions, Cost |
Dimensions | Date |
Suggested visualization | Time series chart |
Understanding the data
Clicks: The number of times people clicked on the link in your ad.
Conversions: The number of times people performed a desired action after clicking your ad.
Cost: The sum of your CPC and CPM costs during the reporting period.
Date: Splits results by day so you can track the combined trend across all three metrics.
More resources
You might also be interested in: