Home / Connectors / Google Ads
Connector

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.

7 datasets30 metric definitionsRead-onlyRefreshes daily5 cross-source metrics

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

DatasetWhat it holds
[Google Ads] CampaignsCampaigns
9 columnscampaign_id, campaign_name, campaign_status, channel_type, bidding_strategy, daily_budget, currency, account_id, account_name
[Google Ads] Campaign performanceCampaign performance
12 columnsdate, campaign_id, campaign_name, platform, channel_type, account_name, impressions, clicks, cost, conversions, conversion_value, currency
[Google Ads] Ad group performanceAd group performance
12 columnsdate, campaign_id, campaign_name, ad_group_id, ad_group_name, ad_group_status, impressions, clicks, cost, conversions, conversion_value, currency
[Google Ads] Keyword performanceKeyword performance
16 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 shareSearch 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 termsSearch 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 performanceDevice performance
11 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

MetricHow it is calculatedDated byNotes
Google Ads spendSum of costdateGoogle Ads cost in the account currency, by day.
Google Ads impressionsSum of impressionsdateTimes Google Ads showed an ad.
Google Ads clicksSum of clicksdateClicks on Google Ads.
Google Ads conversionsSum of conversionsdateConversions as Google Ads counts them (the account's conversion actions and attribution).
Google Ads conversion valueSum of conversion_valuedateValue of Google Ads conversions in the account currency.
Google Ads ROASGoogle Ads conversion value ÷ Google Ads spenddateConversion value per unit of spend (2.5 = 2.50 back for 1.00 spent).
Google Ads CPCGoogle Ads spend ÷ Google Ads clicksdateAverage cost per click.
Google Ads CTRGoogle Ads clicks ÷ Google Ads impressionsdateClicks per impression, as a decimal (0.03 = 3%).
Google Ads CPAGoogle Ads spend ÷ Google Ads conversionsdateAverage cost per conversion.

[Google Ads] Impression share

MetricHow it is calculatedDated byNotes
Google Ads share-measured impressionsSum of measured_impressionsdateHelper: impressions on days Google reported an impression share. The numerator of impression share.
Google Ads eligible impressionsSum of eligible_impressionsdateHelper: impressions the ads were eligible to show (impressions / impression share). The denominator of every impression share.
Google Ads budget-lost impressionsSum of budget_lost_impressionsdateHelper: eligible impressions lost to budget.
Google Ads rank-lost impressionsSum of rank_lost_impressionsdateHelper: eligible impressions lost to ad rank (bids and quality).
Google Ads top impressionsSum of top_impressionsdateHelper: impressions shown above the organic results.
Google Ads top-eligible impressionsSum of eligible_top_impressionsdateHelper: impressions eligible to show above the organic results.
Google Ads absolute-top impressionsSum of abs_top_impressionsdateHelper: impressions shown in the very first ad position.
Google Ads absolute-top-eligible impressionsSum of eligible_abs_top_impressionsdateHelper: impressions eligible for the very first ad position.
Google Ads impression shareGoogle Ads share-measured impressions ÷ Google Ads eligible impressionsdateSearch 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 impressionsdateShare 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 impressionsdateShare of eligible impressions lost to low ad rank (bid or quality), as a decimal.
Google Ads top impression shareGoogle Ads top impressions ÷ Google Ads top-eligible impressionsdateShare of top-of-page impressions won, as a decimal.
Google Ads absolute top impression shareGoogle Ads absolute-top impressions ÷ Google Ads absolute-top-eligible impressionsdateShare of first-position impressions won, as a decimal.

[Google Ads] Search terms

MetricHow it is calculatedDated byNotes
Google Ads search term spendSum of costmonthCost of the search terms people typed before clicking Search and Shopping ads (Performance Max excluded), by month.
Google Ads search term clicksSum of clicksmonthClicks by search term.
Google Ads search term conversionsSum of conversionsmonthConversions by search term.

[Google Ads] Device performance

MetricHow it is calculatedDated byNotes
Google Ads device spendSum of costmonthGoogle Ads cost by device (mobile, desktop, tablet, connected TV), by month.
Google Ads device clicksSum of clicksmonthClicks by device.
Google Ads device conversionsSum of conversionsmonthConversions by device.
Google Ads device conversion valueSum of conversion_valuemonthConversion value by device.
Google Ads device ROASGoogle Ads device conversion value ÷ Google Ads device spendmonthConversion 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.

MetricHow it is calculatedNeedsNotes
Google Ads nCACGoogle Ads spend ÷ New customersShopify + Google AdsGoogle Ads spend per new customer: Google Ads spend divided by New customers in the same period.
Google Ads aMERNew customer net sales ÷ Google Ads spendShopify + Google AdsFirst-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 customersShopify + Meta Ads + Google AdsMeta Ads and Google Ads spend per new customer.
Blended aMERNew customer net sales ÷ (Meta Ads spend + Google Ads spend)Shopify + Meta Ads + Google AdsFirst-order net sales per paid ad dollar across Meta Ads and Google Ads.
Blended MERNet sales ÷ (Meta Ads spend + Google Ads spend)Shopify + Meta Ads + Google AdsMarketing 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.

Questions to ask

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?
No. The Google Ads connector is read-only. Quiriz reads the data into datasets and never writes back to Google Ads.
How often does the Google Ads data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Google Ads with other sources?
Yes. 5 cross-source metrics are added automatically when the other connector is there too. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.