PAID ADS SKILL
ads-performance-analytics
How to read a paid-media dashboard without fooling yourself: platform reporting quirks, seven attribution models, multi-platform reconciliation, the ROAS-versus-LTV trap, statistical noise, incrementality, and twelve interpretation failures.
by RampStackrampstackco/claude-skillsMIT licencecommit a67dd34upstream 2026-09-07read by us 11 September 2026
This is the skill to load the day before a scale, kill or rebudget decision. It assumes the strategy was sound and the creative was tested, and it asks only one thing: what does this number mean, and what must it be reconciled against.
Its examples are concrete without being invented for you: the campaign that reported 3.5x ROAS for six months and measured 1.2x in a geo holdout; the Google-Meta-LinkedIn stack that reported 1,600 conversions against 950 in the warehouse; branded search at 5 to 20% incremental, retargeting at 20 to 40%, prospecting at 50 to 90%.
Like every RampStack skill it carries the data-availability rule: when a required number is missing, the deliverable states the gap; it never estimates one to finish.
When to use it
The phrases that trigger it
From the skill’s own description: say any of these and an agent that has it installed will load it.
- read paid media dashboard
- attribution analysis
- ROAS vs LTV
- multi-platform reconciliation
- ad incrementality
- geo holdout
- conversion lift study
- blended CAC
- MMM
- MTA
What’s inside
The playbook, section by section
The nine-item result panel
Spend, impressions, clicks; conversions with definition and window visible; attribution breakdown; frequency; saturation; time series; cost metrics in a named currency; conversion paths; filters and exports. Missing rows are where to dig.
Platform-reported versus reality
Meta 7-day click plus 1-day view against Google 30-day click plus 1-day view; view-through often half of reported conversions; modelled iOS conversions as educated guesses; every platform claims the same sale.
Multi-platform reconciliation
Trust the order system for totals, platforms for ranking within platform, never platform sums; blended CAC is total spend over total new customers from the order system.
ROAS versus LTV
Meta 2.5x ROAS at $80 LTV against Google 1.8x at $200 LTV: the lower ROAS is the better channel over the customer lifetime.
Noise
Real changes are 30% or more in metrics that vary 10 to 20% naturally; day-of-week, seasonality, exogenous events and reporting delay all masquerade as signal.
Incrementality
Geo holdout, Google Conversion Lift and Experiments (the skill notes "ghost bidding" is a literature term, not a Google feature), Meta conversion lift, PSA tests; run quarterly on the biggest lines.
Reference files: metric-definitions-glossary.md attribution-model-comparison.md platform-reporting-quirks.md incrementality-testing-playbook.md dashboard-reconciliation-patterns.md cohort-analysis-templates.md common-interpretation-failures.md
See it in action
One real run, cropped
We installed the skill folder, gave it the request below, and kept what it returned. Nothing was edited; the excerpt is the first 1,775 of 12,723 characters. The full output is in our repository as research/skills/runs/ads-performance-analytics.md.
A client's Meta retargeting campaign shows 3.5x ROAS in Ads Manager over the last 30 days and they want to triple its budget next month. Walk us through your 12 considerations for this specific decision and tell us what we must check before agreeing. We have Shopify order data but no warehouse.
Should we triple the Meta retargeting budget? The 12 considerations, applied
Decision on the table: a Meta retargeting campaign reports 3.5x ROAS in Ads Manager over the last 30 days; the client wants to 3x its budget next month.
What we have: Ads Manager numbers, Shopify order data. What we do not have: a warehouse, a unified attribution layer, GA4 confirmation, or any incrementality test result.
Framework answer right now: HOLD. Not because 3.5x is wrong, but because the one number we have is the one number the framework says never to act on alone. Retargeting is the campaign type most likely to look excellent in-platform and least likely to be incremental. Below is each consideration applied to this campaign, then the checklist we need cleared before saying yes.
A note on the data gap up front: everything below that needs a customer count, a revenue figure, or a lift number is stated as a check to run, not a result. No figure in this document is estimated. Where the skill's reference material gives a typical range, it is labeled as a typical range, not as this client's number.
The 12 considerations
1. Result panel completeness. What is Ads Manager showing us, and what is it hiding?
For this decision the panel must expose, for this campaign and this 30-day window: spend, purchases, purchase conversion value, the attribution setting applied, the breakdown by attribution type (click vs view vs modeled), frequency, and a daily time series. If the 3.5x came from a top-line campaign row with the attribution breakdown collapsed, we have not yet seen the number; we have seen a summary of it.
Meta specifically hides the modeled-conversion share unless you open the attribution breakdown. That is where we dig first.
Cropped here. The rest continues in the same register.
What it could not do in this run
any actual account data (attribution breakdown, daily series, frequency, audience size, CAPI status), any Shopify reconciliation figures, and any incrementality result. Per the skill's "If required data is unavailable" rule these were written as checks to run with the gap stated; no number was estimated. The 20 to 40 percent retargeting range is quoted from the reference as a category range and labeled as such.
Method behind it
Where we would differ, and why
Our Performance Max guide is the case study of this skill’s PMax warning: a black box that reports the branded search you would have had for free. Read the skill for the twelve considerations, the guide for what PMax hides and how to audit the brand queries inside it.
- Note 1
- The skill treats a warehouse as the canonical source. A Shopify store has no warehouse; Shopify orders are the canonical count, and the skill’s reconciliation pattern works unchanged with that substitution.
- Note 2
- It recommends MMM as the mature-stage reference. Below a few hundred thousand a year in spend the regression has nothing to fit; incrementality tests are the ceiling.
SKILL.md
The upstream file, as we read it
Copyright RampStack, MIT licence, commit a67dd34 of rampstackco/claude-skills. Reproduced here under that licence so you can read what the agent will read; the folder’s reference files are in the repository.
Open SKILL.md (3,479 words)
---
name: ads-performance-analytics
description: "How to read paid media dashboards without fooling yourself. Attribution models, platform reporting quirks, multi-platform reconciliation, ROAS vs LTV horizon traps, statistical noise in performance metrics, incrementality testing, and the failure modes that produce expensive lessons. Triggers on read paid media dashboard, attribution analysis, ROAS vs LTV, multi-platform reconciliation, ad incrementality, geo holdout, conversion lift study, ghost bidding, paid media reporting, board-deck paid media metrics, blended CAC, MMM, MTA, last-click attribution. Also triggers when a marketer is about to scale, kill, or rebudget a campaign based on platform metrics, or when reconciling platform reports against warehouse revenue."
category: marketing
catalog_summary: "Read paid media dashboards without fooling yourself: attribution models, platform reporting quirks, ROAS vs LTV, multi-platform reconciliation, incrementality testing, and the interpretation failures that compound into wasted budget"
display_order: 3
---
# Ads Performance Analytics
A data-team-mentor's playbook for interpreting paid media dashboards without fooling yourself.
The dashboard is the moment of truth for paid media decisions. The numbers on it determine whether you scale, hold, or kill. They also expose every platform's self-attribution bias, every modeled-conversion shortcut, every cross-platform double-count. Most "scale this campaign" decisions trace back to misreading the dashboard.
This skill is the discipline that prevents misreading. It assumes the campaign was strategically sound (see `paid-media-strategy`). It assumes the creative was tested properly (see `ads-creative-development`). The hard part is knowing what each number actually means, what it does not, and how to reconcile platform-reported metrics with the truth in your warehouse.
When to use this skill: any time you are about to scale, kill, or rebudget a campaign based on platform metrics; reconciling platform reports with revenue data; evaluating an agency's reporting; or building a paid media dashboard that will not lie to you.
---
## What this skill is for
This skill spans paid media result interpretation. It does not cover paid media strategy (use `paid-media-strategy`), creative production (use `ads-creative-development`), or platform-specific tooling (covered in the integrations microsites). Pair this skill with the relevant integrations microsite for platform-specific MCP commands and example prompts.
The audience is a marketer, growth analyst, agency analyst, or founder evaluating paid media reports. The voice is patient and clinical. There is no "trust the platform's number" or "ignore the platform entirely." Both are wrong. The discipline is knowing which numbers from which platform mean what, and what to reconcile against to make the actual decision.
---
## The result panel: what every paid media platform should expose
A trustworthy result panel exposes nine things. Anything missing is a signal to treat reported numbers with extra skepticism.
1. **Spend, impressions, clicks.** Table-stakes metrics. Should match across platforms within rounding.
2. **Conversions with definition and window visible.** Not just a count; the definition of what counts as a conversion and the attribution window applied. Without this, the count is unreadable.
3. **Attribution breakdown.** Last-click vs view-through vs modeled. The mix of how the conversions were credited.
4. **Frequency.** Impressions per unique user. The fatigue early-warning system.
5. **Audience saturation.** Where the platform exposes it. A flat audience-saturation curve means there is room to scale; a steep curve means efficiency is dropping.
6. **Time series.** Daily breakdown to spot novelty effects, fatigue, day-of-week patterns, and exogenous variance.
7. **Cost metrics in clear currency.** CPC, CPM, CPA, ROAS with the math defined and the currency labeled. Do not assume USD.
8. **Conversion path data.** Touchpoints before conversion, where available. Tells you whether a campaign is a closer or an opener.
9. **Filters, segments, and exports.** Without these, the panel is a brochure, not a tool.
Platforms hide what makes their reporting look weakest. Google PMax hides keyword-level and placement-level data. Meta hides the modeled-conversion share. LinkedIn hides cross-device click paths. Treat hidden metrics as the place to dig.
---
## Platform-reported vs reality
Every platform's dashboard is optimized to make the platform look effective. This is not a moral failing; it is a structural incentive. Platforms with rosier reporting attract more spend.
**Conversion windows.** Meta defaults to 7-day click plus 1-day view. Google defaults to 30-day click plus 1-day view. Different windows, same activity, different reported numbers. If you compare Google's 30-day-click count against Meta's 7-day-click count, you are comparing different definitions and pretending they are the same.
**View-through attribution.** Counted by Meta and Google for users who saw but did not click. Often half the reported "conversions" are view-through. Treat view-through as a signal of awareness contribution, not as a direct response measurement. The user might have converted from organic search anyway.
**Modeled conversions.** When iOS users opt out of tracking, Meta and others statistically model what the conversion would have been. Modeled numbers are educated guesses, not measurements. They are useful for direction; they are not reliable for precision.
**Self-attribution bias.** Every platform's pixel fires on conversion and the platform claims credit. If you ran Meta, Google, and TikTok in the same week, all three platforms report your conversions as theirs. Sum-of-platforms is always greater than 100% of actual conversions.
The discipline. Never report platform-reported numbers as fact in board decks. Always reconcile against the single source of truth (warehouse, GA4, or unified analytics platform). Detail in [`references/platform-reporting-quirks.md`](references/platform-reporting-quirks.md).
---
## Attribution models in practice
Six models and one anti-model. None is right. They are all approximations. The discipline is picking one, committing, and reading the others as sanity checks.
**Last-click.** Simple, reproducible, undercredits awareness. The conversion is fully credited to the last click before the conversion event. Easy to compute; easy to compare across channels; bad for understanding upper-funnel contribution.
**First-click.** Opposite bias. Fully credits the first touchpoint, undercredits closing channels. Useful as a sanity check against last-click; rarely the right primary view.
**Linear.** Equal credit across all touchpoints. Gives every channel something. Defensible; not informative. Most useful for board reporting where avoiding "Google gets 70% so we cut Meta" politics matters more than precision.
**Time-decay.** More credit to recent touchpoints. Reflects the intuition that recent ads are more influential. Hard to argue against; hard to verify.
**U-shaped (position-based).** Heavy on first and last (40% each), light on middle (20% distributed). Honors both opener and closer roles. The default in many MTA tools.
**Data-driven attribution (DDA, Google).** Machine-learning model that distributes credit based on observed conversion paths. Opaque; hard to audit. The closest to "right" for digital channels but a black box.
**Marketing mix modeling (MMM).** Regression-based, top-down. Uses spend and revenue time series across channels to estimate channel contributions. Requires 2+ years of data. The strongest defense against platform self-attribution because it does not rely on platform-reported conversions at all.
**The anti-model: trusting platform-reported attribution.** Each platform's "DDA" or "attributed conversions" is the platform's self-attribution. Sum across platforms exceeds reality. Use platform attribution for in-flight optimization within the platform; use a unified attribution model for cross-channel decisions.
Practical guidance.
- Early-stage. Use last-click plus a single guardrail metric (warehouse-attributed CAC). Sophisticated attribution requires data volume you do not have.
- Mid-stage. Data-driven attribution from Google plus GA4, with explicit awareness vs closing channel labeling.
- Mature. MMM as the canonical incremental reference. MTA for in-flight optimization. Last-click for channel-level decisions where ambiguity is acceptable.
Detail and a decision matrix in [`references/attribution-model-comparison.md`](references/attribution-model-comparison.md).
---
## Multi-platform reconciliation
The trap. Google says you spent $50K with 800 conversions. Meta says $30K with 600. LinkedIn says $20K with 200. Total reported equals 1,600 conversions. Your warehouse says 950. Where did 650 go?
The answer. Nowhere. They never existed. Each platform claimed conversions other platforms also claimed.
The reconciliation pattern.
- Trust the warehouse for total conversions and total revenue.
- Trust platforms for relative ranking within platform (which campaign won, which audience won).
- Never trust platform sums.
- Compute blended CAC as (total ad spend across platforms) divided by (total new customers from warehouse). Not from platform reports. Where the warehouse figure is unavailable, state the gap per the data-availability rule.
The board-deck pattern. Report warehouse-attributed conversion counts, never platform-summed. Report blended CAC, not channel-by-channel CAC unless explicitly noted as platform-self-attributed. Detail and templates in [`references/dashboard-reconciliation-patterns.md`](references/dashboard-reconciliation-patterns.md).
---
## ROAS vs LTV: the time horizon trap
ROAS is short-term. Revenue from purchases attributed to a campaign in a fixed window, often 7 to 30 days. LTV is long-term. Total customer lifetime revenue.
Decisions made on ROAS can be wrong if LTV varies by channel. A worked example.
Meta drives 2.5x ROAS at $40 CAC with $80 LTV. That is 2.0x payback over the customer lifetime.
Google drives 1.8x ROAS at $60 CAC with $200 LTV. That is 3.3x payback over the customer lifetime.
Google looks worse on ROAS, better on LTV-adjusted return. Allocating budget to Meta because the ROAS is higher is the wrong move.
The fix. Cohort-based LTV by acquisition channel, updated quarterly. Compare channels on payback period or LTV-CAC ratio, not raw ROAS. The 2x ROAS heuristic is a dangerous shortcut. Same ROAS at different LTVs equals different actual returns.
The trap that compounds. Performance teams optimize for short-term ROAS because the metric refreshes weekly. Brand and high-LTV channels get cut because their short-term ROAS is lower. Six months later, the brand pipeline has eroded and short-term ROAS itself drops because the cheap channels are saturated. The metric that drove the decision was the wrong horizon.
---
## Cohort analysis vs daily metrics
Daily metrics tell you what happened today. Cohort analysis tells you whether today's customers are different from last month's.
Three cohort cuts that matter for paid media.
**By acquisition month.** Are users acquired in March retaining better than users acquired in January? A declining LTV over rolling acquisition cohorts means recent acquisition is lower quality; the daily metrics will show this two to three months later when the retention starts hurting.
**By acquisition channel.** Are users from Meta retaining better than users from Google? Channel-level cohort divergence is the data behind the LTV-vs-ROAS argument. Meta might drive volume at lower LTV; Google might drive lower volume at higher LTV. The cohort tells the story the daily ROAS hides.
**By acquisition campaign.** Campaign-level cohort signals. Useful for diagnosing why a campaign that "works" in week 1 produces no recurring revenue.
The signal to act on. Declining cohort LTV over two consecutive months is the alarm. Pause the channel or campaign before the daily metrics force you to. Detail in [`references/cohort-analysis-templates.md`](references/cohort-analysis-templates.md).
---
## Statistical noise in performance metrics
Most "the campaign improved 15% week over week" stories are noise. Real performance changes are 30% or more in metrics that vary 10 to 20% naturally. Below that threshold, you are looking at variance and calling it signal.
Sources of noise in paid media metrics.
- **Day-of-week effects.** B2C tends to weekend dips. B2B tends to weekend gains. A "Monday morning is better" hypothesis often dissolves when day-of-week is normalized.
- **Holiday and seasonal effects.** Q4 dwarfs most "optimization" effects. A campaign launched in Q4 looks great because of seasonality, not strategy.
- **Weather, news, competitor activity.** Real exogenous variance. Last week's news cycle can shift CPMs across an entire vertical.
- **Pixel fire and reporting delay.** Conversions reported on a 7-day click window arrive incrementally. Reading the panel on Monday for last week's performance undercounts.
The fix. Pre-commit to test duration before drawing conclusions. Use the experimentation discipline from `experimentation-analytics` for any directional change you want to claim is real. The signal-to-noise problem in paid media metrics is the same as the signal-to-noise problem in product experiments; the framework transfers.
This is where `experimentation-analytics` bridges in. The statistical patterns are the same; the application is different. Read both for the full picture.
---
## Incrementality testing
The honest test. If we had not run this ad, would we still have gotten the conversion? The number above zero is the incremental contribution.
Most paid media is 30 to 70% incremental, not 100%. Some is zero. Branded search bidding is often 5 to 20% incremental (most converters would have found you organically). Retargeting is often 20 to 40% incremental (many of those users were going to convert anyway). Prospecting is often 50 to 90% incremental.
Four methods.
**Geo holdout.** Hold one region out from the campaign. Measure the difference in conversions between the holdout region and the matched test region. The cleanest causal test for paid media at scale.
**Conversion Lift and Experiments (Google).** "Ghost bidding" is a term from the incrementality-testing literature, not a Google Ads feature you can switch on. Google's real surfaces are Conversion Lift studies, which a Google rep enables, and geo or holdback Experiments you configure yourself.
**Conversion lift studies (Meta).** Splits audiences into test and control. Test sees the ad; control does not. Reports incremental lift. The cleanest within-Meta test.
**PSA tests.** Serve some users a public service announcement instead of your ad. Compare conversion rates. Useful for legacy brands with deep budget.
Incremental rate ranges by channel type are in [`references/incrementality-testing-playbook.md`](references/incrementality-testing-playbook.md). The discipline is to run incrementality tests at least quarterly on the highest-spend channels. Without them, you are optimizing against platform-reported attribution that systematically overcounts.
---
## Geo experiments and holdouts
For paid media specifically, geo-based testing is the most reliable causal method.
**Geo holdout.** Turn off paid media in one region. Measure baseline organic conversions. The difference between expected and actual conversions in the holdout region is the incremental paid contribution.
**Geo lift.** Scale spend in one region by 2x. See if conversions scale linearly. A linear scale means the channel has headroom. A sublinear scale means saturation; further spend is diminishing returns.
**Switchback.** Alternate weeks of campaign on and off. Compare on-weeks to off-weeks. Useful when geo splitting is not feasible.
**Pre-and-post analysis.** Launch in a region; measure 30 days before vs 30 days after. Weak design because external factors confound the comparison. Use only when no other test is available.
The right setup. Matched markets (similar demographics, similar baseline conversion rates). Statistical power calculation upfront (how big a difference can the test actually detect). Pre-committed analysis window (so you do not stop early when the data looks good or wait too long when it looks bad).
The trap. Calling a geo test successful because of timing-correlated revenue lift. A campaign launched in October will see "lift" because Q4 is starting; without a control region, the lift is not attributable to the campaign.
---
## Platform self-attribution bias
A specific failure mode worth its own section.
The mechanism. Platform's pixel fires on conversion. Platform claims credit. The user might have converted from any channel; the platform that loaded the pixel last gets the credit on the platform's own dashboard.
Why platforms reward this design. More credit on the platform dashboard equals better-looking ROAS equals more advertiser spend. Platforms have no incentive to underreport their own contribution.
Detection patterns. When platform-reported conversions exceed warehouse-attributed conversions for the same channel by more than 30%, you have heavy double-counting. When sum-of-platform-reports exceeds total conversions in the warehouse, you have cross-platform double-counting.
The fix. Warehouse as canonical for board reporting. Platform reporting as in-flight signal only. Incrementality tests at least quarterly to keep the channel-attribution honest.
A worked example. A retargeting campaign in Meta showed 3.5x ROAS for six months. The team scaled spend from $20K to $80K per month. A geo holdout test revealed that 65% of the "conversions" would have happened anyway from organic. Real ROAS adjusted for incrementality was 1.2x, not 3.5x. The campaign got cut and warehouse-attributed CAC dropped 18% in the next quarter.
---
## Common interpretation failures
Twelve patterns recur in paid media reporting work. Detail in [`references/common-interpretation-failures.md`](references/common-interpretation-failures.md).
- "ROAS dropped 20% week over week, kill the campaign." Could be noise. Pre-commit a test window before acting on weekly variance.
- "Meta says 500 conversions, my warehouse says 200, who is right?" Both are wrong; warehouse is closer to truth, Meta self-attributes. Reconcile, do not pick a winner.
- "We turned off Google PMax and conversions did not drop." PMax was harvesting branded search you would have gotten free. Audit branded queries inside PMax.
- "The new campaign hit 5x ROAS in week 1." Likely retargeting hot leads. Check the audience composition before declaring victory.
- "We A/B tested and one creative wins by 12%." Within margin of platform noise. Not significant.
- "Our LTV calculation says this channel is profitable." Check cohort age. Recent cohorts may not have hit LTV yet; the calculation is a projection, not a measurement.
- "The platform says high frequency is fine because conversions are still happening." Fatigue masked by free organic conversions. The campaign is taking credit for conversions that would have happened anyway.
- "Last-click attribution shows Meta at 60% credit." Last-click bias. First-click view of the same data shows different. Pick a model and stick.
- "We scaled spend 5x and conversions only doubled." Saturation. The channel found its ceiling; the marginal CAC at the new spend level is much higher.
- "Brand campaigns underperform on direct ROAS." They do not have to. Brand impact shows up in other channels' efficiency. Measure brand against brand-search lift, not direct ROAS.
- "ROAS held steady but profit dropped." The mix shifted toward lower-margin products. Channel-level ROAS hides product-mix effects.
- "Agency reported a 4x ROAS month." Whose number? Platform-reported, warehouse-attributed, or model-adjusted? The unit of measurement matters more than the magnitude.
---
## The framework: 12 considerations for trustworthy paid media interpretation
When reading a paid media dashboard about to inform a decision, walk these 12 considerations. Skipping any of them is how teams ship the wrong call.
1. **Result panel completeness.** What is the platform showing vs hiding.
2. **Platform-reported vs reality.** View-through, modeled conversions, conversion windows.
3. **Attribution model.** Pick one and read the others as sanity checks.
4. **Multi-platform reconciliation.** Sum-of-platforms is always inflated.
5. **ROAS vs LTV horizon.** Short-term metric, long-term impact.
6. **Cohort vs daily.** Cohort tells the quality story; daily tells the volume story.
7. **Statistical noise.** Weekly variance, day-of-week, seasonal, exogenous.
8. **Incrementality.** What would have happened without the spend.
9. **Geo and holdout testing.** The honest causal test.
10. **Self-attribution bias.** Platforms claim credit they do not deserve.
11. **Decision rule.** Pre-committed scale up, hold, or pull back.
12. **Single source of truth.** Warehouse over platform reporting for board metrics.
The output of the framework is one of three answers. Scale (the campaign is incremental and unit economics work). Hold (data is ambiguous; gather more before deciding). Kill (the campaign is not incremental enough to justify the spend).
---
## If required data is unavailable
This skill's output depends on data, measurements, or tool results it cannot generate on its own. When a required input, tool, or data source is unavailable or unverifiable, the sanctioned output is the deliverable with the gap stated: what was needed, what was actually obtained or verified, and which parts of the output are affected. Fabricating, estimating, or interpolating a required number to complete the deliverable is never sanctioned. A stated gap is a complete answer.
---
## Reference files
- [`references/metric-definitions-glossary.md`](references/metric-definitions-glossary.md) - CTR, CPC, CPM, CPA, ROAS, LTV, AOV, frequency, reach, impressions, conversion window, view-through, modeled conversion, blended CAC, MER.
- [`references/attribution-model-comparison.md`](references/attribution-model-comparison.md) - Last-click, first-click, linear, time-decay, U-shaped, DDA, MMM. Decision matrix by business stage.
- [`references/platform-reporting-quirks.md`](references/platform-reporting-quirks.md) - Google PMax black box, Meta iOS impact and Conversions API, LinkedIn 30-day click defaults, TikTok video-completion attribution, programmatic viewability gates.
- [`references/incrementality-testing-playbook.md`](references/incrementality-testing-playbook.md) - Geo holdout, Conversion Lift and Experiments, PSA tests, switchback designs. Setup, duration, analysis pattern, expected incremental rates.
- [`references/dashboard-reconciliation-patterns.md`](references/dashboard-reconciliation-patterns.md) - Warehouse as canonical, platform as in-flight signal, blended CAC formula, board-deck patterns, reconciliation cadence.
- [`references/cohort-analysis-templates.md`](references/cohort-analysis-templates.md) - By acquisition month, channel, and campaign. Retention curves, when to act on cohort signals.
- [`references/common-interpretation-failures.md`](references/common-interpretation-failures.md) - Twelve failure patterns with symptom, root cause, fix, prevention.
---
## Closing: the courage to call it incremental zero
Most paid media spend is not 100% incremental. Some channels are 70% incremental. Some are 30%. Some are zero, paying for conversions you would have gotten anyway.
The discipline of accepting that channels can be incremental zero, and pulling spend accordingly, is the single highest-impact skill in paid media analytics. Most accounts have at least one campaign that looks profitable in the platform but is incremental zero in the warehouse. Branded paid search at $4 CPC when the same users find you at position one organically. Retargeting at $0.30 CPC for users who already added items to cart. PMax cannibalizing free brand traffic.
The discipline of finding those campaigns and killing them is the work. The platform will not tell you. The platform's incentive is the opposite. The warehouse, paired with quarterly incrementality tests, is the only honest source.
When in doubt about whether a campaign is incremental, run a geo holdout. The two-week test is cheaper than a quarter of unincremental spend. The team that does not run incrementality tests is optimizing against numbers that are systematically wrong, and the size of the error is exactly the size of the budget waste.
Questions
Questions people ask before installing
Our client wants to triple a 3.5x ROAS campaign. What does the skill say?
Check the window and the view-through share, reconcile against orders, look at the audience composition (retargeting hot leads reads high), check cohort LTV by channel, and run a geo holdout before scaling. Its worked example is that exact campaign, and it measured 1.2x.
Does it connect to Meta or Google?
No. Pair it with a connector: the Google Ads MCP or claude-ads on our toolkit shelf for reads, or a pasted export.
What if I cannot run a holdout?
The skill’s rule: state the gap. The decision then defaults to hold, not scale.