Seatext library / BotRefund evidence
How to Track Wasted Spend in Google Ads: A Step-by-Step Setup Guide
Track wasted spend by first implementing proper conversion tracking, then creating custom columns that compare cost against conversion value, and finally building automated reports that surface non-converting clicks, irrelevant search terms, and invalid traffic...
✓ Built for advertisers who need clear, refund-ready traffic evidence.
To track wasted spend in Google Ads, start by verifying that conversion tracking captures every meaningful action on your site. Then create custom columns that calculate waste as cost minus converting-click cost, and schedule automated reports that break down waste by campaign, search term, device, and audience. The result is a living dashboard that shows exactly where budget leaks occur so you can fix them systematically.
What Counts as Wasted Spend in Google Ads
Wasted spend is any portion of your ad budget that does not contribute to a measurable business outcome. That includes clicks from bots and click farms, impressions served to non-human traffic, spend on search terms that never convert, and budget consumed by campaigns with broken or missing conversion tracking. Industry data shows the average Google Ads account loses 11% to 14% of clicks to invalid traffic, and Google's own automated filters catch less than half of that invalid activity.
High-CPC verticals such as legal, insurance, and B2B SaaS often see even higher invalid traffic rates. When conversion tracking is incomplete, Smart Bidding optimizes toward noise, amplifying the waste. A clear definition lets you build reports that isolate each waste category instead of treating all non-converting spend as a single blob.
Prerequisites Before You Start Tracking
- Full conversion coverage: Every lead form, purchase, phone call, and key micro-conversion must fire a conversion action with a unique ID.
- Enhanced conversions enabled: This matches hashed first-party data to ad clicks, improving attribution accuracy especially when cookies are restricted.
- Auto-tagging turned on: GCLID parameters must append to landing-page URLs so click-level data flows into Analytics and your CRM.
- Link Google Ads to GA4: Provides a second attribution layer and lets you compare platform-reported conversions with analytics-reported events.
- Admin access to the Google Ads account: Required to create custom columns, saved reports, and scheduled emails.
If any of these are missing, fix them first. Waste tracking built on incomplete data produces misleading priorities.
Step 1: Set Up Conversion Tracking Properly
- Open Tools > Conversions and verify every conversion action shows "Recording conversions" status.
- For each action, confirm the conversion window matches your sales cycle (typically 30-90 days for B2B, 1-7 days for e-commerce).
- Enable Enhanced conversions for web and, if you capture leads offline, Enhanced conversions for leads.
- Set each action's category correctly (Purchase, Lead, Sign-up, etc.) so value-based bidding works as intended.
- Assign a conversion value — even a placeholder — so cost-per-conversion and ROAS columns calculate.
- Run the Conversion diagnostics page (Tools > Conversions > Diagnostics) and resolve every "Unverified" or "Tag inactive" warning.
Without this foundation, any waste metric you build will inherit the same blind spots.
Step 2: Build Custom Columns for Waste Metrics
Custom columns turn raw cost and conversion data into waste indicators you can sort, filter, and chart.
- Go to Campaigns > Columns > Modify columns > Custom columns > + New column.
- Create Wasted Cost: Formula =
Cost - (Cost / Conversions) * Conversions— this approximates spend on non-converting clicks. Name it "Wasted Cost" and format as Currency. - Create Waste Rate %: Formula =
Wasted Cost / Cost— shows the share of budget not tied to a recorded conversion. Format as Percent. - Create Cost Per Converting Click: Formula =
Cost / Conversions — benchmarks what a "good" click costs. - Create Invalid Click Estimate: If you use a click-fraud tool that exports a daily invalid-click count, import it via a Google Sheet and build a column referencing that sheet, or manually update a "Known Invalid Clicks" column weekly.
- Save all columns and add them to your default campaign, ad group, and keyword views.
These columns let you sort any table by Waste Rate % and instantly see the leakiest segments.
Step 3: Create Automated Reports for Ongoing Monitoring
- Navigate to Reports > Predefined reports (formerly Dimensions) > Basic > Campaign.
- Add your custom columns (Wasted Cost, Waste Rate %, Cost Per Converting Click).
- Add segments: Device, Network (Search vs. Search Partners vs. Display), Day of week, Hour of day.
- Set a date range of "Last 30 days" and click Save as > "Waste Audit - Campaign Level".
- Repeat for Ad group, Keyword, and Search term predefined reports, each saved with a clear name.
- Open each saved report, click Schedule, choose "Weekly" on Monday 6 AM, and email to yourself and the account manager.
Weekly cadence catches new waste before it compounds. For high-spend accounts ($50K+/month), add a daily "Top 10 Waste Keywords" report.
Step 4: Use Search Terms Reports to Identify Waste Sources
The search terms report is the single highest-leverage waste detector.
- Open Insights & reports > Search terms.
- Add columns: Impressions, Clicks, Cost, Conversions, Cost/conv., Waste Rate % (your custom column).
- Filter: Conversions < 1 AND Cost > [your average CPA].
- Sort by Cost descending. The top rows are search terms burning budget without converting.
- For each term, decide: Add as negative keyword, Move to a dedicated low-budget test campaign, or Adjust match type on the triggering keyword.
- Export the filtered list weekly and feed it into your negative-keyword master list.
Search Partners and Display Network often show higher waste rates. Segment by Network to see if opting out of Search Partners reduces Waste Rate % without hurting volume.
Step 5: Segment by Device, Location, and Audience
Waste concentrates in predictable segments.
- Device: Mobile clicks sometimes convert at half the rate of desktop but cost the same. Add a Device segment to your waste report and bid-adjust or exclude if Waste Rate % is 2x the account average.
- Location: Sort the Geographic report by Waste Rate %. Exclude or bid-down regions where waste exceeds 40% and conversion volume is statistically insignificant.
- Audience: In Audience Manager, compare "Observation" vs. "Targeting" modes. Observation lets you see waste rates per audience without restricting reach. Remove audiences with Waste Rate % above your threshold.
Document every exclusion in a change log so you can revert if performance shifts.
Step 6: Track Invalid Traffic Separately
Invalid traffic (bots, click farms, competitor clicks) requires behavioral evidence that Google's filters miss. Specialized tools capture GCLIDs with behavioral signals — mouse tremor, pointer path, session duration, VPN detection — and generate audit-ready refund dispute reports. Install a client-side detection script on your landing pages to capture this evidence automatically. The script should log each click's GCLID, timestamp, and behavioral fingerprint, then export a CSV you can upload with a Google Ads refund request. Industry data indicates sophisticated invalid traffic (SIVT) makes up the majority of fraud that automated filters miss.
Verification: How to Confirm Your Tracking Works
- Click your own ad in an incognito window (use the Ad Preview tool to avoid inflating costs).
- Complete a test conversion on the landing page.
- Wait 30 minutes, then check Tools > Conversions > [your action] > Recent conversions. The test click should appear with its GCLID.
- Open your latest scheduled waste report. Verify the test campaign shows 1 conversion, cost > 0, Waste Rate % = 0% (or near zero).
- Confirm the custom columns populate for all active campaigns — no "—" or "0" where data should exist.
If any step fails, revisit the prerequisite checklist. A single broken tag invalidates the entire waste model.
Key Facts About Google Ads Wasted Spend
Metric Value Source
Average invalid click rate across Google Ads campaigns 11%–14% S1
Google's automated filters catch rate for invalid traffic Less than 50% S1
Global digital ad fraud projected cost (2026) Over $100 billion S1
Invalid traffic share of programmatic ad spend (WFA) 10%–30% S1
Invalid click rate range for Google Search campaigns 4% (well-protected) to 35%+ (high-CPC competitive) S5
BotRefund refund success rate for high-volume advertisers 83% S2
Estimated bot share of ad traffic 20% S2
Common Limitations and Blind Spots
- Attribution lag: Conversions can take days to appear. Waste Rate % for the last 3-7 days is artificially high. Always exclude the most recent 72 hours from trend analysis.
- View-through conversions: Display and YouTube view-throughs inflate conversion counts without a click. They lower Waste Rate % but may not reflect true intent. Decide whether to include them and stay consistent.
- Offline conversions: If you import CRM stages (MQL, SQL, Closed Won) as offline conversions, waste tracking improves — but only if the import is timely and deduplicated.
- Cross-device gaps: Users who click on mobile and convert on desktop may not match if they're not signed in. Enhanced conversions mitigate this but don't eliminate it.
- Search Partners opacity: You cannot see which partner sites delivered clicks. If Search Partners waste is high, the only lever is opt-out.
Terminology Quick Reference
- Wasted Cost
- Custom column: total cost minus estimated cost of converting clicks.
- Waste Rate %
- Wasted Cost divided by total Cost, expressed as a percentage.
- Invalid Traffic (IVT)
- Clicks or impressions generated by non-humans (bots, scripts, click farms).
- Sophisticated Invalid Traffic (SIVT)
- IVT that mimics human behavior well enough to bypass automated filters.
- GCLID
- Google Click Identifier — a unique parameter appended to landing-page URLs when auto-tagging is enabled.
- Pixel Poisoning
- When bot traffic fires conversion pixels, corrupting the audience signals that Smart Bidding uses.
- Refund Dispute Report
- A structured evidence package (GCLIDs, timestamps, behavioral fingerprints) submitted to Google Ads support to request credit for invalid clicks.
FAQ
How often should I review the waste report?
Weekly for most accounts. Daily for spend above $50K/month or during new campaign launches. Monthly is too slow — waste compounds.
Can I automate negative-keyword additions from the search terms report?
Yes, using Google Ads Scripts or the API. Many advertisers export the filtered search terms sheet, run a script that adds terms with Waste Rate % > 50% and Cost > 2x CPA as campaign-level negatives, and log each addition.
What's the difference between Waste Rate % and invalid click rate?
Waste Rate % includes all non-converting spend (poor targeting, wrong match types, low-quality ads). Invalid click rate measures only bot/fraud clicks. They overlap but are not identical.
Do I need a third-party tool to track invalid traffic?
Google's built-in invalid click report (Tools > Invalid clicks) shows only what their filters caught. For SIVT — the majority per industry data — you need client-side behavioral detection that captures GCLIDs with evidence like mouse tremor, pointer path, and session patterns.
How far back can I claim refunds for invalid clicks?
Google typically accepts refund requests for the past 60 days, though some advertisers have recovered spend dating back to 2017 with sufficient evidence. Submit claims promptly each month.
Should I pause keywords with high Waste Rate % immediately?
Not always. Check conversion volume first. A keyword with 2 conversions and 60% Waste Rate % may just need more data. Set a minimum click threshold (e.g., 100 clicks) before making structural changes.
What if my conversion values are estimates?
Use relative values (e.g., Lead = 1, Qualified Lead = 5, Sale = 50) rather than leaving them blank. Even rough values let cost-per-conversion and ROAS columns function, which feeds Smart Bidding and your waste columns.
Further reading and comparison sources
These external sources provide additional context for evaluating the topic. Their inclusion is not an endorsement.
Learn more
Visit the website for more information.