ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How it WorksLimitationsProduct Definitions
2
This spreadsheet only handles one campaign at a time. So there should be no more than one campaign in the 'Campaign' sheet.Text Banner creatives can only be created and edited via the Ads Manager UI. Existing Text Banner creatives will be displayed on the download sheet with partial data, but only delete operations are supported via bulk at this time.Audience: Targeting people based on locations they've visited
3
Ad groups should be entered in the 'Ad Groups' sheet. If you're creating a new ad group, the ID column should be blank and the same ad group name should be used across the other sheets. Duplicate names cannot be used.Existing lists (e.g. location filters, drive-to locations, etc.) cannot be appended to with bulk upload, only replaced entirely.Geotargeting: Targeting people in real-time, while they are withinin selected states, DMAs, cities, zip codes, or in radial fences around specific addresses or coordinates
4
If you're updating an ad group, be sure to leave the id columns unchanged, as removing the ids will result in the creation of new ad groups.HTML5 creatives can only be created and edited via the Ads Manager UI. Existing HTML5 creatives will be displayed on the download sheet with partial data, but only delete operations are supported via bulk at this time.
5
The budget information is split between the 'Ad Groups' sheet and the 'Time Period Budgets' sheet. High level details, such as bid price are on the 'Ad Groups' sheet, while flight schedule/time period schedules are handled on the 'Time Period Budgets' sheet.
6
If the upload is not successful, errors will be listed on the furthest column on the right side of each sheet. It will include details as to what processed successfully and what caused the error. Always double check the values in other cells when fixing errors to make sure everything processes as desired.
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