Stay ahead of the metrics curve
Get weekly insights on business metrics, analytics best practices, and data strategy delivered to your inbox.
No spam, ever. Unsubscribe anytime.
Blog
Insights on business metrics, analytics, and data strategy.
37 Decisions Hiding in Your Churn Rate (and Why They Matter)
Your churn rate isn't a single number — it's the output of 37 implicit decisions. This guide enumerates every one, explains why each matters, and shows the variance impact of getting them wrong.
How to Define CAC: The 12 Hidden Decisions in Customer Acquisition Cost
CAC seems simple: total spend divided by new customers. But 12 hidden decisions determine your number — from what counts as 'acquisition spend' to who qualifies as a 'new customer.'
How to Define MRR: 10 Decisions That Change Your Revenue Number
Monthly Recurring Revenue seems straightforward — until two teams report different numbers. Here are the 10 decisions hiding in your MRR definition and how to resolve them.
How to Define NRR: Why Your Net Revenue Retention Has 15 Blind Spots
Net Revenue Retention is the metric investors care about most — but it hides 15 decisions that can swing your number by 30+ percentage points. Here's every decision you need to make.
Data Quality vs Metric Quality: The Gap Nobody's Talking About
Your data quality tools monitor pipelines. But who audits your metric definitions? Data quality and metric quality are different problems — and solving one doesn't fix the other.
Metric Governance vs Data Governance: What's the Difference?
Data governance manages data availability, quality, and compliance. Metric governance audits the decisions behind metric definitions. They're complementary but distinct.
SaaS Metric Definitions: The Complete Guide to Churn, CAC, NRR, MRR, LTV
The definitive guide to SaaS metric definitions. For each metric — churn, CAC, NRR, MRR, and LTV — we cover the formula, the hidden decisions, common mistakes, and benchmarks.
Your Semantic Layer Solves Half the Problem. Here's the Other Half.
Semantic layers like dbt Metrics, Cube, and MetricFlow standardize how metrics are calculated. But they don't audit whether the definition is complete. Here's the missing piece.
What Your dbt Model Doesn't Tell You About Your Metrics
dbt transformed how teams build data pipelines. But your dbt model encodes decisions without auditing them. Here are 7 things your dbt project is missing.
Why Your Dashboard Numbers Don't Match (It's Not a Data Bug)
When the CEO's churn doesn't match the VP of Product's number, everyone blames the data. But usually the data is fine — the definitions are different.
Data as a Product: A Complete Guide to Building Data Products That Teams Actually Trust
Learn how leading organizations like Netflix apply product thinking to data. This comprehensive guide covers the principles, frameworks, and practical strategies for treating your data assets as first-class products.
The Decision Graph: Our Vision for Data-Validated Metric Analysis
Our roadmap for transforming AI-generated metric analysis into data-validated insights backed by real user data. See how the Decision Graph will work.
Daily Active Users (DAU): The Complete Guide to Measuring Real Engagement
DAU is one of the most tracked metrics in tech—and one of the most misused. Learn how to define 'active' correctly, calculate DAU with SQL, and turn vanity metrics into actionable insights.
Net Revenue Retention (NRR): The Silent Growth Engine
A comprehensive guide to Net Revenue Retention—the metric that separates good SaaS companies from great ones. Includes calculation methods, benchmarks, improvement strategies, and SQL examples.
Customer Acquisition Cost (CAC): The Metric That Makes or Breaks Growth
A comprehensive deep-dive into Customer Acquisition Cost—covering calculation methods, channel attribution, CAC payback, LTV:CAC ratios, industry benchmarks, and optimization strategies.
15 Signs Your Metrics Are Broken (And How to Fix Them)
Common warning signs that your business metrics are unreliable, inconsistent, or misleading—plus practical solutions for each.
SQL for Funnel Analysis: The Complete Guide
Master funnel analysis in SQL—from basic conversion funnels to advanced multi-step, time-constrained, and segmented analysis with 15+ production-ready queries.
Introducing the QueryLens Blog
A new content hub for metric definitions, analytics best practices, and SQL techniques.
SQL Window Functions for Metrics: The Complete Practical Guide
Master SQL window functions for calculating running totals, growth rates, rankings, moving averages, and retention analysis—with 50+ real-world examples for metrics and analytics.
What is a Metric Health Score?
Understanding metric health scores—how to evaluate whether your metrics are well-defined, consistently measured, and actually useful for decision-making.
SQL for Cohort Analysis: The Complete Guide
Master cohort analysis in SQL—from basic retention cohorts to advanced revenue, behavioral, and predictive analysis with 15+ production-ready queries.
The Complete Guide to Defining Business Metrics
Learn how to create precise, unambiguous metric definitions that drive consistent decision-making across your organization. Includes frameworks, real-world examples, and implementation checklists.
How to Audit Your Company's KPIs: A Complete Framework
A step-by-step framework for auditing your key performance indicators—evaluating definition quality, measurement accuracy, and strategic alignment.
How to Build a Metrics Dashboard That People Actually Use
A practical guide to designing dashboards that drive decisions—covering what to include, how to structure it, and common mistakes to avoid.
SaaS Metrics Template: The Complete Guide to SaaS Metrics
A comprehensive template of SaaS metrics with definitions, SQL queries, formulas, and benchmarks—covering revenue, growth, retention, and unit economics.
E-commerce Metrics Template: The Definitive KPI Guide for Online Retail
The complete e-commerce metrics reference covering sales, conversion, customer behavior, marketing performance, and operations. Battle-tested frameworks from Amazon, Shopify, and top DTC brands with SQL queries and real benchmarks.
Churn Rate: The Complete Guide
A comprehensive breakdown of churn rate metrics—including logo churn, revenue churn, cohort analysis, predictive indicators, and reduction strategies with real-world examples.
Product Analytics Metrics Template: The Definitive KPI Guide for Product Teams
The complete product metrics reference covering engagement, activation, retention, feature adoption, and growth. Battle-tested frameworks from companies like Slack, Spotify, and Notion with SQL queries and real benchmarks.
Monthly Recurring Revenue (MRR): The Complete Guide
The definitive guide to MRR—how to calculate it correctly, track all components (New, Expansion, Churned, Contraction), avoid hidden calculation pitfalls, and use it to drive predictable growth.
Metrics Governance: How to Keep Your Data Trustworthy at Scale
A practical framework for metrics governance—establishing ownership, documentation standards, and change management processes that scale.
OKRs vs KPIs: Understanding When to Use Each
A clear explanation of the differences between OKRs and KPIs, when to use each framework, and how to make them work together.
Customer Lifetime Value (LTV/CLV): The Complete Guide
A comprehensive guide to calculating customer lifetime value—including multiple formulas, cohort analysis, segment-specific LTV, predictive models, and the relationship with CAC.
Gross Margin: The Complete Guide to Your Business's True Profitability
The definitive guide to gross margin—what to include in COGS, how to calculate it correctly for SaaS and e-commerce, industry benchmarks, and strategies to improve margins.
Have a metric question?
Get instant clarity on any business metric with QueryLens. Our AI analyzes your questions and uncovers the hidden decisions you need to make.
Try QueryLens