Product Analytics
Product Analytics data model
Product Analytics data model
When you enable Product Analytics, Altertable creates the catalog tables for you and exposes API endpoints that make ingestion easier. As your application sends events and identity updates through the Product Analytics API, Altertable writes the resulting data into these tables and views:
Table | Description |
|---|---|
main.events | Raw events (everything /track receives) |
main.identities | Raw identities (everything /identify receives) |
main.identity_distinct_ids | Raw distinct IDs mapping |
main.identity_distinct_id_overrides | Raw distinct ID override mappings |
analytics.events | Identity-resolved events |
analytics.identities | Identity-resolved user profiles |
analytics.web_sessions | Aggregated session data |
analytics.web_pageviews | Page-level analytics |
Collection mode
The mode column distinguishes product and audience events. Filter by mode when analyzing identified product behavior separately from audience measurement:
SQL
SELECT mode, event, COUNT(*) AS event_countFROM product_analytics.main.eventsGROUP BY mode, event;
Audience events do not carry client-provided user, anonymous, session, or device identifiers. Do not use them as a substitute for identified-user retention or cross-day user journeys.