Home / Paid Media
For paid media managers and PPC specialists

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.

Try it on sample ad data → No signup, no account connection, no tracking script.

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

How it works for a paid media manager

  1. 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).
  2. 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.
  3. 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.
  4. Deliver. The tracking sheet, the written summary and the monthly review deck.
  5. 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.

MetricNames in QuirizDefinition and caveat
SpendGoogle Ads spend, Meta Ads spend, Microsoft Ads spendSum of cost, in the ad account's currency. Excludes agency fees and credits unless the platform nets them out.
ROASGoogle Ads ROAS, Meta Ads ROAS, Microsoft Ads ROASConversion value divided by spend. Platform-attributed, so it is an upper bound.
CPAGoogle Ads CPA, Meta Ads CPA, Microsoft Ads CPASpend divided by conversions, whatever the platform counts as a conversion.
CPCGoogle Ads CPC, Meta Ads CPC, Microsoft Ads CPCSpend divided by clicks. Meta clicks are link clicks, so it can differ from an Ads Manager export that counts all clicks.
CTRGoogle Ads CTR, Meta Ads CTR, Microsoft Ads CTRClicks divided by impressions.
CPMMeta Ads CPMSpend 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:

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

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.

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.

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.

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:

  1. Agenda and executive summary.
  2. August against July by platform: spend, conversion value and ROAS, as a table.
  3. ROAS by platform by month: a line chart.
  4. August by campaign: a table.
  5. The campaign that fell: spend and ROAS by month, showing the month it turned.
  6. Blended ROAS by month: a line chart, labeled as store-level, not attribution.
  7. 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.

Ask the sample ad data → Then connect an ad account, or try your own export and check it against a figure you already trust.

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

Questions

Why does my CPA differ from the one in my spreadsheet?
Because a spreadsheet usually averages each row's daily CPA, which gives a $2 day the same weight as a $2,000 day. Quiriz divides total spend by total conversions for the group you asked about, which is the definition the ad platforms use themselves.
What is the difference between MER and ROAS?
ROAS is conversion value divided by spend as one platform reports it, so platforms can each claim the same purchase. MER is store net sales divided by total ad spend, so it counts each sale once. With Shopify connected beside Google Ads and Meta Ads, Quiriz adds Blended MER automatically. It is a store-level figure, not attribution.
How do I calculate break-even ROAS?
Divide the selling price by the contribution per order, which is the same as 1 divided by your contribution margin before ads. At a 40% margin, break-even ROAS is 2.5. Any ROAS above it makes money on the order. With Shopify Payments connected, Quiriz also stores Break-even MER (actual fees) using the fees you were actually charged.
Do the conversions match my store or CRM totals?
No, and nothing reading ad platform data can make them. Each platform attributes and dates conversions by its own window, so all three claim the same purchase. Ask the ad question of ad data and the revenue question of your order or CRM data.
Which ad platforms connect, and what about LinkedIn?
Google Ads, Meta Ads and Microsoft Ads connect directly. Each connection is read-only, refreshed daily and included on paid plans. There is no LinkedIn Ads connector. Export the Campaign Manager report or land it in a Google Sheet and upload it, and it uses the same definitions.
Should I connect my ad accounts or upload exports?
Connect when you want daily-fresh numbers and a join with other sources such as Shopify or Google Analytics 4. Upload when the source has no connector, such as LinkedIn, or when you would rather not sign in to an account. Both routes use the same definitions.
Is CTR shown as a percentage?
Answers return rates as a decimal, 0.0408 rather than 4.08%, because that is what the stored definition computes. It is the same number; if you want percentages in a report, format the column.
Can Quiriz build the monthly paid media deck?
Yes. In Quiriz for PowerPoint or Google Slides, describe the deck, such as ROAS and CPA by platform for last month against the month before. Quiriz shows a plan of slide titles and questions to edit before it builds, with editable charts. Every ratio is a ratio of sums, and next month you press Refresh all instead of rebuilding it. Make a deck is in Beta.
Does this work for an agency reporting on several clients?
Yes. Connect each client's ad accounts, and the ad account breakdown separates clients. To manage several client companies under one admin login with a portfolio view, you need the Max plan. See Quiriz for agencies.