Google Ads connector: datasets and metric definitionsBeta
Bring in campaign, ad group and keyword performance, plus search terms, impression share, quality score parts and device performance. Updates daily.
When you connect Google Ads, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.
DatasetsMetric definitionsWorks withQuestionsFAQ
Datasets
| Dataset | What it holds |
|---|---|
| [Google Ads] Campaigns | Campaigns9 columnscampaign_id, campaign_name, campaign_status, channel_type, bidding_strategy, daily_budget, currency, account_id, account_name |
| [Google Ads] Campaign performance | Campaign performance12 columnsdate, campaign_id, campaign_name, platform, channel_type, account_name, impressions, clicks, cost, conversions, conversion_value, currency |
| [Google Ads] Ad group performance | Ad group performance12 columnsdate, campaign_id, campaign_name, ad_group_id, ad_group_name, ad_group_status, impressions, clicks, cost, conversions, conversion_value, currency |
| [Google Ads] Keyword performance | Keyword performance16 columnsmonth, campaign_name, ad_group_name, keyword, match_type, keyword_status, quality_score, expected_ctr, ad_relevance, landing_page_experience, impressions, clicks, cost, conversions, conversion_value, currency |
| [Google Ads] Impression share | Search and Shopping campaigns per day (Performance Max has no impression share). Shares are stored as the impression counts behind them: impression share = measured / eligible impressions, lost to budget = budget-lost / eligible, lost to rank = rank-lost / eligible; top and absolute-top use their own eligible counts. Always sum the parts, then divide; never average daily shares. Google reports very low shares as "less than 10%", which reads as 9.99%.13 columnsdate, campaign_id, campaign_name, channel_type, impressions, measured_impressions, eligible_impressions, budget_lost_impressions, rank_lost_impressions, top_impressions, eligible_top_impressions, abs_top_impressions, eligible_abs_top_impressions |
| [Google Ads] Search terms | Search terms from Search and Shopping campaigns by month; Performance Max is excluded (Google reports its terms only as categories). term_status says whether the term is already a keyword or excluded.11 columnsmonth, campaign_name, ad_group_name, search_term, term_status, impressions, clicks, cost, conversions, conversion_value, currency |
| [Google Ads] Device performance | Device performance11 columnsmonth, campaign_id, campaign_name, channel_type, device, impressions, clicks, cost, conversions, conversion_value, currency |
Metric definitions
Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.
[Google Ads] Campaign performance
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Google Ads spend | Sum of cost | date | Google Ads cost in the account currency, by day. |
| Google Ads impressions | Sum of impressions | date | Times Google Ads showed an ad. |
| Google Ads clicks | Sum of clicks | date | Clicks on Google Ads. |
| Google Ads conversions | Sum of conversions | date | Conversions as Google Ads counts them (the account's conversion actions and attribution). |
| Google Ads conversion value | Sum of conversion_value | date | Value of Google Ads conversions in the account currency. |
| Google Ads ROAS | Google Ads conversion value ÷ Google Ads spend | date | Conversion value per unit of spend (2.5 = 2.50 back for 1.00 spent). |
| Google Ads CPC | Google Ads spend ÷ Google Ads clicks | date | Average cost per click. |
| Google Ads CTR | Google Ads clicks ÷ Google Ads impressions | date | Clicks per impression, as a decimal (0.03 = 3%). |
| Google Ads CPA | Google Ads spend ÷ Google Ads conversions | date | Average cost per conversion. |
[Google Ads] Impression share
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Google Ads share-measured impressions | Sum of measured_impressions | date | Helper: impressions on days Google reported an impression share. The numerator of impression share. |
| Google Ads eligible impressions | Sum of eligible_impressions | date | Helper: impressions the ads were eligible to show (impressions / impression share). The denominator of every impression share. |
| Google Ads budget-lost impressions | Sum of budget_lost_impressions | date | Helper: eligible impressions lost to budget. |
| Google Ads rank-lost impressions | Sum of rank_lost_impressions | date | Helper: eligible impressions lost to ad rank (bids and quality). |
| Google Ads top impressions | Sum of top_impressions | date | Helper: impressions shown above the organic results. |
| Google Ads top-eligible impressions | Sum of eligible_top_impressions | date | Helper: impressions eligible to show above the organic results. |
| Google Ads absolute-top impressions | Sum of abs_top_impressions | date | Helper: impressions shown in the very first ad position. |
| Google Ads absolute-top-eligible impressions | Sum of eligible_abs_top_impressions | date | Helper: impressions eligible for the very first ad position. |
| Google Ads impression share | Google Ads share-measured impressions ÷ Google Ads eligible impressions | date | Search and Shopping impressions received as a share of those the ads were eligible for, as a decimal (0.62 = 62%). Performance Max is not included. |
| Google Ads lost impression share (budget) | Google Ads budget-lost impressions ÷ Google Ads eligible impressions | date | Share of eligible impressions lost because the budget ran out, as a decimal. |
| Google Ads lost impression share (rank) | Google Ads rank-lost impressions ÷ Google Ads eligible impressions | date | Share of eligible impressions lost to low ad rank (bid or quality), as a decimal. |
| Google Ads top impression share | Google Ads top impressions ÷ Google Ads top-eligible impressions | date | Share of top-of-page impressions won, as a decimal. |
| Google Ads absolute top impression share | Google Ads absolute-top impressions ÷ Google Ads absolute-top-eligible impressions | date | Share of first-position impressions won, as a decimal. |
[Google Ads] Search terms
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Google Ads search term spend | Sum of cost | month | Cost of the search terms people typed before clicking Search and Shopping ads (Performance Max excluded), by month. |
| Google Ads search term clicks | Sum of clicks | month | Clicks by search term. |
| Google Ads search term conversions | Sum of conversions | month | Conversions by search term. |
[Google Ads] Device performance
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Google Ads device spend | Sum of cost | month | Google Ads cost by device (mobile, desktop, tablet, connected TV), by month. |
| Google Ads device clicks | Sum of clicks | month | Clicks by device. |
| Google Ads device conversions | Sum of conversions | month | Conversions by device. |
| Google Ads device conversion value | Sum of conversion_value | month | Conversion value by device. |
| Google Ads device ROAS | Google Ads device conversion value ÷ Google Ads device spend | month | Conversion value per unit of spend, by device. |
Works with other connectors
These metrics are added automatically when Google Ads and the other connector are both connected. The rules they follow are on the connectors page.
| Metric | How it is calculated | Needs | Notes |
|---|---|---|---|
| Google Ads nCAC | Google Ads spend ÷ New customers | Shopify + Google Ads | Google Ads spend per new customer: Google Ads spend divided by New customers in the same period. |
| Google Ads aMER | New customer net sales ÷ Google Ads spend | Shopify + Google Ads | First-order net sales per Google Ads dollar: New customer net sales divided by Google Ads spend in the same period. |
| Blended nCAC | (Meta Ads spend + Google Ads spend) ÷ New customers | Shopify + Meta Ads + Google Ads | Meta Ads and Google Ads spend per new customer. |
| Blended aMER | New customer net sales ÷ (Meta Ads spend + Google Ads spend) | Shopify + Meta Ads + Google Ads | First-order net sales per paid ad dollar across Meta Ads and Google Ads. |
| Blended MER | Net sales ÷ (Meta Ads spend + Google Ads spend) | Shopify + Meta Ads + Google Ads | Marketing efficiency ratio: Shopify net sales per paid ad dollar across Meta Ads and Google Ads, in the same period. Net sales are Shopify's own, not what the platforms report. |
- Shopify + Google Ads: New-customer cost and return on Google. Google Ads nCAC and aMER, the same pair for Google spend.
- Shopify + Meta Ads + Google Ads: Blended MER across ad platforms. With Meta and Google both connected, Blended nCAC, aMER and MER divide Shopify’s figures by the combined spend.
- Google Ads + Google Analytics: Ad conversions against analytics. Why Google Ads and GA4 count conversions differently. Read the guide.
- Meta Ads + Google Ads: Meta against Google. ROAS by platform on the same basis, because the metric names line up across ad platforms. Read the guide.
- HubSpot + Google Ads + Meta Ads: Pipeline per ad dollar. HubSpot closed-won revenue against ad spend by month, as your own cross-source metric. Define it as your own metric.
Questions to ask
- How much did we spend on Google Ads each month this year?
- Which campaigns had the best ROAS last month?
- What was our cost per conversion by campaign in the last 30 days?
- Which keywords spent the most without converting last quarter?
- Which search terms spent money without converting last month?
- What is our impression share by campaign, and how much is lost to budget versus rank?
- How do mobile, desktop and tablet compare on cost per conversion?
Related guides
- Paid Media Reporting: ROAS, CPA and CPC on One Definition
- Google Ads AI: Ask Your Account Questions
- Google Ads Dashboard You Build by Asking
- Google Ads Wasted Spend: Find Keywords That Spend Without Converting
- Google Ads Report: What to Include and How to Build It (2026)
Ask Google Ads in plain words
Try the questions on sample data with no signup, then connect Google Ads read-only and ask your own.
Try Quiriz free →Frequently asked questions
Does Quiriz change anything in Google Ads?
How often does the Google Ads data refresh?
Can I change how a metric is calculated?
Can I combine Google Ads with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.