Collects keyword Quality Score data (overall QS, expected CTR, ad relevance, landing page experience) with historical tracking, and generates a visual Google Sheets dashboard — supports both single and MCC accounts.
by Martin Roettgerding (Bloofusion Germany GmbH)·sea-safeguard.com/kostenlose-tools/qs-dashboard
Monitors your account for unexpected performance deviations by comparing today's stats against historical averages for the same weekday. Sends an alert email when impressions, clicks, conversions, or cost deviate beyond configurable thresholds.
One 0-100 score for the whole account, built from seven objective checks — tracking flatlines, disapprovals, serving status, budget losses, negative coverage and query hygiene — with the deduction breakdown as your fix list.
Finds the structural gaps that stop ad groups from serving: ad groups without active ads, without an RSA, without keywords, keyword-stuffed themes, and multi-RSA ad groups.
Generates a daily at-a-glance performance overview of your entire Google Ads account. Writes prior-day stats to a Google Sheet with running history and optionally emails a formatted comparison of yesterday vs. two days ago vs. one week ago.
Generates a Google Spreadsheet with ad performance stats segmented by headline and final URL, including distribution charts. Covers all ad types and optionally emails the report link weekly.
Maps every campaign's ad schedule and flags forgotten narrow serving windows, stale schedule bid modifiers that Smart Bidding ignores, and (optionally) campaigns running 24/7.
Quality Score Dashboard tracks keyword-level Quality Score components across your account or MCC, storing current and historical data in a Google Sheets dashboard with charts. Run it daily to build a QS trend over time — useful for monitoring optimization impact and identifying keywords that need attention.
| Variable | Default |
|---|---|
config.labelName | "" |
config.baseFolder | "Quality Score Dashboard" |
config.speadsheetUrl | "" |
config.trackOnlyEnabled | false |
config.trackOnlyGoogle | true |
config.daysToTrack | 28 |
Quality Score Dashboard v4.0 powered by SEA Safeguard The dashboard is here: https://docs.google.com/spreadsheets/d/...
The script automatically creates a Google Sheets dashboard with charts on first run. It supports both single accounts and MCC accounts (parallel processing up to 50 accounts, then sequential). Quality Score history is tracked monthly for trend analysis over the past 12 months. The dashboard template is copied from a base spreadsheet maintained by the author.