Local Data Providers – Behind the Smoke

By David Rodecker

It shouldn’t surprise you that when it comes to Core Data Providers (CDPs), information really is power. If you aren’t already familiar with CDP’s, they are a select group of companies that most internet destinations rely upon for business information in the United States.

Knowing what your CDP can offer – and what it can’t – is essential when choosing the right service for your enterprise. To help you out, I’ve compiled some basic facts about the three major online information conglomerates, Acxiom, InfoUSA, and LocalEze (aka AMACAI).

This brief survey will give you a clearer picture of CDPs, their capabilities, and how to utilize them intelligently for your enterprise.

Core Data Providers Offer a Partial View of Some of the Story

In a study commissioned by local.com, we determined that each of the three CDPs is about 52% to 72% accurate. CDP databases have some intrinsic flaws resulting from their primitive sources – often a literal transcription of Yellow Page books that are out-of-date, incomplete, and fail to account for emerging businesses and services. The study evaluated data complete data sets from three mid-sized cities: Irvine, CA; Trenton, NJ; and Philadelphia, PA. I can’t (yet) publish the entire evaluation and methods used, but here are some interesting statistics from the study:

Core Data Provider – Data Quality Comparison

Acxiom AMACAI (Localeze) InfoUSA
Listings (Sample Size) 89,952 87,340 80,159
Null Categories 15.69% (14114) 14.11% (12328) 0% (0)
Null Street Addresses 15.28% (13744) 12.96% (11317) 3.86% (3095)
Null Phone Numbers 0 0 0
Duplicates 0.36% (325) 6.32% (5516) 13.48% (10806)
Categorization Accuracy 95.96% 72.73% 89.90%
Phone Number Accuracy 73.24% 60.61% 77.08%
Business Name Accuracy 59.13% 46.46% 66.67%
Street Address Accuracy 43.87% 29.29% 52.08%

This basic flaw in their information gathering process led us to determine these seven basic flaws of most CDPs:

They’re Incomplete. Many business listings are missing, making them an unreliable source for all the information you need.

They’re Unreliable. These services are littered with businesses that no longer exist, or have changed names, ownership, and operations. We’re not just talking about recent one’s either, many of them have been out of business for several years.

They’re Inaccurate. Records are out-of-date – an old name here, an old phone number there – which can lead to hours of frustration for you and your company.

They’re Grammatically Incorrect. Typographical errors are common, making searches difficult and your life harder.

They’re Partially-Accurate. Extended data fields – URL, hours of operation, key names and positions, etc. — are not available for most business listings, and key details are absent.

They’re Messy. Lack of standardization in fields like business category and products/services. The classification systems have swelled to uncontrollable levels, with 10′s of thousands of categories riddled with duplicates for example, there are nearly 200 standard yellow page headings (SYPH aka categories) associated with “Storage”, here is a sampling:

It seems that rather than use multiple categories to describe a listing; multiple business lines have been aggregated to a single category.

They’re Slow. In the timeliness category, CDPs get a definite “F.” It can take months or years for listings to be updated or corrected – and in our fast-paced times, that’s a major problem. The CDP’s usually turn data each month; however the updates on websites are completely out their control. For most web destinations, comparing and updating 20 million records is quite an undertaking so they rarely perform that task even though they have licensed the data.

Local Destinations Are Challenged to Rely Upon Core Data

These seven flaws lead to major end-user problems for anyone utilizing a traditional CDP.

Many Web sites license CDP databases to show business listings – but given the partial data and messy architecture that bog down many CDPs, end-users often face a less-than-satisfactory search/browsing experience. In fact, chances are that users will choose a different tool for their next local search experience – and that’s the last thing you want.

Data updates are also difficult given this model. Although the CDPs publish their databases on a monthly basis, many Web sites are incapable of regularly and efficiently re-importing these massive databases – if they’re able to import them at all, that is. This leaves your Web site displaying old, inaccurate information, and ignoring important new locations and information (locations, products, services, hours of operation, phone number, and/or current address).

Does It Add Up?

Even if your information does make it to its destination on your site, the output is generally very basic. The exact same information is probably displayed on a number of other Web sites, leaving end-users to ask, “Why should I use your site when the same data’s available everywhere else? What’s special about your service?” Additionally, when and if search engines crawl the page, they will see this information as duplicate content, thus eliminating its SEO benefit.

Given all these objections, you might think I’m advocating against Core Data Providers. Let me say now: that’s not the case! Despite their limitations and short-comings, CDPs play a crucial role in the world of Local Search. In fact, we use them as part of our service. They are a long-term investment that can perform if you use them right. If you know how to intelligently work with CDPs, and if you’re aware of their benefits, then you can utilize them to increase your online presence positively.

So, considering using a CDP for your business, keep in mind:

1) Ensure that the business information you publish across the web is congruent to that held by the CDPs.

2) Submitting current and accurate business information to Core Data Providers is the foundation to any effective local online marketing campaign.

3) Don’t expect results from directories that rely upon the CDPs as an exclusive source of business information. These sites have little to no online value.  In our subsequent article, we’ll address how you can help destinations deliver some results in search optimization.

The Benefits of PPC

By Laure Muller

Chances are that if you run a business of any sizefrom a plumbing company in Louisiana to a limo service in New York City- you’ve considered executing a Pay-Per-Click campaign. And it’s no wonder – PPC is one of the best ways to get your business out there and on users’ screens!

If you run a successful Pay-Per-Click campaign, you can:

1. Be found online instantly!

2. Increase your sales and find hot leads!

But again, that only works if you know how to launch the right kind of Pay-Per-Click campaign – with the right tools, brains, and strategy to get the job done right!

“What exactly is PPC?”

Pay-Per-Click, or PPC, is one of the easiest ways to advertise your online business. It goes like this: when someone searches for a related keyword to your business on a major search engine, your ad will appear at the very top or on the right side of the results page. These ads are generally called “sponsored links”.

The most important thing about PPC is that you only pay when someone clicks on your ad. You can set up a maximum daily budget, meaning you decide how much you want to spend on your PPC advertising!

Ideally, PPC campaigns offer:

1) Immediate online visibility;

2) Flexibility in budgeting and planning. (You can turn the campaign on/off whenever you like.);

3) Maximally targeted audience reception – allowing you to choose who sees your ads, when, where, and how often.

It takes less than a day to create a PPC advertising campaign. Once active, your ad will appear in less than 5 minutes on the Internet! Compare that to traditional advertising, with its long delays between concept and execution.

“Why is it important for me to run a PPC campaign?”

You are a local business and you want to be found online by clients/customers around your targeted area, right? PPC will make it happen! It’s all about targeted execution: using a PPC campaign, you can specify either a geographic perimeter or a radius (10, 20, 30 miles or more stemming from your physical business address) in which your ads will show.

Also, be reassured that PPC advertising will not require any changes to your Web site. In fact, even if you do not have a website, a PPC campaign is still possible because of very affordable landing page options provided by SEM companies.

Besides instant results, PPC advertising allows for great flexibility. You can modify your account at any time, adjust your budget instantly, change your targeted geography, determine exact hours in ad scheduling (24/7, only from 8am to 5pm, etc.), and much more. The power to craft a campaign specifically for your business needs is what makes PPC such a powerful marketing venue for your enterprise!

“This sounds great! Now, how do I start a PPC campaign?”

Our service, Local Splash, is a turnkey solution for executing an effective PPC campaign for your business. Our PPC experts use specific PPC tools to carefully select the best-performing and the most relevant keywords for your company.

Our team is Google AdWords Qualified: that means that according to Google, our team graduated “summa cum laude” in crafting effective PPC campaigns using Google’s powerful services!

Our expert team will manage your PPC campaign from top-to-bottom; they’ll find the best keywords to bid on and determine the exact keywords that people would type in search engines to find you.  We will create pertinent and compelling ads for you. We’ll also build a user-friendly, marketing-savvy, keyword-rich, and totally optimized landing page for your company that displays all of your business and contact information!

We will help you determine the best daily budget for your campaign and rest assured that we will not go over it. If you don’t want to spend more than $10/day, fine! We will set $10 as your maximum daily budget in our system and you will not be billed over this amount, we guarantee it!

Once your LocalSplash account has been created, you will be able to instantly access and manage your PPC data- including the number of times your ad was displayed, clicks your ad received and the average position of your ads. Additionally, we will show you precisely what keywords drove traffic to your Web site!

At Local Splash, we have copywriters specialized in PPC ad copy and the best experts to create and manage your PPC account!

A successful PPC push can mean major momentum for your business – so why not rely on an expert team with a proven track record of successful campaigns? Don’t go it alone: give us a call and turn clicks into revenue today!

Remove a Bad Review in Google

Bad reviews in Google Local Business Center, Yahoo! Local, MSN Live Maps, Yelp or any other online destination are a serious matter to the business and to potential customers who read them. There are many things you can do to reduce the amount of bad reviews you get and a few things you can do to remove bad reviews in Google (or elsewhere). However, the best action you can take to minimize the impact of a bad review is to simply acquire numerous positive reviews.

How to Remove a Bad Review in Google

This tutorial will show you how to manage bad reviews and obtain positive reviews. If you do receive a bad review and for good reason, we recommend working with your colleagues to minimize future similar reviews by any means possible.

How to Remove Bad Reviews in Google Local

The Google Local Business Center (GLBC) and Google Maps channels offer searchers an alternative to traditional and online Yellow Pages. Because the search engines offer the ability for users to critique businesses via reviews, it puts non-internet savvy business owners at a disadvantage against malicious competitors and unintentionally dissatisfied customers.

If you find your listing victimized by these perpetrators, the first thing to do is to not panic. Here are some ways you can help eliminate these reviews from the search results:

  • If your negative review comes from a 3rd party website, such as TouchLocal.com, Yelp.com or CitySearch.com, you can contest the review at the source.
  • If the review comes directly from a Google user, you can incentivize the patron to remove the listing with a discount coupon or complimentary service. These types of customers will typically change their review to positive if the service was better the second time around.
  • You can ask new customers to post positive reviews if they were happy with your service, and tactfully select “No” next to the question “Was this review helpful?” if they disagree with the negative review.

Below is a snapshot of a negative review in Google Local Business Center. We’ve circled the “No” to have happy customers help you remove the negative review.

Click No to Help Remove a Bad Review from Google

How to Get Positive Reviews in Google

These techniques to get more positive reviews in Google also work for Yahoo! Local, CitySearch.com and other business review websites and is very easy. Try one or all to get better reviews to bury those negative ones that never seem to go away.

  • Have a takeaway postcard with a discount coupon good on the next visit for customers you know had a good experience.
  • Capture your customers’ email addresses and send out periodic discounts and offers. Mention on the offer to please give positive reviews by clicking a link that takes them directly to the page to leave a review.
  • Give free workshops and hold customer appreciation events. Have a computer on site and ask patrons if they wouldn’t mind doing a video testimonial and/or give a quick review of the business on one destination (such as Google Local Business Center).
  • Hold or participate in charity events and capture emails of those people who used a service or purchased a product, then follow up with a coupon and link to the review pages of choice.

Removing and burying bad reviews from Google can be extremely frustrating. Remember not to panic, do your best to contest the review or incentivize the reviewer, and focus as much as possible on getting every satisfied customer to post a positive review.

Great tips like these are always available through your Local Splash local SEO services Account Manager. Call us today to learn more about extended SEO services.

Rank Higher in Google Local Business Center

For maximum web traffic, submitting your business to Google for placement in their search results requires much more than simply requesting inclusion. There’s a mathematical formula behind everything Google displays. In this tutorial, we will help you understand exactly what it takes to rank higher in Google Local Business Center (GLBC) for search terms that could generate more leads and sales for you from Google’s search results pages.

Ranking Factors

Content is King

Having great content themed around, but not stuffed, with search terms that your prospects are querying to find your business is key. Even if you rank high now, without good quality content, Google will eventually penalize you for having a high bounce rate from their search results, or worse, if users vote/review your business negatively as a result of poor content.

For a local business, it’s important to include your business address and phone number in the global footer of your website, near the copyright (or anywhere really), to correlate with the other websites (and the GLBC) that share your business information. There are two critical fields on every page of your website that should have service-related keywords in them: The HTML Title Tag and the H1 Heading Tag. Both should be different, but contain the keyword someone in the context.

Example of a Good HTML Title:
Call Joe’s Plumbing in Anaheim, CA for Fast, Quality Service

GLBC Categories and Details

As you start filling out your Google Local Business Center listing, you’ll notice several fields. We at Local Splash literally live our lives mining the best content to put into these fields to support our goal of ranking higher.

If you want to rank higher in the GLBC, you’ll need to do some research. First of all, you’ll want to spend some time in the free Google Keyword Tool for AdWords to determine which keywords hold the highest search volume and directly correlate to your service (don’t use the term SEO if you sell SEO Services, use the term SEO Services instead).

Next, spend some time querying for the terms you believe will drive the best results from Google then analyze the categories of the companies that come up in the Google Local Business Center for those terms (pay attention to the order of the categories). Our leading-edge technology automates this process for you, insuring your categories are set and recalibrated continuously. This has been known to drive your competitors absolutely crazy.

Snapshot of the results our program produces for the best categories around the search query “local seo services”:

Google Local Business Center Categories

Details are important; just don’t stuff your profile with keywords. Work to get 100 percent completeness in Google Local Business Center. Videos, images, and so forth are all important. Our team of Local SEO Experts have already defined the best possible fields for hundreds of common industries, which explains why so many of our new customers come from referrals from happy customers.

Websites / Web References

As with Organic Search Engine Optimization, local SEO requires visibility (aka: links and mention) from other related websites on the Internet. The best place to get that visibility is from individual profile pages on other local-related websites (ie: Superpages.com, Clush.com, Yelp.com, Yahoo! Local, MerchantCircle.com, and so forth). Done with a little SEO magic, those profiles pass a “vote” to your website with verbatim business data, reinforcing your website’s creditability with the search engines.

If you didn’t get all that, just remember: The more other websites discuss your website in a way that influences the search engines to better understand your topic (also called “service tag” in the local SEO world), the more likely Google will be to reward your website with higher ranking.

User Reviews and User Content

We have seen a number of businesses rank higher than a business with dozens of reviews. So before you get nervous about the importance of reviews; keep in mind that this focal point is not the most critical ranking criteria.

That being said, a listing with more reviews is more likely to be clicked on than a listing with no reviews. Encourage your store visitors to post reviews, offer an online coupon that starts with instructions on how to review the business in Google Local Business Center. Capture email addresses for repeat customers and ask for reviews in periodic newsletters and offer emails.

Scrutinize Google Local Business Center Traffic Statistics

Once you’ve verified your listing, or have had us verify your listing with you, use the data in the GLBC to see if your business profile is appearing for the search terms you are targeting. The Google Local Business Center offers some incredible data, including Impressions (how many time your listing appeared for a query) and Clicks (how many times a searcher clicked on the listing to read more).

See a Screenshot Below

Google Local Business Center Traffic Statistics

Our Local SEO Account Specialists spend an exhaustive amount of time trying to understand the GLBC traffic statistics to insure that our customers are appearing for the best possible keywords. Our Local SEO moguls (we like to call them “SEO Scientists”) analyze this data across thousands of accounts to create formulations and best practices, all of which are integrated into our leading edge local SEO applications.

Save Time and Money with Local Splash

The good news is that anyone can do their own search engine optimization using the strategies and techniques mentioned above. The bad news is that the time it will take for someone new to local SEO is a lot longer than you might think. Worse, for these techniques to sustain longevity, they need to be repeated month after month, meaning every month you’ll have to spend more time researching new destinations and insuring that you are using the right details in your GLBC profile and so forth.

Put your local SEO on autopilot with Local Splash. Our program is affordable and will save you valuable hours that you could be applying to running your business. Let our pros and our leading edge software handle your local search engine marketing, so that you can go back to business as usual while we help you rank higher in the Google Local Business Center. Call today at 877-635-6225 for more information or click Sign Up Now above.

PPC Landing Page Best Practices

This tutorial on PPC Landing Page Best Practices was written by the local SEO services experts at LocalSplash.com. Executing the strategies on this page could result in lower costs and improve keyword performance in Google AdWords, Yahoo! Marketing Solutions, and Microsoft AdCenter.

How Search Engines Define Quality

Pay-Per-Click is no longer a bidding war thanks to the term “quality”. Google wants to return the most relevant search result to their users so they have defined criteria to reduce costs for those advertisers focusing on quality. For Google, this is defined as “Quality Score”, for Yahoo! it’s “Quality Index” (don’t get the two confused, account managers get snuffy when you use the wrong term).

To achieve higher quality in either engine, it’s recommended that you start by creating isolated pages on your website specifically for A/B testing landing pages. To keep these pages from being indexed in the organic search engine results, create or update a robots.txt file containing the following snippet of code:

User-agent:*
Disallow: /{adwords or other category name, remove brackets}/

How to Get Better Quality Scores (or Quality Index)

Below is a list of things that you can do to achieve improved performance from your PPC Campaign. Note that you cannot control the search engines, but implementing these best practices have shown improved results according to the search engine marketing community and particularly MarketingSherpa.com.

Higher Landing Page Conversions

There are other enhancements you can make to improve quality and conversion, the above lists just a few. The single most important landing page factor is conversion.

The best examples of websites made for conversion that we have found are listed below. Notice the clean appearance, videos, call-to-action (“Buy Now”) buttons, etc. You’ll notice that these landing pages don’t look like typical websites. They are built specifically for higher conversion rates.

Sample PPC Landing Pages / Websites

The “As Seen on TV” industry has done a great job with optimizing landing pages. Apply some the principles used above toward your business to get the highest possible conversion rate.

The above PPC landing page best practices will not only help you to improve visit-to-purchase ratio, but may also lower your costs on PPC engines such as Google AdWords, Yahoo! Marketing Solutions and Microsoft AdCenter. Quality is everything, A/B testing to get the best possible quality with the search engines will make the difference between a successful campaign and an expensive, less successful PPC strategy.

Online Reputation Management

This article by local SEO services company Local Splash describes considerations and actions for online reputation management, the art of reducing and eliminating negative search results from search engines such as Google, Yahoo! and MSN.

When was the last time you did a search in Google for your company name? Try it now. Do you see anything negative appear about your company, such as a blog post from a customer who might have had a less than desirable experience? How about a BBB page or the infamous RipoffReport.com? These search results could be detrimental to the success of your online marketing campaign, especially for those users who understand that the true value of the Internet is not just information but diligence.

So How Do You Manage Your Online Reputation?

You can start by looking at your business and practices to make sure there is nothing in the way you do business that could be seen as unethical. If there are negative search results in Google, is there a common theme? Are your prices too high or your customer service not adequate? Look inside first.

Then apply some SEO best practices. Start by jotting down the web address of every website that appears when you search for your company name (or product brand). Spend some time analyzing the titles of the listing in Google and the page theme. Once you’ve compiled a list of web addresses, with columns for titles and page themes, start semi-duplicating the negative strategy but with positive content. Here is an example:

Sample Bad Listing

PizzaReviewGuy · Chucky’s [not] So Cheese Pizza
NEVER go to Chucky’s because the pizza is awful. We reviewed this place and were not impressed
by the service or food quality…
pizzareviewguywebsite.com/chuckys-pizza.html

Sample Replacement Listing

Read Reviews of Chucky’s Cheese Pizza in Anaheim, CA
NEVER go to any pizza restaurant in Anaheim until you have tried Chucky’s Cheese Pizza because
the pizza is fantastic. Read more reviews of this place and were prepare to be impressed…
betterpizzareviews.blogspot.com/chuckys-pizza.html

Follow this same exercise for each negative posting that appears in the search results. When done, you’ll need to do some periodic linking to move up the visibility of each new page you created on the web to push down the negative search results. If you link too quickly or all at one time, your page is likely to be filtered from the search engine results.

Link Strategy for Online Reputation Management

Follow these steps to build links over time to improve ranking in the search results. There are thousands of ways to build links, here are just a few methods that may make a difference:

  • If you posted your better page on a blog, submit the RSS Feed all over the Web
  • Favorite the page in delicious.com, digg.com, stumbleupon.com, and other social bookmarking websites
  • If you use Twitter, Facebook, LinkedIn, MySpace, or any other social network, get some linkage from those locations
  • Find forums and blogs that talk about your industry, product, or service and engage in dialog with that community using a signature containing a link to the post(s) you want to have visibility
  • Have all of your friends and family (not all at once) start linking from their own websites and social profiles.

Over time, Googlebot will hit your better listing through all of the above links far more time than they will hit the negative listings and eventually you will move up.

Repeat with other destinations, such as:

  • Squidoo.com
  • WordPress.com
  • MySpace.com Blog
  • Blogger.com
  • LiveJournal.com
  • Thoughts.com
  • ClearBlog.com
  • and more…

Online Reputation Management and the BBB

You might as well be competing with Wikipedia in the search results if your brand or company name appear in a BBB page at the top of the search results, since websites as large and reputable as BBB.org and RipoffReport.com have much more Google PageRank and trust with the search engines. They are also more likely get higher traffic volumes than an newer, smaller website.

To remove these 800 lb websites from the search results, start by contacting them directly to see what can be done. If you don’t get a response that includes an action item list, you’ll probably have to contact a lawyer and battle them out in court. The 1st amendment protects individuals, but only to the extent that it doesn’t become slander or a number of other scenarios your legal counsel will most-likely tell you about.

Worse Case Reputation Management Solution

The world is online. If you have multiple negative listings regarding your brand (or someone else using the same brand name), the worse case solution would be to change your name. Be sure to trademark your name if possible, so that your competitor doesn’t try to use your name in their own brand strategy later.

Understanding how important online reputation management can be is the first step to preventing negative search listings in Google. But if it happens to you, executing the strategy above could make an impact over time to the ranking of negative listings, while at the same time improving your own brand marketing campaign.

Free SEO Guide

Free SEO GuideGet higher placement in the organic search engine results with our Free SEO Guide written by our Owner, CTO and resident Local SEO Expert, Dave Rodecker.

Learn 5 power techniques you can implement TODAY to get higher ranking in Google, Yahoo!, Bing, and other search engines where people are actually searching for your product or service.

Also included in this Free SEO Guide is a list of what not to do to your website and off your website to avoid being penalized or banished from the search results. This guide on search engine optimization is your completely free. All you need to is provide us with your email address so that we can send the guide right to your email Inbox. Optionally, you can provide us with your phone number if you’d like someone on our team to call and discuss your SEO needs.

Where Should We Email Your Free SEO Guide?