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
It's Back! The Golden Ticket Contest Returns for Hero Conf Austin!
That's right, your chance to win one of three FREE tickets to Hero Conf Austin, our annual all-PPC conference, begins on Tuesday!
From Last Click To Position-Based: An Attribution Test
Get an overview of Google’s attribution, what led us to consider testing a different attribution, what changes you can expect, our results, and advice for future tests.
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
New Sessions. New Networking. An All New Experience.
When we get feedback on ways to make Hero Conf more relevant, more actionable, and more meaningful, we take it pretty seriously. It's our most powerful tool in creating an event we believe helps our industry thrive. And we've used that information to build our...
Why Digital Marketing: Traditions Aren’t Always the Best
Explore how digital marketing can take your business goals to the next level and start expanding into new markets.
PPC Budgets: Pass Go into 2018 and Collect Optimal ROI
In this webinar, Shape CEO Jon Davis and Hanapin Director of Services Jeff Baum will share their expert advice about how you can perfect your 2018 budget strategy to achieve optimal ROI in the new year.