Blog · Board and management reporting · Sales teams
Compare Google advertising costs, conversions, and attributed revenue from campaign exports. Follow a worked example that reconciles campaign totals and separates advertising return from profit.
Google ad KPIs connect advertising spend to traffic, conversions, and attributed business value. Compare campaigns using the same dates, conversion actions, currency, and attribution settings, then calculate the ratios from their underlying totals. A campaign can attract inexpensive clicks while producing expensive sales outcomes.
A useful campaign review answers a specific question: where should the team investigate cost, conversion quality, or revenue before changing its budget? Select the measures that support that decision rather than treating every available column as a key performance indicator.
Export campaign ID, campaign name, reporting period, impressions, clicks, cost, conversions, and conversion value. Preserve the account currency and the settings that define which conversion actions enter the report. Use campaign IDs as keys because names can change.
For a B2B company, a conversion might be an inquiry, a qualified meeting, or a completed purchase. These are different business events. A marketing operations owner should record the selected event, while sales operations confirms whether it corresponds to the intended CRM outcome. Finance confirms whether the reported value represents sales, estimated lead value, or another measure.
Do not label every conversion value as revenue. Google's documentation explains that conversion values can be transaction-specific or a common value assigned to conversions. An assigned lead value is useful for a defined comparison, but it is not evidence that an invoice was issued.
The following definitions use clicks as the qualifying interactions because the worked example contains search campaigns measured on that basis.
| Measure | Calculation | Question it answers |
|---|---|---|
| Clickthrough rate, or CTR | Clicks / impressions | Do impressions lead to clicks? |
| Average cost per click, or CPC | Cost / clicks | What does a click cost? |
| Conversion rate | Conversions / qualifying interactions | How often does an interaction convert? |
| Cost per acquisition, or CPA | Cost / conversions | What does the selected conversion cost? |
| Return on ad spend, or ROAS | Conversion value / cost | What attributed value accompanies each advertising dollar? |
Google defines CTR as clicks divided by impressions. Its conversion rate definition uses eligible ad interactions, which need not always be clicks. Keep the exported interaction basis when comparing different campaign formats.
Aggregate CPA = Total cost / total conversions
Aggregate ROAS = Total conversion value / total cost
Express CTR and conversion rate as percentages. Express CPC and CPA in dollars, and ROAS as a multiple. A zero denominator produces an undefined ratio; show that explicitly instead of displaying a reassuring zero.
Consider an illustrative US industrial supplier reviewing September 2026. All campaigns use USD and the same purchase conversion action. Here, conversion value is the recorded sales value attributed to that action, before deducting product and operating costs.
| Campaign | Impressions | Clicks | Cost (USD) | Conversions | Attributed sales value (USD) |
|---|---|---|---|---|---|
| Brand Search | 40,000 | 4,000 | 2,400 | 100 | 12,000 |
| Nonbrand Search | 120,000 | 3,000 | 6,000 | 60 | 9,000 |
| Product Search | 60,000 | 3,000 | 3,600 | 90 | 18,000 |
| Total | 220,000 | 10,000 | 12,000 | 250 | 39,000 |
Apply the definitions to each row. Percentages, dollar ratios, and multiples below are rounded to two decimal places; calculations retain the underlying values.
| Campaign | CTR | CPC (USD) | Conversion rate | CPA (USD) | ROAS |
|---|---|---|---|---|---|
| Brand Search | 10.00% | 0.60 | 2.50% | 24.00 | 5.00x |
| Nonbrand Search | 2.50% | 2.00 | 2.00% | 100.00 | 1.50x |
| Product Search | 5.00% | 1.20 | 3.00% | 40.00 | 5.00x |
| Total from summed inputs | 4.55% | 1.20 | 2.50% | 48.00 | 3.25x |
The overall CPA is $12,000 / 250 = $48.00. Overall ROAS is $39,000 / $12,000 = 3.25x. Nonbrand Search has a $100.00 CPA because $6,000 / 60 = $100.00; its lower conversion rate and higher click cost both warrant investigation.
The campaign costs must sum to the selected campaign report total: $2,400 + $6,000 + $3,600 = $12,000. Check clicks, impressions, conversions, and value in the same way. Exclude report subtotal rows when adding detail rows.
A second check reconstructs value from campaign spend and ROAS:
2,400 × 5.00 + 6,000 × 1.50 + 3,600 × 5.00 = 39,000
For CPA, divide total cost by total conversions rather than averaging campaign CPAs. The unweighted average of $24.00, $100.00, and $40.00 is $54.67, which does not describe the account's acquisition cost. The campaigns contribute different conversion volumes.
If transaction-level data is available, reconcile the attributed sales values to the eligible transaction list under the documented attribution rules. The advertising total need not equal the whole company ledger: organic sales, untracked transactions, returns, and different reporting dates can sit outside its scope.
Marketing owns the campaign investigation. For Nonbrand Search, inspect the search terms, landing page, and purchase records behind the result before cutting spend. Compare like audiences and purchase types; brand demand and new customer acquisition have different roles.
Sales operations owns the connection to qualified opportunities when the selected conversion is a lead. Finance owns the bridge from attributed sales to margin and recognized revenue. Use financial KPIs for the wider profitability review rather than asking ROAS to answer every financial question.
Keep the review distinct from a general metric versus KPI discussion. Decide which exception needs action, who will investigate it, and which later export will confirm the outcome. For another advertising source, Facebook ad KPIs covers its own measurement context.
Covirage is not affiliated with Google.
Bring a campaign export with its conversion definitions and a sample of your own transaction or CRM records where relevant. Covirage maps the columns, and its tools compute and check the supplied figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own export.
See revenue driver analysis for the supporting business context.
Prioritize the outcome your campaign is intended to produce, such as qualified opportunities or attributable sales. Keep cost and volume beside that outcome. A low cost per form submission can conceal weak sales qualification, so document the conversion action before comparing campaigns.
ROAS compares attributed conversion value with advertising spend. It does not automatically deduct product costs, sales labor, fulfillment, or returns. When conversion value represents sales revenue, assess those costs separately before treating the campaign as a profitable source of business.
Advertising and CRM reports can use different events, attribution rules, and reporting dates. A form submission may count as a conversion before an opportunity closes. Compare a documented set of conversion actions with matching CRM records and allow time for outcomes to mature.