How It Works

Google Ads doesn't keep a history of Quality Scores, meaning once they change, the old data is lost. This script solves that problem by logging your scores every single day into a Google Sheet.

Historical Tracking

The script reads your existing list of keywords from the sheet. It then queries Google Ads for the current Quality Score of each keyword and appends a new column with today's date, creating a permanent day-by-day record.

Intelligent Cleanup

To ensure accurate matching, the script automatically cleans your keyword text by removing match type symbols (like brackets [ ] or quotes " ") before querying the API.