Meta claims 4,717 purchases at 0.80 ROAS, but only 2,231 Shopify orders actually carry a Meta UTM and just 1,977 are genuinely new customers. Meta is crediting itself ~2.1× more conversions than carry its tag. True new-customer CAC is ~$141.92, not the ~$60 Meta implies. Only 7.9% of untracked orders even look social, so this is Meta inflation — not UTM leakage.
UGC video brings customers ~16% cheaper ($147.75 vs $175.28 CAC) and is the volume engine. But Static-image creatives show higher early repeat (3.5% vs 2.5%) and similar 30-day LTV (~$48). The best ad on both axes is a Static "Weight Manager – Did You Know 3."
They post the highest early repeat (3.6% / 2.9%) at reasonable CAC. Gut-health / Longevity is the most expensive to acquire ($186.80 CAC) with the weakest repeat. Creator/TikTok ads acquire the cheapest customers ($94.26 CAC) but launched too recently to judge downstream value.
Subscription starts are invisible at acquisition — only 3 of 3,458 new orders carry a native selling plan (Subscribe&Save runs through StayAI). And the 60-day wall truncates LTV. So "value" here = ≤30-day repeat + realized net revenue. Fixable: surface a {ad.id} macro + sellingPlan in checkout attributes.
Plain statement: 50.4% of new-customer orders and 88.2% of Meta-attributable orders are joined to a specific ad. Rankings below are based on that joined subset — ad-level Meta coverage (88.2%) is above the ~80% bar, so the creative/hook/format reads are reasonably trustworthy; whole-funnel coverage (50.4%) is lower because ~30% of orders are genuinely non-Meta.
Bucketed by Shopify's native first-visit source: Direct/unknown 609 (57.7%), Search/SEO 336 (31.8%), Email 15, and only 83 (7.9%) look paid/organic social. So the UTM gap is overwhelmingly genuine non-Meta traffic, with only a small (~83-order) sliver of possible Meta-UTM leakage to fix.
Primary key failed. The leading numeric of utm_id (e.g. 120247118732340381_v2_s06) matched 0 of 201 live Meta ad IDs — it's a hard-coded ID carried over when ads are duplicated. Per your fallback, the join dropped to ad-name level: utm_term → Meta ad name (exact-normalized + unique-prefix). Confidence is high because both use the identical naming convention; 88.2% of Meta orders mapped.
utm_campaign — [NM] IBB - Prospecting - Scaling - CBO - LC Rebuild → [NM] = agency (NordMedia)IBB / CDM = product lineProspecting / Retargeting = funnelScaling / Testing = strategyCBO / ABO = budgetLC = objective/landing
utm_term — IBB - The Weight Manager Manager - Did You Know 3 - Nord Static - Paid media Lander - Brand Page → seg1 = productseg2 = persona/hook or creatorseg3 = concept/variantseg4 = vendor + FORMATseg5–6 = landing + page type
Format from seg4: "Static" → Static image · "UGC"/"TikTok" → UGC video · "Nord Video" → Studio video. Hook theme clustered from persona/concept keywords (Motherhood, Weight management, Gut health/Longevity, Collagen/Beauty, Creator/Influencer, Price/Promo). Funnel: essentially all spend is Prospecting — no meaningful retargeting campaign ran in-window. Correct any misread tags and I'll re-cluster.
| Format | New custs | Spend | CAC (true) | 30-day repeat | 30-day LTV | LTV:CAC |
|---|---|---|---|---|---|---|
| UGC video | 1,169 | $172,714 | $147.75 | 2.5% (n=317) | $47.99 | 0.32 |
| Static image | 555 | $97,281 | $175.28 | 3.5% (n=344) | $47.30 | 0.27 |
| Studio video | 19 | $9,189 | $483.61 | — | — | — |
CAC = window spend in that format ÷ mapped new customers (true CAC, new-customers only). 30-day repeat & LTV measured on customers acquired by May 27 (n shown). Studio video sample is tiny/recent.
| Format | New custs | Spend | CAC (true) | 30-day repeat | 30-day LTV | LTV:CAC |
|---|---|---|---|---|---|---|
| Motherhood | 698 | $107,770 | $154.40 | 2.9% (n=242) | $47.66 | 0.31 |
| Gut health / Longevity | 446 | $83,313 | $186.80 | 2.4% (n=170) | $46.10 | 0.25 |
| Weight management | 331 | $54,200 | $163.75 | 3.6% (n=250) | $48.46 | 0.30 |
| Creator / Influencer | 233 | $21,963 | $94.26 | — | — | — |
| Price / Promo | 35 | $9,223 | $263.53 | — | — | — |
Creator/Influencer (TikTok) and Price/Promo launched mostly mid-June → too recent for 30-day value (shown as —), but Creator has by far the lowest acquisition CAC.
Proven set only — creatives with ≥25 acquired new customers AND ≥15 with 30-day value observability. Sorted by early repeat, then 30-day LTV.
| Creative (ad name) | New | Spend | Meta CPA | CAC (true) | 30-day repeat | 30-day LTV | LTV:CAC |
|---|---|---|---|---|---|---|---|
| ibb - leah x - the mother - bb ugc - back to work - video - paid media landing page - partner page | 30 | $6,056 | $41.76 | $201.86 | 5.6% (n=18) | $68.68 | 0.34 |
| cdm - the health manager - 099 collagen without the hassle 3 - nord static - paid media lander - brand page | 135 | $18,974 | $60.62 | $140.55 | 4.1% (n=74) | $44.11 | 0.31 |
| ibb - the weight manager manager - did you know 3 - nord static - paid media lander - brand page | 241 | $33,745 | $60.26 | $140.02 | 3.6% (n=223) | $48.51 | 0.35 |
| ibb - the mother - daily routine mom day 2 - bb ugc video - paid media lander - brand page | 529 | $72,947 | $69.34 | $137.90 | 3.2% (n=158) | $46.39 | 0.34 |
| ibb - living beyond measure - march - busy mom - the mother - bb ugc - video - paid media landing page - partner page | 79 | $13,500 | $42.86 | $170.89 | 2.7% (n=37) | $43.41 | 0.25 |
| ibb - the health manager - body needs 4 - nord video bb ugc - paid media lander - brand page | 180 | $27,908 | $65.36 | $155.04 | 1.6% (n=63) | $47.26 | 0.30 |
| Creative (ad name) | New | Spend | Meta CPA | CAC (true) | 30-day repeat | 30-day LTV | LTV:CAC |
|---|---|---|---|---|---|---|---|
| ibb - tiktok kelsilee06 - 7648325093973658894 - paid media lander - brand page | 141 | $11,198 | $39.85 | $79.42 | — | — | — |
| ibb - the health manager - 100 fits well 3b - nord static - paid media lander - brand page | 66 | $15,591 | $85.20 | $236.23 | — | — | — |
| ibb - tiktok shopwithshawn_ - 7648813718972779807 - paid media lander - brand page | 60 | $5,633 | $40.82 | $93.89 | — | — | — |
| ibb - the health manager - 090 longevity nourishers 3 - nord video bb ugc - paid media lander - brand page | 52 | $10,615 | $72.70 | $204.13 | 0.0% (n=10) | $55.08 | 0.27 |
Across the board Meta's CPA ($42–69) runs 2–3× cheaper than true new-customer CAC ($138–202) — Meta credits returning buyers and view-throughs it can't actually claim. Within that, the relative ranking still diverges:
Meta gives them an average-to-poor CPA, but they bring the best repeat buyers.
Meta loves them (low CPA) but the customers don't come back.
Strong on Meta's CPA and on real Shopify value.
read_all_orders scope), so the literal "first order in last 6 months / 90-day LTV" isn't possible. Window used: Apr 27 – Jun 26, 2026.sellingPlan; Subscribe&Save is run through StayAI, so the highest-confidence LTV signal you wanted is not visible at the point of acquisition. Weighting therefore shifted to repeat + realized LTV.netPaymentSet), measured only on customers acquired by May 27 so every cohort has ≥30 days. Recent cohorts (TikTok, Summer Sale) show "—" for value.Generated from Shopify Admin order custom attributes + Meta Ads (acct 196212110934535). New customer = first order in window (customer first seen Apr 27+). All dollar figures USD.