← all posts

Data

Analytics, tracking, metrics, dashboards

North Star Metric: An AI Framework for Choosing Your Key Metric

Tutorials Data

Select a North Star Metric with AI: criteria by business model, analysis prompts, unit economics validation. SaaS, marketplace, and e-commerce examples.

Retention Curve and PMF: How AI Finds the Signal in the Data

Tutorials Data

Identify PMF from retention curves: SQL for cohort analysis, statistical flattening detection, and AI interpretation prompts. Tutorial with ready-to-use code.

Automated Metric Alerts with AI: Catch Problems Before Users Do

Tutorials Data

Anomaly detection, AI prompts for configuring alerts, and tools (Grafana, PostHog, custom). Practical rules and configs for product metrics.

Experimentation Playbook: 10 A/B Tests a Month as a Solo Founder

Tutorials Data

Run 10 A/B tests monthly in 3.5 hours: LLM hypothesis generation, experiment templates, PostHog and Statsig setup. Full framework inside.

Dashboard Design for Startups: Why 3 Dashboards Beat 30 (and How AI Builds Them in Minutes)

Tutorials Data

A practical guide to dashboard design for startups: executive, product, and engineering. Concrete metrics, SQL queries, and prompts for generating dashboards in Metabase and Grafana.

SQL for Product Managers: 7 Cohort Queries That AI Writes Better Than an Analyst

Tutorials Data

7 SQL queries for cohort analysis: retention, revenue cohorts, activation, churn prediction. Ready-made prompts for AI generation. Copy and run.

Magic Number: How to Find the Action That Retains Users

Tutorials Data

Methodology for finding a product's magic number: cohort analysis in SQL, AI correlation of user actions with 30-day retention, A/B test validation. Ready-to-use queries and prompts.

Event Taxonomy from Scratch: AI-Generated Tracking Plan in 1 Hour

Tutorials Data

How to build an event taxonomy for a SaaS product with AI: naming conventions, taxonomy structure, prompts for generating 30 events, and a ready-to-use tracking plan.