Query data
Product Analytics
Product Analytics
Product Analytics data is queryable as lakehouse tables and through specialized insight types for common behavioral questions. Use these views when you want to segment users, measure retention, or inspect conversion through a funnel.
Optimize large insights
The insight builder can trade some precision for faster queries on large Product Analytics datasets:
- Sampling reads a repeatable subset of data. Default samples up to 1,000,000 rows; Aggressive samples up to 100,000 rows. Keep sampling Off when exact results matter.
- Approximate counts estimates distinct counts instead of calculating every unique value exactly.
These settings are saved with the insight. Sampled or approximate results are labeled in charts and tables so viewers can see when the result is not exact.
SegmentationGroup users into cohorts from behavioral patterns and compare segments with governed metrics in Altertable insights.RetentionMeasure how cohorts that perform a starting event come back and perform a returning event over time.FunnelTrack user progression through sequential events to measure conversion rates and identify drop-offs.