Advertising
Track your Quality Score history with a free Google Ads script
Copy for AI
The Quality Score in Google Ads is a snapshot.
You open the interface, see a 6 next to a keyword, and that’s the state right now. What it was yesterday, last week or before your latest ad copy change isn’t in that column.
The verdict: a quality score history script fixes that for free. It logs a daily snapshot per keyword in a Google Sheet, so every change gets judged on its effect.
Without history you can’t see cause and effect. You adjust something, the score moves, and you don’t know whether your change did it.
This is a deep dive alongside our pillar on what SEA is.
New to the basics? First read what the Quality Score actually measures, because the rest of this article assumes you know the three components.
One rule runs through it all: log the components, not just the number.
Why doesn’t Google keep the history you need?
Because Google Ads treats Quality Score as a live signal, not as a report card.
The score reflects recent performance on three components: expected click-through rate, ad relevance and landing page experience.
What Google’s help says about the score
Google’s Quality Score help page sets out the basics:
- Scale: 1 to 10, at keyword level
- Ratings: each component is Above average, Average or Below average
- Benchmark: compared with advertisers whose ads showed for the same search over the last 90 days
- Auction: “Quality Score is not an input in the ad auction”
So the number is a diagnostic tool. It isn’t the thing Google ranks you on directly.
Need the short definition first? Our Quality Score wiki entry has it.
The historical columns, and why they’re not enough
The standard column only shows the current state.
Google does offer historical columns such as Quality Score (hist.), Exp. CTR (hist.) and Landing Page Exper. (hist.). The same help page says “You can view the change in daily scores by segmenting your table by day.”
That’s a useful first check. But it lives in the keywords table, one view at a time, without your notes or your lead data beside it.
Our view: use the (hist.) columns for a quick look, and your own log for decisions.
The column picker looks like this:
Why the history matters to you
For the algorithm, the current estimate is enough. For you as an advertiser, the history is what counts.
For example, you want to know whether restructuring an ad group lifted relevance. Or whether a new landing page pushed the score down.
At best you remember that a score “used to be higher”. That’s a feeling, not a measurement.
The fix is simple in principle: record the score yourself every day.
Do it long enough and you build the timeline that turns a hunch into evidence.
What does a Google Ads script do for you?
It reads every active keyword’s score each day and writes it to a Sheet with the date.
Google Ads scripts are pieces of JavaScript you run directly in your account. They can read your campaign data and write it to a Google Sheet.
Our guide to Google Ads scripts covers what else they can automate.
How the log grows
Every day the script loops through your active keywords. It reads the Quality Score and the three components per keyword, then adds a row with the date attached.
The timeline builds up fast:
- After a week: seven data points per keyword
- After a month: visible trends
- After a quarter: the effect of every structural change you made
The setup, step by step
Five steps get the script running:
- Create an empty Google Sheet and copy its URL.
- In Google Ads, go to Tools, then Bulk actions, then Scripts.
- Create a new script and paste the code that pulls the score and components per keyword and writes them to the Sheet, with the date as the first column.
- Authorise the script to talk to your account and your Sheet.
- Set a daily schedule so it runs automatically.
Step 2 brings you to the scripts overview:
Where to find the code
You’ll find the exact code in the official Google Ads scripts documentation, which has examples for reading keyword statistics.
The key part: per keyword, log not only the number but the three components as separate columns too. Without that context the number tells you very little.
How often it can run
Google’s scripts getting started guide says you can schedule runs “hourly, daily, weekly, monthly, or on demand”.
Daily is the right rhythm for this log. Quality Score doesn’t need hourly snapshots.
What your Sheet should look like
A clean log has one row per keyword per day. For example, two rows for the same keyword could look like this:
| Date | Campaign | Keyword | QS | Exp. CTR | Ad relevance | Landing page | Notes |
|---|---|---|---|---|---|---|---|
| 2026-05-11 | Search BE | crm software sme | 7 | Average | Average | Average | |
| 2026-05-12 | Search BE | crm software sme | 4 | Average | Average | Below average | new landing page live |
The notes column is what makes the second row readable at a glance.
Practical points before you start
A few choices keep the log usable:
- Only keywords with traffic: keywords that never serve have no reliable score
- A fixed date format: so you can filter and chart later
- One tab per month or campaign: a Sheet on a large account gets heavy
Watch out: a script can run for at most 30 minutes on an advertiser account, per Google’s scripts limits. On a very large account, log per campaign or limit the log to keywords with traffic.
The script itself runs within the free limits of Google Ads, so there are no costs attached.
Why do you log the components separately?
Because the number tells you something is wrong, and the components tell you what.
A worked example
Say a keyword’s score drops from 7 to 4 in three weeks.
The number alone says something is going wrong, but not what. Log the components separately and you see it straight away:
- Expected CTR collapsed, ad relevance stayed Average: something happened to your ad or your keyword match
- Landing page experience fell to Below average on the day a new page went live: you know where to look
Here’s that diagnosis as one picture:
From vague to precise
That separation is the whole point.
The score from 1 to 10 summarises three signals, and a summary hides where the problem sits.
Track each component over time and a vague “the score is dropping” becomes “landing page experience broke on 12 May”. That’s the difference between guessing and fixing with precision.
To understand how the three interact, read how the Quality Score components work together. For each one on its own, see ad relevance and landing page experience.
When the score shows ”—”
A dash in the column isn’t an error.
Google says it means there aren’t enough searches that exactly match your keyword. Log it as empty, not as zero, or your averages will lie.
Score dropped for real? Our checklist for when your Quality Score dropped walks through the usual causes.
For a low score that never moves, see low Quality Score.
Why do snapshots only become valuable when tied to pipeline?
Because a higher score only matters when it lowers your cost per qualified enquiry.
Here’s the pitfall. A daily log of Quality Scores is nice, but the number isn’t a goal in itself.
You can chase a 10 on a keyword that never produces a sales conversation. Then you’ve spent your time on a vanity number.
Put the trend next to your conversions
Your snapshot Sheet shouldn’t stand alone. Put the trend next to your conversion data.
Two readings decide what you do:
- Score drops, cost per qualified lead stays flat: probably not worth an alarm
- Score rises after you split an ad group, cost per enquiry falls too: a real improvement to repeat elsewhere
That’s how your log becomes a steering instrument instead of a pile of numbers.
Make sure the conversion is the right one
That only works if Google Ads counts real enquiries.
In our own account, the contact form is the primary conversion action:
The contact form conversion action in our own Google Ads account, October 2026. It’s set as primary, so campaigns optimise on real enquiries.
Our guide to primary vs secondary conversions explains that choice.
Where many accounts get stuck
Many accounts measure the score but never connect it to what happens after the click.
A manager account view shows the gap well. CTR can look fine while conversions stay at zero:
Our own manager account (MCC) in Google Ads, October 2026. Client names and IDs are replaced. Compare the CTR column with the conversions column.
If you want to dig deeper than isolated snapshots and review your whole account in one go, the Quality Score audit with a 12-point check helps you find structural problems instead of plastering over symptoms.
When is a script no longer enough?
When you have the trends and the breaking points, and the real fixing has to start.
A daily script is an excellent starting point, but it has limits. It tells you what’s happening, not always why, and it fixes nothing.
The work that follows the log
Once you see the breaking points, four jobs remain:
- straighten out the account structure
- tighten the keyword-to-ad match
- make landing pages match intent
- get conversion measurement right, so you know which budget produces pipeline
That last job often means offline conversions in Google Ads, so deals flow back into the account.
What that looked like for Facilicom
For Facilicom, many ad groups had a low Quality Score, so they paid a premium for the same clicks.
Splitting ad groups, sharper keywords and better landing pages led to 25% media savings.
When to bring in a partner
That’s where it pays off to outsource your Google Ads to a partner who ties the snapshots to your sales data.
At Google Ads outsourcing we don’t look at the score as a final grade. We look at what it means for your acquisition: is your account steering on clicks and ROAS vanity, or on qualified enquiries and deals?
A script gives you the history. The interpretation and the intervention make the difference.
For us, SEA is the fast acquisition layer of one orchestrated growth machine, with offline conversions and lead-to-deal attribution underneath it.
A Quality Score log fits in there as an early warning signal, not as a goal.
How do you get started?
Start small: set up the script today and let it run for a week.
You don’t need a perfect dataset to begin. What you mostly need is the habit of recording every day what the standard column doesn’t keep.
A month from now you’ll have a timeline that lets you judge every change on its effect.
Add a notes column from day one
Write down each day what you adjusted, such as new ad copy, a split ad group or a revised landing page.
Then the cause sits next to the effect. You won’t have to puzzle later over why a score moved on exactly that date.
Google Ads keeps its own record of edits too. Our guide to the Google Ads change history shows how to cross-check your notes against it.
More free helpers
The script sits well next to the other free Google Ads tools, such as Keyword Planner and Microsoft Clarity.
Stuck on the setup, or want us to put your snapshot data next to your conversions? Get in touch and we’ll look together at where your account loses value and what fixing it is worth.
Free website scan
Enter your website and get an automatic scan within minutes, with concrete technical and SEO improvements. No sales pitch.
We only use your details for your scan. No spam, unsubscribe anytime.