Tabellab

Local SEO & Google Business Profile: Profile Insights, Local Rank Grids, Citations, Review Velocity & Local Lead Value

Measure local search the way a branch manager needs it. You will turn Business Profile views, calls, direction requests and website clicks into action rates, split views by Search and Maps, separate brand from discovery searches, find missed calls and price a profile action. Then you summarise local rank grids, check name, address and phone consistency across listings, track review velocity, replies and review requests, set realistic rating targets, judge service-area pages and travel profit, estimate clicks from keyword ranks, compare grids before and after, plan a citation clean-up, score profile completeness, forecast calls, build a what-if grid and finish with a branch scorecard. 20 hands-on labs, fictional home-services company Brindlewick Plumbing & Heating, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches the numbers behind local search in 20 interactive spreadsheet labs. You work with the data of Brindlewick Plumbing & Heating, a fictional home-services company with eight branches. First you read Business Profile insights: views, calls, direction requests and website clicks become action rates, shares and month-over-month growth, and you work out what a single call is worth. Then you summarise local rank grids, audit name, address and phone consistency across listings, measure review velocity, replies and review requests, and test whether a rating target is realistic. Later labs cover service-area pages, travel profit by zone, keyword ranks and click share, a citation clean-up budget, a weighted completeness score, a call forecast and a what-if grid, and the final project is a scorecard per branch. Every formula is typed by you and checked at once. All companies, people and numbers are fictional, and benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  1. Reading Business Profile Insights: Views, Calls, Direction Requests, Website Clicks and the Action Rate per BranchLabFree
  2. Where the Views Come From: Search vs Maps, Mobile vs Desktop and Month-over-Month GrowthLab Locked
  3. Search Terms Report: Brand vs Discovery Searches with SUMIF, Shares of the Total and the Biggest TermsLab Locked
  4. Calls from the Profile: Answered and Missed Calls by Hour, the Missed-Call Rate and the Value LostLab Locked
  5. What a Profile Action Is Worth: Lead Rate, Close Rate, Job Value and the Value per Call, Direction Request and ClickLab Locked
  6. Local Rank Grids: Average Map Rank, Points in the Top 3, Top-3 Share and a Heat Map of the Weak SideLab Locked
  7. Citations and NAP Consistency: Comparing Name, Address and Phone with the Master Record and Scoring the ListingsLab Locked
  8. Review Velocity: New Reviews per Month, the Running Total, the Overall Rating and a 3-Month PaceLab Locked
  9. Rating Mix and Review Replies: Counting Stars with COUNTIF, the Reply Rate, Reply Time and Unanswered Low RatingsLab Locked
  10. Asking for Reviews: Request Rate, Request-to-Review Rate, Reviews per 100 Jobs and a Ranking per TechnicianLab Locked
  11. Rating Targets: How Many 5-Star Reviews Lift the Average to the Target and How Long It Takes at the Current VelocityLab Locked
  12. Service-Area Pages: Conversion Rate, Leads per 1,000 Households and County Totals with SUMIFSLab Locked
  13. Drawing the Service Area: Drive Time, Travel Cost per Job, Profit After Travel and a Keep-or-Review Decision per ZoneLab Locked
  14. Keyword Rank Tracking: Rank Change, Click Share by Position with XLOOKUP, Estimated Clicks and a Weighted Average RankLab Locked
  15. Before and After: Comparing Two Rank Grids, Points Gained, the Top-3 Share and a Head-to-Head Against a CompetitorLab Locked
  16. Citation Clean-Up: Status Counts with COUNTIF, a Priority Score, Fix Hours and the BudgetLab Locked
  17. Profile Completeness: A Weighted Checklist Score per Branch, Missing Items and the Link to the Action RateLab Locked
  18. Forecasting Calls from the Profile: SLOPE, FORECAST.LINEAR, a Three-Month Outlook and a Staffing CheckLab Locked
  19. What-If Grid: Monthly Profit from Profile Leads by Close Rate and Job Value, Break-Even Close Rate and Return on CostLab Locked
  20. Final Project: Local SEO Scorecard per Branch with SUMIFS, Action Rate, Lead Value, a Review-Velocity Flag and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy