Performing the Perfect Citation Audit Guide

Duplicate citations, business info inconsistency and low-quality sites are the main reason businesses don’t fully receive the value of a citation. Those problems can cause a rank drop on SERP’s and confusion for the visitors who might see the wrong info

To determine the problems with your citations, we need to perform a full citation audit to track all existing instances. This guide is what our team for Loganix uses, and we have great results. This is a combined manual and automated audit, to ensure we track all possible existing citations.

Tools Needed

  • Spreadsheet –  Prepare a spreadsheet, it could be an excel sheet, a google spreadsheet or whatever you prefer as long  as you can find it easy and accessible. We prefer using Google Spreadsheet because we can easily share them with our clients and multiple people can collaborate at once. Here is a sample report template we have https://docs.google.com/spreadsheets/d/1cdv5yIdxcu8kddGyzHzkGJOLefOeO62lN1kkxwpcutY/edit#gid=684413488. Make sure to include a client intake form to get the needed information.
  • NAP Hunter – This free tool from Andrew Shotland helped us spin our NAP variations. It also save you from missing any NAP combination during google search. You can download an extension to your chrome browser here.
  • Scraper (or Good ‘Ol Fashion Elbow Grease) – We built our own scraper using macro codes (unfortunately this is not available to public). You can use Whitespark LCF or BrightLocal Citation Tracker. In this demonstration, we will be emphasizing doing things the old fashioned way, as we want the fullest picture possible. We will demo how to use LCF or BL’s tool, but only as means of making twice certain that we didn’t leave a single citation behind, important or otherwise. If they are indexed in Google, we will find them.

The Process

Data Gathering

You need to collect all important data about the business and record it on a spreadsheet. We need to identify the current/correct business name, address, local phone # and website. We also need to know if the business has another location active or not. Has the business moved from one location to another, been rebranded or changed phone? We need to know this information in preparation for the audit that will take place. All of this information will help us categorize every NAP variations we might found during the audit.

We also need to find out if the business uses other data provider services such as data aggregators like yext, mozlocal, UBL and other similar services. These data providers automatically build citations to a number of sites. If we’re aware that the business uses any of these services, it can give us an idea on which sites the business is already submitted.

Check our sample client intake form here. The more information you get, the better the results of the citation audit.

Collecting NAP Variation

We usually collect NAP variations during the citation audit. Every time we find a different name, address or phone # that the business used, we note it on our spreadsheets and will use them for searching existing citations. In some cases, the business owners are aware of the old business info, which they will provide during data gathering. Some Won’t know.

Below are some tips on how to collect all possible NAP variations that the business used on different citation sites:

Via Map Maker

image22

  • Click the “Details” and then click “History”. You can view how many times this business has been edited.

image36

  • Click “Show all changes” to view the details on those changes. Check for different modifications if you can see some old business NAPs

image24

Via Better Business Bureau

This is an interesting tip from Phil Rozek. He found out that old business info often can be hosted on bbb.org. Here is the link to the article.

  • You can go to google and do a search query. Example “site:bbb.org + business name”

image47

  • Check your business profile and look for additional info (additional phone, location and alternative business name)

Via Yellowbot and Merchant Circle

Interesting info from Darren Shaw’s WBF: When two sites don’t merge business profiles and instead create duplicate profiles, we can use these site to search for old business info. Just go to the site and use the site search.

Manual Audit

Open your chrome browser and click the NAP hunter icon.

image44

Enter NAP variations one at a time. So for the starter, let’s use the current correct business info. Enter the business name, street address, suite # (if present) and the phone #.

image45

Click the “Hunt” button. Notice that it will open up several tabs in your browser.

Note: It is best not to include the complete address. Try a different query like adding only some portion of your address. example “32183 Dupont” or “Dagsboro, DE”.

image16

What NAP Hunter does is to automate search queries using the NAP that you provided. One tab is for one google search query.

image46

This is a helpful tool because it took away the manual job that we usually do before, where we prepared a notepad and wrote down all the possible Google search queries like the sample format below:

“Business Name”

“Business Name” + “Phone”

“Address”

“Address” + “Phone”

“Phone”

“Business Name” + “Phone”

“Business Name” -”Phone”

Note: Don’t make too many searches via NAP Hunter in a short period of time. Google may detect that you are using an automated tool to do the searches and might block you from using Google search for a few hours. Stick to 3-5 searches per minute.

Check each tab and visit every link. Check if the link directs you to the citations for your business. Check for the business info and record it to the spreadsheet.

image40

If it matched  your business NAP record, it is correct.

image34

If it doesn’t, check the incorrect business info and note it on your report.

image43

image05

Some search results are not related to your business. Make sure to match it to your current business info or previous business info. If it does not match either one, don’t bother to include that to your report.

Do not stop after checking the business NAP on one specific citation profile. Check other information such as website link, category, business hours and other details. Check the image below where I also point out other business info.

image00

I found some of the info was missing, but since I we don’t know if that website allows us to enter more business information, we need to open another business profile in order to verify. Below we see that it is possible to include website links, payment modes, services and etc.

image32

I added a remarks on my audit report, suggesting to my client that it is possible to add more business details on that citation profile.

image13

Note: Some sites allow us to include limited business information on “FREE” accounts, meaning you have to upgrade in order to display more details about your business. Paying probably isn’t necessary in most cases. Just leave your profile as it is.

Check the next tab once done, and make sure not to visit the same link again. The link you visited will automatically change the font color from blue to purple, indicating you’ve already visited that link. This will save you so much time in your audit.

image08

Make sure to record every new NAP variation that you found during the audit. Every NAP variation will be used as search query using NAP Hunter.

image30

Once you’ve finished checking all the links on all the tabs, run another NAP Hunter using the next variation.

image25

Remember, the number of times you run the NAP hunter is based on the number of NAP variation you found. if, every time, you found different NAP variation, it is subject to the audit and should br run through NAP Hunter. This way we can track all possible existing citations.

Also remember, if the citation is not indexed (Google hasn’t found it and stored it in their search results), then you won’t find it this way. This is why when we conduct a citation building campaign, regardless of the findings in our very thorough citation audit, we perfect a search using the directories’ search function to be sure they aren’t yet submitted.

Data Provider Check

Most data provider services support US businesses and might not be available for other countries. This includes US aggregators such as Neustar Localeze, Acxiom, InfoGroup and Factual. Other data providers are UBL, Yext and MozLocal. It is best to do audits on these site because they distribute business info to other sites. To better understand where these data provider send business data, here’s an article from moz.

If you will be cleaning up all inconsistencies after the audit, make sure to start with these data provider. If not, no matter how many times you try to edit the incorrect business info on one specific site, it will revert to the same business status it had before you fixed it. This is because the source (which is the data provider) is still sending incorrect business info to that site.

You need to do a site search to check if your business is present on these data providers, because they may not appear on Google search results. Below are some quick steps on how to do it for specific website.

How to check on Neustar Localeze

image38

If no business profile is present, you are free to add a new  business (unfortunately this is not free). If you found an existing business profile, record it on your spreadsheet.

image23

How to check on Acxiom

  • Go to http://www.acxiom.com/, mouse over to “products”. Under “data” click “Local Search” . Then enjoy another new page again (haha). The easiest way is to go to this link https://mybusinesslistingmanager.myacxiom.com/
  • Search your business using its phone number. Unfortunately the MBLM has been down for almost a month now at the point where I am writing this guide so I can’t provide a screenshots

image35

How to check on InfoGroup

image18

How to check on Factual

image15

How to check on YEXT

image26

  • Visit every link and check for the business info.

image28

  • Audit every citation from YEXT and record it to your spreadsheet.
  • Recording those citations from YEXT to the spreadsheet is based on the profile status.
  • For “Not Verified Through Yext” we just includes it on our manual audit because YEXT does not control these citations.

image03

  • For “PowerListings Synced” We sort it as such because to prepare it for the cleanup. YEXT has control over those citations and the only way you can fix it is via YEXT dashboard.

image33

How to Use Moz Local

Moz Local Search will help you to check if your business is listed on top citation sites, and especially the top aggregators. You won’t have to do s manual aggregator check. It will also give you an idea of the current status of each profile.

  • To search, just login to your Moz account.
  • Go to “Check Listing” and enter your “Business Name” and “Zip Code”

image19

  • Click “Check my Listing” button and choose the most accurate business in the results

image06

  • Now you can view the current status of your business profile, and where it is listed.

image42

Note: Remember if you have multiple NAP variations, be sure to use them and check those data provider sites.

Backup Automated Check

To make sure that we track every possible existing citation, we use our own automated scraper. We do this after a manual audit to check if there are citations that we missed so they can be included in our audit.

You can check Whitespark Local Citation Finder or BrightLocal Citation Tracker if you want to automate your our citation audit. Please note that neither tools is built to find every citation, but instead to deliver only results that these tools builders deem important, without overloading you with data. To get a truly full view of your citations, it is recommended that you do a manual search yourself, in Google, as we have demonstrated.

Here’s how to use Whitespark for Citation Audit

  • Go to http://www.whitespark.ca/ and login to your whitespark account.
  • Click “Local Citation Finder”
  • Go to “Business Search” tab and enter your business info

image17

  • Click “View Search Results”

image31

  • Click “view results”

image39

  • You can now view all citation found by whitespark. You can get a csv copy by click “Export” links.

image09

How to Use BrightLocal for Citation Audit

image21

  • Click “Create New Report”

image11

  • Enter all required business info.

image29

  • Then click “Run Citation Search”

image27

  • Wait for your search to be completed

image10

  • Once completed, it will display the # of active location your business has and potential citation sources you can use if you’ll be doing citation building in the future.

image02

  • Click “View Report”

image41

  • Click “Active Citations”

image14

  • Below you can view the existing citations found by BrightLocal

image37

  • You can also export a report to type that works for you.

image04

Specific Site Search

This process is usually performed during the actual citation building campaign, because it will take forever to do a site search for all citation sources. Whenever we want to list a business on a specific sites, we do a site search before we add the business. Not all citations have been indexed by search engines, especially if those profiles are new or the citation site has blocked search engines from scraping its website.

You can do it by going to Google Search and searching for your business on a specific sites. Sample keywords would be: site:[domain name] [business info]. In the below image, I used the phone #. You can use business name to double check:

image20

In this example, no results appeared

image07

To double check, let’s do a search using the website. Just go to that site and use the search box to search for your business. Notice we found 2 citations which never appeared on Google results

image12

Categorizing NAP Variation

There are plenty of scenarios to consider before labeling a citation “Correct” or “Incorrect”. Usually if it matches your business NAP, we automatically we record it under “Existing Correct Citation”. But what if there is incorrect info in the NAP? what if there is a slightly incorrect business name? Below are some scenarios and our judgement:

Note: Our categorization of the citation is based on the business NAP. If ever a citation has incorrect business info except the NAP, we add a note to remarks. It is like giving our client a recommendation on what needs to be done in a specific citation.

image01

#1 Matched all business NAP?

We automatically label it as “Correct NAP

#2 The business name, address or phone is incorrect?

We add it to “Existing Incorrect Citations” and add a status depending on the incorrect info (Incorrect Name, Incorrect Address, Incorrect Phone)

#3 None of NAP matched?

If it did not match any business info (current or previous) then it is likely not worth it to include in your audit.

#4 Slight error on business name, address and phone format?

Here is a great article from whitespark that we are using on proper NAP format. Here is the list of acceptable NAP’s

Address and phone format might be different for other sites or other country. Make sure to check other business profiles listed on that site.

#5 Existing citation used a toll free phone or other active phone instead of main local phone?

We do not label them as incorrect, but we make sure that we sort it from the others and add a remark that it uses another active phone. So that if the client want to modify the phone it would be pretty easy to determine which citations need to dealt with.

#6 Duplicate Citation?

If we find duplicate profiles, we choose the best one based on factors like if that citation has a great amount of good review versus to none, or the other has complete business info.

For business categories like legal, real estate and doctors, it is ok to have a citation for the brand and a citation for each professional under that business.

#7 Business shares the same address?

Often you encounter this for businesses inside a mall or a building, but as long as it is a completely different business from yours and you don’t share the same phone, this will not cause any problems.

Conclusion

There are no such thing as perfect audit. As I earlier explained, if they are not indexed, you won’t see them. The spread of bad info can be maddening. Even if you kept a record of your existing citations, some site may scrape your info and create a citation without your awareness. You need to stay on top of it. We always recommend running a quarterly citation audit. You will sleep better knowing your citations aren’t being copied and manipulated.