Growth Analysis for a Hair Health Franchise
In December 2023, Medical Hair Posadas, a franchise focused on hair health services such as surgeries, mesotherapy, and various treatments, reached out to us to explore the reasons for their stagnant growth. Our initial approach involved analyzing their data, which was stored on an outdated website. From there, we extracted information regarding scheduled appointments and patient details. We divided our analysis into two main areas: appointments and patients. For the appointments, we calculated the churn rate and evaluated various influencing factors, including the wait time between appointment requests and actual appointments, follow-up procedures for no-shows, consultation reasons, and other pertinent information. For the patient segment, we assessed their needs based on age, gender, nationality, and other demographic factors to improve their marketing strategies. Our deliverables included detailed reports for each segment of the analysis and a Looker dashboard that updates every three days, enabling the client to track their objectives continuously. The client expressed high satisfaction as they could pinpoint the timing and reasons for their stagnation, leading to us being engaged for another project at a different location.