Notifications & Messages

Jared Hamilton
From: Jared Hamilton
Hey - It’s time to join the thousands of other dealer professionals on DrivingSales. Create an account so you can get full access to the articles, discussions and people that are shaping the future of the automotive industry.
×
Cassie Allinger

Cassie Allinger Senior Advertising Performance Strategist

Exclusive Blog Posts

Take me off the List!

Take me off the List!

      The last thing a dealer wants to hear is “take me off of your marketing list.” Each and every time you get th…

Using Vehicle Safety Features to Drive New and Used Car Sales

Using Vehicle Safety Features to Drive New and Used Car Sales

Selling a consumer a large ticket item like a car, truck, or SUV comes with a degree of understandable skepticism for the buyer. Consider the importanc…

Why Branding Your Price is a Great Idea!

Why Branding Your Price is a Great Idea!

If you’ve been reading my pieces for the last few months, you’ve probably noticed how passionate I am about branding. By branding every aspect of your …

Interview With Ken Kupchik, Sales Humor Creator

Interview With Ken Kupchik, Sales Humor Creator

Last month, the was our top blog. So we decided to interview Sales Humor creator Ken Kupchik to get learn more about his successful social media platforms,…

Is Your VDP Your MVP?

Is Your VDP Your MVP?

The vehicle display page (VDP) is often the last page a customer sees before contacting a dealer. By the time they’ve arrived there, they’ve li…

Quick & Easy Fixes for Dealing With Modified Broad PPC Keywords In Excel

 

Guilty admission: I find cool new tricks very exciting, especially when they provide a solution to an annoying or tedious task. So! You can imagine my excitement (and maybe even a happy dance or two) when I stumbled upon a gem in Twitter promising an easy fix to dealing with modified broad match keywords in Excel.

 

One click later, I found myself knee deep in Mark Jensen’s piece which offers a cool macro and step-by-step directions that will solve all your modified broad match problems. In fact, I was so intrigued that I had read the entire post before realizing that I didn’t need his solution. I found another way to deal with these pesky modified broad match errors years ago, and it’s much much much easier than geeking out with macros. I promise.

 

Problem: The error comes from the fact that Excel places a ‘=’ in front of all ‘+’ because it assumes that ‘+’ indicates a mathematical formula. So all we’re going to do here is a simple find and replace.

Solution: Replace all ‘=’ with a single (‘) apostrophe.

Result: Voila! By removing the ‘=’, the cell contents are transitioned from a formula to a general text format. You’ll also notice that the (‘) which is referred to as a leading apostrophe, will not be shown in the cell, so you’re left with your modified broad match keywords in perfect shape.

That’s it! Easy, painless, and should take you only a matter of seconds when you’re working with keywords in a spreadsheet. With that said, I’m actually a big fan of Mark’s solution, so if you have the time to go through the extra steps of working with his awesome modified broad match macro, check it out. I actually think it could prove to be extremely useful if you have a have a big workbook template that you work with often and don’t want to run F&R each time that you update the data.


Original Post: "An Even Easier Modifed Broad Match Excel Fix" on the Get Found First PPC Blog. 

Jared Hamilton
Cassie - im not sure how I missed this post in early dec, but this is good stuff. A simple solution to a potential big annoyance. Thanks you for sharing.
Cassie Allinger
You're welcome & thanks for the comment Jared! I agree that while it may be a very simple little fix, it's one that causes big headaches for some people. I'm planning to follow up this post with a few more to follow the theme. Stay tuned! :)

 Unlock all of the community & features  Join Now