Quality Score Dashboard

Name: Quality Score Dashboard
Author: Martin Roettgerding (Bloofusion Germany GmbH)

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.

quality-score

dashboard

keywords

mcc

spreadsheet

reporting

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 & Settings → 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.
6

Ready to Use This Script?

Configuration Variables

Variable	Default	Description
`config.labelName`	""	MCC label to filter accounts (blank = all accounts).
`config.baseFolder`	"Quality Score Dashboard"	Google Drive folder for the dashboard spreadsheet.
`config.speadsheetUrl`	""	URL of existing spreadsheet to reuse (leave blank to auto-create).
`config.trackOnlyEnabled`	false	Only track enabled keywords in enabled ad groups/campaigns.
`config.trackOnlyGoogle`	true	Exclude search partner data from statistics.
`config.daysToTrack`	28	Number of days for statistics lookback (does not affect QS history chart).

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.