The weather is an essential environmental factor. Mood, activities and our purchasing behaviour are significantly influenced. When it’s warm, we eat ice cream and wear T-shirts. If it is cold, we wear coats and drink hot drinks. This article shows how weather data can be used efficiently as an ad customizer to deliver individual speeches due to the weather in the user’s target region.

How can the weather be beneficial in Google Ads ads?

Google Ads already offers a number of options to target users individually. The weather is not part of it at the moment. This article shows how to build Ad Customizer, which offers the user an individual approach based on the weather conditions at the user’s whereabouts.

With the design shown, it is possible to address users based on the daily forecast with (weather name, wind speed, maximum temperature, minimum temperature) or the current weather conditions (weather name, temperature, wind). A practical side effect is the name of the city, which the ad customizations directly provide. Ad adjustments such as “Fast Delivery by ” are also {Nutzerstandort} possible.

Thus, in sunshine and 25C° the user can be delivered a different ad text than in 2C° and drizzle. This makes particular sense in the case of generic search queries, which does not make any inferences as to the exact search intend. In the end, the most attractive ad wins here.

Example:

Search term: bedcover 135×220

If, in a normal Google Ads ad group, you were to revise the ads every 3 months to have the right approach to the users, we have a different approach in all the target regions used, without further steps.

Ideas for slogans in ad customizer based on weather data

Product / Service	Ad Customizer
Jackets	Warm jackets for cold days. Weatherproof jackets on rainy days.Light jackets for summer days.Windproof jackets when it storms.
Food / Gastronomy	Delicious fruit schorlen on offer.Large selection of were drinks.Defty soups in the lunch table.Daily fresh fruit ice cream.
Duvets	cuddly, warm winter blankets year-round transitional blankets airy light summer blankets

I look forward to more ideas on weather data ad matching in the comments below the post.

Overview of the structure

1. Weather data Retrieves via Google Ads Script and the OpenweatherAPI (free plan) into a Google Spreadsheet.
2. Import the weather data from the script-filled spreadsheet into another spreadsheet. This makes it possible to use the data obtained in step 1 multiple times. This spreadsheet then contains the full ad customizer with the text adjustments for each campaign.
3. The ad customizer is added to the business data in the Google Account and an auto-retrieval connection is established.
4. Now Google Ads can be used with the new ad customizations.

Collecting weather data for Google Ad-Customizer

1. Download Google Ads Script for weather data.
2. Add the Google Ads Script to the Google Ads account (Tool > Scripts > + icon.
3. Adjust variables at the top of the script.
   1. OPEN_WEATHER_MAP_API_KEY: A corresponding API key must be entered here. The free key should be enough in most cases. Create an OpenWeatherApi key.
   2. SPREADSHEET_URL: Create a copy of this spreadsheet and store it in the script.
4. Preview Start press. Authorizations for Google Ads and Spreadsheets are queried. These must be confirmed.
5. Test execution. If the script works, the first lines of the sheet should now be filled.
6. If the execution works, then an hourly execution can be set. The weather data should then be renewed from 0:00 at night and should only be queried once a day.

The weather data table

The list, which now fills up with weather data, has deposited all postcodes of Germany, Austria and Switzerland in its original state. If you want to use other Target locations, that’s not a problem. These are in the sheet geotargets-2020-01-30 and can be updated at any time from here.

If you use a different type than the Target Location “Postal Code”, a small adjustment has to be made in the SEARCHMODE variable in the current version of the script.

Script options for different modes of operation

Variable	Description
DEBUG	writes relevant information for debugging in spreadsheets and the log
MODE	CURRENT: The current weather at the site is determined: The weather is determined over the current day in high and low values.
SEARCHMODE	ZIP: The postal code is used for search. (default) (use when the location table wird.NAME applied unchanged: It is used by name (value before the 1st comma of Taget Location).
LOCATION_UPDATE	Number of hours after weather data is outdated in Current Mode (default: 1h) (note api limits)
APILIMIT	Number of retrievals before a timeout
timeOutInSeconds	Number of seconds of timeout

Using Weather Data for Google Ads

In order to use the weather data from the first spreadsheet for several campaigns or statements, another spreadsheet is created in which the actual ad-customizers are created.

1. Copy Google Ads table.
2. Exchange URL in the Export cell A1 to the spreadsheet URL created in the first step. If the access works, the weather data collected so far should appear. From column L, the corresponding ad customizers can then be seen.
3. Go to the “Setup” sheet. Here you can set ad texts for different weather conditions using some parameters.

In the Setup table, temperatures can be changed and corresponding texts can be made for one ad adjustment text per condition. This is, of course, just one example, the sheet and its conditions can be changed at will.

Here is a look at the table:

Klicken Sie auf den unteren Button, um den Inhalt von docs.google.com zu laden.

Inhalt laden

Import weather data into Google Ads

The finished ad customizer can now be imported to Google Ads and then used in the ads.

1. Download the created, finished ad-customizer table in spreadsheets as csv (File > Download > Comma-separated Values)
2. Import the Ad-Customizer table into Google Business Data (Tools > Business Data > + icon). A short name_with_underdot is recommended.
3. Enter the Google table with the ad customizers in the upload plan so that the data is also updated. Attention! Be sure to add required authorizations.

Use Ad-Customizer with Weather Data in Google Ads

The ad customizer have only the Target Location as the targeting criterion as the demonstrated form. This means that all users who trigger this ad will receive ad customizations based on their current location, provided it is included in the ad customization data.

A new ad is created in the ad group where an ad customizer ad is to be created. If you tap the menu, a menu will automatically open in which “Ad adjustments” can be selected. The table that has just been created will then appear here.

Conclusion

With a few setup steps, it becomes possible to use Google Ads for free with weather data and thus make valuable improvements to you ad-copy.