Simple Formula to Change Your Broad Match To Modified Broad Match
As experienced PPC Advertisers know, Google recently rolled their modified broad match modifier to all accounts.
Being a “PPC Guru”, I needed to find a way to turn all of my broad match terms into broad match modifier using excel, simple & easy.
The formula is simple:
=concatenate(“+”,substitute(a2,” “,” +”)
Attached is a spreadsheet with the formula sample… Yes, you will still need to reupload to Google Adwords editor or something. BTW, you can do this in adwords itself, using Google’s in-table editing.
Alternatively, you can download Chad Summerhill’s Excel Macro, or use Maria Nichita’s Find Replace Strategies.