Omnichannel Attribution (demo)
A consumer brand selling on its website, on Amazon, and through physical retail. Marketing touches happen mostly online; purchases happen everywhere. Joining ad-platform touchpoints to Shopify, Amazon, and Square POS revenue in the warehouse — via shared email and loyalty IDs — is the only way to compute true ROAS for channels that drive purchases off your own site.
Each row is the marketing channel that earned attribution credit; each purchase column is where the order was actually rung up. ROAS is total revenue across all purchase channels divided by ad spend.
| Attribution Channel | Ad Spend | Online | Amazon | In-Store | Total Revenue | ROAS |
|---|---|---|---|---|---|---|
| google / cpc — brand | $84,200 | $412,00060% | $188,40027% | $92,00013% | $692,400 | 8.2× |
| google / cpc — non-brand | $142,800 | $286,00048% | $224,40038% | $84,40014% | $594,800 | 4.2× |
| facebook / paid_social | $96,400 | $132,00026% | $312,40062% | $58,20012% | $502,600 | 5.2× |
| instagram / paid_social | $62,800 | $88,40024% | $244,20065% | $41,60011% | $374,200 | 6.0× |
| direct-mail / catalog | $52,000 | $48,40015% | $18,4006% | $248,40079% | $315,200 | 6.1× |
| organic / seo | — | $184,40061% | $92,00031% | $24,4008% | $300,800 | ∞ |
| (direct) / (none) | — | $96,40035% | $48,40017% | $132,00048% | $276,800 | ∞ |
| tiktok / paid_social | $48,400 | $32,40013% | $188,80076% | $28,40011% | $249,600 | 5.2× |
| klaviyo / email | $12,400 | $142,80068% | $38,40018% | $28,40014% | $209,600 | 16.9× |
| retail-flyer | $28,400 | $8,4004% | $4,2002% | $188,40094% | $201,000 | 7.1× |
| youtube / video | $38,400 | $24,40013% | $88,40046% | $78,20041% | $191,000 | 5.0× |
Key insight: Facebook, Instagram, and TikTok all drive 2–6× more revenue on Amazon than on the website. Looking only at Shopify revenue, TikTok ROAS is 0.7× — looks like a money loser, kill the channel. Adding Amazon orders (joined by shared email) brings TikTok to 5.2× ROAS. The opposite story shows up in direct-mail and retail flyers: nearly invisible online, but they account for the majority of in-store traffic. Without joining all three purchase systems back to the touchpoint in the warehouse, you can't make a defensible budget allocation across these channels.
Each bar is one marketing channel; the segments show where the attributed revenue actually landed.
The headline split a web-only analytics tool can never produce — you need the warehouse to see Amazon and POS revenue alongside your web orders.
Six months of revenue, broken out by where the order was placed. Holiday peak in December affects all three channels but not equally.