Skip to main content
A materialized segment is a segment that loads its list of units from your BigQuery instance. You write SQL, Confidence executes it as the service account you have configured, and you can then use this list of units as targeting for A/B tests, rollouts, or flag rules.
Materialized segments are only available for BigQuery.

​
When to Use Materialized Segments

Use materialized segments when you need to target a specific list of users defined by complex queries in your data warehouse. Common use cases include:
  • Beta testers: Target users who have opted into beta programs
  • High-value customers: Target users based on purchase history or engagement metrics
  • Cohort analysis: Target users who signed up during a specific period
  • Custom segments: Any segment that’s easier to define in SQL than with attribute criteria

​
How Materialized Segments Work

  1. You define a SQL query that returns a list of entity IDs
  2. Confidence runs this query against your BigQuery instance
  3. Confidence loads the resulting IDs into a segment
  4. You can use this segment for targeting in rules, experiments, and rollouts

Create Materialized Segment

Step-by-step creation guide

Segments Reference

Learn about standard segments

Audience Reference

Configure targeting and allocation

BigQuery Setup

Configure BigQuery connection