Log in

Marketing

True CAC by channel, no spreadsheet required

Revenue data from Stripe meets marketing spend across every channel, and ZeroTwo calculates real customer acquisition cost by channel and campaign. Updated weekly.

Integrates with:

What changes

Before
With ZeroTwo
CAC accuracy
Platform-reported (inflated by double-counting)
Revenue-matched from Stripe (one unified dataset)
Time to calculate
Hours of spreadsheet work each week
CAC report with trend lines delivered to Sheets every Monday
Channel coverage
Tracking gaps between ad platforms and revenue
All channels tracked consistently
Budget decisions
Based on gut feeling and vanity metrics
Reallocation recommendations based on actual revenue

CAC accuracy

Before

Platform-reported (inflated by double-counting)

With ZeroTwo

Revenue-matched from Stripe (one unified dataset)

Time to calculate

Before

Hours of spreadsheet work each week

With ZeroTwo

CAC report with trend lines delivered to Sheets every Monday

Channel coverage

Before

Tracking gaps between ad platforms and revenue

With ZeroTwo

All channels tracked consistently

Budget decisions

Before

Based on gut feeling and vanity metrics

With ZeroTwo

Reallocation recommendations based on actual revenue

You're guessing where your budget should go

Every platform tells you it's working. Google Ads claims 200 conversions. Meta says 180. Your CRM shows 150 new customers. The numbers don't add up because every platform takes credit for the same customer, and nobody's math includes the full picture from first touch to closed revenue.

So you build a spreadsheet. You export spend from each ad platform, pull revenue from Stripe, match customers by UTM parameters (when they're not broken), and try to calculate a real CAC. The formula is fragile, the data is stale by the time you finish, and you're never fully confident in the numbers.

How ZeroTwo calculates your true CAC

1

Pulls revenue, subscription tier, and payment dates for new customers

Stripe

ZeroTwo collected 47 new customers this week with MRR and payment metadata mapped to each

2

Pulls ad spend and cost-per-result across all active campaigns

Meta

ZeroTwo captured spend, impressions, and conversion counts by campaign and ad set for the same period

3

Matches each customer to the campaign or touchpoint that acquired them

Google

ZeroTwo traced every new customer using UTMs, referrer data, and CRM source fields — Google Search delivers $38 CAC with a 5.2x LTV ratio, while LinkedIn sits at $210 CAC with a 1.1x ratio

4

Builds the channel-by-channel attribution report with trend lines

Google

ZeroTwo compiled spend, CAC, LTV:CAC ratio, and 12-week trend lines showing where acquisition costs are rising fastest

5

Delivers budget recommendations to your marketing team

Slack

ZeroTwo posted the three most efficient channels, flagged LinkedIn for a spend review, and suggested shifting $2K/week to Google organic content

Runs every Monday at 8:00 AM · Attribution report updated in Google Sheets, key findings posted to #marketing in Slack

Get started in under 10 minutes

1

Connect your tools

One-click OAuth for each integration. No API keys, no engineering.

2

Describe what you need

“Calculate blended CAC and per-channel CAC weekly using spend from Google Ads, Meta, and LinkedIn plus closed-won deals from HubSpot. Use last-touch attribution and flag any channel where CAC exceeds $250.”

3

It runs on schedule

Updated weekly with alerts when CAC spikes above your threshold.

Frequently asked questions

ZeroTwo supports multiple attribution models: first touch, last touch, linear, and time-decay. You can run the analysis with different models to see how channel value shifts depending on the framework, giving you a clearer view of what's driving conversions.

ZeroTwo connects to any ad platform with a spend reporting API (Google, Meta, LinkedIn, TikTok, and more). Each channel gets its own CAC calculation, and ZeroTwo normalizes the data so cross-channel comparisons are apples-to-apples.

ZeroTwo uses multiple signals beyond UTMs, including referrer data, landing page patterns, and CRM source fields, to attribute customers. It also flags attribution gaps so you know where your tracking needs improvement.

Multi-touch customers are attributed based on the model you choose. ZeroTwo shows you the full journey map and lets you compare how different attribution models assign credit, so you can decide where to shift budget.

Yes. Each weekly run builds on previous data, so you get trend lines showing how CAC by channel evolves. This helps you spot when a channel is becoming more expensive or when a new campaign is outperforming expectations.

Yes. By combining Stripe revenue data with acquisition cost, ZeroTwo calculates LTV:CAC ratios by channel and cohort. This reveals which channels bring in the most valuable long-term customers, not only the cheapest acquisitions.

Related workflows

Stop doing the work your tools should do for you.

Set it up once. ZeroTwo runs it every time.