Skip to content
DocumentationProduct Analytics
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_count
FROM product_analytics.main.events
GROUP 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.