01
Name the stalled decision first
Write the decision you cannot make confidently right now — scale Meta or hold, whether TikTok is paying its way, which campaign to cut. The number you need is the one that unblocks this decision.
Free spec
One number per spend decision.
When Meta, Google, and Shopify report different revenue, the spend decision stalls. This one-page spec gets you to one reconciled number you can fund decisions on — built backward from the decision that is stuck, then only the data that decision needs.
The method
Five steps to one number.
Sec. 01 — Spec
02
List the tools that disagree
Put each tool’s answer in its own row — Meta, Google, TikTok, Shopify, GA4 — with how each one attributes. The spread between them is the problem; the goal is to reconcile them into one view.
03
Fix the tagging before you trust the numbers
Lowercase, no spaces, a fixed vocabulary for source and medium, every paid link tagged, one convention everyone uses. Below ~80% UTM coverage, your channel view is guesswork.
04
Define the one number (and its limits)
For the decision in step 01, write the single metric you will fund on — its source, formula, and where it under- or over-counts. The honesty about limits is what makes it trustworthy.
05
The decision-ready view
One screen: blended truth (revenue, spend, MER, CAC, AOV), platform-reported vs. reconciled with the delta visible, and the trend that matters. If you can answer "which channel and campaign earned its spend?" unaided, you are done.
Build it, or have it built
Build it yourself with this spec, or have it built in 5 days.
If the stalled decision is costing you more than the build, every week it stays stuck, Dashboard Studio delivers a custom reconciled dashboard over your own data — every number defined — in 5 business days for $3,500 flat.