Home / Templates / Local Ranking Change Log
Free worksheet

Local Ranking Change Log

A dated log of every profile, website, and review change alongside the share of local voice before and after, so you can tell which actions actually moved the map.

Download the worksheet (.csv)

Reviewed for 2026, updated September 8, 2026.

Local rankings respond to changes over weeks, not hours, and if you change five things at once you will never know which one worked. The fix is boring and effective: write down every change with the date, note the grid figure before you made it, and come back thirty days later to record the figure again. Over a few months the log becomes the most honest record you have of what moves your market and what does not.

The worksheet uses share of local voice (SLV), the percentage of grid points where the business appears in the top three for a term, because it captures the shape of the map better than a single average rank. Read the before figure from your baseline grid and the after figure from the same grid, same terms, and same device thirty days on. The example rows show the kinds of changes worth logging, including outside events you did not cause, since a competitor opening nearby explains a drop just as well as anything you did. Our guide to reading grids and reporting progress (/guide/) and the article on reporting local SEO to a client (/blog/report-local-seo-to-client/) explain how to turn the log into a monthly report.

DateChange madeAreaTerms affectedSLV beforeSLV after 30 daysNotes and verdict
2026-09-08Baseline grid recorded, no changes yetTrackingAll tracked termsYour figureNot applicableSave an export of this grid; everything below is compared to it
Your dateCorrected primary category to the most specific true matchProfile: categoryBare category termYour figureYour figureCategory edits often show within days; watch the whole grid, not the office point
Your dateAdded two secondary categories for services actually offeredProfile: categoryService termsYour figureYour figureExpect movement on service terms only
Your dateFilled the services section with real descriptionsProfile: servicesService termsYour figureYour figureSmall on its own; supports the category change above
Your datePublished a dedicated website page for one service and linked it from the profileWebsiteThat service termYour figureYour figureTypically slower than profile edits; allow more than one cycle
Your dateStarted asking every customer for a review with a direct linkReviewsAll tracked termsYour figureYour figureJudge by review count and recency first, ranking second; effect accrues over months
Your dateFixed an old address on a major directory and a data aggregatorCitationsAll tracked termsYour figureYour figureRemoves a trust problem rather than adding a signal; do not expect a jump
Your dateUploaded twelve new photos and replied to all open reviewsProfile: activityAll tracked termsYour figureYour figureKeeps the profile active; usually no measurable ranking change by itself
Your dateCompetitor opened a second location on the east side (outside event)ExternalAll tracked termsYour figureYour figureLog it so a contraction on that side of the map is not blamed on your own work
Your dateGrid radius changed from 5 to 8 milesTrackingAll tracked termsYour figureYour figureMeasurement change, not a ranking change; start a new baseline from this date

Also from MapRankr