Seven days · Meta ad account · Shopify product sales by medium & attribution type, same window · prepared for the CEO
Paid social influenced $19,489 of revenue and cleared $3,371 of contribution after media — $2.89 back for every dollar spent. Throw away every assisted order and count only the ones where social took the final click, and it still cleared $1,234.
That second number is the floor, and it is the only thing last click is good for. It is the deliberately unfair reading in which every ad that opened a customer's consideration gets zero credit unless it also closed them. Even there, the week clears break-even by 1.7×. The profit is not in question. What is in question is how much of it we are choosing to see.
Everything above the floor is the actual job. Meta is a demand-creation channel — it interrupts people who were not shopping and puts BTO in front of them. Judging it on last click is judging a channel on the one thing it is structurally worst at, and it is the reason prospecting budgets get cut in exactly the weeks they are working hardest.
Paid social touched $19,489. It closed $11,515. The difference — $7,974 — is not a rounding artefact or a measurement error. It is the work Meta is bought to do.
Why last click understates a social channel specifically. Someone scrolling Instagram is not shopping. They see a Bell Moto-10 at 40% off, register it, and come back two days later through a Google search for the model name or by typing btosports.com. Google gets the click; social created the demand. On a last-click scorecard the ad that made the sale happen reads as a wasted impression, and the search campaign that harvested it looks like a genius.
The same logic runs the other way for Meta's own 33.4×. That figure counts anyone who merely saw the ad within a day, and measures against the pre-return value at the pixel. It is the platform marking its own homework and it should not leave the ad account. Any-click is the honest middle: an order Shopify can actually point to, where a paid-social click sits somewhere in the path.
| Reading | Gross | Total sales | Items / purchases | ROAS on total sales | × break-even, gross basis |
|---|---|---|---|---|---|
| Any click (revenue influenced — the working number) | $18,912 | $19,489 | 171 items | 10.95× | 2.9× |
| Last click (the floor) | $11,059 | $11,515 | 110 items | 6.47× | 1.7× |
| First click | $9,295 | $9,598 | 95 items | 5.39× | 1.4× |
| Meta-reported | — | $59,367 | 237 purchases | 33.35× | n/a |
Total sales is gross less discounts and returns, plus shipping and tax, for utm_medium = paidsocial. The break-even multiple is computed on gross, because the clearable rates it derives from are defined against gross. Meta's figure is Website purchases conversion value summed across all ads; it has no gross equivalent in this dataset.
Applying BTO's own measured return rates and cost structure by category, this week's mix clears 27.2%. Run it on the revenue paid social influenced and on the revenue it closed, and both land well above zero. The floor is the proof; the ceiling is the ask.
Now the same walk-down on the floor. Same cost model, same categories, same axis — only the revenue definition is tightened to orders where paid social took the final click. This is the sanity check, not the scorecard.
This is not a new margin assumption. It is the same category-level model already in the profit diagnostic — measured return rates from BTO's own Shopify data, markup held flat at 40%, with freight, processing, return handling and markdown recovery as stated estimates. Applied to this week's actual product mix rather than a catalogue average.
Returns are priced in, not ignored. The clearable rate is applied to gross revenue and already carries each category's own return rate, so the $471 of returns visible in the window is not double-counted — and the returns still to come on these seven days' orders are already accounted for. Returns land weeks after the click; a report showing only booked returns would flatter itself badly.
The honest sentence for the board: "Seven days of paid social cleared between $1,234 and $3,371 of contribution on $1,780 of media. The lower figure assumes every assisted order would have happened anyway."
| Line | Any click — influenced | Last click — floor |
|---|---|---|
| Gross revenue, paid social | $18,912 | $11,059 |
| Less COGS, returns, freight, processing, handling | −$13,761 | −$8,045 |
| Clearable contribution (27.2% both) | $5,151 | $3,014 |
| Less media | −$1,780 | −$1,780 |
| Contribution after media | +$3,371 | +$1,234 |
| Return per media dollar | $2.89 | $1.69 |
| Efficiency headroom before break-even | 65% | 41% |
Helmets and boots are 67% of the week's influenced revenue — and they are the two categories that clear the least, because they carry the highest return rates in the catalogue.
This is the whole markup-versus-contribution argument showing up in a single week. Helmets influenced $9,254 of gross — half the week — at a 25.6% clearable rate and a 3.91 break-even ROAS. Goggles, gloves and consumables clear 28–32% and break even below 3.30. The blended break-even lands at 3.67 precisely because the mix is helmet-heavy.
Goggles are the quiet good news. They influenced $1,866 across 20 items at a 30.3% clearable rate — the best-clearing meaningful category in the week, and up sharply on the four-day read. Every dollar the mix moves from helmets toward goggles, apparel and consumables raises contribution without raising spend.
Note where the assist layer is heaviest. Pants went from $1,502 closed to $2,364 influenced and helmets from $5,481 to $9,254 — on a last-click scorecard, roughly $3,800 of helmet revenue social touched simply disappears.
| Category | Gross influenced | Share | Items | Clears | Contribution | BE ROAS | Gross, last click |
|---|
On last click the two look identical — 6.5× each. On influenced revenue ASC pulls clear at 11.2×.
ASC spent $988 and closed $6,440 — 6.5×, indistinguishable from Flash on the strict measure. But it influenced $11,049, a +72% uplift, with $3,766 carrying no last-click credit at all — three times Flash's $1,219. ASC is buying the top of the funnel and last click cannot see it. Cut it on the strict number and Flash's conversion rate falls a week later.
CPM $6.07. Landing-page view rate 83%. Frequency 1.3–2.8 across delivering ads.
293,188 impressions and 9,005 link clicks for $1,780. 83% of clicks became landing-page views — the site is not losing people on load. All three catalogue ads carry Meta's "Above average" quality, engagement and conversion-rate rankings. Frequency is the one to watch: ASC_Gear_Catalog is now at 2.76, the highest in the account and climbing. Everything else sits between 1.3 and 2.3, so there is still audience — but the workhorse ad is the first thing that will fatigue.
Over seven days, every creative type earned roughly its share of the budget. The catalogue took 46% of spend for 45% of value; UGC took 31% for 29%. UGC's apparent efficiency edge in the four-day cut does not survive the full week.
The honest read: per dollar, UGC returned 0.96× the catalogue's rate over seven days. The four-day snapshot put it at 1.7×, which was a three-day artefact. This matters because it changes the recommendation — the case for more UGC is no longer an efficiency case, it is a capacity case. The catalogue feeds can only sell to someone already in market and they are the ads whose frequency is climbing. UGC is the only creative type that can be manufactured on demand and the only one that puts someone in market in the first place.
The video read is where the real signal is. UGC_Flash_Sale_Bell_Moto10_40%_FH held a 25.2% three-second play rate and carried 556 viewers to 95% — 11.4% of everyone who started it finished, four times any other asset. UGC_Oakley_Airbrake_Goggles_40% hooked 31.7% and Sale_UGC_Youth_Bell_Moto9_FH 31.1%. Those three are the templates to reproduce; the rest lose 97%+ of starters before the end.
| Creative type | Spend | Share | Meta value | Share | Purchases | Meta ROAS |
|---|
| Video asset | Spend | 3-sec plays | Hook rate | Reached 95% | Completion |
|---|
Meta's ROAS is scaled down by the account's own 0.33 calibration factor — the ratio of influenced Shopify revenue to Meta-reported value — and set against each category's real break-even. Four ads, $95 of spend, are underwater even on the generous reading.
$95.03 — 5.3% of the week's budget — produced about $33 of contribution against $95 of cost. A net drag of roughly $62 over seven days, about $3,250 a year if left running. Redeployed at the account's own average it would have produced closer to $275, so the real cost of leaving it alone is the $242 gap, not the $62 loss. Materially smaller than the four-day cut suggested — that snapshot flagged $144 across six ads, because two of them had barely spent anything by then.
The whole problem is one ad. Sidi_X-Power_Boots_50%_v1 is $76.87 of the $95. It generated 10,831 impressions and 267 link clicks for two purchases — a 2.47% CTR and a 0.75% click-to-purchase rate against the account's 2.63%. The creative is getting clicks; the page is not closing them.
But it launched on Aug 16, so it has three days of data, not seven. That is not a reason to keep spending — it is the second-largest single-ad spend outside the catalogue and it has produced almost nothing — but it is a reason to check size availability on that SKU before writing off the creative. It is the exact signature of the depleted-size problem already documented in the Channable work.
| Ad | Category | Spend | Meta ROAS | Calibrated (any click) | Calibrated (last click) | BE | Verdict |
|---|
Ranked by revenue paid social influenced. Nine of the ten influenced more than they closed, and one of them closed nothing at all on a last-click basis.
| Product | Type | Influenced | Closed | Assist uplift | Units |
|---|
Bell Moto-10 Fasthouse Raven leads at $3,404 influenced against $1,166 closed — a +192% assist uplift, the most assisted product of the week, and the subject of the account's best-performing video. Alpinestars Tech 10 LE Air Gold Boots sold $657 with a paid-social click in the path and zero last-click credit — revenue a strict report files under "not social."
The Oakley Airbrake goggles at #2 are the most interesting line in the table. $1,140 influenced across nine units, in the category that clears best in the catalogue — and there are four separate Oakley Airbrake ads running, one of which has the highest hook rate in the account at 31.7%. This is the mix shift the profit work has been arguing for, happening on its own.
Order Protection was attached 46 times across influenced orders — the only order-count signal in this dataset. It is opt-in, so it sets a floor rather than a count: at least 46 distinct orders had a paid-social click somewhere in the path.
Efficiency can degrade 65% on the working number, or 41% on the floor, before this week's spend stops clearing. That is real room, and it is tighter than the four-day snapshot implied.