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

Click-to-Call [Infographic]

Click-to-Call [Infographic]

  Most dealers understand the importance of making it easy for customers and prospects to find contact information. Websites often have prominent &…

Quick Tips for Improving Dealership Culture

Quick Tips for Improving Dealership Culture

Car dealers have a terrible reputation. It's such a negative experience for so many that people are electing to make a major purchase like a vehicle fr…

The Biggest Mistake Dealers Make When It Comes to Customer Retention

The Biggest Mistake Dealers Make When It Comes to Customer Retention

Jim Roche is the Divisional VP of Marketing & Managed Services at Xtime. We asked him to tell us the biggest mistake he sees dealers making today when …

Is 2018 the Year of Customer Convenience?

Is 2018 the Year of Customer Convenience?

It seems that every year has a theme attached to it in terms of where dealerships’ focus will be. Which themes or buzzwords will dominate 2018? We…

Upcoming Webinar: Show with Your Showroom, Sell with Your Website

Upcoming Webinar: Show with Your Showroom, Sell with Your Website

Today's customers walk into your showroom better-informed than ever before. Because they've done their research ahead of time, 89% walk into t…

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