Optimize Bids By Weather Using AdWords Scripts
June 6, 2014
It’s that time of year… drums please, summer summertime!” The time of year when the sun is shinning one minute and the next minute, rain is ruining your summer BBQ plans. If you have a product or service that is directly affected by the weather, this post is for you! The AdWords bid by weather script is simple to set up and allows you to optimize bids automatically based on geo-location and weather forecasts.
What type of account would bid by weather scripts work well for, you ask? How about golf courses that may want to bid more on a sunny day and decrease bids on a rainy day. Or a company that sells snow blowers or umbrellas? Changing bids manually based on the weather can be very time consuming and nearly impossible. This, my friends, is where weather scripts come in and save the day!
How It Works
The script first references a Google spreadsheet that has the campaigns and geo locations. Then, the script calls to the OpenWeatherMapAPI where it references current weather conditions for the locations specified in the spreadsheet and some basic rules. If the rule evaluates to be true, then the bid multipliers are applied to the campaigns specified. An example of a rule could be > if it’s sunny, increase bids by 10% for Ann Arbor, Michigan. You will specify what is considered “sunny” on another tab in the Google spreadsheet, which I will cover in more detail later on in this post. First, we will cover the basics.
- Register for an API key at the http://openweathermap.org/appid. *Make a note of your API Key. You will need this for the script.
- Make a copy of the bid by weather template spreadsheet located here
- Make sure the geo-locations are set on the AdWords campaigns you plan to use – *The script will not change geo-location of the campaign or fire if the location does not match.
- Identify weather locations according the OpenWeatherMap API. The location entered must match what is listed on the OpenWeatherMap API http://openweathermap.org/help/city_list.txt
- Gather a list of AdWords geo target codes based on location. Here is the complete list of geo target codes.
Creating The Google Spreadsheet
If you have downloaded and renamed the template listed above, next you will need to fill out the data in the Google spreadsheet. The Google spreadsheet includes three tabs – Campaign, Weather Conditions, Geo targeting mapping. Make sure that you take the time to ensure everything matches correctly to the OpenWeatherMap cities and Google geo codes otherwise the script won’t fire.
The campaign tab you will need to fill out the following information:
- Campaign name: The name of the campaign to be modified.
- Weather location: The location for which weather conditions should be checked.
- Weather condition: The weather condition for which this rule should be applied.
- Bid modifier: The location bid modifier to be applied if the weather condition is met.
- Enabled: Specify [yes] to enable a rule and [no] to disable it.
As you can see in the image above, you will need to determine what is considered “Sunny”. For example: Sunny = Temperature between 65 to 80 degrees Fahrenheit, Precipitation below 1mm of rain in the last 3 hours and wind less than 5mph.
If you leave cell blank, the value of that cell is not considered for calculation and will look something like this:
On this tab you will need to define and map the weather locations that are defined on the campaign tab. If you’ve already pulled this data from step 3 & 4 listed above you can just plug right into the spreadsheet. The two columns you will need to input the data are listed below:
Weather Location – This is a weather location name, as understood by the OpenWeatherMap API. You can find this data here
Geo target code: This is a geo target code, as understood by AdWords scripts. You can refer to https://developers.google.com/adwords/api/docs/appendix/geotargeting for a list of supported geo target codes.
You may need to list multiple geo-target code for a specific weather location because the weather location targeting is not as granular as the AdWords targeting. See example below.
You can find a copy of the bid by weather script here. Place the script in your AdWords account under: Bulk operations > Scripts. You will need to have your open weather API Key code and the link to your Google spreadsheet as mentioned below.
The script will read rules from all three sheets in order. If the data matches, the rule is executed and the bid modifiers are made. No changes will be made if the weather conditions do not match.
You can set up in AdWords how often you would like the script to fire and even go back and see what changes were made.
The overall set-up will take a little time to make sure all the data is entered correctly but once it’s set up, the script should save a ton of time and help your ads become more efficient if they are affected by the weather. Are you currently using bid by weather scripts for your account? How have they worked for you?
Expanded Text Ads: 7 Million Clicks Say They’re Underperforming
Over the past 6 weeks, we have been lucky enough to experiment with expanded text ads, and frankly, I’m not impressed with their performance.
£300 Off Hero Conf London Ends Tomorrow!
Time is nearly gone to reserve your seat for Hero Conf London, 24-26 October at etc.venues St Paul’s, at a huge discount off the regular conference rate!
Expanded Text Ads Come To Google AdWords Editor
Advertisers have been able to create expanded text ads, but couldn't utilize AdWords Editor. That has now changed with the release of the latest version of AdWords Editor.
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
Bidding Farewell to Adwords Converted Clicks: Don't Panic
AdWords will soon be saying goodbye to the "Converted Clicks" metric. Learn more about what this means for your account and how to prepare for the transition.
Olympic PPC Ad Strategies
How spectators consume sporting events and a massive expansion in the digital space will prove to shake up who and how advertisers reach their audiences.
Hanapin's PPC Resources Are Now Ungated!
You can now access Hanapin's whitepapers and toolkits without having to fill out a form!
View Ad Creative Through The Eyes Of Your Searchers
Learn to understand that ads do not live in the vacuum of an excel sheet and common practices should be tested.
[New Webinar!] 11 Red Flags To Watch Out For When Working With An Agency
Leveraging Analytics For Remarketing: Picking The Ripest Fruit
Remarketing prevalence is well founded based on competitive returns in both volume and efficiency. With that said, this "low hanging fruit" world isn't always easy to pick.
How To Analyze Time-Of-Day Performance For Luxury Products
The importance of ad schedules varies across industries, services, and products. For e-commerce companies that sell luxury goods, ad schedules are more crucial.
One Week Left to Save 25% at Hero Conf London!
You still have time to join us for Hero Conf London, 24-26 October at etc.venues St Paul's at 25% off the conference price. But time is running out.
4 Common Questions Prospects Ask Me During The Sales Process
There’s always new, hot topics and questions we get asked by prospects to see what our company’s take is, and how we go about implementing from a services perspective. Read what our most common questions are.
Mobile Price Extensions Rolling Out In AdWords
It looks like "Christmas in July" has come to Google. Recently announced price extensions are designed to help mobile marketers qualify clicks and inform prospective consumers.