ABCDEFGHIJKLMNOPQRST
1
This spreadsheet provides data for the bid by weather settings scripts. To use this spreadsheet,

1. Make a copy of this spreadsheet.
2. Enter your geo locations on the Geo target mapping sheet. The first column is the name of the city as understood by openweathermap.org, the second column is the corresponding AdWords scripts geo code. See https://developers.google.com/adwords/api/docs/appendix/geotargeting for details.
3. Define your weather conditions on the Weather Condition tab. The first column is the name by which you want to refer to this weather condition (e.g. Sunny). The remaining rows are rules that define range of values for temperature, precipitation and wind. The rules can be of the form
a) below xxx (e.g. below 50)
b) above xxx (e.g. above 70)
c) xxx to yyy (e.g. 5 to 50, both inclusive)
4. Enter the campaigns for which you want to adjust bids. The first column is the campaign name, followed by Weather Location, Weather Condition and Bid Modifier.
5. Edit the script, and enter this spreadsheet's url in it.
6. Signup for an API key at openweathermap.org. Edit the script and enter the API key in it.
7. Run the script.

Note: The bid modifier will be applied only if there is a campaign that matches the name, all the weather conditions match and the campaign has a custom targeting for the specified geo location.


2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100