Am I paying for ads that aren't producing anything?
Your ad platforms say the campaigns are working. Your accounting software says you spent $8,000 on ads. But did those ads actually produce revenue you can trace? Here's how to find out.
The short answer
Compare what your ad platform reports against what your accounting shows. Ad platforms report conversions, but those conversions may not match real revenue. To know if ads are producing, you need to check three things: what you spent (from accounting), what the platform claims (from the ad dashboard), and what revenue actually came in from ad-sourced customers (from your CRM and invoices).
Ad platforms have every incentive to make campaigns look good
Google Ads says your campaign generated 28 conversions last month. Meta Ads says another 15. That sounds great. But a “conversion” on these platforms might be a form fill, a page view, or a button click. It is not necessarily a paying customer.
Meanwhile, your QuickBooks shows $8,400 in advertising expense for the month. And when you look at your actual closed deals, only 6 of those 43 reported “conversions” turned into invoiced revenue. At $8,400 in spend and $24,000 in revenue from those 6 deals, your real return on ad spend is 2.9x. Not bad. But the ad platform told you the return was 8x based on their conversion counting.
The danger is not that ads do not work. It is that you cannot tell which ads work and which are burning money, because the platform's numbers and your real numbers are in different systems and nobody is reconciling them.
What “not producing” actually means across your systems
An ad that is not producing has one or more of these characteristics:
- High spend in accounting, low conversions in the ad platform. You are spending but not even generating clicks or leads.
- Conversions in the ad platform, but no matching CRM leads. The platform says people converted, but nobody showed up in your CRM.
- CRM leads from ads, but no closed deals. Leads came in but none of them turned into paying customers.
- Closed deals from ads, but the revenue does not justify the spend. You spent $5,000 and closed $4,000. Your return is negative.
How to check ad performance against real revenue (step by step)
This requires data from three systems: your ad platform, your CRM, and your accounting software.
Step 1: Get your actual ad spend from accounting
- 1In QuickBooks: Reports → Profit and Loss
Run the P&L for the current month. Find your Advertising or Marketing expense category. This is what you actually spent, per your bank transactions. In Xero: Accounting → Reports → Profit and Loss, same process.
Step 2: Get reported performance from ad platforms
- 2In Google Ads: go to Campaigns → Overview
Set the date range to the same month. Note the total spend, conversions, and cost per conversion for each campaign. Click “Download” (the three-dot menu) and export as CSV.
- 3In Meta Ads Manager: go to Campaigns
Set the date range. Check Amount Spent, Results (conversions), and Cost Per Result. Click “Export” and download the campaign data as a CSV spreadsheet.
Step 3: Match ad leads to CRM records
- 4In your CRM, filter by lead source
In HubSpot: go to CRM → Contacts, filter by “Original Source” equals “Paid Search” or “Paid Social” and Create Date in the current month. In Salesforce: run a Lead report filtered by Lead Source. Count how many leads came from ads and how many converted to deals.
Step 4: Match closed deals to invoiced revenue
- 5Calculate real return on ad spend
From the CRM, total the value of deals that originated from paid campaigns and actually closed. Cross-reference with your invoice list to confirm the revenue was billed. Divide actual revenue by actual spend. That is your real ROAS.
Total time: 1 to 2 hours. You are logging into three different systems, exporting data from each, and manually tracing leads from ad platform to CRM to invoice. The attribution chain is the hardest part because lead source data is often incomplete.
Ad spend is continuous, but reconciliation rarely happens
You are spending money on ads every day. The platforms are auto-billing your card. But how often do you actually check whether that spend is producing real revenue? For most businesses, the answer is rarely or never. They look at the ad platform dashboard, see “28 conversions,” and assume it is working.
The manual reconciliation described above is a 1-to-2-hour project every month. Most business owners do it once, realize how tedious it is, and never do it again. Meanwhile, underperforming campaigns keep running and keep spending.
Or let Bottomline reconcile ad spend against real revenue
Bottomline connects to your ad platforms, CRM, and accounting software. It traces the full path from ad spend to lead to deal to invoice. Every month, it shows you which campaigns produced real revenue and which ones burned money.
The Meta cold audience campaign shows 0x return. Without this cross-referencing, the ad platform might still show 12 “conversions” for that campaign, and you would keep spending. Bottomline shows you the truth by following the money through every system, from ad click to bank deposit.