Wouldn’t it be great if you could choose how much you pay to place each ad depending on the weather?
For example, imagine you are the head of marketing of an amusement park. How likely is anyone to visit your park if it is going to be windy and raining?
And how much more likely are they to go if they know it is going to be sunny and warm?
Just imagine if you could adjust your rates to bid to pay most when the advertisement is going to have the highest positive impact and likely client conversions, and least when the odds are against you for reasons out of your control…
Well – now you can! With the new Bid by Weather app in Ads scripts you can adjust how much you want to bid to place your ad depending on the weather forecast for your geographical area.
Bid by Weather in a Nutshell…
This app takes the time-consuming and tedious drudgery out of adjusting your ad bids on a daily, manual basis. Now in just a few minutes you can use Google Spreadsheets to program your localized campaigns to self correct according to weather forecast data, with your bids per ad being increased or decreased depending on the parameters you choose to pre-set.
Google Spreadsheets automatically contacts the OpenWeatherMap API for each of your pre-selected locations and gathers expected weather conditions. The app then evaluates this information and uses basic rules to decide which bid multiplier (up or down) should be applied for each campaign at each location, depending on what the weather is predicted to do.
There are three separate spreadsheets on which information is collected:
Spreadsheet 1: General ad campaign data
First you need to pre-select the set of rules and which bid modifiers you want to apply according to a pre-determined set of parameters. The deciding factor on whether each specific rule will be applied will be the weather conditions for each selected location.
You need to provide date for the following columns:
Name of campaign: The name of the campaign to be modified.
Geographical location: The area where you want the weather conditions to be taken into account prior to placing your bid.
Weather conditions: What specific weather conditions are going to decide if this bid is applied or not?
Bid modifier: If the weather performs as you anticipated above, what type of bid modifier do you want to apply?
Enabled or disabled: Enter yes if you want to enable this rule or no if you want it to be disabled.
The rules that will be applied from the sheet above are:
If it is sunny, to modify the bid for Test Campaign 1 by a factor of 1.3 for the New York area.
If it is rainy, to modify the bid for Test Campaign 2 by a factor of 0.8 for the New York area.
The rule only works if you have already pre-specified in which geographical area you want to search for weather conditions data (in other words, decide on your geographical areas first for each campaign).
Be aware that if you set up multiple choice rules for each campaign and geographical location, the last programmed rule that matches will be the one selected. This is important because the OpenWeatherMap API data is constantly updated as weather conditions change, which can affect how your ad bids are played out in real time.
Spreadsheet 2: Weather Conditions data
On this spreadsheet you will define the type of weather conditions that will decide if the rule is implemented or not. There are four columns, namely:
Condition Name: What kind of weather condition are you looking for?
Temperature: Specify the range of temperature you require in Fahrenheit.
Precipitation: Specify the amount in millimeters of rain to have fallen in the last 3 hours.
Wind: What is the range of wind-speed in miles per hour for which the rule will be applied?
As you can see on the spreadsheet above, for one specific campaign two different sets of weather condition parameters have been pre-programmed:
Weather is sunny with the temperature measuring 65-80°F, less than 1 millimeter of rainfall in the last three hours and the wind speed is less than 5 miles per hour.
Weather is rainy with more than 0 millimeters of rain falling in the last 3 hours and a wind-speed of less than 10 miles per hour.
Important details: You can define weather condition as being:
Specific values less than x (for example, below 5)
Specific values more than x (for example, above 5)
A range of values between x and y (for example, 70-80)
Leave the cell blank if you don’t want to include that parameter in the rule
Please note that all the parameters are considered together to calculate the specific weather condition. So, for example, the Sunny condition shown above is evaluated as:
var isSunny = (temperature >= 65 && temperature <= 80) && (precipitation < 1) && (wind < 5);
Spreadsheet 3: Weather location data
This spreadsheet defines which weather locations you use in your Campaign data (see Spreadsheet 1). There are just 2 columns:
For each selected weather location Ads scripts allow you to specify more than one geo-target code. This is because Ads allows for smaller geographical areas than OpenWeatherMap API so you may have to enter more than one geo-target code to cover all of your desired geographical area. Write each geo-target code on a separate line with the same weather location name, as seen in the example below:
As you can see above, this spreadsheet is specifying 2 weather locations which cover one area of Boston (geo target code 10108127) and two areas in New York (geo target codes 21167 and 20050).
Google Spreadsheets Script logic
Google Spreadsheet scripts begins by reading all the rules off the three spreadsheets and then tries to execute each of them in sequence.
So, for each rule it:
Checks to see if the specific campaign has a weather location.
If it does target a weather location, the script then looks for the bid modifier data.
Then script contacts OpenWeatherMap API to verify if the actual weather conditions in the specified location coincide with those specified.
When there is not a match, the previous bid modifier holds good.
When there is a match, the selected bid modifiers are applied until the weather conditions change.
When the weather conditions change, the script automatically applies the new bid modifier that matches the actual conditions in that location.
If your campaign does not specify the weather location your bid will remain constant and will not be affected by the OpenWeatherMap data.
I did my research because I know a lot of SEO companies exist and wanted to choose the right one for me. Wisdek's reviews on BBB were good and they explained themselves quite well in my opinion. I approached them for a website design and online marketing program. They took the time to understand everything that I wanted to include in my website and made recommendations even before I signed with them to ensure everything was user friendly and also stayed within Google's guidelines. Next, they treated me with respect and advised us of how long it would take to get ourselves noticed online. All reports are delivered on time and everything is explained to us monthly. Due to their efforts I have been able to gain more clients and people to my website so If you are looking for a company that will simplify the Website and online marketing process to you and show you realistic results at a good price, Wisdek is the way to go.
We started working with Wisdek in June of 2016. We have approached them with an idea that shortly became our core business. They developed our website within one month. We were very happy with the process and communications. We just opened our store location and Wisdek's technicians helped us set up email, hosting and Google maps. We are very excited to start our search engine optimization campaign and grow our business nationwide.
My experiences with Wisdek SEO has exceeded my expectations with the impressive scope of the program. Like many business owners, we find it difficult to stay on top of many of the changes and updates on the SEO industry to stay ahead. We have to rely on experts like Wisdek to do all of the research required to keep up to date with the internet visibility needed to support my business. I look forward to the upgrade, and I look forward to a continued partnership with Wisdek.
We've asked Wisdek to develop our new site and we were quite happy how this project turned out. We've got ourselves involved further with Wisdek by expanded into SEO. They've helped us grow our business locally during first three month and thereafter globally. We still work with Wisdek on daily basis.
We've worked with Wisdek right from the beginning to develop and launch our SEO equipped website. We've grown tremendously on account of their SEO and funnel optimization services. Thanks to Wisdek we were able to take our initial steps onto the market in a quick, safe and inexpensive way. We made the decision to jump in with both feet an utilize almost every unique service that they offer and we're glad we did. Today we have over 1 million clients that are getting organized, getting promoted and getting paid using our application.
I’ve been with Wisdek for over 2 years now and I am very pleased with their service. What was promised, was delivered. About 3 months after I started I began to enjoy good rankings across Google, Yahoo and Bing. Also, the cost was not unreasonable! Wisdek’s service delivers more leads than posting an add in an old fashioned printed directory and is more affordable than print listings were 5 years ago!
Today I have expanded my services with Wisdek from my beginnings in SEO, to PPC and Content Network Advertising. The return on investment has been incredible. I truly believe Wisdek offers their clients cutting edge marketing services and puts businesses where people are searching. I would like to recommend Wisdek to anyone who needs consistent leads for their business.
Northgate Chiropractic & Massage Therapy Centre in Calgary has used Web based advertising and marketing since 2004. As a result of continual investment and effort, our web site always came up first in local searches. The payoff came 3 years ago when people really began to use search as a way of finding our services. Last fall, our internet traffic slowed considerably and we noted that our search listing had dropped from first on page one to the middle of page four, literally making us disappear.
One of our service providers, Eran Hurvitz of Wisdek, explained to us that Google had changed their rules for search and were imposing a penalty on our web site for having back links. (The very thing they promoted previously as improving our web site standing). This penalty resulted in our listing being dropped to page four. There were thousands of these links and it looked like a significant job to remove these links. Eran offered the services of Wisdek to clean up these links and petition Google to remove this penalty. It was initially estimated to take 3 to 6 months to complete this task. To our great pleasure, Wisdek achieved the penalty removal in just over one month. We are now back on top for our local area and are very pleased with Wisdek’s service.
I would strongly recommend Wisdek and for web based service.
Wisdek has provided me with a service I need to make my business grow. It has saved me a substantial amount of time by outsourcing and has allowed me to generate more revenue and build more customer relationships.
My clients are international, there is no better way to reach them than online!
Tony & Bruna Cooper
Our Firearm Safety Training business did not exist before we started working with Business Media and Wisdek. Business Media built us a beautiful SEO-Ready website from scratch that is now pulling in leads left right and center. Wisdek applied their most affordable SEO package for local coverage, and it was so effective that we started to rank all across the PROVINCE!
Business is so good that the phones are now ringing daily. We are happy to report that we will be opening a second location as well as a massive firing range in the next few months to capitalize on the overflow. We are actually going to upgrade our campaign with Wisdek to push our business even harder!!
Tony and Bruna Cooper