• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Logo for Cody See

Cody See

Life & Marketing

  • Home
  • Articles
  • Recommendations
  • Subscribe

How to Bulk Update Zip Code Targeting in Microsoft Ads

September 21, 2019

Microsoft’s documentation doesn’t explain how to bulk update location targeting with zip codes in Microsoft Ads. This process is confusing, but it’s better than adding each zip code one by one.

Hopefully it saves you some time.


1. We need to find the “Microsoft location ID” for each zip code you want to target. This is necessary because Microsoft uses their own IDs to identify location targets, so if you want to add multiple zip codes at once, you need to know their corresponding IDs.

To do this, start by downloading Microsoft’s Geographical Locations Code file. You can find this in the Microsoft Advertising Developer Portal. A few language options are available, so choose the one applicable to you.


Microsoft Ads Geographical Location Codes
The page where you can download the file looks like this. Click here to see it full-width.

2. Open the Geographical Locations Code file in Excel or Google Sheets (it doesn’t matter which; the process works the same either way).

3. Add a second tab to the file. Paste the list of zip codes you want to target into the second tab, beginning with cell A1.


Bulk Update Zip Codes Microsoft Ads Step 3
Paste your zip code list into a second tab titled “Sheet1”.

4. Go back to the first tab. Add a heading in column G. I’ve called it “Match” as you’ll see in the next image, but you can call it whatever you want.

5. Paste the following formula into the cell immediately below the heading you just added:

=SUMPRODUCT(--ISNUMBER(SEARCH(Sheet1!$A$1:$A$???,B2)))>0

In the formula, replace the three question marks with the cell number of the last row in the second tab.

For example, if I want to target 14 zip codes, then that’s how many zip codes are in the second tab, and it would end at row 14. I would replace ??? with 14. The formula would look like this:

=SUMPRODUCT(--ISNUMBER(SEARCH(Sheet1!$A$1:$A$14,B2)))>0


Bulk Update Zip Codes Microsoft Ads Step 5
Use this formula. Click here to see the image full-width.

6. Copy the formula down so it applies to all of the cells in column G.


Bulk Update Zip Codes Microsoft Ads Step 6
Drag the formula so it applies to every cell in column G that has corresponding data in column A. Click here to see the image full-width.

The logic here basically says “If any of the zip codes I want to target match the zip codes in Microsoft’s file, respond with TRUE”.

7. Add a filter. In column G, deselect “FALSE”. This will leave only the “TRUE” cells.


Bulk Update Zip Codes Microsoft Ads Step 7
Create a filter, then deselect the FALSE cells. Click here to see it full-width.

Congrats! That was the hard part. You now have all of the corresponding location IDs for the zip codes you want to target.

If you know another way to pull out the location IDs based on your target zip codes, go for it. There are always multiple ways to accomplish the same task with spreadsheets. This method works though, if you don’t know any others.

Note: You may notice that some of Microsoft’s location IDs do not have corresponding AdWords / Google Ads IDs. In my experience, Microsoft Ads will match more zip codes than Google Ads, so it’s worth doing this process rather than porting your location targets from Google Ads so you don’t miss any.

8. Open up your account in Microsoft Ads Editor.

9. In the bottom left “Manage” panel, drop down “Keywords and targeting”, then select “Locations”.


Bulk Update Zip Codes Microsoft Ads Step 9
Select Locations.

10. In the secondary navigation at the top, drop down “Make multiple changes”, then click “Add/update multiple campaign area targets”.


Bulk Update Zip Codes Microsoft Ads Step 10
Click “Add/update multiple campaign area targets”. Click here to see the image full-width.

11. Go back to your spreadsheet and copy all of the location IDs (the ones that are marked TRUE in column G) from column A.

Paste them into the Microsoft Ads window that just popped up. Deselect the box that says “My campaign locations data includes campaign names”, then check the applicable campaign(s). When you’re done, click “Next”.


Bulk Update Zip Codes Microsoft Ads Step 11
Select your campaign(s), then paste your location IDs into the box. Click here to see the image full-width.

12. Drop down the menu on the next screen and select “Target”, then click “Next”.


Bulk Update Zip Codes Microsoft Ads Step 12
Make sure you select “Target”. Click here to see the image full-width.

That’s it! Microsoft Ads Editor will process the request and provide a summary, then you can close the pop-up window and post the changes so they’re live in Microsoft Ads.

Thanks for reading. This is where I'm supposed to tell you to sign up for my email list. So, uhh... sign up fo my email list if you feel like it.

Footer

Affiliate Disclosure

I take part in various affiliate programs. Learn more here.

Links

  • About
  • Now
  • Privacy Policy

Search

© 2017 533 Digital LLC