AdWords Editor is a free downloadable application to manage your AdWords campaign. You can make bulk changes by importing all of the account data and then uploading the campaigns back into the account for the changes to take effect. Here you can even work offline and make changes. When you go online you can upload the same. You can download the AdWords Editor for Mac or Windows from here: Google AdWords Editor.
Upon opening the application you will see the above shown interface. To add an account you need to click on Add, as shown in the screenshot above.
Next a dialogue box will appear where you have to sign in with your AdWords account.
In the next dialogue box, you can either download all the campaigns or choose which ones to download.
Upon clicking the Open button you can see all of the campaigns. You can also click on Ad groups on the left hand side and see all of the Ad groups that are on that account. You can even see the keywords and ads by clicking on them on the left sidebar.
Now let's make some sheets from where we can upload the data by copying it into the Editor.
This is a campaign sheet where you have to include the Campaign name, Budget, Status and Campaign type. Make sure you use the same column names, otherwise Editor won’t pick it up. Copy this to your clipboard.
Now select Campaigns on the left side bar and then click on Make Multiple Changes.
As you click on Make Multiple Changes, a new dialogue box will appear wherein you have to put the excel sheet data. I hope you already have copied the campaign sheet. Now click on Paste from Clipboard button and wait for the data to populate. Look over the data, and if everything looks good, then click Process.
Here in this dialogue box you have to review the data that you have imported. Take a look at the number of campaigns you have made and the number of campaigns that are processed. If they are same, then just hit the Finish and Review changes button.
On the next screen, you would see the changes that you have made in highlighted in green. Analyze everything and then click on the Keep button that is at the top.
You have now created the campaigns in much less time when compared to making campaigns manually on the AdWords Interface.
This is the AdGroup sheet which contains three columns. These are Campaign, Ad Group and Max CPC. If there are 5 Ad Groups in a single campaign then write that campaign 5 times under Campaign and all 5 different Ad Groups against the campaign rows. You can put in the Max CPC as you wish. Copy the sheet.
Now click on Ad Groups on the left sidebar and then click on Make Multiple changes.
Do not forget to click on the radio button that says “My data includes columns for campaigns and/or ad groups” on the upper left corner. If you don't check this radio button, then the process results might be drastic. Paste all of the data by clicking the “Paste from clipboard” button. Finally, click on Process.
We have now inserted all of the campaigns and their Ad Groups in Editor. Now we have to add keywords.
I have taken a new topic for the keyword sheet just to show you that only the keyword sheet can be used to load the campaigns, Ad Groups and Keywords all at one time. You just have to add all the columns that we have discussed above into one sheet, copy it and put it in Editor (discussed in the next step). Do make sure that there are no duplicate columns. You can consider Campaign, Ad Group, Keywords, Match Type, Max CPC, Campaign Status and Columns.
As you can see in the screenshot above, we have included all of the columns so that we don't have to create the Ad Group and Campaign sheets. However, it is recommended to make a Campaign sheet as we cannot include the Campaign budget and Campaign type column in this sheet. You can find this sheet here for your reference: https://docs.google.com/spreadsheets/d/1Sgm8np39dCLptf0ObqgGaoHwee7nwEptpxCPKKVTZXs/edit?usp=sharing
To import this sheet on Editor you have to click on Keywords on the left sidebar and then on the Make Multiple Changes button on the top.
Do not forget to click on the radio button that says “My data includes columns for campaigns and/or ad groups” on the upper left corner. If you don't check this radio button, then the process results might be drastic. Then paste all the data by clicking on the paste from clipboard button. Lastly, click on Process.
After reviewing the changes, Keep them if everything is okay or select Revert if something wrong has happened. You will get a warning that the ad groups don't have any ads in them. Ignore that warning as of now. If there are any errors rectify them.
NOTE: If you are using just the Keywords sheet to input all of the data, then you have to insert your budget in the selected campaign, which will show a error. Also, after posting all the changes in your account, you need to change the Campaign type of your campaigns to Search Only.
This is the Ad sheet which includes columns for Campaign, Ad Groups, Headline, DL1, DL2, Destination URL and Display URL. If you want to make two ads in a single Ad Group, you can just make a duplicate row with the Campaign and Ad Group and input a different Headline, DL1 and DL2. You can find the sheet here: https://docs.google.com/spreadsheets/d/1_sVcSev-UPjfTFvtgVV-bvY0qDWdnXun91qNWU4SfZ4/edit?usp=sharing
To input the ads into Editor you need to click on Ads in the left sidebar and then click on Make multiple changes. The same procedure is followed as discussed in the Adding Keywords section.
After adding all of the data into the AdWords you have to click the Post button, which is situated at the top, to post all the changes into your AdWords account.
NOTE: Whenever you start working on AdWords Editor do keep in mind to click on the Get Recent Changes button.
Adding data through AdWords Editor is pretty easy and it saves a lot of time.