Grace and Mila — Product Analytics and PLG
A real-world product analytics project in partnership with Grace and Mila, a French fashion e-commerce brand. Analysis of 6 months of GA4 data.
6
Months of GA4 data
1
NSM defined
AARRR
Full funnel mapping
Jury
Pro jury presentation
What I Did
Conversion funnel analysis
Advanced SQL queries on BigQuery to analyze user journeys across 6 months of raw GA4 data. Identification of drop-off points at each stage.
Retention cohort analysis
Cohort segmentation by acquisition date to measure long-term retention patterns and identify high-value customer segments.
North Star Metric and AARRR mapping
Definition of the North Star Metric aligned with business goals. Complete AARRR framework mapping for Grace and Mila.
Strategic dashboard on Looker Studio
Design and construction of an executive dashboard connecting BigQuery to Looker Studio. Real-time KPI monitoring and cohort heatmaps.
GTM tracking audit and RICE prioritization
Complete GTM audit to identify tracking gaps. RICE scoring to prioritize friction point fixes. Recommendations presented to professional jury.