Skip to content
  • Texas | Arizona | Virginia | Idaho | Illinois
  • (888) 705-0930
  • info@therawragency.com
Facebook-f Twitter Instagram Linkedin-in
rawr logo short
  • Home
  • About
  • Solutions
  • Industries
  • Services
  • Blog
  • Contact
colorized icons 04
B2B Marketing
colorized icons 05
B2C Marketing
colorized icons 06
Online Visibility Management
colorized icons 07
Healthcare
colorized icons 08
Manufacturing
colorized icons 10
Home Services
colorized icons 09
Professional Services (B2B)
colorized icons 11
Retail
colorized icons 01
Brand Strategy
  • Graphic Design
  • Corporate Brand Identity
  • Sales Enablement
  • Editorial Calendar Management
colorized icons 02
Website Design
  • WordPress Website Development
  • Conversion Rate Optimization
  • eCommerce Development
  • Content Strategy & Copywriting
colorized icons 03
Digital Marketing
  • Digital Marketing Strategy
  • Search Engine Optimization (SEO)
  • Pay-Per-Click (PPC) Management
  • Content Marketing & Digital PR
  • Account Based Marketing (B2B)
  • Marketing Automation
  • Social Media Management
Let's Talk

Advanced Google Ads script removes locations from keywords

  • March 12, 2020
  • General
  • Agency
Facebook
Twitter
LinkedIn
Email

One of the most tedious tasks when working with location-based keywords is removing the individual locations from the keywords at-scale. These are the location-based keyword terms such as “car dealership London.”

Like with any tedious, repetitive task the developers at my agency created a Google Ads script to automate removing the locations from keywords within Google Sheets.

How the script works

The script pulls all of the keywords within your account and then searches each one against our database of all UK locations. 

You can also configure it to only pull keywords from certain campaigns in the settings which I will explain in the setup section below.

It then pulls the location from the keywords and creates an output as below. The keyword is in the first column and then the location that is contained within it is in the second column.

How to set up the script

Before you can run the script there are a few variables that you need to configure.

  • On line 18. You will need to create a new Google Sheet which will be used to output the report showing the keywords and the locations within them. You will then need to specify the URL of the sheet that you want the report to be outputted to on line 18 of the script. 
  • On line 21. You can change which campaigns you want to include. To include all of the campaigns that contain the term “brand” for example, you would enter the word “brand” here. if you want to include all of the campaigns, then just leave this field blank.
  • On line 22. On the other hand, if you want to exclude all of the campaigns that contain the term “generics” for example, you would enter the word “generics” here. if you want to include all of the campaigns, then just leave this field blank.

The script 

The post Advanced Google Ads script removes locations from keywords appeared first on Search Engine Land.


Source: IAB

Facebook
Twitter
LinkedIn

Recent Blog Posts

Navigating Supply Chain Disruption: Harnessing Innovation in Turbulent Times

December 4, 2023

Transform Your Patient Experience

November 28, 2023

Unleashing the Potential: The Revolutionary Impact of Artificial Intelligence (AI) in Healthcare

November 6, 2023

Empowering Patients through Online Communities/Enhancing Engagement with The RAWR Agency

October 20, 2023

Sustainable Manufacturing: Advancing Net Zero and ESG Goals in 2023

October 6, 2023
View More
rawr logo short
Facebook-f Twitter Instagram Linkedin-in
Get In Touch
  • Texas | Arizona | Virginia | Idaho | Illinois
  • (888) 705-0930
  • info@therawragency.com
Send An Email

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Copyright 2023 | The RAWR Agency, LLC. |

Sitemap | Privacy Policy