A useful multi platform ppc report combines Google, Meta and TikTok into one business view: total media spend, one deduplicated results number and one clearly defined MER. It then shows the platform split underneath, with each platform’s attributed conversions labelled as diagnostic data rather than added into a false total.
The central rule is simple. Add spend because each dollar was spent once. Do not add platform-reported conversions because the same conversion may be claimed more than once.
Why three platform reports do not add up
Google, Meta and TikTok each report performance from inside their own measurement systems. Each platform has its own attribution settings, lookback windows and rules for assigning credit.
A person might see an ad on Meta, search for the business on Google and later convert after another visit. Meta may claim influence from the earlier interaction. Google may claim the conversion from the later search. TikTok could also claim it if that person interacted with a TikTok ad during the applicable window.
That does not automatically mean one of the platforms is wrong. It means they are answering separate questions:
- The platform report asks, “Which conversions can this platform claim under its attribution rules?”
- The combined client report asks, “How much did we spend, and what did the business receive?”
Those questions need separate rows in the report.
Treat platform conversions as claims, not additions
Never produce a combined conversion total by adding the conversion column from Google to the conversion columns from Meta and TikTok. That total can count one person or sale more than once.
Use a first-party source for the combined result whenever one is available. Depending on the client, that may be a CRM, ecommerce system, booking system or another system that can identify individual leads or transactions.
Deduplication should use a stable identifier where possible, such as an order ID or lead ID. If a stable identifier is unavailable, state the limitation instead of presenting an estimated total as exact.
Keep the native reports
Native platform reporting still matters. Google, Meta and TikTok are often the better views for campaign diagnostics, delivery details and platform-specific optimization decisions.
The mistake is not using those reports. The mistake is treating three attribution systems as if they were one accounting system.
| Reporting view | Best used for | Main limitation |
|---|---|---|
| Google, Meta or TikTok platform report | Campaign diagnosis and platform-level decisions | Can claim the same conversion as another platform |
| First-party business system | Deduplicated leads, sales or revenue | Channel assignment still depends on the chosen attribution method |
| Combined client report | Total spend, total business result and blended efficiency | Needs clear definitions and consistent data handling |
Build one reporting spine before adding charts
The reporting spine is the small set of numbers that remains consistent from the summary page through every detail table. For a multi platform ppc report, start with the business totals before showing channel detail.
1. Define the reporting period
Use the same start date, end date and time zone for every platform. A report that closes Google at one time and Meta several hours later can create avoidable differences around the reporting boundary.
Record whether the current period is final or still receiving late conversions. If conversions can appear after the period ends, label the report’s extraction date.
2. Define what counts as spend
Pull media spend from the ad accounts. Before adding it together, confirm that every account uses the same reporting currency.
Keep the headline media-spend number separate from agency fees, production costs and other marketing expenses. Those costs can appear elsewhere, but they should not move in and out of the MER denominator without explanation.
The basic spend formula is:
Total media spend = Google spend + Meta spend + TikTok spend
This is usually the cleanest number in the report because the same dollar is not spent twice across platforms.
3. Choose one business result
Pick the result that best represents the client’s objective and can be counted without duplication. It might be completed sales, qualified leads, booked appointments or another defined outcome.
Write the definition beside the number. “Leads” is not enough if one source counts form submissions while another counts calls, chats and duplicate submissions.
A useful label looks like this:
Qualified leads: unique leads accepted into the CRM during the reporting period.
That definition gives the media buyer and client something specific to verify.
4. Define MER before calculating it
MER compares revenue with the spend included in its denominator:
MER = measured revenue ÷ defined marketing spend
If the denominator contains only Google, Meta and TikTok media spend, label the metric “paid media MER” or “blended paid media MER.” If it includes other marketing costs, list them.
For a fuller treatment of the formula and its limits, see Marketing Efficiency Ratio: How to Calculate It and When It Beats ROAS.
Do not force an MER into the report when reliable revenue is unavailable. Show total results and blended cost per result instead, then mark MER as unavailable.
5. Reconcile the account list
Keep a list of every account included in the report. Confirm that paused accounts, newly opened accounts and accounts with billing problems are not silently omitted.
This is especially important for multi-location clients. A clean dashboard can still be incomplete if one account stopped spending because a card expired or access changed.
A worked example with simple maths
The following numbers are illustrative. They do not represent an Ads Arsenal result, client result or benchmark.
Say the reporting period contains this media spend:
| Platform | Media spend | Platform-attributed conversions |
|---|---|---|
| $10,000 | 120 | |
| Meta | $6,000 | 90 |
| TikTok | $4,000 | 50 |
| Total shown by addition | $20,000 | Do not report 260 as the business total |
The spend adds cleanly:
$10,000 + $6,000 + $4,000 = $20,000 total media spend
The platform-attributed conversions do not. The same conversion may appear in more than one platform’s column.
Now say the client’s first-party system contains 200 unique, accepted results and $100,000 in measured revenue for the same period. The combined report would show:
| Headline metric | Example value | Definition |
|---|---|---|
| Total media spend | $20,000 | Google, Meta and TikTok spend |
| Unique business results | 200 | Deduplicated results from the first-party source |
| Blended cost per result | $100 | Total media spend divided by unique results |
| Paid media MER | 5.0 | Measured revenue divided by media spend |
The calculations are:
Blended cost per result = $20,000 ÷ 200 = $100
Paid media MER = $100,000 ÷ $20,000 = 5.0
The report can still show 120 Google-attributed conversions, 90 Meta-attributed conversions and 50 TikTok-attributed conversions. Those numbers simply need a heading that makes their role clear.
A useful label is “Conversions attributed by each platform.” A misleading label is “Total conversions.”
Show the platform split without losing the business view
The summary should lead with one spend number, one business-result number and one MER. The platform split belongs immediately below that summary, not in place of it.
Use the platform table for decisions
A practical platform table can include:
- Media spend
- Share of total media spend
- Platform-attributed conversions
- Platform-attributed CPA or ROAS
- First-party results assigned to the channel under the client’s chosen model
- Delivery or tracking notes
The platform-attributed column helps the media buyer evaluate campaigns inside each system. The first-party column helps explain the business result under one shared reporting method.
Neither column is perfect. The point is to label the method and use it consistently.
Keep per-platform ROAS, with a label
Per-platform ROAS can be useful when deciding where to investigate or test. It should not be presented as a complete account of how every channel contributed to the sale.
For example, a platform may introduce demand that another platform later captures. Moving budget based only on last-touch revenue could reduce activity that helped create those later conversions.
When the numbers point toward a budget change, use them as evidence for a controlled decision. The framework in Google Ads vs Facebook Ads: How to Split One Client Budget Between Them can help structure that review.
Put attribution caveats beside the numbers
Do not bury the explanation at the end of the report. A short note under the summary table is enough:
Google, Meta and TikTok apply separate attribution rules and may claim the same conversion. Total results and paid media MER use the client’s first-party reporting source. Platform-attributed results are shown for campaign diagnosis and are not added together.
The note should also name the first-party source, reporting period, time zone and revenue definition. If refunds, cancellations or offline sales are excluded, say so.
Use one stable report order
A consistent order makes recurring reports easier to read:
- Total media spend
- Total deduplicated business results
- Blended cost per result
- Paid media MER, when reliable revenue exists
- Platform spend split
- Platform-attributed performance
- First-party channel view
- Attribution and data-quality notes
- Actions, tests and decisions
A good multi platform ppc report does not hide disagreement between systems. It organizes that disagreement so the client can see what happened, what each platform claims and which source governs the business total.
Frequently asked questions
Why do Google, Meta and TikTok each report more conversions than you actually got?
Each platform applies its own attribution window and rules, so more than one platform can claim the same conversion. Their conversion totals are useful inside each platform, but they should not be added together.
What is MER and why use it in a client report?
MER compares measured revenue with the spend used to produce it. It gives the client one blended efficiency number without forcing every sale into a single-platform story.
How do you combine ad spend across platforms in one report?
Use the spend recorded by each ad account for the same reporting period, currency and time zone, then add those amounts. Keep media spend separate from agency fees and other costs unless the report defines a broader denominator.
Should a client report show per-platform ROAS?
Yes, when the revenue attribution method is clearly labelled and applied consistently. Per-platform ROAS is useful for diagnosis, but blended MER is usually the cleaner headline for the business.
How do you explain attribution differences to a client?
Explain that each platform reports the conversions it influenced under its own rules, while the combined report uses one agreed source for total business results. The numbers answer different questions, so they are not expected to match exactly.
What Ads Arsenal does for this today
Ads Arsenal for agencies runs Google, Meta and TikTok from one login. Its overview shows combined cross-platform metrics with MER at the top, and scheduled reports can be sent as PDF or CSV on the template and cadence you choose. It does not sell media, so it reads the three platforms as one budget without a stake in which platform receives the spend.
Conversion Arsenal counts first-party leads and sales by landing page and channel, with ad spend, cost per lead and MER on one screen. Feeding that sales value back into Ads Arsenal so recommendations can aim at sales rather than only leads is coming.
Ads Arsenal is in a free design-partner beta for agencies and in-house teams running real spend on Google, Meta and TikTok. Become a design partner.