Automating Bidding with Google Sheets and AdWords Scripts
January 8, 2018
Bid changes are vital in steering your account towards performance goals. While the process is important, making the changes and implementing them adds little value.
In this article, we’ll cover setting up an automated bidding system using both Google Sheets and AdWords scripts. Specifically, we’ll utilize the bulk upload functionality to format and post the changes directly to AdWords.
You may ask, “why would I need this?”, can’t I use the editor? Bulk Upload allows you to directly upload files to AdWords. This means you can outline your workflow/decision making inside a spreadsheet and use a script to handle the implementation portion. The code is straightforward too. you don’t need to understand much in terms of programming to get it up and running!
In this article, we’ll walk through a use case and show how we set up the sheet, the script, and how we handle scheduling.
We want to make bid changes on a weekly basis. We are currently using a spreadsheet template to take a dataset and make bid suggestions. We then take those changes, format them, and upload them to the editor and post the file to AdWords.
While there is value in the determining the bid rules, there is no value in manually uploading them time after time. Not to mention interrupting your day or someone else’s day to push routine changes live isn’t very considerate. If that doesn’t convince you, we can be more dramatic and say rote, meaningless tasks are making the world a worse place. Be a better person this year!
At a high level our process is,
- Get data to the sheet
- Manipulate data to create new bids
- Format results for upload
Getting & Manipulating Data
To make the most of this method, you should either use a script or use a tool like SuperMetrics to export the data to Google Sheets. This keeps you from copy and pasting data into your bidding template.
If you need inspiration check out the reporting functionality in AdWords Scripts. It’s easy to use, free, and is a simple query rather than any intense code.
If you are allergic to all code, Fred Valleys has a solution in This Script Adds Any AdWords Data To a Google Spreadsheet. It adds a spreadsheet front end to the reporting script making is more accessible than ever.
Now that you have the data, you need to create any necessary formulas. This will vary based on your needs but we have a few posts on the topic below.
Format Results for Upload
Depending on how you handled the gathering and manipulation of your keyword data you could skip this step and build a script around the data manipulation sheets but I recommend you don’t.
Creating a new sheet for the upload is cleaner and easier to reference. As a result any future troubleshooting is much easier.
By separating your data pull, manipulation, and final output you can isolate each set of processes in the event something goes wrong and you won’t accidentally break the functionality of multiple parts with a single change.
There are a few ways to do this but one clear winner, the query() function. We can write a single query to select certain columns and certain conditions.
It does not get any easier than that! If you are primarily an Excel user or unfamiliar with query() check out the post and be converted! Since we are talking about scripts, conveniently ignore the name of the site.
Setting up the Bulk Upload
The bulkUpload functionality is straightforward. We initialize the upload file, define the column headers, move through the rows to append the data. Once the file it built we push it to AdWords.
There is an optional preview mode as well. If you include the setting, the changes will stay pending until you approve them in AdWords. This can be helpful for the first few runs and you can turn it off once everything works as intended.
Once this is in place set up any scheduling you need. If you are pulling the data via a script schedule it before so the data is ready.
As a side note, AdWords scripts are queued up within the scheduled hour. If you schedule the data pull and the upload within the same hour you could run into an issue if the data pull ends up occurring after the upload script runs.
Extending The Tool
Seeing as many PPC practitioners are spreadsheet enthusiasts, this bidding system can go a long way. The formulas can nest to your hearts desire, you could import external data, you could implement some top-level controls and switches to modify the output.
You can import from the conversion types report and make adjustments based on multiple conversion types. Since you already have the data you can create summary sheets as well to monitor changes and highlight portions of the account.
Extending the Use Case
You can adapt the bulk upload script for any type of upload too! You could use it for SQRs, changing ad groups statues, adding labels, or controlling budgets.
The only change you’d need to the script is changing the column headers. You can find a list of them in bulkupload entities, or download a template from AdWords.
Give the example script a shot with your own data sets. At the very least you’ll save a little time and make your routine account changes more consistent!
Browse By Category
Take the 2018 State of PPC Survey!
We're looking for marketers to take our State of PPC survey! The survey takes about 5 minutes to complete and establishes benchmarks, identify trends, and helps marketers around the world understand what's working and what's not in PPC.
How To Avoid Overlap Between Multiple Similar PPC Accounts
Get tips on how to avoid overlap between multiple similar PPC accounts and start becoming more effective at running ads for multiple or related brands.
Why You Should Utilize a Facebook Catalog For Vehicle Sales
Set yourself up for future success by building a vehicle catalog on Facebook. From remarketing to prospecting, get your inventory in front of buyers and automate the process of ad creation.
A bi-weekly newsletter packed full of resources and strategies that will help make you a better PPC expert.
Hanapin Marketing | The PPC Agency of Experts Behind PPC Hero
Amazon Launches Seller Central Sponsored Products Dashboard
Amazon has released a new dashboard feature for the Seller Central marketing platform. Found in the Seller Central campaign manager, the dashboard makes it easier than ever to visualize your campaign data and take away valuable insights from your Amazon marketing account.
Boost Social App Campaign CPIs During High Peaks of Seasonality
Understand when it can become cost-effective to shift budget dollars to social app campaigns during periods of peak interest.
How To Use AdWords Geographic Data Reports
AdWords geographic reports provide performance data by location. This data is vital to identifying efficiencies and growth opportunities. In this article we will cover the three main rebuilt reports in AdWords and cover their uses.