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

how to quickly lowercase keywords in editor

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Looking for a quick way to manipulate keywords into lower case format. I originally exported campaign level keywords into excel and did the =LOWER() formula but when I import the keywords, they DO NOT overwrite the existing keywords. Rather they create additional keywords.

 

Also noticed tht the "Change Text Capitalization" button, located within the EDIT section of the toolbar only works when editting ads? Why is this?

 

Any help? Thanks in advnace.

3 Expert replyverified_user

Re: how to quickly lowercase keywords in editor

Top Contributor
# 2
Top Contributor
Hi Justin.
I wrote a free windows application to do just that.
https://www.redflymarketing.com/internet-marketing-tools/keyword-management-tool/

You can do it in editor but you have to do it by find and replace. You can also use AdWords scripts but it's a massive paid. My tool was built with AdWords in mind and it outputs in plain text ready to be pasted into editor.

Re: how to quickly lowercase keywords in editor

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
I guess I should rephrase my question...

Getting the keywords in plain lowercase text is not the issue; however, when I import them they do not overwrite the existing keywords.

Is there a setting that I am missing? How can I import and "make changes" to existing keywords, not necessarily add new ones?

Re: how to quickly lowercase keywords in editor

Rising Star
# 4
Rising Star

Good morning.

 

Importing keywords that use a different case will not overwrite the keywords that already exist in Editor, no, and there is no setting that forces this to happen.

 

You can use the "match case" function in Editor to change the existing keywords to lowercase. Once you've done that (and loaded those changes to the UI), then you can import changes to them as existing keywords.

 

(Note that the imported keywords will only be "changed" instead of "added" in cases where they are not being move to a different campaign or Ad Group.)


Theresa
Google AdWords Top Contributor
*~*~*~*~*~*~*~*

Re: how to quickly lowercase keywords in editor

Top Contributor
# 5
Top Contributor

Hi Justin, probably a silly question, but why are you concerned about the capitalisation of keywords?  AdWords takes no notice of keyword capitalisation in matching, "Red Shoes" is exactly the same as "red shoes" in matching terms.  See here:

 

https://support.google.com/adwords/answer/2497836  (the first point under "Keep in Mind").

 

Jon

AdWords Top Contributor Google+ Profile | Partner Profile | AdWords Audits

Re: how to quickly lowercase keywords in editor

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭
I know this response is a bit late, but I ran into it when looking to lower case my Keywords. In the end, I used an old fashioned find and replace (ie. K to k) for all keywords. In replay to Jon_Gritton's question, having all your keywords in Google Adwords Editor in lower case, makes it easier to spot duplicate keywords in your account. Instead of Adwords Editor stating "there is a similar keyword with different capitals in this adgroup", it will immediately show all duplicate keywords. It's a best practice often used by Adwords specialists for quick-wins in client accounts. It makes things a bit easier. It also helps if you make it a habit of writing all keywords in lower case....

Re: how to quickly lowercase keywords in editor

Follower ✭ ✭ ☆
# 7
Follower ✭ ✭ ☆
[censored]. That would be 26 find and replaces.

Why all lowercase? To clean up someone else's terrible, terrible work, and keep it structured & easy-to-read for the one who comes after you.

It's like "Tabs vs Spaces," in HBO's Silicon Valley.