Home | Blog | Quality Score: Tracking the Mysterious Metric
As PPC advertisers, we’re well aware of what Quality Score means, but did you know you can track this mysterious metric in your account week after week, month after month? Did you know you can track it even down to the keyword level?
Before I dive into how to do so, let’s review Google’s definition of Quality Score: “An estimate of the quality of your ads, keywords, and landing pages. Higher quality ads can lead to lower prices and better ad positions,” which is exactly what we all are dying to have, right?! When I see 10/10 quality scores, I feel like I’ve slam-dunked the Google game. We want to pay as little as we can for a click because, let’s face it, we have real goals to hit. Not all of our clients are just able to hand over this without seeing concrete results.
So, add this cool tool to your PPC toolbox and start tracking Quality Scores in your accounts today!
Step 2: Navigate to Google Drive and add a new Google Sheet (screenshot below). At Visiture, we have an entire folder dedicated to Quality Score Trackers, so, if you’re an agency managing multiple accounts, you may want to consider creating a folder and adding your new sheet(s) to this folder.
Step 3: Go ahead and name your “untitled spreadsheet” something like: X-Account Quality Score Weekly. We’ll be creating 2 scripts: 1 for weekly tracking and 1 for monthly tracking, so it’s important you identify which is which.
Step 4: Open the AdWords account where you want to implement the quality score script, and click “Bulk Operations” on the left side panel. Next, click “Create and manage scripts.”
Step 5: Click the Add Script button. Go ahead and delete the default characters that appear in the script box so you’re starting with a blank slate.
Step 7: The date range for the script you copied from Free AdWords Scripts’ site is defaulted to “Last 30 Days,” which you will use for your monthly script you set up next. Since we’re working on the weekly script now, change line 29 var DATE_RANGE = from Last_30_DAYS to LAST_7_DAYS. You can copy the last 7 days text from line 26 or write it exactly as you see it below. Be sure you paste it directly between the quotations, like this:
Step 8: Copy the URL of the Google Sheet you created and paste it between the pair of quotation marks next to line 34 var SPREADSHEET_URL = like so:
Step 9: You must “Authorize” the script, which essentially means you are accepting Google’s terms & conditions. Once you do this, you can preview the script or jump straight into running the script. It is recommended to first preview the script and check for errors. Often you will be required to authorize it again, so continue authorizing until you’re no longer prompted to do so.
Step 10: After the preview has been completed and the script has run, re-order the tabs in your Google Sheet. Sheet1 always appears as the first tab in your document and is always left blank, so it makes sense to place this tab at the end of your sheet. I prefer to see the account-level data immediately when I open the document.
Step 11: The last and final step is to create a schedule for running your script. Back in the AdWords UI, you’ll see the option to create a schedule. For your weekly tracker, schedule it to run on Mondays (2nd screenshot). I chose a time early in the morning, but the time of day isn’t so important.
After you set up your monthly quality score tracker, be sure to schedule that one to run the 1st day of every month (3rd screenshot).
When you’ve completed setting up your weekly quality score script, you will repeat the entire process to set up your monthly script. You’re free to select whatever date ranges make sense for you and your account initiatives, but I recommend doing at least the weekly and monthly versions. And, voilà! Now you’ve got an automated script to track your quality scores!
I encourage you to explore Russ Savage’s other scripts found on his site. There are many helpful scripts that not only can help save you time managing your accounts, but which will give you insights into things you never have had before.
Share this article
Don’t Miss Our Next Article
Get the Visiture Newsletter
5000+ marketers are already subscribed.
Conversion Rate Optimization for Lead Generation Sites
August 15, 2019
Visiture Named to 2019 Inc. 5000 List for Third Year
August 14, 2019
Going Digital: How Brick-and-Mortar Retailers Can Set Up an Online Shop