Marketing & Growth

How to set up pipeline attribution as CPG Founders

Marketing & GrowthFor CPG Founders3 apps12 steps~24 min to set up

You're running paid ads across Meta, Google, and maybe TikTok — all to drive DTC sales on Shopify — but you have no idea which channel actually sourced a customer. Your Shopify attribution says Meta. Meta's dashboard says Meta. Google says Google. The truth is somewhere in the middle, and you're making budget decisions based on whoever shouts loudest. Most CPG founders at your stage manually copy numbers into a spreadsheet once a week, reconcile UTM data that breaks whenever a customer uses iPhone Mail, and have no clean way to connect ad spend back to repeat purchase behavior or wholesale leads. You're spending real money on paid acquisition without a closed-loop view of what's working.

Build this on Starch → See the apps used

Marketing & GrowthFor CPG Founders3 apps12 steps~24 min to set up

Outcome

What you'll set up

A live pipeline attribution view that connects your ad spend on Meta, Google, and other channels to actual Shopify revenue — so you can see cost-per-acquisition by channel, not by what each platform self-reports

A weekly Growth Analyst digest that surfaces your top-performing acquisition channels, conversion rate changes, and where new signups or buyers are actually coming from — delivered to your inbox without you building a dashboard

A CRM-backed deal and account view for wholesale and broker relationships that tags which outreach or campaign sourced each account, so your retail pipeline has the same attribution rigor as your DTC ads

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

Growth Analyst CRM Ads Agent

Data sources & config

Growth Analyst connects to PostHog from Starch's integration catalog — the agent queries it live — and uses Gmail (Starch syncs your Gmail on a schedule) to deliver the weekly digest. The CRM syncs Gmail threads on a schedule for email history and can pull LinkedIn profile data through browser automation — no LinkedIn API needed. For ad spend data, connect Meta Ads, Google Ads, and Shopify from Starch's integration catalog; the agent queries them live when your attribution dashboard runs.

Prompts to copy

Connect PostHog to my Growth Analyst and send me a weekly email every Monday morning. Include: top referrers by new buyer count, conversion rate by channel (paid vs organic vs direct), which product pages drove the most add-to-carts this week, and one recommendation for where to shift budget or attention.

Build me a CRM for wholesale and broker pipeline. Fields: account name, buyer contact, retailer type (natural grocery / conventional / club / online), region, deal stage, estimated doors, first-contact source (trade show / cold outreach / paid ad / referral), and last activity date. I want to see at a glance which sources are converting to signed accounts fastest.

Show me a dashboard comparing Meta and Google ad spend against Shopify revenue for the last 30 days. Break it down by campaign, and flag any campaign where cost-per-order is more than 25% above my blended average.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect PostHog from Starch's integration catalog. If you're not on PostHog yet, connect Google Analytics 4 instead — also available from the integration catalog. This becomes the source of truth for traffic and conversion data.

2 Install the Growth Analyst starter app from the Starch App Store. Out of the box it will send a weekly digest summarizing signup trends, top referrers, and conversion rate changes by channel.

3 Customize the digest prompt to include CPG-specific metrics: add-to-cart rate by product, geographic breakdown of new buyers, and conversion rate on your highest-traffic product pages.

4 Connect Meta Ads and Google Ads from Starch's integration catalog. Describe a dashboard to Starch: 'Show me weekly ad spend, impressions, clicks, and orders by campaign across Meta and Google, and calculate cost-per-order for each.'

5 Connect Shopify from Starch's integration catalog. Tell Starch: 'Pull Shopify orders and match them to the UTM source in the order metadata. Group by first-touch channel and show me revenue and average order value by source.'

6 Install the CRM starter app from the Starch App Store. Fork it immediately and add CPG wholesale fields: retailer type, estimated doors, region, first-contact source, and deal stage (Prospecting / Intro Call / Buyer Review / PO Received / Active).

7 Wire Gmail into the CRM so that every email thread with a buyer or broker automatically surfaces in the account record. Starch syncs your Gmail on a schedule — no manual logging.

8 Add a 'source' field to every deal and a saved view that groups open opportunities by first-contact source. Over 90 days, this becomes your real wholesale attribution model — which trade shows, which cold outreach campaigns, and which DTC halo effects are opening doors.

9 Set up a weekly automation: 'Every Friday afternoon, pull my open CRM deals, group them by source, and Slack me a count of how many new wholesale accounts were added this week and what sourced them.'

10 Once Ads Agent launches (currently in beta — request access from the Starch App Store), connect it to run cross-channel ad management from the same platform, so budget reallocation decisions use the same attribution data your Growth Analyst and CRM already track.

11 Review your first full monthly attribution picture: DTC channel breakdown from Growth Analyst, wholesale pipeline source breakdown from the CRM, and ad spend efficiency from your Meta/Google dashboard. This is the moment you stop guessing and start making defensible budget calls.

12 Tell Starch: 'Build me a monthly attribution summary that combines my top DTC acquisition channels from PostHog, my ad cost-per-order from Meta and Google, and the source breakdown of new wholesale accounts opened this month. Format it as a one-page report I can share with my investors.'

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

Q1 2026 Attribution Audit — Natural Snack Brand, $180K Monthly DTC Revenue

Sample numbers from a real run

Meta Ads spend (Q1)	18,400
Google Ads spend (Q1)	7,200
Shopify DTC revenue attributed to Meta (self-reported)	94,000
Shopify DTC revenue attributed to Meta (PostHog / UTM)	61,000
Shopify DTC revenue attributed to Google (UTM)	38,000
Shopify DTC revenue — direct / unattributed	41,000
New wholesale accounts opened (Q1)	14
Wholesale accounts sourced by trade show	6
Wholesale accounts sourced by DTC halo / inbound	5
Wholesale accounts sourced by cold outreach	3

Before setting up attribution in Starch, this founder was allocating 72% of paid budget to Meta based on Meta's own reported ROAS of 5.1x. After connecting PostHog and Shopify from the integration catalog and building the UTM-matched attribution dashboard, the actual picture looked different: Meta's real cost-per-order was $18.40 versus Google's $11.20, and $41K in quarterly revenue had no reliable first-touch source at all — likely email and word-of-mouth. The Growth Analyst weekly digest flagged that their protein bar PDP was converting at 4.2% from Google Shopping but only 1.8% from Meta traffic, suggesting a creative-audience mismatch rather than a channel problem. On the wholesale side, the CRM's source breakdown revealed that 5 of their 14 new retail accounts in Q1 came in as inbound inquiries tied to DTC brand awareness — a halo effect they had never measured before. That single insight changed how they justified their DTC ad budget to investors: it wasn't just driving direct revenue, it was opening retail doors.

Measurement

How you'll know it's working

Cost-per-order by channel (Meta vs Google vs organic) — based on UTM/PostHog data, not platform self-reporting

DTC revenue by first-touch source, weekly and monthly

Wholesale pipeline conversion rate by account source (trade show / inbound / cold outreach)

New buyer rate vs repeat buyer rate by acquisition channel — identifying which channels bring customers who reorder

Blended customer acquisition cost across all paid channels as a percentage of average order value

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

Triple Whale or Northbeam

Purpose-built for DTC attribution and excellent at it, but costs $300–$800/month, covers DTC only, and does nothing for your wholesale pipeline attribution or weekly ops reporting — you'd still need a separate CRM and analyst tool.

HubSpot Marketing Hub + Salesforce

Enterprise-grade attribution and CRM, but you're looking at $12K–$40K/year combined, months of configuration, and a platform built for a marketing team of 10, not a founder wearing five hats.

Google Analytics 4 + manual spreadsheet reconciliation

Free and flexible, but GA4's attribution models are notoriously hard to configure correctly for CPG e-commerce, and pulling it into a spreadsheet every week means you're doing analyst work instead of operator work.

Shopify Analytics native reporting

Zero setup cost and reasonably good for Shopify-native data, but it has no view into your wholesale pipeline, no cross-channel ad spend comparison, and no way to ask questions in plain language about what changed this week.

On Starch RECOMMENDED

One platform — growth analyst, crm, ads agent all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

Does Starch store my ad performance data, or does it query live every time?

Meta Ads, Google Ads, and Shopify are connected from Starch's integration catalog and queried live when your dashboard or automation runs — the data isn't stored in Starch's database on a schedule. That means your attribution view always reflects current numbers, but it also means you can't run deep historical trend analysis going back two years in one query. For most CPG founders running monthly attribution reviews, live query is exactly what you want.

My UTM parameters break when customers open emails in Apple Mail or click through Instagram Stories. Does Starch fix that?

Starch surfaces what's in your PostHog or GA4 data — it doesn't reconstruct lost UTM signals. What it does do is make the gap visible: your attribution dashboard will show you how much revenue is landing in 'direct / unattributed' versus tagged channels, which helps you size the problem and decide whether investing in better UTM hygiene or a probabilistic attribution tool is worth it.

Can I track which trade shows or broker introductions are turning into retail accounts?

Yes — this is exactly what the CRM is built for. You add a 'first-contact source' field to your wholesale deal pipeline (trade show name, cold email campaign, DTC inbound, referral), and over time you get a source breakdown of which activities are actually converting to purchase orders. Tell Starch: 'Show me my wholesale pipeline grouped by source, with average days from first contact to first PO for each.' You'll have that view in minutes.

Is Starch SOC 2 certified? I'm connecting Shopify revenue data and customer records.

Not yet — Starch is not SOC 2 Type II certified today. That's worth knowing before you connect sensitive customer PII. Many early-stage CPG founders are comfortable with this given the alternative is a spreadsheet with even less security posture, but it's an honest limitation and you should make the call with your eyes open.

The Ads Agent app sounds useful for rebalancing Meta and Google budget. Can I use it today?

Ads Agent is currently in development. You can request beta access from the Starch App Store to get notified when it launches. In the meantime, the Growth Analyst app plus your manual attribution dashboard gives you the data to make those reallocation decisions yourself — Ads Agent will eventually automate the execution layer.

I sell on Amazon and through a regional distributor in addition to DTC. Can Starch pull those into attribution too?

Amazon Seller Dashboard is a live app in the Starch App Store — connect it and you can pull Amazon order data into the same picture as your Shopify DTC revenue. For distributor data, if your distributor has a web portal you log into manually, Starch can automate that through browser automation — no API needed. Describe what you want: 'Pull my weekly sell-through report from my distributor portal and add it to my attribution summary.' Starch handles the browser session.