ROAS, CPA and CPC across Google, Meta and Microsoft Ads on one definition, every month
Every platform reports well on itself and not at all on the others, so the monthly view gets rebuilt by hand, and it comes out slightly different each time. Quiriz connects Google Ads, Meta Ads and Microsoft Ads read-only, computes every ratio from summed spend and conversions, and delivers the monthly paid report as a deck you refresh instead of rebuild.
This is built for the person who runs the ads and builds the report, where there is no analyst maintaining a dashboard. The work is not hard. It has to be redone every month, and the CPA in the deck never quite matches the CPA in the platform.
What you get
- The same ROAS, CPA and CPC on every platform. Each ratio is total over total, the way the platforms compute it, and the definitions live in Company Context. The cell, the slide and the Slack answer use the same ones.
- Next month's report is a refresh, not a rebuild. Build the deck once. Next month, Refresh all updates every figure and chart.
- Platform ROAS and store-level MER side by side. With Shopify connected, Quiriz adds blended MER and break-even MER, so you can see where platform-reported return overstates what the store earned.
- Read-only, refreshed daily. Connectors never write to your ad accounts. Connectors are included on Plus, Pro and Max.
- Your whole team on one subscription. The founder checking last week's ROAS uses your keys or your Slack binding. There is no per-seat fee.
How it works for a paid media manager
- Connect. Google Ads, Meta Ads and Microsoft Ads connect directly. LinkedIn has no connector, so bring it in as an export or a Google Sheet (see below).
- Quiriz sets up the datasets and definitions. Campaign performance, ad group, keyword, ad set and ad datasets arrive, with spend, clicks, conversions, ROAS, CPA, CPC and CTR as stored metrics in Company Context.
- Ask where you already work. A formula in Excel or Sheets, a Figure in Word, a deck in PowerPoint or Slides, or a pacing question in Slack.
- Deliver. The tracking sheet, the written summary and the monthly review deck.
- Keep it current. Data refreshes daily. Recalculate the sheet, refresh the memo, press Refresh all in the deck.
The metrics come pre-defined
Each connected platform gets the same set, named by platform. Every one is a ratio of sums, so you can check it against how you already measure before relying on it.
| Metric | Names in Quiriz | Definition and caveat |
|---|---|---|
| Spend | Google Ads spend, Meta Ads spend, Microsoft Ads spend | Sum of cost, in the ad account's currency. Excludes agency fees and credits unless the platform nets them out. |
| ROAS | Google Ads ROAS, Meta Ads ROAS, Microsoft Ads ROAS | Conversion value divided by spend. Platform-attributed, so it is an upper bound. |
| CPA | Google Ads CPA, Meta Ads CPA, Microsoft Ads CPA | Spend divided by conversions, whatever the platform counts as a conversion. |
| CPC | Google Ads CPC, Meta Ads CPC, Microsoft Ads CPC | Spend divided by clicks. Meta clicks are link clicks, so it can differ from an Ads Manager export that counts all clicks. |
| CTR | Google Ads CTR, Meta Ads CTR, Microsoft Ads CTR | Clicks divided by impressions. |
| CPM | Meta Ads CPM | Spend divided by thousands of impressions. |
Impressions, clicks, conversions and conversion value are available on their own for every platform, so a question can ask for the components rather than the ratio. Google Ads also stores impression share and lost impression share (budget and rank). Meta Ads also stores hook rate, hold rate and cost per ThruPlay. The reference pages list every dataset and metric.
Why your CPA is probably wrong in the spreadsheet
Put daily CPA in a column and average it, and a Tuesday that spent $2 and converted once counts exactly as much as a Saturday that spent $2,000 and converted eight times. The result moves when nothing about the campaign moved.
Every ratio here is a ratio of sums. CPA for a campaign is that campaign's total spend divided by its total conversions over the window you asked about, never the average of its daily rates. Same for ROAS, CPC, CPM and CTR. It is the definition each ad platform uses in its own interface, and the one your export's per-row cpc and ctr columns will not reproduce once you group them.
A zero denominator returns no figure rather than a zero. A campaign with no conversions yet has no CPA, because $0.00 would read as free.
MER vs ROAS, and break-even ROAS
Platform ROAS tells you what each platform claims. MER (marketing efficiency ratio) tells you what the store earned: net sales divided by total ad spend. They diverge because every platform takes credit for the same purchase. Illustrative: you spend $6,000 on Google and $4,000 on Meta, $10,000 in all. Google reports $21,000 of conversion value (ROAS 3.5) and Meta reports $12,000 (ROAS 3.0). The platforms together claim $33,000, a combined 3.3. Your store booked $28,000 of net sales, so MER is 2.8.
Break-even ROAS is the line below which an order loses money: selling price divided by contribution per order. Illustrative: at a 40% contribution margin before ads, break-even is 1 / 0.40 = 2.5. A MER of 2.8 clears it, and a platform ROAS of 3.5 clears it by more than the store actually earned. Try your own numbers in the break-even ROAS calculator.
With Shopify connected beside your ad accounts, Quiriz adds these metrics automatically, each answering for a period or a trend over time:
Blended MER: net sales divided by Meta Ads plus Google Ads spend.Blended nCACandBlended aMERsit with it.Google Ads nCAC,Meta Ads nCACandMicrosoft Ads nCAC: platform spend per new customer. The aMER versions divide first-order net sales by platform spend.Contribution margin before ads (actual fees)andBreak-even MER (actual fees), when Shopify Payments is connected, so break-even uses the fees you were actually charged. Only Shopify Payments fees are included.
These are store-level figures, not attribution, and they will not equal any one platform's ROAS. They answer for a window or by month, not by campaign. Admins can also define their own metric across datasets and map a Dimension, such as UTM source on orders and platform on ad spend, to break it down.
What it breaks down by
- Campaign and platform, over any window you name.
- Google Ads: ad group, keyword, search term, device and impression share.
- Meta Ads: ad set, ad, and age, gender and placement breakdowns.
- Microsoft Ads: ad group and ad.
Connect, or bring in LinkedIn and everything else
Each connection is one ad account, read-only, refreshed daily, and fully re-read each day over the last 13 months, because the platforms restate recent conversions. Amounts stay in the ad account's currency with no conversion, so combined totals assume the accounts report in the same currency. Your numbers are as current as the last daily refresh, which suits a weekly or monthly review rather than live budget pacing.
- Google Ads: campaigns, campaign, ad group and keyword performance, search terms, impression share and device performance.
- Meta Ads: Facebook and Instagram campaign, ad set and ad performance, video hook and hold rate, reach and frequency, and age, gender and placement.
- Microsoft Ads: Microsoft (Bing) campaign, ad group and ad performance.
- LinkedIn and anything without a connector: there is no LinkedIn Ads connector. Export the Campaign Manager daily campaign report, or land it in a Google Sheet, and upload it. It uses the same ratio-of-sums definitions. For uploads, two columns matter most: campaign id, which is how the daily rows meet a campaign list, and spend in currency. A file of
cost_microsis refused rather than silently divided. See combining Google, Meta and LinkedIn exports.
What connecting more sources adds
With more than one source connected, Quiriz can answer across them, joined on a shared date or a mapping you supply.
- Google Ads, Meta Ads and Microsoft Ads side by side. "Which platform returned more per dollar last month, and what did a conversion cost on each?" Each platform names its columns and counts conversions differently, so in a spreadsheet the comparison starts with a day of renaming and ends with averaged ratios. Conversion counts remain platform-attributed.
- Google Ads spend against GA4 key events. "Did the weeks we raised Google Ads spend bring more key events from paid search in Google Analytics?" Connectors: Google Ads and Google Analytics 4. The join is on date. GA4 traffic is broken out by default channel group rather than by campaign, so compare against the Paid Search channel.
- Spend and revenue. Shopify beside your ad accounts gives the MER figures above. HubSpot deals by paid source beside ad spend works the same way, joined by month and source category.
Search Console beside Google Ads (spend on keywords you already rank for) works the same way. Cross-source figures that are not on the pre-defined list are marked in each answer as either a stored definition or freehand, and a figure you rely on is worth defining once in Company Context. The connectors hub lists the cross-source metrics added automatically.
What it will not answer
Conversions will not tie to your store or CRM totals, and no tool reading ad platform data can make them. Each platform attributes and dates conversions by its own window, and all three will claim the same purchase. Add up three platforms' conversions and you have double-counted on purpose. Quiriz reports what the platform claimed. It does not re-attribute, and it will say so rather than quietly reconciling.
MER and CAC are store-level, not credit. Dividing store revenue by total spend tells you whether paid media as a whole pays. It does not say which platform or campaign deserved the credit.
Reach does not add up across days. Reach counts people, so a week of daily reach is not a weekly reach. Meta Ads reach and frequency are stored at monthly grain. LinkedIn data comes in only as an export.
The monthly paid report you stop rebuilding
The paid report has three audiences: you, checking pacing during the month; the founder or marketing lead, reading a written summary; and the monthly review, which wants a deck. With the ad accounts connected, each is a set of questions that refresh daily.
- The tracking sheet, in Excel or Google Sheets.
=QUIRIZ.ASK("ROAS and CPA by platform by month this year", "table")spills the table. In Google Sheets, use=QUIRIZ("spend and conversions by campaign last month", "table"). Every ratio is a ratio of sums, so the sheet's CPA matches the platform's. - The written summary, in Word or Google Docs. In Word, put last month's spend and ROAS inside your sentences as live Figures; with Mark refreshes as tracked changes on, the reader sees which numbers moved. In Docs, type "spend and conversions by campaign last month" where the table belongs and press Table.
- The review deck, in PowerPoint or Google Slides. Make a deck (Beta) plans the slides first, then builds editable charts. Next month, Refresh all.
- The pacing question, in Slack. "What has Meta spent this month, and at what CPA?" answered in a thread with the chart, as of the last daily refresh. Slack is included from the Plus plan.
Install: Excel, Word, PowerPoint, Sheets, Docs, Slides.
Scheduled data refresh and scheduled reports are available on Plus and up.
Make a deck: two prompts to try
Quiriz plans the slides first, so any title or question can be edited before it builds. In PowerPoint each chart and table carries takeaways written from that slide's own figures; Slides closes with an executive summary.
Monthly paid media review
PowerPoint, Consulting style. Tick your Google Ads and Meta Ads datasets, and your store orders for blended ROAS.
"Paid media review for August 2026. Spend, platform conversion value and ROAS for Facebook and Google for August against July, ROAS by month this year by platform, spend and ROAS by campaign for August, spend and ROAS by month this year for the campaign whose ROAS fell the most, and blended ROAS (net sales divided by total ad spend) by month. End with recommendations."
What comes back, about nine slides:
- Agenda and executive summary.
- August against July by platform: spend, conversion value and ROAS, as a table.
- ROAS by platform by month: a line chart.
- August by campaign: a table.
- The campaign that fell: spend and ROAS by month, showing the month it turned.
- Blended ROAS by month: a line chart, labeled as store-level, not attribution.
- Recommendations, written from those slides.
Budget reallocation review
Google Slides. Tick your Google Ads, Meta Ads and signup (product analytics) datasets.
"Budget review for Q3 and October 2026. Spend and signups by platform by month from July to October, weekly cost per signup on Google Ads and Meta Ads, October cost per signup and click-to-signup rate by campaign, and paid signups as a share of all signups by month."
What comes back: spend and signups by platform by month, weekly cost per signup on each platform as a line (where one platform getting steadily more expensive is plain to see), an October campaign table ranked by cost per signup, and paid share of signups by month, then the executive summary. It is the deck for deciding where next month's budget goes.
Pricing
Free is $0 for 5 files. Connectors, Slack and scheduled reports start on Plus at $12 a month ($120 a year); Pro is $30 and Max is $60 a month. You pay for the workspace and the person who builds it, not for everyone who asks a question. See pricing →
Your files stay yours, and we do not train on your data. Privacy policy →
Related reading
- Break-even ROAS calculator, and the tool
- How to calculate ROAS by channel
- Facebook Ads vs Google Ads ROAS: comparing two platforms that count conversions differently
- A Google Ads report from your connected account
- A Google Ads dashboard from your connected account
- A Meta Ads dashboard from your connected account
- Google Ads search terms and wasted spend
- Tracking Google Ads conversions in GA4
- Asking an AI about your Google Ads account and your Meta Ads account
- CPA vs CPL, and why your number is wrong: the averaged rate column, and what it costs
- Combining Google, Meta and LinkedIn exports: the route for LinkedIn
- CTR, CPC and CPM: what the export column is not telling you
- Why your conversions do not match Shopify: the boundary, stated plainly
- Margin by product category, once the ad spend is in
- All guides →