Web Marketing Experts Blog

Convert Keywords to Phrase Match Using Excel

Posted on 14th Nov 2016 09:12:23 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)


Read More

Branding Ad Group Rules of Thumb

Posted on 22nd Jun 2016 15:00:49 by David Ogletree

It’s not necessarily a rule of thumb for everyone who does AdWords or works with Bing, but it is something most of us abide by when it comes to branding. Or, should abide by, at the very least.


It’s fairly standard industry advice to avoid branding keywords if your brand comes up first in organic search results. But how do we know that’s the case? Are you monitoring your brand to make sure you’re consistently easy to find?

Read More

Google Open Ad Exchange: What's Happening?

Posted on 22nd Jun 2016 14:59:46 by David Ogletree

It pays attention to pay attention.


Google publishes tons of really useful information on its blog. Every now and then, something will jump off the page for the user who’s reading between the lines. This week, that something took the form of a change mentioned in a publication last week about changes in mobile technology.

Read More

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

Posted on 22nd Jun 2016 14:58:34 by David Ogletree

Though most of us might not follow the trials and tribulation of AdWords and PPC marketing verdicts in other countries, those who have know a landmark case unfolded in South Africa this last week. For the first time ever, South Africa’s supreme court turned out a verdict in a case set in motion by confusion over branding in AdWords.


Whether you’ve managed AdWords for some time or not, or personally managed a client touched by trademark law, you know the possibility of a cease and desist is always on the table. This is especially true for those of us who advertise directly on competitor keywords, particularly when we know some of these terms are trademarked.

Read More

Should You Break Up Your Campaigns?

Posted on 27th May 2016 12:28:12 by David Ogletree

There are many cases where you’d want to break up your AdWords budget between campaigns. There’s no uniform right or wrong way to do this – as always, it’s a game of testing  - but it does make sense to split your budget in a way that emphasizes the success of top performing keywords and ads.


Here are some situations in which you’d be better off splitting an AdWords campaign budget up between multiple campaigns:


Read More

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.