Reviews Management System
Company: WIN Home Inspection
Timeline: March 2020 - July 2020
Executive Summary: Built automated review generation system that increased reviews by 500x while saving $24K+ annually in vendor fees.
Situation
Despite 30 years of outstanding service and millions of inspections, WIN had only 1,000 total reviews across Google and Facebook. With 87% of consumers reading reviews before selecting service providers, this represented a critical gap in digital presence.
Task
The challenge was to:
- • Build automated system for review generation
- • Ensure Google policy compliance
- • Eliminate manual bottlenecks causing delays
Action
- • Researched Google's review policies and documented optimal timing strategies
- • Compiled complete dataset of 200+ franchise locations
- • Built Python ETL pipeline connecting CRM to HubSpot with automated syncing
- • Created compelling email templates with multi-stage workflows
- • Deployed on AWS Lambda with cron scheduling for reliability
Result
The system transformed WIN's digital presence from virtually non-existent to industry-leading, generating over 500K five-star reviews while eliminating vendor dependencies and saving significant costs.
Key Metrics
- • 500x increase in review generation
- • $24K+ annual cost savings
- • 64% email open rate
- • 500K+ reviews generated
- • 200+ franchisees onboarded
- • 100% adoption rate
Tech Stack
Coding Languages: Python
Cloud Resources: AWS (Lambda, EventBridge, Lightsail)
3rd Party Services: HubSpot, Sakari (SMS), Google Sheets