Experiments

Which A/B testing tools have native BigQuery integration?

A graphic of a bar chart with an arrow pointing upward.

Several A/B testing tools can connect to BigQuery, but only a smaller group uses BigQuery as the place where your experiment metrics are actually computed.

That distinction matters. “BigQuery integration” can mean at least four different things: exporting a vendor's events into BigQuery, reading raw GA4 exports, importing modeled metrics into a vendor cloud, or running the analysis SQL inside your Google Cloud project. All four can be useful. They are not interchangeable.

For a product team whose revenue, activation, retention, and account data already live in BigQuery, the most consequential question is not whether a logo appears on an integrations page. It is whether the platform can analyze the source-of-truth data without forcing the team to rebuild those definitions in a second event system.

This guide compares five credible options: GrowthBook, Datadog Experiments, Statsig Warehouse Native, Optimizely, and Varify. It evaluates the BigQuery relationship, permissions, assignment model, metric workflow, statistical tooling, pricing shape, and likely implementation burden. The goal is to help you shortlist tools for a production-shaped proof of concept, not to crown a winner from a feature matrix.

The short answer

If “native BigQuery integration” means that the platform reads approved BigQuery tables and runs experiment-analysis queries in your warehouse, the strongest candidates are GrowthBook, Datadog Experiments, and Statsig Warehouse Native.

Optimizely offers BigQuery data sharing that makes Optimizely Experimentation data available through a linked dataset. That is a useful pipeline for downstream analysis, but it reverses the direction of a warehouse-native workflow: experiment events originate in Optimizely and become available in BigQuery.

Varify offers a specialized BigQuery analysis path for web experiments measured with raw GA4 exports. It is a narrower fit than a general product experimentation platform, but it can be practical for conversion teams that want a visual editor and BigQuery-backed reporting without writing SQL.

ToolBigQuery relationshipAssignment optionsBest fit
GrowthBookRuns transparent analysis queries against connected BigQuery dataGrowthBook flags, visual experiments, or external exposure logsProduct and data teams that want warehouse-native analysis, open source, and deployment choice
Datadog ExperimentsRuns warehouse-native metric and exposure models in BigQuery; uses an output dataset and Cloud Storage staging bucketDatadog Feature Flags or warehouse exposure modelsExisting Datadog customers that want experiments alongside product and performance signals
Statsig Warehouse NativeReads source data and writes intermediate and materialized results to an isolated BigQuery datasetStatsig SDKs or external assignment dataEnterprise teams wanting flags, analytics, and experimentation in one commercial platform
OptimizelyShares Optimizely Experimentation data into BigQuery as a linked datasetOptimizely Web or Feature ExperimentationOptimizely customers that need vendor event data available for downstream BigQuery work
VarifyQueries raw GA4 export data in BigQuery for web-test evaluationVarify visual or code editorCRO teams running website experiments primarily through GA4

This classification is more useful than a simple yes-or-no integration column. It tells you where assignment is generated, where raw outcomes live, where computation runs, and which system owns the result.

What “native BigQuery integration” should mean

A native connection should solve an experimentation job rather than merely move files. Use the following levels to make vendor claims comparable.

Level 1: Export experiment events to BigQuery

The platform assigns variants and collects exposures or outcomes in its own event system. It then exports rows or exposes a shared dataset in BigQuery. This is valuable for archival, reconciliation, BI, and custom analysis. It does not automatically use the business facts your team already models in BigQuery.

Ask about delivery latency, event schemas, historical backfills, deduplication, regional availability, retention, and whether the export contains the IDs required to join to billing or account data. Also ask who pays for storage and downstream queries.

Level 2: Read BigQuery data into a vendor-managed analysis service

The tool connects to BigQuery, extracts approved data, and computes results outside your project. This may reduce warehouse compute, but it changes the privacy and governance model. “Connects to BigQuery” is true, while “warehouse-native” may not be.

Require a data-flow diagram. Identify whether user-level rows, query results, or only aggregates leave Google Cloud. Review deletion, retention, subprocessors, regional processing, and credentials. A marketing description is not a security architecture.

Level 3: Run metric and experiment computation in BigQuery

The platform generates SQL that runs through a service account in your project. Source rows remain in BigQuery, while the vendor receives aggregate results and operational metadata. Some platforms require an isolated dataset for temporary tables, cached results, or forwarded exposure events.

This is the most meaningful warehouse-native model, but it is not “zero access.” The service can run queries against every resource its identity can read. Use dataset-level grants, authorized views, separate execution projects, job labels, budgets, and query review. Google's BigQuery access-control documentation explains why job execution and data access are separate permissions.

Level 4: Bring your own SQL and statistical layer

Some platforms let data teams define exposure and metric SQL, inspect generated queries, choose statistical methods, and reuse governed definitions across experiments. This is the strongest form of composability. It also asks more of the data team.

The tool should make the analysis legible without requiring every PM to become a statistician or BigQuery operator. Look for previews, validation, versioning, ownership, reusable metric definitions, and a clear path from a result back to the rows and SQL that produced it.

How we evaluated the tools

The shortlist focuses on products with current, documented BigQuery behavior that contributes directly to experiment delivery or analysis. We did not count a generic reverse-ETL connector, CSV upload, webhook, or dashboard export as native experimentation support.

The criteria reflect what becomes painful after the first demo:

  • Data direction: Does the tool query canonical BigQuery facts, export vendor events, or both?
  • Compute location: Does statistical preparation run in your BigQuery project or a vendor cloud?
  • Permission surface: Can source reads be scoped? Is write access required? Can temporary objects be isolated?
  • Assignment flexibility: Can the tool analyze external flags and historical exposures, or only experiments assigned by its own SDK?
  • Metric governance: Are metrics reusable, versioned, testable, and understandable to analysts?
  • Statistical depth: Are diagnostics, variance reduction, sequential methods, multiple-testing controls, and segments available where needed?
  • Operational fit: How are refreshes scheduled, failed jobs diagnosed, and costs attributed?
  • Commercial fit: Is warehouse-native support available in an entry plan, priced per seat, per event, per experiment, or only by enterprise contract?

Also test delivery portability. The OpenFeature specification can reduce application-level coupling to a flag provider, although it does not standardize warehouse schemas, metric definitions, or historical experiment records.

Independent reviews are useful for discovering onboarding and usability concerns, but they do not prove a data architecture. For example, current Eppo reviews on G2 and Statsig reviews on G2 can inform questions about setup and day-to-day use. Confirm every technical claim against current documentation and your own query logs.

Test your BigQuery workflow

Connect governed warehouse metrics to transparent experiment analysis and validate the pipeline with real data.

Start Building Free

1. GrowthBook: Best overall for transparent warehouse-native experimentation

Where it fits

GrowthBook is the strongest default for engineering, product, and data teams that already trust BigQuery as their analytical source of truth. Its warehouse-native architecture connects experiment analysis to existing warehouse data rather than requiring all business events to be copied into a proprietary event store.

That model is particularly useful when a decision depends on metrics such as contribution margin, paid conversion, subscription renewal, support load, or organization-level activation. Those facts rarely exist in a client analytics SDK with the same cleaning, identity resolution, and governance applied in the warehouse.

BigQuery integration and permissions

GrowthBook data sources define how to query experiments and metrics. Teams map an experiment-assignment query to the stable randomization unit, variation, experiment identifier, and exposure time. Reusable metrics then query outcome facts. The analysis engine generates SQL, executes it against BigQuery, and uses aggregate results for statistical analysis.

The practical advantage is inspectability. An analyst can preview the query, reconcile rows in BigQuery, and reason about conversion windows, denominator rules, and late data. GrowthBook's data-source documentation should be treated as the starting point; the production contract belongs in version-controlled warehouse models and runbooks.

Use a dedicated service account and query project. Grant job execution in that project and read access only to approved datasets or authorized views. If your deployment enables caching or materialization, isolate those objects. Apply BigQuery job labels so experiment workloads are visible in billing and INFORMATION_SCHEMA.JOBS.

Key strengths

GrowthBook combines warehouse-native analysis with feature flags and experiments, allowing one platform to cover assignment, exposure logging, and decision analysis without making its event collector the only source of truth. Teams can also analyze exposures created by another flag service or an internal assignment system.

Its open-source foundation and cloud or self-hosted deployment options matter for organizations that need architectural control. The statistical layer supports frequentist and Bayesian workflows, variance reduction, guardrails, and reusable metrics. Results remain connected to the SQL and metric definitions that produced them.

The public GrowthBook pricing offers a free starter tier and a per-seat Pro tier, while enterprise capabilities are custom priced. BigQuery users should still model warehouse compute separately: software pricing does not include bytes scanned or reserved slot consumption.

Watchouts

Warehouse-native flexibility does not repair inconsistent data. You need a dependable exposure contract, stable identifiers, and unit-level metric facts. A team that expects a no-code platform to discover every business rule will struggle.

The proof of concept should therefore include one A/A test and one completed A/B test. Compare populations, metric values, and effect estimates with an analyst-owned reference. Review generated SQL and measure bytes processed. GrowthBook is most compelling when your team values transparency enough to perform this validation.

Pricing and implementation notes

Start with one BigQuery project, one exposure source, one binary metric, and one revenue or count metric. Build production access only after the team can explain every join and filter. If security, self-hosting, or procurement requirements are substantial, book a GrowthBook demo to validate them against the intended topology.

2. Datadog Experiments: Best for teams already operating in Datadog

Where it fits

Datadog Experiments brings experimentation into a platform many engineering organizations already use for observability, real-user monitoring, and product analytics. It can be attractive when teams want to read business outcomes from BigQuery and examine performance or behavioral signals within the broader Datadog workflow.

Datadog's current Experiments documentation supports experiments randomized with Datadog Feature Flags and bring-your-own randomization defined by warehouse exposure models. Warehouse-native mode supports BigQuery, Snowflake, Redshift, and Databricks.

BigQuery integration and permissions

The BigQuery warehouse connection guide requires a service account, a BigQuery output dataset, and a Cloud Storage bucket used to stage experiment records. Source datasets receive viewer access; the output dataset and bucket receive write permissions needed by the pipeline.

Metric SQL Models describe warehouse outcome data, while Exposure SQL Models can describe assignments generated outside Datadog. The documented analysis path filters and deduplicates exposures, joins post-exposure metric events, aggregates at the subject level, applies configured outlier handling, and computes group summaries.

This is genuine warehouse-native analysis, but the required write surface is broader than a read-only connection. Security review should cover the dataset, storage bucket, service-account ownership, outbound network controls, and whether Datadog-synchronized exposure logs are used. The documentation also states that an organization supports one warehouse connection, an important constraint for companies with regional or business-unit isolation.

Key strengths

The integrated view is Datadog's clearest advantage. An experiment can combine warehouse business metrics with user behavior and system performance. That can shorten the investigation from “conversion fell” to “the treatment increased latency for a specific segment.” Protocols and diagnostics can standardize planning and identify problems in exposures, metrics, randomization, or analysis.

Bring-your-own assignment support avoids forcing a flag migration merely to evaluate the analysis product. Teams can define an Exposure SQL Model over existing logs, provided warehouse-native metrics are used with that path.

Watchouts

The platform's breadth can also be an adoption cost. Data scientists, product managers, application engineers, and observability owners need a shared operating model. Confirm which Datadog products and permissions are actually required for your intended metrics.

Current documentation says warehouse results refresh nightly by default, with an on-demand update option. Validate whether that cadence fits launch monitoring and decision meetings. Also test the one-warehouse-connection constraint if your company separates data by region or subsidiary.

Pricing and implementation notes

Datadog publicly prices Experiments per successfully launched experiment. Its pricing page currently lists a starting annual-contract rate and explains the subject and duration thresholds that make a launch billable. Because this can change, use the pricing page and a written quote rather than embedding an old number in a budget.

Run the POC inside the Datadog account and BigQuery project that resemble production. Measure the combined cost of product licenses, experiment volume, BigQuery queries, output storage, and the operational ownership of the integration.

3. Statsig Warehouse Native: Best for an integrated enterprise product stack

Where it fits

Statsig combines feature gates, experimentation, product analytics, and session-oriented workflows. Its Warehouse Native offering fits larger organizations that want that integrated product stack while computing experiment results over BigQuery source data.

Statsig's pipeline documentation describes a warehouse pipeline that processes first exposures, metric data, user-level values, and group-level summary statistics. Teams can use Statsig's assignment infrastructure or bring existing assignment and metric sources.

BigQuery integration and permissions

The current BigQuery connection guide says Statsig reads experiment data and writes staging tables in the customer's Google Cloud project. Setup can use a Statsig-owned service account or supplied first-party credentials. It requires job execution, read access to selected source datasets, and editor access on an isolated staging dataset.

That explicit staging model is useful for permission planning. It is not a read-only connector, so create a dedicated dataset, constrain source grants, and monitor data manipulation and query jobs. Statsig's privacy documentation recommends isolating the staging environment and says the product modifies tables it creates there.

For teams that log through Statsig SDKs, forwarded data can place exposure and event records into BigQuery. For teams with another flagging system, assignment sources can use warehouse records. Evaluate these paths separately: they differ in freshness, deduplication, operational ownership, and portability.

Key strengths

Statsig offers a broad experimentation system: reusable metrics, diagnostics, variance reduction, sequential methods, layers, holdouts, and integrated flags. Warehouse Explorer and no-code configuration can make BigQuery facts accessible to product teams after data owners establish safe models.

The option to combine managed assignment with warehouse outcomes can reduce integration work for a team that wants one vendor. Conversely, bring-your-own assignment lets a company preserve an existing delivery layer.

Watchouts

Warehouse Native is a distinct deployment and commercial commitment. Statsig's documentation says migrations from its cloud product should use a separate Warehouse Native project for side-by-side validation, not an in-place conversion. That is sensible, but it means teams should budget for duplicate setup and reconciliation.

Review event forwarding carefully. Current docs describe different schedules and freshness behavior for exposures and events, including deduplication and retention details. A POC should compare the forwarded tables with your own exposure logs and establish which record is canonical.

Pricing and implementation notes

Statsig's pricing page places warehouse-native deployment in the custom-priced Enterprise tier. Its lower tiers use event-oriented pricing, but they should not be treated as a proxy for a Warehouse Native quote.

Request a quote tied to your experiment volume, warehouse topology, support level, event forwarding, and expected contract term. During implementation, keep source datasets read-only to the service identity and grant write access only to the dedicated staging dataset.

4. Optimizely: Best when BigQuery is a downstream destination

Where it fits

Optimizely remains relevant for enterprises already using its Web Experimentation or Feature Experimentation products. Its BigQuery integration is most useful when those teams want Optimizely-generated experimentation data available in BigQuery for reconciliation, reporting, or custom modeling.

The crucial distinction is direction. Optimizely's documented integration does not present itself as a platform that reads arbitrary canonical BigQuery metrics and performs the full experiment pipeline inside your project. It shares Optimizely Experimentation data into BigQuery.

BigQuery integration and permissions

The current BigQuery data-sharing guide configures a connection between a customer's BigQuery project and an Optimizely Experimentation dataset. The data is made available as a linked dataset through Analytics Hub. Optimizely notes location and access prerequisites that should be checked early.

This can simplify access to Optimizely event data and avoid a bespoke export job. Analysts can join the shared data to account or financial facts in BigQuery. Those downstream joins and statistical analyses, however, become your responsibility unless another supported Optimizely workflow covers them.

Key strengths

For an established Optimizely program, data sharing can make experiment events more accessible without replacing the assignment and delivery platform. It also gives a central data team a path to audit results, create custom segments, and connect tests to outcomes not modeled in the vendor UI.

Optimizely has mature web and feature experimentation capabilities. Organizations already invested in its governance, visual workflows, and SDKs may reasonably prefer adding BigQuery access to migrating the delivery layer.

Watchouts

Do not score this as equivalent to query-in-place analysis. Ask whether a proposed metric is computed by Optimizely before data sharing or by your team after the rows arrive. Verify event completeness, identifiers, freshness, schema changes, regions, deletion behavior, and historical availability.

You may also need to build and operate the BigQuery-side semantic layer that a warehouse-native experimentation platform would provide. That can be a good trade if your data team wants full control, but it is additional work.

Pricing and implementation notes

Optimizely pricing is quote based and depends on products, traffic, and implementation shape. Its support guidance on plan costs directs buyers to evaluate those variables with the vendor.

In the POC, provision the linked dataset, reconcile a known experiment, and estimate the cost of the downstream models and dashboards you will own. Compare the total with a platform that computes warehouse metrics directly.

5. Varify: Best for GA4-centered web experimentation

Where it fits

Varify is a specialized choice for marketing and conversion teams that run browser-based experiments and measure them through Google Analytics 4. Its BigQuery integration reads raw GA4 export data and presents experiment reporting without requiring the operator to write the queries.

That is narrower than a product experimentation platform that models subscription, account, or operational facts across arbitrary tables. It may be exactly the right scope for a CRO team whose assignment and measurement already revolve around web pages and GA4.

BigQuery integration and permissions

Varify describes its BigQuery results integration as direct evaluation over GA4 raw data. Its current setup material says the connection can use read-only access and automatically calculate experiment results from the selected dataset.

This can avoid relying on aggregated GA4 reports for test decisions. It also avoids creating a second independent tracking system when GA4 is already the team's agreed measurement layer.

Key strengths

The combination of a visual or code editor, browser experiment delivery, and no-SQL BigQuery reporting reduces the distance between a conversion idea and analysis. Pricing is public, flat by plan, and not based on tested traffic according to the current Varify plan page.

For smaller web teams, that focus can be a strength. They do not have to configure a general metric catalog or teach marketers a warehouse-native product designed for application experimentation.

Watchouts

The approach inherits the quality of GA4 instrumentation and identity. BigQuery access does not correct duplicate events, consent gaps, cross-device identity, missing revenue adjustments, or a treatment marker that fires after the outcome. Reconcile the experiment population with browser logs and order systems.

Varify's claims about exact raw-event analysis and handling should be validated with query-level evidence. Ask for the generated query or enough documentation to reproduce a result. Confirm how statistical methods, outliers, multiple goals, and late GA4 exports are handled.

Pricing and implementation notes

Public plans can make initial budgeting easier than an enterprise quote. Still include GA4 export setup, BigQuery storage and query cost, consent implementation, and analyst QA in the total.

Use Varify when the bounded use case is web conversion testing. If the roadmap includes backend experiments, account-level randomization, long-term retention, or governed finance metrics, compare it with a broader warehouse-native platform before standardizing.

Which tools did not make the native shortlist?

Many capable experimentation products can send data to BigQuery through an export, integration platform, or custom pipeline. That is not enough for this list. A tool belongs in the query-in-place category only when current documentation explains how it reads warehouse exposure and metric data and executes the experiment pipeline against it.

This exclusion is not a judgment that exports are inferior. An export-first architecture may be ideal when the vendor's SDK is the canonical collector and the data team wants independent auditability. It simply solves a different problem.

When evaluating another vendor, ask it to place itself in the four integration levels above. Then request documentation for the exact data path. If the answer relies on “we have a BigQuery connector” without explaining computation and egress, treat the architecture as unverified.

A practical BigQuery proof-of-concept plan

Do not compare tools with unrelated demo datasets. Give each finalist the same historical tests, definitions, and success criteria.

Step 1: Prepare two reference experiments

Select one A/A test or synthetic random split and one completed A/B test. The A/A test exposes imbalance and pipeline bias; the completed test checks whether the tool reproduces a known practical result. Include at least one binary metric and one revenue or count metric.

Automate a sample ratio mismatch check before interpreting effects. The published SRM taxonomy and diagnostic guidance shows why a simple allocation discrepancy can be a symptom of assignment, logging, filtering, or joining failures.

Freeze a reference table containing first exposure per unit, assigned variation, eligibility, and timestamps. Freeze unit-level outcome facts for the agreed conversion window. Have an analyst calculate control and treatment counts, means, variances, and exclusions independently.

Step 2: Give every vendor the same access boundary

Create a dedicated service identity or vendor identity. Grant permission to run jobs in an isolated project, read only POC views, and write only to a vendor-specific scratch dataset when required. Never hand a vendor project-wide editor access because it makes setup faster.

Google's authorized-view guidance can limit direct source exposure. Remember that column masking, row policies, VPC Service Controls, and region constraints may affect generated queries. Test the real controls instead of promising to add them after selection.

Step 3: Reconcile populations before statistics

For each platform, compare:

  1. eligible units;
  2. first exposed units;
  3. units observed in multiple variations;
  4. units excluded for missing identifiers;
  5. metric maturity and conversion windows;
  6. null, zero, and missing-event behavior;
  7. per-variation unit counts and metric sums.

If those differ, confidence intervals will differ for a reason. Resolve population semantics before debating statistical schools.

Use the same estimand and statistical settings as well. A broad review of online controlled-experiment methods describes the methodological choices that can produce defensible but different outputs from the same underlying rows.

Step 4: Review generated queries and compute cost

Use BigQuery dry runs or query previews to estimate bytes scanned. Inspect partition filters, selected columns, join cardinality, temporary tables, and repeated scans. Google's query-cost guidance recommends previewing costs and controlling bytes billed; apply the same discipline to vendor-generated SQL.

Run each platform on a cold cache and on its normal refresh cadence. Use 0 to attribute bytes, slot time, failures, destination tables, and labels. Model daily, monthly, and peak concurrent costs.

Step 5: Change a metric

Modify a conversion window, exclusion, or attribution rule. Observe who can make the change, how it is reviewed, whether historical experiments recompute, and whether the old definition remains discoverable.

This exercise reveals the actual metric-governance model. A polished result page is less important than the team's ability to change a definition without silently rewriting history.

Step 6: Test failure and recovery

Rotate the credential, revoke a dataset grant, introduce a schema change in the POC view, and exceed a query budget. Check the alert, error message, retry behavior, and audit trail. Verify that failures cannot widen permissions or leave uncontrolled jobs running.

How to choose among the finalists

Choose GrowthBook when BigQuery is the source of truth, transparent SQL and deployment flexibility matter, and the team wants flags plus rigorous experiment analysis in one system. It is the most balanced option for teams that want a production-capable path without making warehouse-native support an enterprise-only concept.

Choose Datadog Experiments when your organization already centralizes performance, user experience, and operational workflows in Datadog, and the per-experiment commercial model fits your program. The combination of business and performance signals can be unusually valuable for engineering-led experiments.

Choose Statsig Warehouse Native when an enterprise wants an integrated commercial platform for flags, analytics, and experimentation and is comfortable with a custom contract and isolated staging dataset. Validate migration and forwarding details rather than assuming the cloud and Warehouse Native products behave identically.

Choose Optimizely when Optimizely remains your delivery and analysis platform and the immediate need is to make its event data accessible in BigQuery. Treat any BigQuery-side custom analysis as a separately owned data product.

Choose Varify when a CRO team needs focused website testing over GA4 raw data, wants a visual workflow, and does not need the broader unit types or metric catalog of a product experimentation system.

Questions to put in the RFP

Ask every vendor to answer these in writing:

  • Which user-level fields leave BigQuery, and where are they processed or retained?
  • Which source roles and destination roles are required? Can we use authorized views?
  • What temporary and permanent objects are created, by whom, and under what naming policy?
  • Can we use our existing flag service and exposure logs?
  • How are first exposure, crossovers, bot traffic, late events, and identity changes handled?
  • Can analysts inspect and version every metric and generated query?
  • How are A/A tests, sample ratio mismatch, novelty effects, and multiple comparisons handled?
  • What is the normal refresh cadence, and what triggers recomputation?
  • How are BigQuery jobs labeled, budgeted, retried, and canceled?
  • What are the complete software, implementation, support, storage, and compute costs?
  • Can we export definitions, experiment history, and results in a usable format?
  • What changes if we move regions, warehouses, or assignment providers?

Community conversations about warehouse-native tools often focus on data control and avoiding duplicate event pipelines. A recent practitioner discussion about platform selection also warns that a platform cannot rescue poor instrumentation. That is the right framing: software can automate a trustworthy contract, but it can also automate a broken one faster.

The bottom line

GrowthBook, Datadog Experiments, and Statsig Warehouse Native have the clearest current claim to query-in-place BigQuery experiment analysis. Optimizely has a valuable data-sharing integration, and Varify offers a focused GA4-to-BigQuery workflow for web testing. Put them in different categories before comparing features or prices.

For most teams beginning with canonical BigQuery metrics, GrowthBook is the best starting point. It combines warehouse-native analysis, integrated assignment, transparent definitions, open-source deployment choice, and an accessible path to a real proof of concept. You can start building free with a bounded data source and expand only after the results reconcile. The recommendation is strongest when the team is willing to validate exposures, metrics, SQL, and compute cost rather than outsource judgment to a dashboard.

Record the selection as an architectural decision, not just a procurement score. Name the canonical exposure source, metric owners, service account, execution project, staging dataset, expected refresh cadence, cost boundary, and export plan. Those commitments determine whether the chosen “integration” stays understandable after the implementation team changes.

Schedule a post-implementation review after the first production experiments. Compare actual job cost, refresh latency, metric-change effort, support load, and data discrepancies with the POC assumptions. Vendor selection is complete only when the operating evidence supports the promised architecture.

Repeat the review before renewal so pricing, product scope, and the data path are evaluated against current reality rather than the original demo.

Choose warehouse-native testing

Use your source-of-truth BigQuery metrics, inspect the analysis path, and build an experimentation program your data team can govern.

Create a Free Project

Table of Contents

Related Articles

See All Articles
Experiments
Feature Flags
AI

CLI vs MCP: TLDR, it doesn’t matter as much as you think

Oct 21, 2026
x
min read

Your agent should know how to do the job whichever interface it uses.

Your coding agent can already run terminal commands. Your product manager's assistant can connect to remote tools. Both need to inspect the same experiment, understand the same metric, and prepare changes to the same feature flag.

That creates a familiar question: should you give them a CLI or an MCP server?

The usual answers mix several concerns. A CLI is easy to compose with scripts. MCP gives compatible clients a standard way to discover and invoke tools. Skills can supply the instructions that make either route useful. None of those statements tells you whether the agent knows your release process or can distinguish a draft from a live change.

For GrowthBook, the choice has become smaller. We've built the agent layer around a REST API and reusable workflow skills, then made those available through different interfaces. Your choice of CLI or MCP no longer needs to determine which product workflow your agent can understand.

It still determines how the agent connects, executes requests, and handles credentials. This article explains that distinction, shows the same disabled-flag operation through both routes, and gives you a way to evaluate the integration you actually intend to use.

The debate combines three different questions

Start with a specific job: prepare a release control for a new checkout flow. The agent needs to know which project owns checkout, which environments exist, what the default behavior should be, and whether the proposed flag key already exists.

Choosing an interface answers only part of that job.

How can the agent reach the product?

A command-line interface lets an agent invoke a program in an environment where it has shell access. That program can make authenticated API requests and return data. You can also run the same commands yourself, put them in scripts, and preserve output for inspection.

The Model Context Protocol architecture connects a host application to servers through clients. An MCP server exposes capabilities that a compatible host can discover and call. The host might be a coding environment, a desktop assistant, or another agent application.

These categories overlap. A terminal-based agent can also be an MCP client. A local MCP server can be a process launched by that client. A remote MCP connection can work without the host giving the model a general-purpose shell.

So “terminal agent” doesn't automatically mean “use the CLI,” and “MCP” doesn't automatically mean “remote service.” Ask what access the runtime provides before choosing the adapter.

What procedure should the agent follow?

An API can expose a create operation without teaching an agent when to use it. A syntactically valid feature flag might still have the wrong project, an ambiguous key, or a default value that doesn't match the application.

That's the job of a skill: reusable instructions for a recognizable task. The Agent Skills format gives those instructions a portable structure, including a skill entry point and supporting references. A workflow can describe the context to inspect, the sequence to follow, and the evidence to return.

For the checkout example, useful guidance says to resolve environments, check the permanent key, choose a value type, and create the flag disabled. Merely exposing a create command leaves those decisions to the agent's general knowledge.

Skills are also useful when the right answer is to take no action yet. “Create a flag” and “design an experiment” are related requests, but they can require different objects and sequencing. An agent needs enough product guidance to make that distinction.

What context makes the procedure relevant?

Even a good playbook needs the current product state. The agent should inspect the objects in your GrowthBook organization and, when it is changing application code, the repository's SDK initialization and tests.

Those are different sources of context. GrowthBook supplies flags, experiments, metric definitions, and other authorized product resources. Your coding runtime supplies the application files it can access. An MCP connection doesn't by itself grant repository access, and a CLI doesn't by itself explain your metric definitions.

Evaluate the combination: access to the product, a maintained procedure, and enough context to apply that procedure. A comparison that changes all three at once cannot isolate the effect of CLI versus MCP.

GrowthBook puts the durable parts below the interface

We separated the agent layer into responsibilities that can be reused. The product API exposes operations. Skills explain workflows. The interface connects the agent to those two layers.

This is the architectural shift behind GrowthBook's agent experience. Instead of making every client integration carry its own interpretation of experimentation, we can share the interpretation and change how it is delivered.

The API provides the operations

GrowthBook's REST API makes product objects addressable. An agent can inspect a project, retrieve a flag, or perform an authorized operation against those objects.

The rebuilt API described in GrowthBook 4.4 uses shared schemas to support types, validation, and API documentation. The CLI is generated from the API definition. That reduces the amount of separately maintained command logic needed to expose product operations.

The OpenAPI specification explains the underlying principle: a machine-readable description can represent an HTTP API's paths, operations, inputs, and responses. Generation is useful because it derives another interface from that contract.

Generation doesn't mean any installed binary knows every future endpoint. The generated client still has a version, and your GrowthBook server still has a version. A self-hosted instance can lag behind the public documentation. Treat API compatibility as a deployment fact you verify.

Skills provide the workflow guidance

GrowthBook's feature-flags skill routes requests to more specific workflows. Creating a flag, inspecting dependencies, changing targeting, requesting review, and publishing a revision are separate procedures.

That structure lets the agent load the guidance relevant to the current job. The skill authoring guidance on progressive disclosure supports this approach: keep the entry point focused and place detail in references that are loaded as needed.

The benefit is maintainability as well as context management. A correction to a flag workflow can be made in the maintained skill rather than repeated across a series of tool descriptions and client-specific prompts.

There are two shell concepts to keep distinct. The generated growthbook CLI is a terminal interface to the product API. The skills repository also includes a small gb-call helper for making REST requests. Installing a skill doesn't make that helper a globally available command; its location depends on the installation. Both can reach the API, but their configuration and invocation are different.

MCP provides a thin bridge

The current GrowthBook MCP implementation exposes four tools: growthbook_list_skills, growthbook_read_skill, growthbook_api_read, and growthbook_api_write.

An agent discovers a domain, reads the relevant workflow, then makes API calls. It doesn't need a dedicated MCP tool for every product endpoint. Calls described as gb-call GET in a skill map to the read tool; mutating methods map to the write tool with the same path and body.

The bridge does not run the shell helper. It forwards authenticated requests. Product-side permissions and validation remain important because a small tool surface can still reach many operations.

Shared guidance also has a delivery boundary: the MCP server bundles skills when it is built, using a pinned source revision. A newly edited skill in the repository needs to be included in a subsequent server build before that server supplies it. “Shared source” is a maintainability claim, not a promise of instant synchronization.

Explore the shared flag workflows

Open the feature-flags skill to see the procedures that guide creation, targeting, reviews, and publishing. Bring the same workflow knowledge to the agent interface your team uses.

View the Flag Skill

The same disabled flag can use either route

The practical question is whether the interface changes the job. Let's create a Boolean flag called checkout-redesign, with a false default and every environment disabled.

This is an API example for a sandbox project, not an application integration tutorial. It creates a control object; your application still needs a correctly configured GrowthBook SDK to evaluate it. The feature flag documentation covers the product concepts behind that integration.

Connect and verify before preparing the write

For the terminal route, install the current GrowthBook CLI, configure a Personal Access Token through its interactive setup, and inspect the available command syntax:

npm install -g growthbook
growthbook configure
growthbook whoami
growthbook features create --help
growthbook features get --help

Check that the active server and identity are the ones you intend to use. Prefer a tested, pinned CLI version in repeatable automation. Don't include a live token in a command you plan to share.

For an MCP route, the GrowthBook Cloud setup uses the hosted endpoint and browser OAuth. In a client using the documented mcpServers configuration shape, such as Cursor, add:

{
  "mcpServers": {
    "growthbook": {
      "url": "https://mcp.growthbook.io/mcp"
    }
  }
}

Complete the browser authorization and confirm tool discovery. Other clients can use a different configuration shape. Self-hosted GrowthBook users should follow the local stdio or self-hosted HTTP instructions rather than point a private instance at the Cloud service.

Next, let the connected agent discover the flag-creation workflow. These are tool-call parameters, shown separately in the order to invoke them:

{"name":"growthbook_list_skills","arguments":{}}
{"name":"growthbook_read_skill","arguments":{"name":"feature-flags"}}
{"name":"growthbook_read_skill","arguments":{"name":"feature-flags/references/flag-create"}}

The returned guidance should describe the prerequisites for creating the flag. If the workflow isn't present, resolve the server's bundled skill version before substituting instructions from an older integration.

Resolve real IDs and construct one payload

The flag-creation workflow checks existing keys, lists projects, and resolves environments. In the MCP client, invoke the read tool with each of these argument objects:

For the CLI route, perform that discovery with the corresponding command groups documented in the CLI command catalog:

growthbook features list-keys --output-format json
growthbook projects list --output-format json
growthbook environments list --output-format json

Inspect each command's help if your installed version differs. The returned keys, project IDs, and environment IDs are the inputs to the payload below. In MCP, the equivalent read-tool arguments are:

{"path":"/api/v2/feature-keys"}
{"path":"/api/v1/projects"}
{"path":"/api/v1/environments"}

Verify that checkout-redesign isn't taken, identify the sandbox project's ID, and enumerate every actual environment. These read responses determine the payload; don't treat example environment names as a complete inventory of your organization.

Save the following as flag.json, replacing <PROJECT_ID> and the environment keys with the discovered values. This example assumes the only environments are staging and production:

{
  "id": "checkout-redesign",
  "valueType": "boolean",
  "defaultValue": "false",
  "description": "Control exposure to the redesigned checkout",
  "project": "<PROJECT_ID>",
  "environments": {
    "staging": { "enabled": false },
    "production": { "enabled": false }
  }
}

The API represents defaultValue as a string, even for a Boolean flag. Explicitly disabling each environment avoids relying on the organization's default state for newly created flags. Use a PAT for this example so the caller has a user identity for attribution.

Review the permanent key, project, value, and disabled states before submitting. If the intended job is an experiment, route to experiment design first instead of creating an unrelated flag and hoping to connect it later.

Submit once, then read the object back

With the CLI, the create command accepts a JSON body. In a Bash-compatible shell, inspect the request with dry run before submitting:

growthbook features create --body "$(cat flag.json)" --dry-run
growthbook features create --body "$(cat flag.json)" --output-format json

The first command previews a request; it doesn't prove the server will accept it. Run the second only after checking the preview and approving this creation. In PowerShell, use that shell's file-reading syntax rather than paste the Bash substitution unchanged.

The PowerShell equivalent, using the same reviewed file, is:

$flagPayload = Get-Content -LiteralPath .\flag.json -Raw
growthbook features create --body $flagPayload --dry-run
growthbook features create --body $flagPayload --output-format json

The same distinction applies: preview first, approve the specific creation, then submit. Neither command changes the application's deployed code.

Through MCP, call growthbook_api_write with the same payload serialized into its body string. Substitute the same resolved project and environment names:

{
  "method": "POST",
  "path": "/api/v2/features",
  "body": "{\"id\":\"checkout-redesign\",\"valueType\":\"boolean\",\"defaultValue\":\"false\",\"description\":\"Control exposure to the redesigned checkout\",\"project\":\"<PROJECT_ID>\",\"environments\":{\"staging\":{\"enabled\":false},\"production\":{\"enabled\":false}}}"
}

Choose one creation route. Don't run both against the same key; they target the same product object, and the second creation should encounter an existing key.

Verify through the CLI get command:

growthbook features get --id checkout-redesign --output-format json

Or invoke growthbook_api_read with:

{"path":"/api/v2/features/checkout-redesign"}

Check the returned key, project, value type, default value, disabled state of every environment, and absence of unintended rules. Report those facts rather than “success.” No targeting or exposure change is included in this example.

Choose the route that fits the runtime

Once the procedure and API operation are shared, the remaining choice is operational. Where does the agent run? What can it execute? How does it authenticate? What does your team need to inspect afterward?

Shell access favors terminal composition

A shell-capable agent can run the CLI alongside repository tools, save structured output, and combine product inspection with local checks. That is useful when the job includes code changes, generated files, or a reproducible script.

For example, a flag audit can produce an inventory file while an engineer separately checks code references. The agent should preserve the association between the GrowthBook key and each repository reference. The final artifact can include both the product state and the proposed code diff.

The shell makes composition available; it doesn't make a workflow safe by default. A script can select the wrong profile or swallow an error. Decide which failures stop the workflow, where outputs are stored, and which steps need a reviewable artifact.

Remote tool access favors MCP clients

MCP is useful when the host already provides a tool connection but doesn't expose a terminal. A PM can inspect an experiment through a compatible assistant without installing a product CLI inside that assistant's runtime.

The MCP authorization specification defines an authorization framework for HTTP transports. GrowthBook Cloud uses browser OAuth, while local stdio configurations use credentials supplied to the process. Those are distinct deployment paths.

MCP also gives hosts a structured description of tools. The tool specification includes annotations such as read-only and destructive hints. Hosts can use those signals in their interaction design, but the signals are not an access-control boundary. The product must still enforce the caller's actual permissions.

Use a small decision table

Your immediate requirementRoute to considerWhat to verify
Combine product operations with local files and scriptsCLI plus maintained skillsShell access, profile, installed version, structured output
Connect a compatible assistant without a shellHosted MCPHTTP/OAuth support, identity, tools, bundled workflow
Keep requests inside a self-hosted deploymentCLI or self-hosted MCPNetwork reachability, server version, credentials, trusted app origin
Reuse a procedure across different team clientsShared skills through either routeWorkflow revision, API compatibility, expected review artifact

You can support more than one row. An engineer's CLI and a PM's MCP connection can operate on the same objects with different identities and permissions. Standardizing the workflow is often more useful than standardizing everyone's client.

Compare actual outcomes, not tool counts

Four MCP tools can address a large API. A large CLI command catalog can expose the same operations. Counting entries tells you little about whether an agent completed the intended job correctly.

Likewise, there is no universal token or speed result implied by the architecture. The client, model, instructions, response size, pagination, and number of requests all affect a real run. Measure the work you need instead of importing a result from an unrelated integration.

Keep the evaluation task constant

Use one sandbox project and one bounded task. For a read test, ask each route to find a named flag and identify its enabled environments, current revision, and relevant dependencies. For a write test, use separate temporary keys with the same reviewed disabled-flag requirements.

Give both runs the same expected output. Record whether each identified the correct objects, loaded the relevant workflow, handled missing data, and preserved the boundary between creation and exposure. Measure elapsed time and context consumption only alongside those correctness checks.

If one run gets rich workflow guidance and the other gets only a command name, you're testing the guidance as well as the interface. That can still be a useful product evaluation, but describe what changed.

Test failure behavior deliberately

Try a nonexistent object, an existing key, and a credential without the required permission. The agent should identify the failure and stop the dependent action. It should not invent an ID, silently pick another environment, or reinterpret a permission error as permission to retry with a broader credential.

The revision workflow adds another important test: multiple open drafts. When a chain of changes belongs in one revision, the agent must preserve its version rather than repeatedly ask for whichever draft is latest.

A creation receipt and a publication receipt are different artifacts. If your evaluation only checks that a request returned without error, it can miss the point where a proposed change became live or where a draft failed to include the intended edits.

Record the versions behind the result

Capture the CLI version, server version when available, client configuration, and the skill text or revision used. With MCP, inspect the guidance actually returned by the connected server. With installed skills, inspect the local instructions actually loaded.

That record makes a later regression diagnosable. A changed result may come from new guidance, a client update, a changed API, or different product state. “MCP became worse” is too broad to help you fix it.

Build workflows that survive the next client

The most useful consequence of GrowthBook's design is organizational. Engineers, PMs, and analysts can choose the agent surface that fits their work while referring to the same flags, experiments, and metrics.

An engineer can prepare a disabled flag from a terminal. A reviewer can inspect its draft in the app. An assistant connected through MCP can retrieve the same object and explain its state. The handoff should carry an ID, a revision where applicable, the proposed behavior, and the decision still required.

This is where the CLI-versus-MCP question loses much of its importance. Your release procedure doesn't need to be rewritten around each client. The product holds state; the API exposes operations; skills explain the work; the chosen interface delivers access.

Start with one inspection or sandbox creation. Require the agent to return a concrete object and its verified state. Then add the next workflow only when the current one is reliable enough for your team to review.

GrowthBook's feature flag platform gives that work a common place to live. The durable choice is how you connect release control and measurement to your team's process. CLI and MCP are ways to carry that process into the tools people already use.

Start with a common foundation

Set up GrowthBook for the flags, experiments, and metrics your agents will share. Then choose the CLI or MCP connection that fits each team member's work.

Get Started With GrowthBook
Experiments
Analytics

Standard deviation vs variance: Key differences for A/B testers

Oct 21, 2026
x
min read

A metric can have wide user-to-user variation and still yield a precise experiment estimate.

That is why confusing standard deviation with standard error creates bad A/B testing decisions. A dashboard may show that users differ substantially while the average effect is estimated closely enough to guide a release. Those statements can both be true.

Variance and standard deviation describe spread. Variance works on a squared scale; standard deviation takes its square root to return to the metric's original units. Neither is automatically the uncertainty around an experiment result.

For A/B testers, the useful distinction is practical: use standard deviation to communicate outcome variability, use variance in the calculations that combine uncertainty, and inspect the standard error or interval for the treatment effect. Start by making sure all three describe the correct unit of analysis.

Understand the difference in units

Variance uses squared distances

Outcomes above and below a mean have deviations with opposite signs. Simply averaging those signed deviations gives zero. Variance avoids that cancellation by squaring each deviation before combining them.

The sample variance formula is s² = Σ(xᵢ − x̄)² / (n − 1), where x̄ is the sample mean and n is the number of observations. The symbol Σ means to add the terms across observations.

If the outcome is measured in seconds, variance is measured in seconds squared. That is mathematically useful but less intuitive for explaining a product experience. “Variance is 4 seconds squared” does not mean users differ by 4 seconds.

Standard deviation returns to the original scale

Standard deviation is s = √s². A variance of 4 seconds squared corresponds to a standard deviation of 2 seconds. Both describe the same dispersion, expressed on different scales.

Do not define standard deviation as the average absolute distance from the mean. That is a different measure. Squaring deviations gives large deviations more influence, and taking the square root afterward does not undo that weighting.

QuantityWhat it describesUnits for task time
VarianceSquared dispersion in outcomesSeconds squared
Standard deviationOutcome dispersion on the original scaleSeconds
Standard error of the meanSampling variability of an estimated meanSeconds

Neither variance nor standard deviation requires a normally distributed population merely to be calculated. Normality matters for particular interpretations and inferential procedures, not for the existence of these summaries when the required moments are finite.

Calculate both from the same observations

Work through a small dataset

Use four synthetic task times: 2, 4, 4, and 6 seconds. This tiny dataset is for arithmetic, not evidence about a real product or a basis for confident inference.

The mean is (2 + 4 + 4 + 6) / 4 = 4 seconds. Deviations from the mean are −2, 0, 0, and 2 seconds. Their squares are 4, 0, 0, and 4 seconds squared, totaling 8.

Treating these observations as a sample, the usual sample variance is 8 / (4 − 1) = 8/3, or about 2.667 seconds squared. The sample standard deviation is √(8/3), or about 1.633 seconds.

This is a useful check on a report. If someone describes the same sample's variance as 1.633, they have probably substituted the standard deviation. If the units are missing, the mistake is much harder to spot.

Choose sample or population formulas deliberately

If those four observations constitute the entire finite population you want to describe, population variance divides by 4: 8/4 = 2 seconds squared. Population standard deviation is √2, or about 1.414 seconds.

The population and sample distinction depends on what you are estimating. Having every recorded event from an experiment does not necessarily make those events the full population of future users or future conditions you care about.

The n − 1 denominator makes the usual sample variance an unbiased estimator of population variance under independent, identically distributed sampling with finite variance. It does not make the square root exactly unbiased for population standard deviation. Nor does it correct biased sampling or dependence between observations.

Verify the calculation with explicit function names

Python's statistics functions distinguish sample calculations from population calculations. With Python 3 installed, this standalone example requires no external packages or data:

from statistics import variance, stdev, pvariance, pstdev

times = [2, 4, 4, 6]
print(round(variance(times), 3), round(stdev(times), 3))
print(round(pvariance(times), 3), round(pstdev(times), 3))

The first line of output is 2.667 1.633; the second is 2 1.414. The different denominators explain the difference. Before comparing statistics from two tools, check their sample/population defaults and handling of missing values.

Find the noise you can reduce

Explore practical variance reduction methods, including metric design and CUPED, and the conditions that make each approach useful.

Read the Variance Reduction Guide

Use standard errors for experiment uncertainty

Distinguish users from estimated means

Standard deviation describes how users' outcomes vary. Standard error describes how an estimator would vary across repeated samples. For an independent sample, the estimated standard error of its mean is s / √n.

Suppose a user-level task-time metric has a sample standard deviation of 20 seconds among 10,000 independent users. The estimated standard error of the mean is 20/√10,000 = 0.2 seconds. Large differences between users coexist with a much smaller uncertainty around their average.

Collecting four times as many independent users would halve this standard error if the outcome variance stayed similar. It would not mechanically halve user-level standard deviation. The individual experience remains variable even as the estimated mean becomes more precise.

Combine arm variances before taking the square root

For independent treatment and control groups, a simple unadjusted difference in means has estimated variance s²ₜ/nₜ + s²꜀/n꜀. Its standard error is the square root of that sum. You do not add the two arm standard deviations and call the result the experiment's uncertainty.

Take a separate synthetic summary with 10,000 independent users in each arm and a 20-second standard deviation in both. The variance of the estimated difference is 400/10,000 + 400/10,000 = 0.08 seconds squared. Its standard error is √0.08, about 0.283 seconds.

If the observed treatment-minus-control difference is −1 second, an illustrative large-sample, unadjusted 95% normal interval is −1 ± 1.96 × 0.283, approximately −1.554 to −0.446 seconds. Negative values mean faster completion under this metric definition.

This example assumes independent groups and an appropriate large-sample approximation. It is not the exact output of GrowthBook's relative-lift, sequential, covariate-adjusted, or ratio-metric methods. GrowthBook's statistical details describe how the platform estimates effects and their uncertainty.

Avoid interpreting intervals as outcome ranges

That interval concerns the mean treatment effect. It does not say that 95% of individual users improved by between 0.446 and 1.554 seconds. An individual user's causal effect is a different quantity, and the experiment does not observe both potential outcomes for the same person.

Likewise, mean ± one standard deviation is not a universal statement about where 68% of users fall. That familiar interpretation depends on an approximately normal distribution. Skewed task times or revenue can look very different.

The frequentist confidence level describes the repeated-sampling coverage of the interval procedure under its assumptions. It is not a posterior probability assigned to a fixed realized interval.

Check what your metric actually measures

Match the variance to the randomization unit

If users are randomized and each contributes many requests, request rows are not automatically independent experimental units. Treating 100 requests from one person as 100 unrelated users can make uncertainty look smaller than it should.

Define the outcome at the intended unit or use a method that accounts for clustering. GrowthBook's aggregate data requirements are relevant when supplying precomputed summaries: the sample size, sum, and dispersion must correspond to the statistic and analysis method.

Two teams can report different standard deviations without either making an arithmetic mistake. One may summarize per-request latency while the other summarizes each user's average latency. They are describing different outcome distributions. Clarify the grain before comparing their numbers.

Paired measurements need another distinction. If the same users provide before-and-after outcomes, the measurements within each pair can be correlated. Analyze each user's difference or use an appropriate paired method; do not apply the independent-arm formula automatically. The paired-means framework treats those differences as the observations of interest. Pairing also does not remove time trends or establish causality by itself; the design still determines which comparison is defensible.

Inspect tails instead of deleting them casually

Large observations influence both variance and standard deviation. A few unusually long tasks can dominate a time metric; a few large purchasers can dominate revenue. Determine whether those values reflect valid behavior, instrumentation defects, retries, or unit errors.

A valid expensive user is not automatically an outlier to discard. Removing high values after seeing an experiment result can change the estimand and introduce selective analysis. Decide justified exclusions or transformations before interpreting the test.

Report complementary summaries when they answer useful questions: a histogram, median, or a relevant tail percentile can show what a single spread measure hides. Those summaries do not replace the mean effect if the mean remains the decision metric.

Keep units consistent across pipelines

Converting seconds to milliseconds multiplies every value by 1,000. Standard deviation also multiplies by 1,000, but variance multiplies by 1,000,000. A dramatic numerical variance increase can therefore be a unit conversion rather than a product regression.

For the four-value example, sample standard deviation becomes approximately 1,633 milliseconds and variance becomes approximately 2,666,667 milliseconds squared. The underlying task times have not changed. Store units with metric definitions and inspect them when comparing dashboards.

A lower variance caused solely by rescaling a metric does not create more statistical information. The effect size rescales too. Separate a numerical change in units from an actual improvement in the precision of your estimate.

Also avoid averaging standard deviations from daily reports and labeling the result a weekly standard deviation. The complete-period spread depends on both variation within days and differences between daily means. Keep the underlying observations or sufficient summaries that support the intended calculation. A simple average of displayed daily values generally loses information needed to reconstruct the full distribution.

Turn spread into a better testing plan

Define the outcome before planning the sample

Start with the metric definition: population, identity, aggregation, window, units, exclusions, and desired effect. Estimate variability from representative historical data at that same grain.

Historical variance is an input, not a guarantee. New traffic, a different user mix, or a changed measurement window can alter it. Explore plausible variance and effect-size assumptions rather than treating one historical number as exact.

Keep the two arm variances separate when appropriate. A treatment can change variability as well as its mean. The simple equal-standard-deviation illustration above is a teaching assumption, not a requirement that production groups have identical spread.

Reduce estimation noise without hiding behavior

CUPED and post-stratification use suitable pre-experiment information and covariates to improve effect estimation. CUPED stands for Controlled-experiment Using Pre-Experiment Data. Its value depends on useful predictive information and a valid implementation.

Adjustment can reduce uncertainty in the treatment effect without making real users' outcomes less variable. That distinction prevents a reporting error: a narrower adjusted interval is not evidence that customers now experience a more consistent product.

Also separate missing data from genuine zeros. A user with no purchase may correctly contribute zero revenue; a missing instrumentation event might represent an unknown outcome. Treating both identically can distort the mean and its variance before any statistical engine sees the data.

Report the right quantity for the decision

Reader's questionUseful quantity
How much do individual outcomes differ?Standard deviation, with distribution context
What enters this uncertainty calculation?Variance at the correct analysis unit
How precisely is the effect estimated?Standard error and an appropriate interval
Is the measured difference worth acting on?Effect size, uncertainty, guardrails, and decision context

For a clear experiment readout, show the metric's unit and analysis grain, the estimated effect, and its appropriate uncertainty interval. Add outcome spread when it helps readers understand the population or diagnose a noisy metric.

GrowthBook's experimentation platform brings defined metrics and statistical analysis together. A trustworthy interpretation still starts with your measurement choices: describe spread with standard deviation, calculate with variance where required, and judge precision using the estimator's uncertainty.

Build a clearer experiment readout

Connect your metrics to GrowthBook and evaluate effects with the analysis method and measurement definitions your team has chosen.

Get Started With Experimentation
Experiments
Analytics

How to calculate true positive rate (TPR)

Oct 21, 2026
x
min read

Catching 80 defects means little until you know how many defects existed.

Suppose a detector flags 125 suspicious software changes. Engineers inspect them and confirm 80 real defects. That tells you something about alert quality, but it does not tell you how many defects the detector missed. To calculate true positive rate, you need the actual positives outside the alert queue too.

True positive rate, or TPR, measures the share of actual positive cases that a system correctly identifies. It is also called recall or sensitivity. The formula is TP / (TP + FN), where TP means true positives and FN means false negatives.

The arithmetic is simple. Choosing the right population, labels, threshold, and denominator is the difficult part. This guide works through an engineering example, distinguishes neighboring metrics, and explains what changes when the “test” is an A/B experiment rather than an item classifier.

Start with actual positives, not alerts

Define the positive class

“Positive” means the condition you want to detect. It does not necessarily mean a good outcome. In a defect detector, positive means a real defect. In a spam filter, it means spam. Write that definition before calculating anything.

A true positive is an item that is actually positive and predicted positive. A false negative is actually positive but predicted negative. Those two groups together form the denominator: all actual positives in the evaluation sample.

The recall definition is therefore conditional on actual class membership. TPR asks, “Among the real defects, what proportion did we catch?” It does not ask, “Among the alerts, what proportion were real?”

Fix the unit and observation window

Choose a consistent evaluation unit. A code change, an individual finding, and a repository are different units. If one change generates 12 duplicate alerts, counting alerts in the numerator and changes in the denominator produces a meaningless rate.

For the example, each unit is one code change, evaluated once by one fixed detector version at one fixed threshold. An independent review process eventually labels each change as defective or not defective. The observation window is long enough for those labels to mature.

This resembles the discipline needed when defining experiment metrics: the event, identity, time window, and denominator must describe the same question. A correct formula applied to incompatible counts still gives the wrong answer.

Calculate TPR from the confusion matrix

Put every evaluated item in one cell

Consider an original synthetic evaluation of 1,000 code changes. Reviewers establish that 100 contain a defect and 900 do not. The detector catches 80 defects, misses 20, and incorrectly flags 45 nondefective changes.

Actual labelPredicted positivePredicted negativeTotal
Defective80 true positives20 false negatives100
Not defective45 false positives855 true negatives900
Total1258751,000

Read the labels rather than relying on cell position. Libraries and reports can arrange axes differently. The scikit-learn confusion matrix convention uses actual classes on rows and predicted classes on columns, with class order also affecting where each value appears.

Check the totals before calculating rates. The four cells sum to 1,000. True positives plus false negatives sum to 100 actual defects. Predicted positives total 125, which is a different denominator.

Divide detected positives by all actual positives

The calculation is:

TPR = TP / (TP + FN) = 80 / (80 + 20) = 80 / 100 = 0.80 = 80%.

Interpret it in words: the detector caught 80% of the actual defects in this evaluation sample. It missed 20%, so the false negative rate is 20%. For a binary task with complete labels, TPR and false negative rate sum to 100%.

Do not divide 80 by 1,000. That would measure true positives as a share of all evaluated changes, not recall. Do not divide 80 by 125 either. That is precision, which answers the alert-quality question.

The result describes this sample and threshold. It does not establish that every future workload will have the same recall, or that all defect categories are equally detectable. Keep the counts beside the percentage so readers can see the support behind it.

Handle zero positive support explicitly

If the sample contains no actual defects, TP + FN equals zero. Sample TPR is undefined. Returning 0% would imply the detector missed known defects; returning 100% would imply it successfully found them. Neither interpretation is supported.

Software libraries need a practical zero-division convention. That convention can return a placeholder or warning, but it does not create evidence. Report “TPR unavailable: zero actual positives” and preserve the support count. A pipeline can then distinguish an unevaluable slice from measured poor performance.

Check the experiment error risks

See how power, repeated checks, and multiple comparisons affect the reliability of experimental decisions beyond a single classifier score.

Read the False Positives Guide

Compare TPR with precision and false positives

Keep the denominators visible

For the same 1,000 changes, the other common metrics tell different stories:

MetricCalculationResult
True positive rate / recall80 / 100 actual positives80%
Precision80 / 125 predicted positives64%
False positive rate45 / 900 actual negatives5%
Specificity855 / 900 actual negatives95%
Accuracy(80 + 855) / 1,000 changes93.5%

The classification metric definitions differ because they condition on different populations. Here, 36% of alerts are false, but the false positive rate is 5%. Calling both numbers “the false positive rate” hides the operational distinction.

Accuracy can also look reassuring in an imbalanced population. A detector that labels all 1,000 changes nondefective would be 90% accurate while detecting none of the 100 defects. TPR exposes that failure, though it still needs the false-positive side of the picture.

Choose a threshold for the decision

Suppose a stricter threshold, evaluated on the same labeled changes, catches 60 defects and incorrectly flags 10 nondefective changes. Its TPR is 60%, its precision is about 85.7%, and its false positive rate is about 1.11%.

This threshold reduces the review queue from 125 changes to 70. It also misses 40 defects instead of 20. Whether that tradeoff is acceptable depends on the consequences of a missed defect, the review team's capacity, and what action follows an alert.

A ROC curve plots TPR against false positive rate across thresholds. It helps compare operating points. It does not pick the operational threshold for you, and an area-under-curve summary does not specify the queue size at the threshold you intend to deploy.

If you tune thresholds using the same labels you later report as a final evaluation, the score can be optimistic. Use separate validation and held-out evaluation data, or another defensible evaluation design, and freeze the decision rule before the final assessment.

Specify the action at each threshold too. A low-confidence finding might create a suggestion, while a high-confidence finding might block a merge. Those are different interventions with different error costs. One aggregate recall figure should not imply that every detected item received the same treatment.

Make sure the labels can support the claim

Audit predicted negatives too

If engineers review only alerts, you can estimate precision within the reviewed alert population. You cannot directly count missed defects among unreviewed negatives. Assuming those changes are clean makes FN artificially small and TPR artificially high.

An evaluation may need independent review of a representative sample of predicted negatives, delayed incident labels, or a curated benchmark with known defects. Each approach has limits. Incident labels miss undetected failures; curated examples can differ from ordinary production work.

If the evaluation oversamples suspicious changes or certain repositories, report that design. Use appropriate weighting when estimating performance for the real workload. A simple unweighted confusion matrix describes the sampled dataset, which may not represent the deployed population.

Preserve uncertainty and segment support

An 80% estimate based on 4 detected defects out of 5 is much less precise than one based on 800 out of 1,000. The important sample size for recall is the count of actual positives, not just the total number of changes evaluated.

Report positive support by important slices, such as language, defect category, or repository type. A high pooled TPR can hide weak performance on a rare but expensive failure mode. At the same time, avoid declaring tiny slices definitively better or worse from a few examples.

Counts alone do not make observations independent. Many similar changes from one repository can share a common pattern. Use uncertainty methods that fit the evaluation design rather than assuming every row is an unrelated trial.

Separate label delay from label absence

A recently deployed change might appear nondefective because nobody has had time to find the bug. Treating it as a confirmed negative gives the newest cohort a different labeling standard from older cohorts.

Define when an item becomes eligible for evaluation and track unresolved labels separately. Keep model version, threshold, label version, and observation dates with the result. That makes a later score change interpretable: you can tell whether the detector changed, the workload changed, or the labels matured.

For a warehouse-native measurement workflow, these definitions belong in the underlying data model. Joining model decisions to review outcomes still requires identity and time alignment; a queryable warehouse does not automatically resolve ambiguous ground truth.

Keep comparable populations together

When comparing detector versions, evaluate them on the same held-out cases where possible. Otherwise, an apparent recall improvement could come from an easier mix of defects. Preserve a breakdown of new, removed, and unchanged cases so reviewers can see what changed between evaluations.

When combining reports, add the underlying TP and FN counts for nonoverlapping, consistently defined populations, then calculate the pooled rate. An unweighted average of repository percentages answers a different question because it gives a tiny repository the same influence as a large one. Either summary can be useful, but label the weighting explicitly.

If the same change appears in several reports, deduplicate or model that repeated observation before pooling. Repeated scans do not create additional independent defects. Keep an audit trail from the final counts back to the evaluated item identifiers so a suspicious rate can be investigated.

Connect detection quality to product decisions

Distinguish classifier recall from statistical power

In hypothesis testing, statistical power is the probability that a testing procedure rejects the null when a specified alternative is true. It is a repeated-test detection probability, depending on assumptions such as effect size, variance, sample size, and decision rule.

That is related to the idea of detecting a real signal, but it is not the same dataset as a labeled-item confusion matrix. In an ordinary A/B program, you do not observe the true causal effect of every experiment with certainty. Dividing declared winners by all experiments does not reveal a ground-truth TPR.

Power planning asks how often your procedure would detect a particular real effect under its assumptions. A classifier evaluation asks how many labeled positives were detected in the evaluated sample. Keep those questions separate when discussing GrowthBook's statistical methods.

Evaluate the intervention as well as the detector

An improved offline detector can still create a worse product workflow. More alerts might overwhelm engineers, delay releases, or catch defects too late to matter. Conversely, a modest recall change might be valuable if it catches the failures with the highest operational cost.

When appropriate, use randomized experiments to evaluate the downstream intervention: which review experience helps teams resolve defects, with what delay and cost? Keep detector recall, review workload, and product outcomes as separate measures.

GrowthBook's experimentation platform can analyze defined outcomes from such tests. Your team supplies reliable assignment, exposure, labels, and metric definitions. Neither a high TPR nor a significant product result eliminates the need to inspect the other evidence.

Use a repeatable reporting checklist

Before sharing a TPR number, state the positive class, evaluation unit, detector version, threshold, and label process. Show TP and FN beside the rate. Include precision or false positive rate so readers can assess the workload created by detection.

Then ask whether predicted negatives were evaluated, whether labels had time to mature, and whether the sample reflects the population where you will act. Mark zero-support slices unavailable and explain material gaps in coverage.

The useful result is a statement someone can audit: “At this threshold, the detector found 80 of 100 labeled defects in these 1,000 evaluated changes, while producing 45 false alerts.” That is a clearer basis for a decision than “our model is 80% accurate.”

Measure what the change delivers

Connect your data and defined metrics to GrowthBook to evaluate how a product or workflow change affects the outcomes your team cares about.

Start Measuring With GrowthBook

Ready to ship faster?

No credit card required. Start with feature flags, experimentation, and product analytics—free.

Simplified white illustration of a right angle ruler or carpenter's square tool.White checkmark symbol with a scattered pixelated effect around its edges on a transparent background.