Web Marketing Experts Blog


Blog Home


Convert Keywords to Phrase Match Using Excel

Posted on 14th Nov 2016 by David Ogletree




Sometime I get a list of keywords that I want to convert to phrase match. Most often I do this when I'm creating negative keyword lists but this works for normal phrase match as well. Put your keywords in a single column in Excel and then past this formula in the first cell of the next column and hit return. In order to use this on the entire column just double click on the bottom right of the cell you just pasted the formula into. This will copy the formula to ever cell in that column.

Just copy the entire column over to Google AdWords or Google AdWords Editor.

 

=IF(COUNTIF(A1,"* *"),"""" & A1 & """", A1)

Recent Posts

Convert Keywords to Phrase Match Using Excel

Branding Ad Group Rules of Thumb

Google Open Ad Exchange: What's Happening?

What Does a South African Court Case Tell us About AdWords Trademark Issues?

Should You Break Up Your Campaigns?

What's Up With Tablet Bidding?

AdWords PPC: Ever Changing, Ever Expanding

Stop Making Quick Changes!

Adwords Bid Adjustment By Device: But Why?

3 Reasons You Should Never Let AdWords Run On Autopilot

How to Become the Best AdWords Consultant Ever

Google AdWords: How to Set a Baseline

Help! My PPC Campaign is Broken and I Don't Know How to Fix It!

Adwords Latest Changes: Should I Stay Or Should I Go?

Google Adwords Exams: What You Need To Know

How Google Adwords Is Like the IRS

Secrets to Managing Adwords ROI

What delivery method are you using with Google AdWords?

Are you remarketing?

Are you using modified broad keywords?

Has Google finally sold out?

Bid on Vanity Searches

Follow Us

Twitter LinkedIn Facebook

Ask David ANY PPC Related Question!

There’s no issue or question too large or too small – contact David with your individual needs today! Drop him a line or ask your question here and he’ll get back to you within 24 hours or less.

CONTACT