Advanced Quality Score Tracker by Clicteq - Updated to use GAQL Google Ads Script
Here is an updated version of the Advanced Quality Score Tracker by Clicteq Google Ads script, rebuilt from the ground up to take advantage of GAQL (Google Ads Query Language).
The original script was designed to pull keyword-level Quality Score data directly into Google Sheets, giving PPC managers a clear view of how Quality Scores change over time and which campaigns need optimisation. With Google’s migration towards GAQL for reporting, we’ve modernised the script to fix broken parts of the script and ensure continued reliability, faster execution, and better flexibility for future updates.
What’s New in the GAQL Version?
- Faster Data Retrieval - GAQL queries are more efficient, meaning the script runs quicker, even for accounts with thousands of keywords.
- More Accurate Data - Direct integration with the latest Ads API fields ensures the Quality Score, Expected CTR, Ad Relevance, and Landing Page Experience data is pulled exactly as reported by Google Ads.
- Future-Proof - As Google continues to retire legacy reporting methods, this GAQL-based approach ensures compatibility going forward.
Why Track Quality Score?
Quality Score isn’t just a number it’s a key driver of ad rank and cost efficiency. By monitoring changes over time, you can spot:
- Keywords with declining relevance.
- Landing pages that may be impacting user experience.
- Opportunities to improve ad copy and CTR.
How It Works
- The script queries your account using GAQL to fetch keyword Quality Score metrics.
- Data is automatically appended to a Google Sheet each day.
Example Outputs:
