The Challenge
Livingood Daily is a direct-to-consumer health supplement brand running aggressive paid acquisition across Facebook, Google, YouTube, Bing, Snapchat, and other ad networks. They operate multiple product funnels — each with its own checkout flow, attribution logic, and revenue model.
Their reporting lived in Google Data Studio with manual data pulls. There was no unified view of funnel performance across platforms. The marketing team couldn't answer basic questions like which funnels were actually profitable or what a customer acquired through a specific campaign was worth over time.
Worse, roughly half of all orders couldn't be traced back to the ad that drove them. Attribution gaps meant the team was making spend decisions on incomplete data — across a multi-million dollar monthly ad budget.
The Solution
We migrated Livingood Daily off BigQuery and Google Data Studio onto a modern stack built on Snowflake, with automated pipelines pulling from every source system in the business.
What we built:
- Unified ad optimization dashboards replacing legacy reporting — campaign performance, spend, revenue, and ROAS across all six ad platforms in one place
- Funnel-level attribution tying ad clicks to checkout completions across multiple checkout systems (Checkout Champ and Shopify)
- Customer 360 with a daily-updated golden record resolving customer identities across platforms
- LTV models connecting ad spend to long-term customer value by cohort, funnel, and product
- Browser-level identity stitching to close attribution gaps and connect anonymous sessions to known customers
- AI-powered analyst tool so non-technical team members can query data in plain English and export to Excel
- Custom audience activation syncing high-value customer segments directly back to ad platforms for targeting
The Results
- Every ad platform, checkout system, and marketing tool reporting into a single source of truth
- Marketing team making spend decisions on complete, same-day data instead of stale spreadsheets
- Non-technical team members querying the data warehouse directly through an AI analyst — no SQL required
- High-value customer segments automatically synced to ad platforms for lookalike and retargeting campaigns
- Double-digit ROAS improvement after activating high-LTV segments and closing attribution gaps
- Scope has expanded every quarter for two years — from basic reporting to full-stack data operations including warehouse, BI, identity resolution, and AI tooling