Metrics

Metrics worth tracking in Metabase

Clear definitions for the metrics teams actually report on — what each one measures, the data it needs, the SQL patterns behind it, and the pitfalls to avoid. Every guide shows how to track the metric in Metabase from the tools you already use. Filter by category to find the ones that match your work.

154 of 154 results

Win rate

Sales

The share of deals that close won — by cohort, segment, and stage entered.

Sales cycle length

Sales

How long deals take to close, and why medians beat averages for a skewed distribution.

Pipeline coverage

Sales

Open pipeline divided by the quota or target it has to cover in a period.

Conversion rate

Sales

Stage-to-stage and overall funnel conversion — where deals advance and where they stall.

Average deal size

Sales

The typical value of a won deal (ACV), and how mix and outliers distort the mean.

Reply rate

Sales

The share of contacted prospects who reply to outbound — by sequence, rep, and segment.

Meetings booked

Sales

Qualified meetings generated by outbound — booked vs. held, without double-counting.

Forecast accuracy

Sales

How close the forecast came to actuals — why you need snapshots, and how to track bias.

Email bounce rate

Sales

The share of sent emails that fail to deliver — hard vs. soft, and protecting deliverability.

MRR

Revenue

The normalized monthly value of active subscriptions — the base for churn, retention, and LTV.

Churn rate

Revenue

Revenue vs. customer churn, and voluntary vs. involuntary — where recurring revenue leaks.

Net revenue retention

Revenue

Expansion minus contraction and churn across your existing customers.

ARPU

Revenue

Average recurring revenue per user or account, and how it differs from ARPA.

LTV

Revenue

The expected gross-margin value of a customer over their lifetime.

Failed-payment rate

Revenue

The share of payments that fail — the main driver of involuntary churn.

DORA metrics

Software delivery

The four keys: deployment frequency, lead time for changes, change failure rate, and MTTR.

Deployment frequency

Software delivery

How often you ship to production — a DORA throughput metric.

Lead time for changes

Software delivery

Time from commit to running in production — a DORA throughput metric.

Change failure rate

Software delivery

The share of deploys that cause a failure — a DORA stability metric.

MTTR

Software delivery

How fast you recover from a failure in production — a DORA stability metric.

Cycle time

Software delivery

Time from work started to done — how fast issues move once picked up.

Lead time

Software delivery

Time from request created to delivered — end-to-end issue flow.

Build success rate

Software delivery

Successful CI runs over all completed runs — segmented by branch and pipeline.

Pipeline duration

Software delivery

Median and p95 CI wall-clock time, with queue time tracked separately.

Flaky test rate

Software delivery

Tests that both pass and fail on the same code — the tax on every build.

First-response time

Support

How long customers wait for the first human reply — the median, not the average.

Resolution time

Support

Time from ticket created to resolved, and whether to subtract pending time.

CSAT

Support

Customer satisfaction — positive ratings ÷ rated tickets, and why response rate matters.

Ticket volume

Support

Tickets created vs. solved per period, plus the open backlog behind them.

Average order value

E-commerce

The typical revenue per order, and how mix and discounts move it.

Repeat purchase rate

E-commerce

The share of customers who buy again — the core signal of retention and loyalty.

Time to hire

HR

How long a candidate takes from application or first touch to accepted offer.

Time to fill

HR

How long an open requisition takes to reach an accepted offer or start.

Offer acceptance rate

HR

Accepted offers divided by extended offers, with pending and rescinded offers separated.

Candidate conversion rate

HR

Stage-to-stage recruiting funnel conversion from ATS stage history.

Source quality

HR

Which recruiting sources produce qualified candidates, offers, and accepted hires.

Interview pass-through rate

HR

The share of candidates who advance after a completed interview stage.

Cash runway

Finance

Available operating cash divided by average monthly net burn, with restricted cash and FX handled explicitly.

Accounts receivable aging

Finance

Open invoice balances grouped by days past due at a specific as-of date.

Days sales outstanding

Finance

The number of days of credit sales represented by average accounts receivable.

Burn rate

Finance

Gross operating cash outflow and net cash consumed after operating inflows.

Gross margin

Finance

Revenue remaining after direct cost of revenue, based on an approved account mapping.

Budget variance

Finance

Actual results compared with one approved budget version at a shared reporting grain.

Invoice collection rate

Finance

Payments allocated to an invoice cohort divided by the value invoiced in that cohort.

FX exposure

Finance

Foreign-currency balances and commitments translated at a documented valuation rate.

Task completion rate

Work management

Completed work divided by due or committed work in a period.

Task throughput

Work management

How much work is completed per period, by project, team, or work type.

Overdue rate

Work management

Open work past due divided by open work with due dates.

Workload balance

Work management

How open work is distributed across owners, teams, projects, and statuses.

Project health score

Work management

A transparent risk score for overdue, blocked, stale, and incomplete work.

Documentation freshness

Work management

The share of active content reviewed or meaningfully updated inside its policy window.

Knowledge-base coverage

Work management

Required topics and workflows with current, owned documentation.

Workspace activity rate

Work management

The share of eligible boards, spaces, sites, or channels with meaningful recent activity.

Collaboration response time

Work management

Time from a question or new thread to its first useful human reply.

ROAS

Marketing

Conversion value over ad spend, by campaign and channel — with the attribution caveats spelled out.

Customer acquisition cost

Marketing

Spend over new customers — blended vs. paid-only, and the payback math that follows.

Cost per lead

Marketing

Spend over leads generated — raw vs. qualified, so cheap channels don't hide bad leads.

Cost per click

Marketing

The price of attention per channel, with CPM alongside — and why cross-channel comparisons mislead.

Click-through rate

Marketing

Clicks over impressions or delivered emails — the denominator changes by context.

Landing-page conversion rate

Marketing

Conversions over sessions per landing page, with sample-size thresholds that keep rankings honest.

Organic clicks & impressions

Marketing

Search visibility from Search Console rows — branded vs. non-branded, position, and CTR together.

Activation rate

Marketing

Signups reaching the product's value moment — the bridge between marketing spend and retention.

Sync success rate

Marketing

Successful pipeline runs over all runs per destination — with a row-weighted version that catches partial syncs.

Data freshness

Marketing

How old the newest delivered data is, per destination — the metric that notices pipelines going silent.

Incident count

Observability

Qualifying incidents per period, segmented by severity and service.

Mean time to acknowledge

Observability

How fast a responder picks up an incident — the paging-health half of response.

Error rate

Observability

Failed events over total requests, sessions, or users — per service and release.

Alert noise rate

Observability

The share of alerts that never became incidents — the alert-fatigue early warning.

Service availability

Observability

Successful requests or minutes over total, per service — uptime, done per service.

SLO compliance

Observability

Reliability against explicit targets — error budgets and burn rates.

Resource utilization

Observability

Used capacity over requested or provisioned — the bridge between reliability and cost.

Token usage

LLM analytics

Prompt and completion tokens per period, by model and app — and why to track them separately.

Cost per 1M tokens

LLM analytics

Your blended LLM unit cost — the honest number for comparing models and catching drift.

LLM cost per user

LLM analytics

LLM spend over active users of AI features — the unit-economics headline, with its skew.

p95 LLM latency

LLM analytics

The tail response time of LLM calls — why percentiles, not averages, and how streaming changes it.

LLM error rate

LLM analytics

Failed LLM calls over all calls — provider errors, timeouts, rate limits, and guardrail blocks.

Cache hit rate

LLM analytics

Cached responses and tokens over totals — the most direct LLM cost and latency lever.

Eval pass rate

LLM analytics

Passing eval examples over all examples — the test-suite green rate for LLM quality.

LLM requests per day

LLM analytics

Daily LLM call volume by app and model — the denominator behind every other LLM metric.

Open critical vulnerabilities

Security

Open critical and high findings, deduplicated across scanners — by asset group and age.

Mean time to remediate

Security

Median days from a finding's first-seen to resolved, by severity — remediation velocity.

Vulnerability SLA compliance

Security

Findings closed within their severity SLA over all findings due — including the overdue.

Mean time to detect

Security

Median time from first malicious activity to detection — a lower bound, honestly caveated.

Control pass rate

Security

Passing controls over monitored controls per framework, from daily snapshots.

MFA adoption rate

Security

Active users with a strong second factor enrolled — segmented by factor type and privilege.

Failed login rate

Security

Failed authentication attempts over all attempts — user friction and attack signal, separated.

Scan coverage

Security

Assets scanned or protected within a window over the true inventory — the honesty denominator.

Total cloud spend

Cloud cost

Spend per period under one stated convention — amortized, unblended, or net of credits.

Cost per customer

Cloud cost

Allocated infrastructure cost per customer — the unit-economics headline, joined to revenue.

Cost growth rate

Cloud cost

Month-over-month spend change, attributed to services and compared to business growth.

Commitment coverage rate

Cloud cost

Commitment-covered share of eligible spend — always read together with utilization.

Effective savings rate

Cloud cost

Realized savings against on-demand-equivalent cost — the honest commitment-program number.

Untagged spend rate

Cloud cost

Spend with no owner tag over total — the ceiling on every allocation dashboard.

Budget burn rate

Cloud cost

Budget consumed vs. period elapsed — the early-warning pace metric for cloud spend.

Cost per service

Cloud cost

Spend per provider or application service, with the resource-to-service mapping made explicit.

Average position

SEO

Volume-weighted mean search rank — and why GSC and rank trackers report different numbers.

Keywords in top 10

SEO

Tracked keywords ranking in positions 1–10 — the visibility count that survives averaging.

Domain rating

SEO

Vendor link-authority scores (DR, Authority Score) — directional, and never cross-vendor comparable.

Referring domains

SEO

Unique domains linking to a target — count domains, not raw backlinks.

Backlink velocity

SEO

Net new referring domains per week — gains minus losses, with recrawl-spike caveats.

Share of voice

SEO

Your volume-weighted slice of tracked-keyword visibility against a fixed competitor set.

Organic CTR

SEO

Clicks over impressions by position bucket from Search Console — and how SERP features bend it.

Net Promoter Score

Product insights

Percent promoters minus percent detractors on the 0-10 scale — always with response volume.

Survey response rate

Product insights

Responses over invitations, opens, or views — and why the denominator must be labeled.

Survey completion rate

Product insights

Completed over started responses, with drop-off by question to find the leak.

Feedback vote velocity

Product insights

New votes on open feature requests per period — what customers want now, not ever.

Time to close the loop

Product insights

Median time from feature request to shipped and announced — the feedback honesty metric.

Feature adoption rate

Product insights

Adopting accounts over eligible active accounts, with tried vs. adopted tiers.

Rage-click rate

Product insights

Frustration clicks per 1,000 sessions by page — the canonical digital distress signal.

Member growth rate

Community

Net new community members per period, with joins and departures shown separately.

Engagement rate

Community

Share of members who posted, replied, or reacted in a window you define and state.

RSVP-to-attendance conversion

Community

Registrations that turned into check-ins — only measurable when attendance is recorded.

Health score

Customer success

Composite account health, re-derived from its components instead of trusting a vendor black box.

Gross revenue retention

Customer success

Retained recurring revenue excluding expansion — the number that can never exceed 100%.

Renewal forecast accuracy

Customer success

Forecast vs. actual renewals, graded against a forecast frozen at period start.

Time to value

Customer success

Median time from signup or contract start to a value milestone you have explicitly defined.

No-show rate

Customer success

Booked meetings that never happened, with cancellations and reschedules kept out of the denominator.

Refund rate

E-commerce

Refunded revenue over revenue by order cohort — count vs. value rates, and the lagging-metric caveat.

Cart abandonment rate

E-commerce

Abandoned checkouts over started, from event data — cart vs. checkout stages, by device and step.

GMV (gross merchandise value)

E-commerce

Total order value net of cancellations — GMV vs. revenue vs. take rate, decomposed with AOV.

Inventory turnover

E-commerce

COGS over average inventory, annualized — snapshot-based history and days of inventory.

Cost per ticket

Support

Fully-loaded support cost over tickets handled — numerator definition, channel splits, CSAT guardrail.

Resolution rate

Support

The share of tickets that end resolved — closed vs. cohort denominators, with reopens excluded.

Ticket backlog

Support

Open tickets trended daily with age buckets, created-vs-solved flow, and burn-down capacity math.

Escalation rate

Support

Escalated over total tickets, split by escalation path and segmented by topic to find docs gaps.

Deflection rate

Support

Self-service resolutions over total demand, with explicit signals and a quality guardrail.

Unsubscribe rate

Marketing

Opt-outs over delivered per campaign, read next to spam complaints to localize spikes.

List growth rate

Marketing

Net subscriber growth with components broken out, plus cohort quality by acquisition source.

Employee turnover rate

HR

Annualized departures over average headcount, split voluntary/involuntary and by tenure.

Cost per hire

HR

Recruiting cost per hire by quarter and source, paired with 90-day retention as a quality gate.

Renewal rate

Customer success

Logo vs. gross renewal rate — renewals over contracts due, on-time vs. late, and the auto-renew split.

Expansion revenue rate

Customer success

Expansion MRR over starting MRR — the growth component inside NRR, with contraction shown separately.

Active member rate

Community

Active members over total members — the DAU/MAU idea for communities, plus the stickiness ratio.

First contact resolution rate

Support

The share of tickets resolved in a single touch — no reopens, no transfers.

SLA breach rate

Support

The share of tickets that missed a first-response or resolution SLA target, per policy and priority.

Deal profitability

Sales

Margin per won deal — revenue net of discounts minus the cost to deliver, from CRM and finance data.

Deal slippage rate

Sales

The share of committed deals whose close date slips out of the period, from close-date snapshots.

Cost per acquisition (CPA)

Marketing

Spend per conversion, blended and by channel, with warehouse conversions instead of platform claims.

Bounce rate

Marketing

The share of sessions with no engagement, GA4-style, segmented by landing page and traffic source.

Net new leads

Marketing

Leads created minus duplicates and junk — honest top-of-funnel volume by month and source.

Email open rate

Marketing

Unique opens over delivered — read alongside clicks, since Apple MPP inflates opens.

Test pass rate

Software delivery

Passing tests over executed tests by suite, with quarantined tests excluded honestly.

Queue time

Software delivery

How long work waits in kanban states and CI queues — often the biggest share of lead time.

Release burndown

Software delivery

Remaining scope against time toward a release date, with scope changes made visible.

Velocity

Software delivery

Story points completed per sprint — a planning signal, not a productivity score.

Bug count

Software delivery

Net new bugs by severity and open-bug age buckets — the trends behind the raw total.

Uptime

Observability

The percentage of time a service is up — nines as downtime budgets, from synthetic checks.

MTBF

Observability

Average operating time between failures — the reliability counterpart to MTTR.

Course completion rate

Creator

Students who finish a course over those who have had time to finish it — with the maturity window that makes it honest.

Platform fee rate

Creator

The share of gross sales lost to platform commission, payment processing, and payout fees — derived, not quoted.

Shipping cost per order

Logistics

Billed label cost per order and as a share of order value, using post-adjustment carrier charges.

On-time delivery rate

Logistics

Deliveries arriving by the promised date, over shipments with tracking coverage and a known outcome.

Average check size

Point of sale

Restaurant and retail average ticket, with voids excluded and comps, tax, and tips handled deliberately.

App store conversion rate

Mobile apps

Product page views converted to first-time installs, and why Apple and Google define it differently.