Audiio is a subscription-based music licensing platform that provides filmmakers, content creators, and marketers with unlimited access to a high-quality library of royalty-free music and sound effects. Designed for both commercial and creative use, Audiio offers affordable licensing plans that empower users to enhance their projects with professionally curated audio content.
Centralized Stripe subscription data warehouse
Near real-time ETL with Stitch
Modeled churn, cohorts, retention metrics
Visualized CLV, MRR, churn trends
Data Warehouse Engineer
BI Analyst
Subscription Analytics Consultant
Client Success Liaison
Subscription Analytics Initiative / Fixed-Term
Aligning users across time windows while preserving subscription lifecycle.
Translating data outputs into marketing and product-relevant business insights.
The initiative began with extracting data from Stripe using Stitch and centralizing it into BigQuery. Once structured, transformation logic was built to support churn rate, retention curves, and monthly cohort comparisons. Key KPIs like Customer Lifetime Value (CLV) and Monthly Recurring Revenue (MRR) were derived and visualized using Looker Studio.
Subscription Analytics with Automated ETL and KPI-Driven Insights
.png)
