Weighted QS average per campaign experiment

Track how a Google Ads experiment impacts Quality Score for a single campaign over time.

This script monitors the average weighted Quality Score for one base campaign and its experiment campaigns. It weights by impressions so high-volume keywords count more than low-volume ones. By default it looks at the last 7 days, but you can switch it to the last 30 days or last business week.

Setup

1. Choose a base campaign name. The script automatically finds all related experiment campaigns whose names start with that same base name, so a clear naming convention is required: your experiment campaign name must include the original campaign name at the start, for example 1.2 search - nb - nike // 20230831 // more direct ad copy.
2. Provide the URL of a template spreadsheet. The script copies this template and sends the results to the copy.

What the script calculates

The script pulls keyword data from Google Ads and calculates:

• A weighted average Quality Score for each campaign in the date range
• A daily weighted Quality Score per campaign for each of the last 7 days

The sheet views

• Summary view (Sheet1): a compact log where each row shows today's date, the campaign name, the date range (for example LAST_7_DAYS) and the weighted average Quality Score.
• Daily view (Sheet2): a day-by-day overview where each row shows the date, the campaign name, and the daily weighted Quality Score.

This makes it easy to compare original vs. experiment campaigns on Quality Score, spot trends such as improving or declining scores over the last week and keep a daily history for reporting.

Tips

• Always start experiment campaign names with the exact same base name as the original campaign.
• Use a clear naming pattern that includes a date and what you changed, so you remember the test later.
• Run the script on a schedule to keep your Quality Score tracking up to date.