Tabellab

What a Profile Action Is Worth: Lead Rate, Close Rate, Job Value and the Value per Call, Direction Request and Click

Lesson 5 of 20 Lab 🔒 Locked

Lessons in this course

  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