This AdWords Script generates a Google Sheet with a list of all the active keywords in your account that have a Quality Score lower than a predefined Quality Score. It also provides the option to pause these keywords.
This script provides other metrics like cost, impressions etc. for a given period of time to help you gauge the performance of keywords in your account prominently.
Example Use Cases
Get a list of keywords that fall below a certain quality score and optimize them
Do a regular clean up of your AdWords account by pausing keywords with very low Quality Scores
Settings and Customization
EMAILADDRESS: tells the script the email addresses that should get a notification when it finishes creating the spreadsheet. To send to multiple recipients, separate the email addresses with a comma. Do NOT include the name of the person... only include their email address.
QualityScore: defines the threshold Quality Score for the keywords to be identified.
Pause: To pause keywords with a lower quality score, change the value of the field Pause to true.
Date_Range: tells the script the date range to include in the calculation. E.g. 'LAST_30_DAYS'. You can also use the format 'YYYYMMDD,YYYYMMDD'.
Have you ever wanted a way to get more granular stats for AdWords than what's available from the AdWords website? Well then this AdWords automation script is for you... It saves stats for campaigns, ad groups and keywords you choose to a spreadsheet once per hour. It can even save the maximum CPC and the Quality Score, two elements whose historical values are not saved inside AdWords.
Example Use Cases
Keep track of attributes that the AdWords system does not provide historical data for. For example, use this script to record the Quality Score of your most important keywords every hour. AdWords does not store historical QS so the only way to get this data is to save it.
Understand the delivery curve for your ads so you can understand if most of your budget is spent at a particular time of the day. The next time your boss wants to know why the account spend seems low for the day, you can use this hourly data to make sure things are running as expected and show that spend always picks up later in the day.
Monitor your top 10 most important keywords more closely than the rest of your account by automatically putting their latest stats into a spreadsheet which you can then use to feed into a dashboard.
Under The Hood
This script runs once per hour and stores the daily stats for the selected items at that time. Because stats can be delayed and because the script may run at any time during the hour, you will see an hour-by-hour progression in the recorded stats but you will not see stats for specific hours. Usually scripts will run at the same time every hour so you might see stats for today through 8:23am on one line and then stats for today through 9:23am on the next line.
Because this script stores a lot of data in Google Spreadsheets, you should frequently create a new spreadsheet to make sure it doesn't reach its limits. For example, create a new spreadsheet weekly or biweekly depending on the amount of data you're collecting. This script can be adapted to automatically start a new spreadsheet on a predefined cycle but that requires storing the current spreadsheet URL somewhere (for example in a label or in another spreadsheet).
This script provides insight into elements of the AdWords Quality Score that are not available elsewhere in AdWords. It calculates an account weighted average quality score as well as weighted averages for each campaign and ad group. This can help you select which elements of an account to target for optimization. The account level quality score can also be used to measure the impact of the work you do in an account. You can email the daily quality score calculation to yourself to have a historical record of how your performance has changed.
Example Use Cases
Find the top spending campaigns whose quality scores are lower than the account average and target these for a relevance optimization
Store the account level quality score in a spreadsheet for historical charting
Email a notification to someone when the quality score of an account passes a threshold set by you