AdWords
3K members online now
3K members online now
Get started with AdWords - learn the basics to get set up for success
Guide Me
star_border
Reply

Delete Campaign Location Settings Using Bulk Uploads Feature

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

How do I remove a Campaign location setting using bulk upload csv?

 

when i added the location the csv looked like the following:

Campaign ID, Location

<campaign_id>, new york,new york

 

How should the CSV look like when i want to delete new york from the campaign?

 

Thank you

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Ads T
January 2016

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Community Manager
# 8
Community Manager
Hi there,

Thanks for waiting. I heard back from a few of our product specialists, confirmed that removing the location is not possible with a spreadsheet. The recommended way to do this in bulk is the Bulk Locations feature I mentioned above or through AdWords Editor, whichever is more convenient for you (but either will work!).

Cassie

View solution in original post

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Community Manager
# 2
Community Manager
Hi there,

Thanks for posting to the Community. You should just be able to type "remove" into the Status column for that location, then upload your spreadsheet. See "general rules for editing spreadsheets" here: https://support.google.com/adwords/answer/2477116?hl=en

Let me know if you have any questions!
Cassie

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Hi,

Thank you for replying.

I tried this spreadsheet:
Location, Campaign, Status
united states, <campaign_name>, remove

and got an error saying the status is invalid "The value in column 'Status' is invalid.". so i put "removed" instead. but its removing the campaign, not the location:
CHANGE TO CHANGE TYPE
<campaign_name> Remove > Campaign

I would like only to remove the location. not the whole campaign.
There is no spread sheet for campaign settings. only downloading the report. is it possible to remove a location using spreadsheets?

Thank you very much


Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Community Manager
# 4
Community Manager

Hi there,

 

Is there any reason that you have to use a spreadsheet for this? If not, it would likely be much faster for you to do bulk location editing from the AdWords interface:

 

  1. Go to your Settings tab
  2. Hit the checkbox to the left of any campaigns you would like to edit
  3. Click Edit > Locations... at the top of your list
  4. Click on Advanced Search
  5. In the new window, click on Bulk Locations
  6. Now you can search for the location you would like to remove and, once you find it, click on "Remove all matched locations"

Screen Shot 2016-01-25 at 11.39.18 AM.png

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭
Hi,

Yes, I have to use a spreadsheet.
Is is possible?

Unfortunately the bulk location editing is not good for me.

Thank you

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Community Manager
# 6
Community Manager
Hi there,

I'm going to check with a specialist for you whether this is possible. Thanks for your patience!

Cassie

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭
Thank you very much
Marked as Best Answer.
Solution
Accepted by topic author Ads T
January 2016

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Community Manager
# 8
Community Manager
Hi there,

Thanks for waiting. I heard back from a few of our product specialists, confirmed that removing the location is not possible with a spreadsheet. The recommended way to do this in bulk is the Bulk Locations feature I mentioned above or through AdWords Editor, whichever is more convenient for you (but either will work!).

Cassie

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭
alright,

thank you very much

Re: Delete Campaign Location Settings Using Bulk Uploads Feature

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭
Hi Cassie,
is there a way to add new location?
I'm trying to use bulk upload with spreadsheet in order to add new geo location targeting to existing campaings.
The set of colums in the spreadshett is "Campaign", "Location" (so only 2).
However when trying to upload the file i get this error "In column 'Location', a location is not recognised: '"
I have been testing both the canonical name and name as highlighted in the Geographical targeting, see here: https://developers.google.com/adwords/api/docs/appendix/geotargeting#columns
but non is working.
Can you help on this?
Thanks
Michele