Ad Spend Analysis that shows true ROAS by channel
Growth & MarketingCompare Facebook, Google, and TikTok side-by-side. See true ROAS after refunds. Get exact dollars to shift from losers to winners.
Your first run is free - no card required.
Growth & Marketing Data
Live sync
Auto‑Generated
2 min ago
Coming Q3 2026
📍 Blended ROAS calculation complete, CSV upload integration in progress
What's Inside the Excel
Get a ready-to-use file with everything you need
📊
Blended ROAS
All platforms compared: Facebook, Google, TikTok side-by-side
🔍
Winner/Loser rank
Channels ranked by true ROAS after refunds
💰
Budget reallocation
Exact $ to shift from losers to winners
📋
Attribution windows
Compare 1-day, 7-day, 28-day ROAS - see platform tricks
Available for These Platforms
Platform-specific implementations of this decision kit with unique insights for each
What You'll Get
Real outcomes for your business
💰
Find wasted spend: Identify $2,000-$10,000/month on losing channels that look good in-platform but don't pay back
✂️
Know what to cut: Clear winner/loser ranking with exact $ to shift for optimal ROAS
📊
One source of truth: Stop juggling Facebook, Google, TikTok dashboards - compare apples to apples
Is this for me?
✓
You run ads on Facebook, Google, TikTok or other platforms
✓
You're not sure which ad channels actually pay back after refunds
✓
You want to stop wasting money on losing campaigns
How We Calculate Blended ROAS & True CAC
From platform spend to real revenue attribution
📊
Blended ROAS
Definition: (Total revenue from ads) ÷ (Total ad spend across all platforms)
Source: Order revenue + ad spend from all channels
Granularity: Overall, by channel, by campaign
📊
True CAC
Definition: (Total ad spend) ÷ (New customers acquired)
Source: Ad spend + new customer identification
Granularity: By channel, by campaign
📊
Channel Efficiency Rank
Definition: Channels ranked by ROAS, with $ wasted if continued at current spend
Source: ROAS comparison + spend allocation
Granularity: Ranked list with reallocation recommendations
Key Features
Unlock powerful insights with these automated features.
Unified ROAS Dashboard
One view of all ad platforms: Facebook, Google, TikTok, Pinterest - compare apples to apples.
Winner/Loser Identification
Clear ranking: top performers to scale, bottom performers to pause, with $ impact of each decision.
Budget Reallocation Plan
Get exact $ amounts to shift from losers to winners for optimal ROAS.
CSV Upload & Light Connectors
Start fast with CSV upload; graduate to automated connectors as you grow.
Why Manual Reporting Doesn't Work
Hours spent downloading CSVs, cleaning data, and formatting spreadsheets. Every week, every month, every platform.
The Pain Points
- Manual exports that eat up your time
- Inconsistent formatting between platforms
- Errors from manual copy-pasting
- Data that's outdated the moment you get it
Our Solution
- Fully automated report generation
- Expertly formatted Excel & Google Sheets reports
- Fresh data delivered on your schedule
- Pre-built Report Recipes by e-commerce experts
How It Works
3 simple steps to your first report
1. Connect your store
OAuth2 - no passwords
2. Pick dates
Select your date range
3. Download Excel
Ready in ~30 seconds
Prerequisites
- ✓ E-commerce platform with order data (Shopify, WooCommerce, or Stripe)
- ✓ Minimum data: Ad spend CSV upload (Facebook, Google, TikTok, etc.) or light connector to start
- ✓ Optimal: 8+ weeks of spend and revenue data for statistical significance
- ℹ️ CSV upload option available for quick start; attribution is last-touch by default; handles multi-platform spend; ROAS calculated after refunds/returns
Frequently Asked Questions
What ad platforms do you support?
We support Facebook, Google, TikTok, Pinterest via CSV upload. Native connectors for Facebook and Google Ads are in beta - email us to join the waitlist.
How do you attribute sales to ad channels?
We use last-touch attribution by default (matching how most platforms report). You can import UTM data for multi-touch attribution if you have it.
Do you account for refunds in ROAS?
Yes - critical for accuracy. We subtract refunds from revenue before calculating ROAS. Channels that drive returns get penalized appropriately.
Can I upload ad spend via CSV?
Yes - perfect for getting started fast. Export spend from Facebook, Google, TikTok and upload. We'll match it to your order data.
Why Choose Spreadsheet Broccoli?
Start automating your e-commerce reporting today and save hours every week.
🚀
Expert-Built Templates
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
⚡
Lightning Fast Setup
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
📊
Excel & Sheets Native
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
🎯
Playbooks, not just reports
Our report recipes are designed to provide actionable insights and recommendations for your business.
Ready to Reconcile Your Payouts?
Start using Ad Spend Reality (Blended ROAS/CAC) today and turn your data into decisions
No card • Keep the file forever • Cancel anytime