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 |