Marketing · Analyze & Recommend
True CAC by channel, no spreadsheet required
Revenue data from Stripe meets marketing spend across every channel, and Doe calculates real customer acquisition cost by channel and campaign. Updated weekly.
Works acrossStripeSlackGoogle AnalyticsMeta Ads
What you get.
True CAC by channel, calculated weekly from Stripe revenue data and ad-platform spend. Multiple attribution models, LTV:CAC ratios, and budget reallocation recommendations land in Google Sheets every Monday.
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.
What changes.
- 01CAC accuracyBefore · Platform-reported (inflated by double-counting)With Doe · Revenue-matched from Stripe (one unified dataset)
- 02Time to calculateBefore · Hours of spreadsheet work each weekWith Doe · CAC report with trend lines delivered to Sheets every Monday
- 03Channel coverageBefore · Tracking gaps between ad platforms and revenueWith Doe · All channels tracked consistently
- 04Budget decisionsBefore · Based on gut feeling and vanity metricsWith Doe · Reallocation recommendations based on actual revenue
How Doe calculates your true CAC
- 01Pulls revenue, subscription tier, and payment dates for new customersStripeDoe collected 47 new customers this week with MRR and payment metadata mapped to each
- 02Pulls ad spend and cost-per-result across all active campaignsMeta AdsDoe captured spend, impressions, and conversion counts by campaign and ad set for the same period
- 03Matches each customer to the campaign or touchpoint that acquired themDoeDoe 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
- 04Builds the channel-by-channel attribution report with trend linesDoeDoe compiled spend, CAC, LTV:CAC ratio, and 12-week trend lines showing where acquisition costs are rising fastest
- 05Delivers budget recommendations to your marketing teamSlackDoe posted the three most efficient channels, flagged LinkedIn for a spend review, and suggested shifting $2K/week to Google organic content
- 06RecurringEvery Monday at 8:00 AMEvery Monday, Doe recalculates your true CAC by channel using the latest Stripe revenue data and ad platform spend. The report shows which channels are getting more expensive, which are delivering the best LTV:CAC ratios, and where budget reallocation would have the biggest impact. It's ready before the weekly marketing sync. Attribution report updated in Google Sheets, key findings posted to #marketing in Slack.
Up and running in under ten minutes.
- 01Connect your toolsOne-click OAuth for each integration. No API keys, no engineering.
- 02Describe 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.”
- 03It runs on scheduleUpdated weekly with alerts when CAC spikes above your threshold.
Before you delegate.
- 01How does Doe handle multi-touch attribution?Doe 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.
- 02What if we use platforms beyond Google and Meta?Doe connects to any ad platform with a spend reporting API (Google, Meta, LinkedIn, TikTok, and more). Each channel gets its own CAC calculation, and Doe normalizes the data so cross-channel comparisons are apples-to-apples.
- 03What if UTM parameters are inconsistent or missing?Doe 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.
- 04How does this handle customers who interact with multiple channels?Multi-touch customers are attributed based on the model you choose. Doe shows you the full journey map and lets you compare how different attribution models assign credit, so you can decide where to shift budget.
- 05Can I see CAC trends over time?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.
- 06Does Doe calculate LTV:CAC ratio?Yes. By combining Stripe revenue data with acquisition cost, Doe 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.