AdWords Editor

By charles kirkland | Adwords

Feb 17

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

article_3_1

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.

article_3_2

Next a dialogue box will appear where you have to sign in with your AdWords account.

article_3_3

In the next dialogue box, you can either download all the campaigns or choose which ones to download.

article_3_4

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 lets make some sheets from where we can upload the data by copying it into the Editor.

article_3_5

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.

article_3_6

Now select Campaigns on the left side bar and then click on Make Multiple Changes.

article_3_7

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.

article_3_8

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.

article_3_9

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.article_3_10

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.

article_3_11

Now click on Ad Groups on the left sidebar and then click on Make Multiple changes.

article_3_12

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.

article_3_13We have now inserted all of the campaigns and their Ad Groups in Editor. Now we have to add keywords.

article_3_14

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.

article_3_15

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

article_3_16

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.

article_3_17

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.

article_3_18

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.

article_3_19

 

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

article_3_20

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.

Free BannerV1

 

Follow

About the Author