Part 2 · Six weeks, one framework a week · 2 of 7
North Star, Functional, and Granular Metrics
North Star = the domain's leading business metric. Functional = the leading metric for a sub-area. Granular = an indicator of effectiveness.
1 min read
Every data product needs a metric hierarchy, not a single number:
- North Star metric — the domain's leading metric, tied directly to
business outcomes. Example (Sales):
revenue_generated. - Functional metric — the leading metric for a specific function/domain
within that. Example:
#deals_closed_value. - Granular metric — an indicator of effectiveness, usually a rate or
ratio that explains why the functional metric moved. Example:
conversion_rate.
These three sit in a Metric Dependency Tree (MDT): granular metrics roll up into functional metrics, which roll up into the North Star. This is what makes root-cause analysis tractable — you can walk down the tree from "revenue dropped" to the specific granular metric that explains it.
Source: 6-Week Data Products Product Playbook.pdf
Where this shows up
Lessons
Labs
- SQL · See the rows behind the number
- SQL · Functional metric: deals_closed_value
- SQL · North Star metric: revenue_generated
- SQL · Granular metric: conversion_rate (Dana's definition)
- SQL · Capstone: the whole metric tree, one query
- Python · Functional metric: deals_closed_value
- Python · North Star metric: revenue_generated
3 flashcards in Review
Referenced by