How to Measure Marketing ROI Without Expensive Analytics Tools
You don't need Mixpanel or Amplitude to know which marketing channels are actually making money. Most small business founders are overthinking this. Track revenue source, calculate cost per customer acquisition, and compare against your customer lifetime value. That's 80% of what you need.
Start with Revenue Attribution, Not Pageviews
Forget vanity metrics. Your website could get 10,000 monthly visitors and still be unprofitable. Instead, ask every new customer one question: "How did you hear about us?" Document it in a spreadsheet. That's your attribution baseline.
If you're selling online, most platforms (Shopify, WooCommerce, Stripe) let you tag traffic sources. Use UTM parameters on all your links—even free ones. utm_source=newsletter, utm_medium=email, utm_campaign=jan2024. Costs nothing. Then segment your sales by source in a basic Google Sheet.
For service-based businesses, this is even simpler. Your CRM (or a spreadsheet) should track: customer name, deal value, how they found you. Sum by channel monthly. You now have your first real metric.
Calculate Cost Per Acquisition and Compare It
Spend $500 on Google Ads in January and close 2 customers at $1,000 each? Your cost per acquisition is $250. Spend $100 on LinkedIn outreach (your time, mostly) and land 1 customer? That's $100 CAC. LinkedIn wins.
The formula is dead simple:
- CAC = Total Marketing Spend ÷ New Customers Acquired
Track this monthly by channel. You'll quickly spot the losers—the channels bleeding money—and the winners worth doubling down on.
Many founders discover that their word-of-mouth referrals have zero cost but highest lifetime value. Others find that Facebook ads work at 2x ROI while Twitter ads are a waste. You can't optimize what you don't measure, and this measurement costs almost nothing.
Compare Against Customer Lifetime Value
Your CAC only matters in context. If you spend $500 to acquire a customer, but they pay you $2,000 over their lifetime with you, that's a 4:1 return. Healthy. If they pay $400 total? You're losing money, even if you only spent $100 acquiring them.
Calculate rough lifetime value: How much does an average customer spend with you over their relationship? For a SaaS at $99/month with 12-month average retention, that's $1,188 LTV. For an e-commerce store, look at average order value × repeat purchase rate.
A good rule of thumb: your CAC should be no more than 1/3 of your LTV. If LTV is $1,200, keep CAC under $400. This single ratio tells you whether your marketing is actually working.
Build Your Dashboard in a Spreadsheet
Pull your data once a week into a simple table: Channel | Spend | Customers | CAC | Revenue | ROI. Color-code it red or green. That's your entire analytics stack.
If you're building a new product and need to validate demand before investing heavily in marketing infrastructure, platforms like fivedaylaunch can help you get live fast—websites in 5 days, web apps in 10—so you can focus on these fundamentals with actual traffic instead of theorizing.
The best marketing founders don't have the fanciest tools. They have discipline. They measure what matters, kill what doesn't work, and double down on what does. Start this week with a spreadsheet. You'll learn more in 30 days than most teams learn in a year.