Worksheet / 2 min read
The Citation Tracker
A simple worksheet for building and maintaining your business listings, so you know what's claimed, what's consistent, and what still needs fixing.
On this page
Local Reach One built this tool for Florida home service owners working through a local visibility management system. Use it to make one part of how customers find, trust, and choose the business easier to inspect and maintain.
Building citations by hand works, but only if you track them. Without a record, you forget which sites you claimed, lose the logins, and never notice when a listing drifts out of date. This worksheet keeps the whole effort organized. Copy the structure below into a spreadsheet or document, and fill in a row for every listing.
01What to track for each listing
For every site you list on, record these:
- Site name: where the listing lives (Google, Yelp, your chamber, and so on).
- URL: the direct link to your listing there.
- Login or email used: which account controls it, so you can find it later.
- Date claimed or created: when you set it up.
- Status: claimed, pending verification, needs fixing, or done.
- Consistent? yes or no, checked against your NAP master sheet.
- Notes: anything specific, like a category to fix or a verification still pending.
02The core listings to start with
Create a row for each of these first, since they carry the most weight:
- Google Business Profile
- Apple Maps
- Bing Places
- Yelp
- Better Business Bureau
- Foursquare
- Yellow Pages
03Then your trade and local listings
Add rows as you claim them:
- The trade directories that fit you (for example Angi, Houzz, Thumbtack, Porch)
- Your chamber of commerce
- Local business directories for your city or county
- Supplier or manufacturer "find a pro" pages
04How to use it
- Work at a steady pace, a few listings a week, rather than a burst.
- Check every listing's details against your NAP master sheet before you mark it consistent.
- Revisit the tracker a couple of times a year, and whenever your business information changes, to keep everything accurate.
The full method for building citations by hand is in building citations manually. For which sites are actually worth your time, see the citation short list for home services, and pair this with the NAP master sheet so every row checks against one source of truth. The reasoning behind consistency is in NAP consistency.
Keep going
Use it with these lessons
Building Local Citations Manually (the Free, Slow, Right Way)
The free, slow, right way to build citations: the core eight sites, local and trade directories, one listings email, and a tracking sheet that keeps it honest.
GuideThe Citation Short List for Home Service Companies
Which local citation sites are worth your time as a home service business: the universal core, the trade-specific directories that matter, and the ones to skip.
GuideNAP Consistency: One Version of the Truth
Why one exact version of your name, address, and phone number matters, where listing drift comes from, and how to audit before you build.
Put the worksheet in context
Find the visibility gaps this tool should help you fix
The free Local Visibility Audit shows what nearby buyers can see, where confidence breaks down, and which correction deserves attention first. The findings are yours whether or not you hire us.
