Google Ads Audit Script
Free Google Ads script that runs a comprehensive audit of your account — Search, PMax, Shopping feed, and settings — and outputs a 9-tab Google Sheet report with actionable findings.
Your data never leaves your browser
Everything runs 100% client-side. Your CSV files and API responses are processed locally and never sent to any server. We have no access to your data — not even technically.
About this tool
Want a full health check of your Google Ads account without hiring an agency? This free script audits everything — Search keywords, search terms, RSA ads, PMax asset groups, Shopping feed, conversion setup, and campaign settings — in a single run.
Paste the script into Google Ads Scripts, point it at an empty Google Sheet, and hit Run. Within minutes you get a 9-tab report covering every major area of your account. Each tab has color-coded flags so you can immediately see what needs attention.
The Executive Summary tab gives you a bird's-eye view: total cost, conversions, CPA, and ROAS for both Search and PMax, followed by a categorized list of issues (critical, warning, OK) and a Quick Wins section with estimated savings.
Search analysis covers keyword waste (high cost, zero conversions), low Quality Scores, dead keywords, duplicate keywords across ad groups, and conflicts between active keywords and negative keywords. Search terms are analyzed for wasted spend with specific negative keyword recommendations.
RSA ads are checked for ad strength, headline/description count, pinning usage, and ad group coverage. PMax asset groups are audited against Google's minimum and recommended asset counts.
Shopping feed analysis merges product status with performance data — flagging disapproved products, zero-impression items, and high-spend zero-conversion products. A separate issues tab lists every Merchant Center warning.
The Settings tab audits auto-tagging, conversion action configuration (counting type, attribution model), network targeting, geo targeting, budget limitations, and ad extension coverage per campaign.
What's included
- Full account audit in a single script run
- 9-tab Google Sheet report with color-coded findings
- Executive Summary with issue counts and Quick Wins
- Search keywords: waste, low QS, dead keywords, duplicates
- Negative keyword conflict detection (campaign + ad group level)
- Search term waste analysis with negative keyword recommendations
- RSA ad strength, headline count, pinning, and ad group coverage
- PMax asset group audit against minimum and recommended counts
- Shopping feed: disapproved products, zero-impression items, waste
- Merchant Center issue listing per product
- Settings audit: auto-tagging, conversions, geo, networks, extensions
- Configurable lookback period, cost threshold, and QS threshold
- 100% free — no payment, no registration, no limits
Who is this for
Get the script
Copy the code and paste into Google Ads → Tools → Scripts
Frequently asked questions
How do I install this script?
Copy the script code from this page. In Google Ads, go to Tools & Settings > Bulk Actions > Scripts > New script. Paste the code, set your Google Sheet URL in the CONFIG section, authorize, and run.
Is this really free?
Yes, 100% free. No payment, no registration, no limits. Copy the code and use it in as many accounts as you want.
How long does the audit take to run?
Depends on account size. Small accounts finish in 1-2 minutes. Large accounts with 50,000+ products may take up to the Google Ads Scripts 30-minute limit.
What does the script check?
Everything: Search keywords (waste, QS, duplicates, negative conflicts), search terms, RSA ads, PMax asset groups, Shopping feed status and performance, conversion actions, campaign settings (networks, geo, budget, extensions), and auto-tagging.
Can I customize the thresholds?
Yes. The CONFIG section at the top lets you set the lookback period (default 90 days), cost threshold for flagging waste, Quality Score warning threshold, and row limits for large accounts.
Does it work for accounts without Shopping or PMax?
Yes. The script gracefully handles missing campaign types — if you only run Search campaigns, the Shopping and PMax tabs will simply be empty.
Can't find what you need?
We've spent 20+ years building companies, data pipelines, marketing systems, and reporting tools. If you have a specific challenge — reach out. We might already have a solution.
Free. No registration. No limits.
Related tools
Monthly Ads Monitor
Free Google Ads script that generates monthly performance trends with year-over-year comparison. Automatic dashboard with dynamic filtering and email reports.
Weekly Ads Monitor
Free Google Ads script that generates weekly performance trends with ISO week-based year-over-year comparison. Automatic dashboard with dynamic filtering and email reports.
Product Performance Tracker
Free Google Ads script that analyzes Shopping product performance with month-over-month comparison, category aggregation, deterministic insights, trend tracking, and email alerts.
Merchant Center Control Script
Monitor your Google Merchant Center product approval status. Get alerted when disapproval rates exceed your thresholds or product counts drop below minimum.