Which channel has the best ROI?
Every channel looks great in its own dashboard. But when you compare spend to actual revenue across all channels, the rankings change. Here's how to find the real winner.
The short answer
Which channel gives you the best return? Take the revenue generated by customers from each channel and divide by the total cost of that channel. The channel with the highest ratio wins. But you need revenue data from accounting, source data from your CRM, and spend data from your ad platforms to calculate this properly.
Why ROAS from your ad platform is not real ROI
Google Ads shows a 4x return on ad spend. Meta shows 3.2x. Both look profitable. But these numbers are calculated using platform-reported conversions and estimated conversion values, not actual revenue collected in your bank account.
When you trace the money through your CRM and accounting software, the picture often looks different. That 4x ROAS from Google might drop to 2.1x when you only count customers who actually paid. And those referral customers who cost nothing in ad spend? They might be generating 5x more revenue per customer than any paid channel.
Real ROI requires real revenue. And real revenue lives in your accounting software, not in your ad dashboard.
Channel ROI vs. ROAS: understanding the difference
These terms get used interchangeably, but they measure different things:
- ROAS (Return on Ad Spend). Revenue divided by ad spend. Only counts the direct advertising cost, not sales team time, tools, or overhead. This is what ad platforms report.
- Channel ROI. (Revenue - Total Channel Cost) / Total Channel Cost. Includes ad spend plus any allocated costs like sales time or content creation. A more complete picture.
- Revenue per customer by source. Total revenue from customers acquired through a channel divided by the number of customers. This tells you not just how many customers a channel brings, but how valuable they are.
The most common mistake is optimizing for the channel with the lowest CAC when you should be optimizing for the channel with the highest revenue per customer relative to cost. A channel that costs $500 per customer but produces $5,000 customers is better than a channel that costs $50 per customer but produces $200 customers.
How to calculate true channel ROI across ad platforms and accounting (6 steps)
This builds on the channel CAC calculation. If you have already done that work, this adds about 30 minutes. If not, plan for 90 minutes total.
- 1Gather spend per channel from ad platforms
Log into Google Ads and Meta Ads Manager. Note the total spend for each platform this month. Also account for any other paid channels (LinkedIn Ads, direct mail, etc.).
- 2Get revenue per customer from QuickBooks or Xero
In QuickBooks, run the Sales by Customer Summaryreport for the month. In Xero, export paid invoices and sum by customer. You need each customer's total revenue.
- 3Map each customer to their acquisition channel
Use your CRM's “Original Source” (HubSpot) or “Lead Source” (Salesforce) field. VLOOKUP by email to match each paying customer in your accounting export to their CRM source.
- 4Sum revenue by channel
In your spreadsheet, create a pivot table grouping customers by acquisition source. Sum the revenue for each group. Now you have total revenue per channel.
- 5Calculate ROI per channel
For each channel: (Channel Revenue - Channel Spend) / Channel Spend = ROI. Express as a multiple (e.g., 3.2x) or a percentage (e.g., 320%).
- 6Rank and compare
Sort channels by ROI descending. Compare this ranking to what each ad platform reports as ROAS. The differences will likely surprise you.
Total time: 60-90 minutes. The hardest part is matching customers across CRM and accounting. Expect 15-20% of customers to not match cleanly, leaving gaps in your data.
What it takes to track channel ROI every month
Once you have the spreadsheet template, the monthly refresh takes about 45 minutes: re-export data from three platforms, re-run the matches, rebuild the pivot table. The problem is not just the time. It is the reliability of the data.
Customers who convert in one month but pay in the next get attributed to the wrong period. Multi-touch customers (clicked a Google Ad, then came back via organic, then converted via email) get attributed to whichever touch your CRM happened to capture. Revenue from upsells and renewals muddies the initial channel value. Every month, the data gets a little less trustworthy.
Or see your true channel ROI calculated automatically
Bottomline connects to all your systems and matches every dollar of revenue to the channel that produced it. No manual exports. No VLOOKUP. No gaps in the matching.
The ranking tells a clear story: referral and organic are your most efficient channels by ROI. Google Ads is profitable at 3.4x. Meta Ads is marginal at 2.1x. Without cross-referencing all three systems, you would be relying on each platform's self-reported numbers, which always look better than reality.