Finding #1 — SB punches above its weight, halo is huge
A console-only view would systematically undervalue the real growth drivers.
- Monthly spend: $42.4K | click-attributed sales: $102.2K | click ROAS: 2.41
- Halo sales: $30.4K (~30% of click-attributed sales on non-promoted ASINs)
- SP vs SB: SB delivered higher CTR, higher ROAS, and higher halo share of sales
Mix snapshot (by ad product)
- SP — 80.5% spend share | 76.1% sales share | ROAS 2.28 | CTR 0.77% | halo share 28.1%
- SB — 19.5% spend share | 23.9% sales share | ROAS 2.96 | CTR 1.32% | halo share 35.2%
Finding #2 — SB outperformed SP on key generic query clusters
On shared search terms, SB often beat SP by +1.5–4.0 ROAS points.
- Generic glove terms (e.g., “plastic gloves”, “vinyl gloves”, “food prep gloves”) consistently favored SB.
- Nutrition terms (e.g., “mct oil”, “electrolytes powder”) showed SB as underfunded but highly incremental.
- SB also delivered higher halo share — pulling shoppers deeper into the catalog.
Finding #3 — Funnel leakage was mostly DPV → purchase
In this dataset ATC was zero, so we used DPV → purchases as the funnel.
- High-efficiency glove terms showed strong DPV volume and ~17–21% DPV→purchase rates, plus meaningful halo.
- DPV-heavy, purchase-light terms flagged PDP/offer mismatch (C8 MCT), PDP competitiveness (coconut oil), and claim sensitivity (electrolytes).
- Halo patterns helped separate “gateway behavior” from true conversion issues.
Finding #4 — “Gateway” ASIN behavior surfaced via halo
One promoted ASIN drove ~$1.2K sales with 100% halo share.
- The promoted product pulled shoppers in — but they purchased other items instead.
- If the goal is direct ROAS: promote what people actually buy.
- If the goal is portfolio expansion: keep the gateway, but optimize the journey (store path, variations, bundles).
Finding #5 — Measurement guardrails (traffic-time vs conversion-time)
Some generic terms were “laggy” and under-reported in short conversion windows.
- Overall alignment was good (QA passed).
- A subset of generic terms showed 20–40% lower sales on conversion-time within the same window.
- Recommendation: use traffic-time (or lag-aware reporting) for in-flight optimization; keep conversion-time for closed-period finance truth.
Data caveat — SP funnel events were not trustworthy yet
SP DPV/ATC click fields returned zero in the export.
- We treated SP funnel leakage as instrumentation caveat, not business truth.
- Recommended a follow-up schema/threshold QA to confirm which fields populate in their AMC instance.
- Also checked whether granular breakdowns triggered privacy suppression.