ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Authored by Nico Brooks, Two Octobers, LLC
2
A delightful blog post describing the use of this worksheet is located here: http://twooctobers.com/2015/09/replacing-adwords-editor-html-export/
3
The original version of this worksheet is located here: https://docs.google.com/spreadsheets/d/1Rbl-Us5Lw_ZudX_oBkryzuG5a-1cWHnaOh8YLpfjmlo
4
Google Chrome is recommended when using this tool. Firefox seems to work ok too.
5
6
Use at your own risk.
7
In Google Sheets, with the original version of this sheet open: select 'File > Make a copy' to create your own copy of the ad formatter ... this prevents you from overwriting someone else's work. Feel free to delete data from any tab after doing this.
8
In the worksheet there is an Ad Formatter menu at the top, to the right of Help. Select 'Clear all' to clear any existing data from the worksheet.
9
In AdWords Editor: select 'Account > Export > Export current view' from 'Ads and extensions > Expanded text ads - export as CSV'
10
Copy result to the 'ads csv' tab in this spreadsheet - don't rename this sheet
11
In AdWords Editor: select 'Account > Export > Export current view' from 'Keywords and targeting > Keywords - export as CSV' (this step is not necessary if you are only formatting ads)
12
Copy result to 'keywords csv' tab in this spreadsheet (this step is not necessary if you are only formatting ads) - don't rename this sheet
13
In the worksheet: select 'Ad Formatter > Format ads' to bring up the ad formatting dialog box. The dialog box has the follwing options:
14
 Export name - the name of the tab or worksheet to which ads will be exported
15
 Export keywords - set to 'No' if you only want to export ads
16
 Export ads - set to 'No' if you only want to export keywords
17
 Active status - if set to 'Active Only', only active ads and keywords in active ad groups and campaigns will be exported
18
 Create new worksheet - if set to 'Yes', the export will be written to a new worksheet in your Google My Drive folder. This is a useful option if you are planning on sharing the Google sheet directly with clients. If set to 'No', the export will be written to a tab with the name you specified in 'Export name'.
19
20
Several advantages to sharing with your client as a Google Sheet:
21
 You can collaborate with the client directly in the document
22
 Go to Tools > Notification rules to be notified when someone else changes the doc
23
 Go to File > See revision history to see what changes were made
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