Marketing · Step

Revenue join

Joins store revenue with ad spend.

What it does

One step of the Analyze performance playbook. Goose runs it when you ask for the playbook.

The skill file

What your AI app reads when it runs this skill.

Revenue join (atom)

Load: ../analyze-performance/references/revenue-join.md.

Inputs: clean store/CRM numbers; total spend per platform; platform claims; break-even MER and allowable CAC (campaign brief economics box / measurement contract); last week's report (the story the marketer picked).

Do:

Business-truth table: this week, last week, 4-week average, same week last year.
MER, new-customer MER, nCAC, contribution after ads — each vs break-even / allowable / target.
Overclaim ratio, like-for-like as in the reference (claimed purchases ÷ store orders, or claimed revenue ÷ store gross; a floor when a claimant is missing), with its 4-week trend.
Marginal: Δ new-customer revenue ÷ Δ spend vs last week and vs the 4-week average.
If the platform and blended stories point different ways: write both at the same grain, each ending "if true, you'd…", a recommendation, and the cheapest test that would settle it. Carry forward the story the marketer picked last time unless a test changed it.
B2B: pipeline chain and cost per qualified lead / opportunity instead of revenue.

Output: the report's Business truth, overclaim line and Two stories sections.