Integrations 12 min readApril 26, 2026

The Google Ads dashboard every small business should have

Stop trusting Google Ads' attribution at face value. Build a Google Ads dashboard that ties spend to actual revenue, margin, and customer LTV — not platform clicks.

Why your Google Ads dashboard is lying to you

Google Ads has every incentive to make its own performance look as good as possible. The platform's native conversion attribution typically inflates reported revenue by 30-100% for the average ecommerce business, due to:

  • View-through conversions counted at full credit even when the user would have purchased anyway.
  • Branded search clicks counted as Google Ads conversions even though the user typed your brand name (i.e., they were already coming).
  • Last-click bias that ignores upper-funnel work done by Meta, TikTok, email, and SEO.
  • No margin awareness — a $200 sale of a $190-cost product is reported the same as a $200 sale of a $40-cost product.

A proper Google Ads dashboard [blocked] reconciles all of this and reports true ROAS in gross profit dollars.

The five-metric Google Ads dashboard

1. True ROAS (gross profit basis)

Gross profit from Google Ads-sourced customers / Google Ads spend. This is the only ROAS number that matters. A 4:1 platform-reported ROAS often translates to 1.2:1 true ROAS, which means you're roughly breaking even after operating costs.

2. Branded vs. non-branded spend

What % of your Google Ads budget is buying clicks on your own brand name? For most healthy businesses this should be under 15%. If it's 40%+, you're paying Google to capture demand you already created — it's accounting alchemy that makes ROAS look great but doesn't grow the business.

3. CPA by campaign and ad group

Identify which campaigns are profitable at scale and which are draining the budget. Typical small-business Google Ads accounts have a Pareto distribution: 20% of campaigns drive 80% of profitable conversions.

4. Impression share (lost to budget vs. lost to rank)

"Impression share lost to budget" tells you which campaigns to fund more aggressively. "Impression share lost to rank" tells you which need creative or quality-score work. Most small businesses ignore these and miss easy wins.

5. 90-day cohort LTV by acquisition source

Which Google Ads campaigns are bringing in customers who buy again, refer others, and generate referrals? Often the campaigns with the worst day-one ROAS have the best 90-day LTV — and vice versa. Without this view you're optimizing for one-time bargain hunters instead of long-term customers.

Building it without a developer

Illuminated Intelligence [blocked] connects to Google Ads via OAuth and joins the data with your store, billing, and CRM. The platform then computes true ROAS, branded share, CPA waterfalls, and 90-day cohort LTV automatically, and JARVIS monitors for budget waste and surfaces it before the end of the month.

For a $50K/month ad spend account, the typical first-month finding is $5K-$15K of clearly-wasted spend (under-performing campaigns, branded over-investment, low-LTV acquisition channels). The platform usually pays for itself in the first week.

Ready to see your business, illuminated? Start a free 14-day trial [blocked] of Illuminated Intelligence — no credit card required, full setup in under an hour. Or meet JARVIS [blocked], our AI business advisor that turns your data into next-step recommendations.

● FAQ

Frequently asked questions

What's wrong with Google Ads' built-in dashboard?

Google Ads' native dashboard reports conversions and conversion value as Google sees them — which often double-counts revenue, claims credit for branded search that would have happened anyway, and ignores margin. A proper Google Ads dashboard reconciles platform-reported revenue with actual closed revenue from your CRM or store, then computes ROAS on gross profit instead of gross revenue.

How do I calculate true Google Ads ROAS?

True ROAS = (Actual revenue from Google Ads-sourced customers − cost of goods sold) / Google Ads spend. Most platforms report on gross revenue, which dramatically overstates profitability. To get the true number you need to join Google Ads spend with order data from Shopify or your billing system, then subtract product margin. A unified BI tool does this automatically.

What metrics should a small business track in Google Ads?

The five essentials: cost per acquisition (CPA) by campaign, true ROAS (gross profit basis), branded vs. non-branded spend split, top-of-funnel impression share, and 90-day cohort LTV by acquisition source. The last one is what separates businesses that scale ad spend profitably from those that don't.

See your business, illuminated.

Start your free 14-day trial. Connect your tools in under an hour. Get your first AI insight by tomorrow morning.