Quality Score Dashboard
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
Overview
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.
Setup
- 1Open your Google Ads account and go to Tools → Bulk Actions → Scripts.
- 2Click the + button to create a new script and paste the code.
- 3Optionally set config.baseFolder to your preferred Google Drive folder name.
- 4Optionally set config.speadsheetUrl if reusing an existing dashboard spreadsheet.
- 5For MCC: set config.labelName to filter specific accounts, or leave blank for all.
- 6Adjust config.daysToTrack (default 28) for the statistics lookback window.
- 7Schedule the script to run daily.
- 8Preview the script once — it will create the dashboard spreadsheet in your Drive automatically, then save and enable.
Configuration Variables
| Variable | Default |
|---|---|
config.labelName | "" |
config.baseFolder | "Quality Score Dashboard" |
config.speadsheetUrl | "" |
config.trackOnlyEnabled | false |
config.trackOnlyGoogle |
Expected Output
Quality Score Dashboard v4.0 powered by SEA Safeguard The dashboard is here: https://docs.google.com/spreadsheets/d/...
Notes
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.