1. Product metrics is the artifact I used to communicate how metrics are calculated (metric definitions) and breakdowns/segmentation leading to high-quality insights (dimensions)
    1. to leadership - to coordinate & define their value and actionability
    2. to data specialists - to empower them to aggregate the correct data & configure metrics in reports

Product metrics


  1. This template can be used to formulate the most impactful product inquiries, identify respective success metrics & plan concrete steps to achieve the desired results

https://miro.com/app/board/uXjVMRilvQY=/


  1. Example of GA4 (or alternative product analytics tool) tracking plan for a sample ecommerce store

Google Merch Store Tracking Plan (https://your.merch.google)


  1. Example B2B SaaS revenue retention diagnostics tool built from raw data exports from a billing app. Can be used in the following ways:
    1. diagnose the product and business health (check benchmarks in https://www.lennysnewsletter.com/p/what-is-good-retention-issue-29)
    2. identify a target success metric (example: 3-month revenue retention rate) and center the team’s efforts around it
    3. identify the impact of implemented features / applied acquisition channels
    4. identify the most profitable segments

Revenue creation & retention cohorts


  1. Under construction

    BigQuery ecommerce sample dataset exploration


  1. 2-side Lyft-like marketplace profit maximization model accounting for rider & driver CAC, average revenue per ride, rider churn and their dependencies

Lyft-like product unit economics model [test task]