How to Use AdWords Editor for Bulk Upload

adwords-editor-bulk-upload

Creating a new AdWords account is no easy feat, especially when there are a lot of keywords under a very complex account structure. By doing everything in bulk, advertisers can save a lot of valuable time. Here is how to do it using excel.

Keywords

Once you have gathered your keyword list, figured out the desired match type and bids, and which campaign and ad group they belong to, layout all the data in the following manner.

excel keywords

You can choose to take out the Destination URL column if you are not planning on using keyword level destination URLs.

Once the excel data are ready, open up AdWords Editor and click on the Keywords tab and choose Positives.

keywords positive

Select account level operation by highlighting the account name (instead of individual campaign or ad group name).

select accounts name

Click on Make multiple changes and choose Add/update multiple keywords.

multiple keyword changes

Copy and paste all the excel keyword data you have prepared into the following space, choose the pricing model for your new campaigns and click on Process.

paste excel data

Click on Finish.

finish

Now you have all of your new keywords loaded into AdWords Editor with the corresponding ad groups and campaigns created at the same time.

new keywords

Notice the red dots with exclamation mark? It means there is required information missing or something is not done right. Don’t worry about them for now and we will take care of them all at once later.

Negative Keywords

Once you have gathered your negative keyword list, figured out the desired match type and which campaign and ad group they belong to, layout all the data in the following manner.

excel negative keywords

Once the excel data are ready, open up AdWords Editor and click on the Keywords tab and choose Negatives.

keyword negative

Select account level operation by highlighting the account.

Click on Make multiple changes and choose Add multiple negative keywords.

multiple negative keyword change

Copy and paste all the excel keyword data you have prepared into the following space and click on Process.

paste excel nkw data

Click on Finish.

Now you have all of your negative new keywords loaded into AdWords Editor.

new negative keyword

 Campaign Negative Keywords

Once you have gathered your campaign negative keyword list, figured out the desired match type and which campaign they belong to, layout all the data in the following manner.

keyword campaign negative

Once the excel data are ready, open up AdWords Editor and click on the Keywords tab.

Choose Negatives.

Select account level operation by highlighting the account.

Click on Make multiple changes and choose Add multiple campaign negative keywords.

multiple cnkw changes

Copy and paste all the excel keyword data you have prepared into the following space and click on Process.

paste excel cnkw data

Click on Finish.

Now you have all of your new campaign negative keywords loaded into AdWords Editor.

new campaign negative keywords

 

Ads

Once you have created your ad copies, figured out which campaigns and ad groups they belong to, layout all the data in the following manner.

excel ads

Once the excel data are ready, open up AdWords Editor and click on the Ads tab and choose Text.

ads text

Select account level operation by highlighting the account.

Click on Make multiple changes and choose Add/update multiple text ads.

mutiple ads change

Copy and paste all the excel keyword data you have prepared into the following space and click on Process.

paste excel ad data

Click on Finish.

Now you have all of your new ads loaded into AdWords Editor.

new ads

Still remember the red dots? Let’s deal with them now.

Head to the Ad Groups tab and click on the sort by verified status icon. This will pull all the items that need extra attentions to the top.

ad group bids

The reason these ad groups are flagged is they are missing ad group level bids. If you are using keyword level bids, then just give these ad groups an arbitrary bid because keyword level bid overrides ad group level bid, so in this case, what you choose for ad group level bid is not important at all.

If you plan to use ad group level bids instead of keyword level bids, then give each ad group an appropriate bid.

Head to the Campaigns tab and click on the sort by verified status icon. This will pull all the items that need extra attentions to the top.

campaign budget

The reason these campaigns are flagged is they are missing daily budget. Simply give these campaigns an appropriate budget and you are ready to go.

Before making all the changes go live, make sure you have set the correct language, geographic, device, network, etc options.

Click on Post selected campaigns.

post campaigns

Choose All campaigns and then Post.

post all campaigns

You have just uploaded your new campaigns, ad groups, ads and keywords to your account.

VN:F [1.9.22_1171]
Rating: 9.7/10 (3 votes cast)
VN:F [1.9.22_1171]
Rating: +3 (from 3 votes)
How to Use AdWords Editor for Bulk Upload, 9.7 out of 10 based on 3 ratings

About 

Steve worked for Pitstop Media Inc as a Pay per Click (PPC) specialist, helping clients maximize the value of their PPC campaigns. He is also a musician and a part-time sound designer for TV/film.

 

One Response to “How to Use AdWords Editor for Bulk Upload”

  1. AdWords Editor | Keyword Planner Tool said:

    Jul 04, 13 at 9:05 pm

    […] How to Use AdWords Editor for Bulk Upload – Pitstop Media Inc. […]