Oct 092012
 

Duplicate listings can very easily turn into the plague of the online marketing of every local business. They not only often feature old or incorrect and misleading information, but could also potentially “transmit” this information to other sites, thus spreading it throughout the whole ecosystem and ultimately reaching Google’s local data cluster, which could be devastating for business’s local search rankings. Unfortunately, getting rid of such duplicates has proven to be more difficult than any other process related to local listings – adding, claiming, or editing them. Additionally, there is currently no automated service that deals with this problem, so manual clean-up is the only way to go.

Why removing duplicates is so difficult?

There are a few main reasons for this:

1) Making it easy for people and businesses to remove listings from a business directory could very easily backfire and cause the loss of data that has been paid for. Therefore, it is not of the websites’ own interest to offer such a service.

2) Many business directories lack the technology to solve complicated problems with business data and prefer to ignore them rather than invest into trying to fix them (Google itself is an example of a company that has been ignoring the importance and complexity of the problem for way too long).

3) While websites might lack the technology to solve the problem with duplicate listings, they might also lack the human resources to maintain the process via some sort of customer service.

These, together with the fact that many websites are left without (almost) any editorial backing make the process tedious and frustrating. I myself am dealing with it daily and I have a list of good practices for removing duplicate listings on a number of the most important business directories on the web and as I know many others share the same burden I am sharing a few tips here.

Which websites am I covering here and why?

I will definitely not cover the whole list of business directories (note: this article covers predominantly US business directories), but just the ones I consider to be of the highest importance and at the same time have a rather troublesome process of listings removal, plus the ones where I normally find the highest numbers of duplicate listings.

Yelp

The site is notorious for the problems it causes to businesses when they want to remove their listings, usually for the purpose of getting their negative reviews gone, too. In the majority of the cases the answer coming from Yelp is “No”. However, there is a mechanism to get this done in the cases when the listing is a duplicate. You simply have to go to the contact form and choose “Duplicate business listing” from the drop-down menu. After this you’d need to use the search option to locate the two listings – the original one you’d want to keep, and the duplicate one and select them. Normally these get solved within 1-2 weeks.

Citysearch

The site, while hosting one of the largest business databases, has no official system for getting duplicates removed. The fastest way to deal with the problem would be to send them an email at myaccount@citygridmedia.com. Unfortunately, answers are not regular and frequent, so it might take some time and a few attempts to get this done. Another way, which is unofficial and might take you to a sales agent rather than to the desired destination (hopefully a customer service rep or a tech), is to call the company’s phone number 800-611-4827.

Superpages

Similarly to Citysearch, Superpages does not have a system in place to get duplicate listings removed. The best way I’ve found to get this resolved is by calling the customer service phone number: 800-428-8722.

Yahoo! Local

Yahoo’s mechanism is pretty clear when it comes to listing removal (unlike the mechanism for getting a listing verified). You have to go to the Local Listing Removal Request Form, choose “Business Moved” from the drop-down menu, and fill in the form.  Then it usually takes about 2-4 weeks for the listings to be taken down.

MapQuest

The process is again rather simple (once you discover where to start, of course): simply go to the Report an Issue page, tick “Business Listing/Location Issue” and describe the problem in the box at the bottom.

LocalEze

To get a listing “closed” you’d first need to verify your ownership over it. After you are done with that, you’d need to go to the “Manage Listings” dashboard and under “More Actions”, click on “Close Listing”:

Yellowbot

This one is a bit more complicated. You’d need to locate the duplicate listing and click on “Help us make it right” at the bottom of the page (note that you’d first need to register to the website, because you will be practically sending a user edit). On the next page, scroll to the bottom and click on “Submit corrections” and a window will be prompted asking if you are the business owner. Answer with a “No”. At the next page choose “Duplicate” from the drop-down and in “Reason for change” box fill in the URL to the original, correct listing.

MerchantCircle

This is my “favorite” in terms of number of duplicate listings. This is one of the reasons why I was so amazed to see it topping this research by Yext. The mechanism for removing those is, however, relatively easy. You have to go to the Remove a Business Listing, search for the duplicate(s), and after this simply mark them and send them for deletion. All this seems fine, but unfortunately, according to my experience the site is very slow at taking action on these reports and at the same time they are virtually unreachable via phone or email.

HotFrog

The mechanism for removing a listing is very well outlined in the FAQ of the site, so I will just cite it here:

“If you do want to leave though, login and click on ‘My account’ once you’ve logged into the dashboard. From there click on ‘Remove your free profile’ and follow the instructions.”

Therefore, you’d need to first have the listing claimed before being able to delete it.

EZLocal

The site does not have a system in place for removing duplicates, but calling customer service at 877-416-2378 and looking for Denise has proven to be a very nice and easy way to solve one’s problems.

Ones I haven’t Discovered Solution for

Besides these there are a couple of more websites, which often feature incorrect duplicate listings – Citysquares.com and GetFave.com. Unfortunately, my attempts to find a solution to this problem have always failed up to now. It appears that the easiest way to get this issue fixed is by simply editing the duplicate(s), including the correct information in each of them.

Have you had problems with removing a listing from some of these websites, or from other ones? Have you solved them in some more effective ways?

*Note: Our Citation Building Guide features more information, tips, and tactics on how to deal with duplicate listings and data consistency.

Aug 282012
 

Last week I read a post on Search Engine Land that was discussing a study by Implied Intelligence. The study was related to business data accuracy, and was comparing a number of the biggest players in the UK market. As I felt the SEL article didn’t offer too much details, and I was very interested to learn more, I contacted Marc Brombert and he was kind enough to provide me with the complete research.

Which Sites Were Researched

The full list of sites that were researched includes: Foursquare, Thomsonlocal, Scoot/TouchLocal, Bing Local, DNB, ThePhoneBook, Yell, Google Maps, Yelp, 118.com, 192.com, HotFrog, Yahoo Local UK, Qype UK. The mentioned sites were chosen based on traffic and general industry prestige (see here for reference). It is also worth mentioning that:

1) These are all different types of websites. For instance, Yelp and Qype are rather review social networks, Foursquare is a check-in social network, Yell, Scoot/TouchLocal and Thomsonlocal are traditional IYPs, Google Maps, Bing Local, Yahoo Local are a kind of mixtures. Thus, it is to be expected that the business data accuracy would vary.

2) Many of these exchange data between each other, or get data from the same source. For instance, My118information.co.uk provides data to 118.com, 192.com, TouchLocal, Yahoo, Bing, and others (according to Sarah Shepherd, Head of Customer Service at the company). LocalDataCompany.com provides data to Google, Yell, Thomsonlocal, Touchlocal, Qype, 192.com, and others (according to their website). At the same time 192.com gets data by 118.com.

Methodology of the Research

Implied Intelligence researched “1,400 hand-checked records from a random UK geography.” The records were all extracted from the websites of the businesses themselves. Because of this most of the records were of small businesses, as only records with one address per homepage were chosen (which means that chains and franchises were largely excluded). The study looks into a few aspects of the data, going beyond simple data accuracy. These include: coverage (how many of the records were present), number of duplicates (determining if a listing is a duplicate of another listing was based on a robust match between the name, address, phone number and URL), accuracy (of the main business data), and richness (presence of additional details).

Findings

As stated in the title, it turns out that Google is the most accurate and detailed source of business data in the UK. However, before looking into the final details, I’d like to discuss the scoring per factor.

Where everyone seemed to fail was at the coverage test. Google was the only one to score over 50% (58.8%), followed by 192.com (49.1%). Both these companies’ databases receive data from a large number of places, and this could explain their advantage. The worst scoring, by a large margin, is Foursquare with just 6.9% of the records being present on their website. The reason is most probably the relative unpopularity of the social network in the UK (85.2% of the British have never used it, and just 3.1% use it frequently). It is interesting, however, that Yelp takes the second spot (in reversed order) with only 24.6% of the businesses researched being present on their website. This performance is significantly worse than the one the site shows in the US market – 63.2%.

The second factor researched was percentage of duplicate listings. “Winner” is ThePhoneBook with 20.8% duplicates, followed by HotFrog with 12.3%. Yahoo, which in the UK gets data from Infoserve, was found to have 0% duplicates, followed by Yelp (1.4%). Google is just third here with 2.5%. These percentages are generally much lower than what I would expect. Based on my previous researches, the duplicate percentage should be on average around the low double-digits.

It gets scary when looking at the data accuracy findings. The worst performing overall is once again ThePhoneBook, featuring a wrong phone number in 27.8% of the cases, and a wrong address in 2.9% of the cases. It is followed by HotFrog (25.9% and 2.5% respectively). The best two are Qype (19.2% and 1.7%) and Bing (20% and 1.6%). It is to be noted that according to the research DNB does not provide any business information, such as address, phone, and additional details, so most of their scores are either N/A or 0.

The survey looks into what percentage of the records have website URL associated with them. Google is the winner with 87.9%, followed by Yell with 79.7%, and Bing with 78.7%. A number of websites do not allow business websites to be added to listings, so their overall score is significantly lowered by this factor. These include: DNB, ThePhoneBook, 118.com, 192.com, and Qype.

The most inaccurate in terms of business website associated with a listing are Yelp (33.6%), Yahoo (33.3%), and Scoot (32.6%). Google is the best performer (from the ones that do allow business websites to be added to listings) with just 15.8% incorrect URLs.

The research also looks into the percentage of records with opening hours, and the percentage of records with additional information (including about-us information (taglines), payment options, free quotes, certifications, and others, but excluding reviews and check-ins). The unchallenged winner in both is Google with 28.3% and 97.9% respectively. There are again quite a number of directories that do not offer any additional information: Foursquare, DNB, ThePhoneBook, 118.com, 192.com, Yahoo.

Based on the factors discussed above (coverage score, duplicate score, phone error score, address error score, URL coverage score, URL accuracy score, hours score, and additional info score), the winner is Google Maps. Second place goes to HotFrog, and third place goes to Bing.

While I appreciate and respect the scoring system Implied Intelligence used, I believe some of the factors are not equal in terms of importance to other factors. These include URL coverage, URL accuracy, and business hours presence. I combined URL coverage, business hours coverage, and additional details presence into one factor, and completely excluded URL accuracy, and here is how the data accuracy rankings turned out:

1. Google Maps (=)

2. Bing Local (+1)

3. Thomsonlocal (+5)

4. Qype (+3)

5/6. HotFrog (-3/-4) and Yell (-1/-2)

7/8. Yelp (-1/-2) and Yahoo Local (+2/+3)

9. Scoot (-4)

10. 118.com (-1)

11. Foursquare (=)

12. 192.com (=)

13. DNB (+1)

14. The PhoneBook (-1)

Below is a graph that shows the difference in overall score when using Implied Intelligence’s scoring system and my scoring system:

 

Takeaways

Undoubtedly, Google is the winner in terms of complete and accurate UK businesses data. It is interesting that Bing, which does not have an automated system for businesses to list themselves or to edit their data (such as Business Portal in the US), performs very well (they do, however, have a request form for adding/updating a listing). From the viewpoint of local SEO, HotFrog and Yell seem to be important citation sources (I have discussed this previously) as they offer a big number of additional business information bits to be added (check here why this is important).

Aug 062012
 

While Google is gradually cleaning the mess with Plus Local (a step-by-step guide on how to help them in this endeavor by Mike Blumenthal here, and an official one here – I prefer Mike’s guide), Yahoo is adding new features to its Yahoo! Local Listings product. I noticed the last week that when you submit a new listing to Yahoo! Local, or when you claim an already existing one, you are now prompted to verify your ownership:

The email verification is a good and convenient option, which neither Google, nor Bing currently provide.

What does this addition mean? First, it should generally take much shorter time for a listing to be verified and published (in case you choose any other option than the postal mail one). Previously, the process was being completed manually by Yahoo’s moderators and in some cases this was taking well over a month. Apparently, the moderators’ job will now be eased, and most probably some of them will be relocated and/or discarded.

In addition to these changes, the overall layout of Yahoo! Local’s business dashboard has been improved. The enhanced listings ads are now much more prominent than before and getting a preview like the one below is part of the listing creation process:

I have always recommended the enhanced listings. They are a no-brainer at less than $10 per month (previously there were further discount offers, too), although they do not really help in the Yahoo’s local search rankings.

I feel like these improvements have something to do with Marissa Mayer (ex-Vice President of Local at Google) becoming CEO of Yahoo.

Jan 022012
 

If you read this blog regularly, you should know it’s all about local SEO and local SEM. If you don’t, well, now you know. During the year we went through literally hundreds, or even thousands, of local search marketing related articles and we learned a lot from them. We also tried to share some of our knowledge via our blog and we hope we contributed to the local search community with our tips and ideas.

We gathered all the articles that dazzled us during the year and created a compilation of about 100 pieces, divided into 12 categories:

General Local SEO & Local SEM

Onsite Local SEO

Link Building for Local SEO

Content Strategies for Local SEO

Google Places

Citations for Local SEO

Reviews for Local SEO & SEM

Bing Business Portal

Tracking and Monitoring of Local SEO

Local Search Statistics

Local Paid Search

Our Local SEO Articles

While we are trying to always be on top of everything local, we might have missed something out. If it’s so, we would be happy to hear about it in the comments below.

General Local SEO & Local SEM

Local Search Ranking Factors (David Mihm)

Google Local Search Ranking Keys: Relevance, Prominence & Distance (Chris Smith, SEM Clubhouse)

Dissecting Local SEO Via Competitive Analysis (Mike Belasco, Darren Shaw, Mary Bowling, SEOmoz)

4 Tips For Success With Seasonal, Local SEO (Andrew Shotland, Search Engine Land)

Social-Local-Mobile Tactics Drive Retail Success (Paul Bruemmer, Search Engine Land)

How To Boost In-Store Traffic & Sales By Optimizing Your Digital Storefront For Local SEO (Paul Bruemmer, Search Engine Land)

Nifty Hard Core Local SEO Tactics From SMX Advanced (Andrew Shotland, Search Engine Land)

How to Divide up Your Time for Maximum Local Visibility in Google Places (Phil Rozek, Local Visibility System)

Keeping Control of your Local SEO Assets (Steve Hatcher, Search Engine People)

Local Search Ranking Factors? Sadly, They’re Not Actual Industry Practices (Matt McGee, Small Business SEM)

Google Places Algorithm Change – New Proximity Lockout Algo Can Cause Major Ranking Drop (Linda Buquet, Catalyst eMarketing)

Google Places – Cracking the Proximity Lockout Algo (Gav Heppinstall, Crunch Web Design)

10 Local Search Tools I Simply Can’t Live Without (Mike Ramsey, Search Engine Journal)

Local Search Explained (Alan See, Networking Exchange Blog)

Onsite Local SEO

What NOT To Do On Local Business Websites (Chris Smith, Search Engine Land)

A Guide To Geocoding Images For Local SEO (Chris Smith, Search Engine Land)

10 Image Optimization Tips For Local SEO (Chris Smith, Bruce Clay)

Using Semantic Markup To Strengthen Your Local SEO Efforts (Mike Wilton, Search Engine People)

Local Search O-Pack and the Art of Title Tags (Mike Ramsey, Search Engine Journal)

SEO Checklist for Local Small Business Websites (Rae Hoffman-Dolan, Sugarrae)

Link Building for Local SEO

5 Geo-specific Link Building Tips (Kaila Strong, Vertical Measures)

10 Unorthodox Ideas For Local Citations & Links (Chris Smith, Search Engine Land)

3 More Unorthodox Ideas For Local Citations & Links (Chris Smith, SEM Clubhouse)

12 Tips For Using Press Releases In Local Online Marketing (Chris Smith, Search Engine Land)

How To Rank Nationally With Local Links (Ross Hudgens, Search Engine Land)

5 Sources of Links for Local Businesses (Geoff Kenyon, Search Engine Journal)

4 Link Building Strategies for “Too Busy for Link Building” Local Businesses (Brent Carnduff, Search Engine Journal)

Content Strategies for Local SEO

Blogging as a Content Strategy for Local SEO? – You’re Doing it Wrong! (Steve Hatcher, Axemedia)

Local Content Definition: What Makes Material Of Local Signficance? (Mirriam Ellis, Copy Local)

Google Insights for Researching Local Search Keywords (Tommy Redmond, Webbed Marketing)

Google Places

A Brief History of Features in Google Local, Maps and Places (slideshow) (Mike Blumenthal)

Google Places Basics: Listing a New Business – A Timeline for Launch (Mike Blumenthal)

8 Tips to Maximize Your Branded Presence in the Google Local Search Results (Mike Blumenthal)

Google Offers Up a Step by Step Guide to Deal with “We do currently do not support this location” (Mike Blumenthal)

The Untold Story of 2011: Google’s Significant Investments in a Google Places Support Structure (Mike Blumenthal)

9 Common Ways To Bork Your Local Rankings In Google (Chris Smith, Search Engine Land)

A Little Light Reading On Google Maps Ranking Factors (Andrew Shotland, Local SEO Guide)

Closed, Says Google, but Shops’ Signs Say Open (David Segal, The New York Times)

Do Google Places Listings Really Matter? (Steve Hatcher, Axemedia)

An Inside Look At How I Chose 1 Local Tire Shop Out Of The 7-Pack (Mirriam Ellis, Solas Web Design)

7-pack vs Blended Local Results – Split Testing? (Darren Shaw, Whitespark)

Google Places Cross Optimization Case Study (Bhawna Sharma, Milestone Internet Marketing)

Google Places Help – Verification Problems and Tips for Consultants (Linda Buquet, Catalyst eMarketing)

 Las Vegas Hotels: 7 Pack Place Page Review (Michael Dorausch)

Battle Las Vegas: Disappearing Hotels in Local Search (Michael Dorausch)

Hotels Lose against Google Local: Centroid Battle for Las Vegas (Michael Dorausch)

Google’s New Sentiment Phrase Snippets for Google Places (Bill Slawski, SEO by the Sea)

Citations for Local SEO

Top 50 Citation Sources For UK & US Local Businesses (Myles Anderson, Search Engine Land)

9 Secrets for Easier and Faster Local Citation Gathering (Phil Rozek, Local Visibility System)

Top UK Local-Business Directories (AKA Citation Sources) (Phil Rozek, Local Visibility System)

No Punctuation In Localeze And No Field Definitions In Bing Local (Mirriam Ellis, Solas Web Design)

Take Care with UK Local – A Data Flaw in Directory Sources (Nichola Scott, Search Engine Watch)

Google Places Citations: 5 More Tactics to Earn Links for Your Local Business (Rand Fishkin, SEOmoz)

How to Research Local Citations After Google Removed them from Places (Rand Fishkin, SEOmoz)

The Ultimate List of Local Citation Sites (Mike Wilton, Search News Central)

Reviews for Local SEO & SEM

Testimonials as Reviews – A View from the Field (Mike Blumenthal)

5 Tips for Responding (or Not) to “Fake” Reviews (Mike Blumenthal)

The Growth of Reviews In Google Places (aka Hotpot) (Mike Blumenthal)

Changes in Google Places and Reviews – What Does it Mean for the SMB? (Mike Blumenthal)

Review Management: 7 Tips on Avoiding Bad Reviews (Mike Blumenthal)

An Imagined Conversation with Google about Reviews, 29Prime & Sock Puppets (Mike Blumenthal)

5 Tips For Responding To Negative Customer Reviews Online (Andrew Shotland, Search Engine Land)

5 Tips To Get More Online Customer Reviews (Andrew Shotland, Search Engine Land)

Negative Reviews in Local Search: A Survival Guide for Businesses (Eric Edge, Search Engine Watch)

The Local Reviews Ecosystem — Threats and Opportunities Abound (Andrew Shotland, BIA Kelsey)

Google, Yelp and Why Review Counts are Meaningless (Matt McGee, Small Business SEM)

The 3 Pillars of Local Search Reviews (Mike Ramsey, Search Engine Journal)

Bing Business Portal

Bing Rolls Out Integrated Marketing Approach to Their Local Business Portal (Mike Blumenthal)

5 Reasons Search Marketers Shouldn’t Discount Bing (Jon Schepke, Search Engine Watch)

Complete Guide to Bing’s New Local Business Portal (Matt McGee, Small Business SEM)

Tracking and Monitoring of Local SEO

Tracking Offline Conversions for Local SEO (Eric Covino, SEO Book)

Tracking Traffic from Google Places in Google Analytics (Rebecca Lehmann, SEOmoz)

Local Search Statistics

30% of all Restaurant Queries on Google Are Mobile (Mike Blumenthal)

Eye-Tracking Google SERPs – 5 Tales of Pizza (Dr. Pete, SEOmoz)

Search Engines Top Local News Sites for Community Information (eMarketer)

Young Men Lead Location-Based Service Adoption (eMarketer)

Why Your Business Listings Are Probably Wrong! (Yext)

Research Shows Which Google Places Listings Get More Clicks (Research by Mediative)

How Users Search For Local Businesses + 5 Tips To Optimize Local Listings (Myles Anderson, Search Engine Land)

Harnessing The Power Of Online Customer Reviews For Local Business Growth (Myles Anderson, Search Engine Land)

The Numbers and Facts on Google Places Reviews (Phil Rozek, Local Visibility System)

Search Secures Recognition as Local Business Info Provider (Rob Young, Search Engine Watch)