Profile Completeness: A Weighted Checklist Score per Branch, Missing Items and the Link to the Action Rate
Lessons in this course
- Reading Business Profile Insights: Views, Calls, Direction Requests, Website Clicks and the Action Rate per BranchFree
- Where the Views Come From: Search vs Maps, Mobile vs Desktop and Month-over-Month Growth Locked
- Search Terms Report: Brand vs Discovery Searches with SUMIF, Shares of the Total and the Biggest Terms Locked
- Calls from the Profile: Answered and Missed Calls by Hour, the Missed-Call Rate and the Value Lost Locked
- What a Profile Action Is Worth: Lead Rate, Close Rate, Job Value and the Value per Call, Direction Request and Click Locked
- Local Rank Grids: Average Map Rank, Points in the Top 3, Top-3 Share and a Heat Map of the Weak Side Locked
- Citations and NAP Consistency: Comparing Name, Address and Phone with the Master Record and Scoring the Listings Locked
- Review Velocity: New Reviews per Month, the Running Total, the Overall Rating and a 3-Month Pace Locked
- Rating Mix and Review Replies: Counting Stars with COUNTIF, the Reply Rate, Reply Time and Unanswered Low Ratings Locked
- Asking for Reviews: Request Rate, Request-to-Review Rate, Reviews per 100 Jobs and a Ranking per Technician Locked
- Rating Targets: How Many 5-Star Reviews Lift the Average to the Target and How Long It Takes at the Current Velocity Locked
- Service-Area Pages: Conversion Rate, Leads per 1,000 Households and County Totals with SUMIFS Locked
- Drawing the Service Area: Drive Time, Travel Cost per Job, Profit After Travel and a Keep-or-Review Decision per Zone Locked
- Keyword Rank Tracking: Rank Change, Click Share by Position with XLOOKUP, Estimated Clicks and a Weighted Average Rank Locked
- Before and After: Comparing Two Rank Grids, Points Gained, the Top-3 Share and a Head-to-Head Against a Competitor Locked
- Citation Clean-Up: Status Counts with COUNTIF, a Priority Score, Fix Hours and the Budget Locked
- Profile Completeness: A Weighted Checklist Score per Branch, Missing Items and the Link to the Action Rate Locked
- Forecasting Calls from the Profile: SLOPE, FORECAST.LINEAR, a Three-Month Outlook and a Staffing Check Locked
- What-If Grid: Monthly Profit from Profile Leads by Close Rate and Job Value, Break-Even Close Rate and Return on Cost Locked
- Final Project: Local SEO Scorecard per Branch with SUMIFS, Action Rate, Lead Value, a Review-Velocity Flag and a Chart Locked