Starting point
The booking calendar showed appointments but did not answer operational questions: how much working time remains unused, which days are weak, and how performance differs by employee and location.
All case studies
Beauty operations · Booksy data
Tracksy
An operations dashboard for beauty salons that translates Booksy data into team occupancy, schedule gaps and revenue. Instead of seeing only appointments, the owner can identify where the schedule needs attention.
How the solution works
Tracksy combines historical XLSX reports with new events received from Booksy emails. Based on appointments and staff schedules, it calculates daily summaries, occupancy and specific gaps. The data model supports organisations with multiple salons and team members.
03
What was built
Two Booksy data sources
XLSX reports provide historical data, while incoming messages processed by an Edge Function deliver new bookings, changes and cancellations.
Occupancy and open slots
The system compares working time with booked time, classifies each day and records specific gaps that require attention.
Company, salon and employee views
Dashboards and reports move from the organisation-wide result down to a location and an individual team member.
Secure multi-organisation access
Supabase Auth and RLS policies isolate data. A separate inbound address for each salon associates events with the correct location.
04
What the system changes
- Occupancy visibility instead of only an appointment list.
- Automatic detection of days and hours with unused capacity.
- One view across multiple salons and team members.
- Historical data and new events in one reporting model.
Facing a similar process?
Let's start where work consumes the most time today.
During a free call, we will walk through the process, data and current tools. You will receive a recommendation for the first sensible scope.