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

2017 Presidents Club Insights - Patrick McMullen

2017 Presidents Club Insights - Patrick McMullen

Listen to what Patrick McMullen from MAXDigital has to say about the future of automotive, what dealers can do today to prepare, and how DrivingSales Presi…

Five Tips for Selling Used or Certified Pre-Owned Vehicles

Five Tips for Selling Used or Certified Pre-Owned Vehicles

Selling used or certified pre-owned vehicles can be daunting task. With prices, laws, and competition varying across the country selling a pre-owned car fo…

What Motivates Your Employees to Perform?

What Motivates Your Employees to Perform?

Sorting through resumes, you find applicants who show potential. There are some with experience to walk on the job and set your service department abla…

How to Recruit the Best Talent for Your Dealership

How to Recruit the Best Talent for Your Dealership

Employee turnover can cost a dealership approximately $400,000 per year through lost sales, service offerings, new hire search, and training expenses even …

2017 Presidents Club Insights - Mark Brown

2017 Presidents Club Insights - Mark Brown

Hear from Mark Brown, sales director at Grappone Auto, about what he thinks is coming for the auto industry, how dealers can prepare, and how the DrivingSa…

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