Building end-to-end analytics for the TAIRAI SPA salon chain
About the client
TAIRAI SPA salons specialize in traditional Thai massage and SPA programs using natural cosmetics from Thailand. Today TAIRAI is a recognizable brand with more than 70 salons in Moscow and other major cities across Russia.
The task
TAIRAI approached me with an interesting challenge - to build analytics for a mobile app and a website in order to help marketing managers run advertising effectively. And also to build dashboards for analyzing the performance of franchisees.
Goals
- →Build dashboards for marketers
- →Set up the delivery of users' marketing data into the client's accounting system
- →Build dashboards for reporting to franchisees
What was built
- 01
Mobile and website analytics
Defining events for the mobile app and the website. Collecting analytics in Google BigQuery.
- 02
Web service for the accounting system
Creating a web service API to export data from Google BigQuery and deliver it into the accounting system.
- 03
Integration with advertising accounts
Pulling advertising spend into Google BigQuery using online connectors and Python scripts.
- 04
End-to-end analytics
Creating tables in Google BigQuery with end-to-end analytics, from advertising spend through to client payments.
- 05
Building dashboards
Preparing dashboards for mobile analytics, website analytics, the sales funnel, and end-to-end analytics.
Result
The required dashboards were successfully delivered. I provide both technical support for the existing integrations and on-request enhancements to the dashboards.