Introduction to Product Analytics
Altertable's Product Analytics provides API, visualization, and analytical capabilities similar to Segment, Amplitude, and PostHog—with one key difference: everything is stored within your lakehouse.
This unified architecture makes it easy to combine product analytics with your broader data analytics workflows, enabling you to answer questions that span both behavioral and business data.
Built-in Product Analytics Connection
By default, you have a read-only altertable connection for product analytics. This connection is automatically managed by Altertable—data is inserted as your application pushes product events via the Product Analytics API.
| Table | Description |
|---|---|
main.events | Raw events (everything /track receives) |
main.identities | Raw identities (everything /identify receives) |
main.aliases | User aliases (everything /alias receives) |
main.web_sessions | Aggregated session data |
main.web_pageviews | Page-level analytics |
system.metrics | System metrics |
Unified Analytics
Because product analytics data lives in the same lakehouse as your other data sources, you can:
- Join product events with business data: Combine behavioral data with revenue, margins, or support data to answer questions like "which feature drives higher LTV?"
- Query across all data sources: Use SQL to query product events alongside data from your Postgres databases, data warehouses, or other connections
- Build unified dashboards: Create visualizations that combine product analytics with business metrics in a single view
- Leverage AI assistance: Use Altertable's AI agents to surface insights across both product and business data
Key Capabilities
- Event Tracking: Capture product events via SDKs or API with strong typing and validation
- User Identification: Track user identities and attributes across sessions and devices
- Segmentation & Cohorts: Build dynamic cohorts by behavior, attributes, or outcomes
- Funnels & Paths: Model multi-step funnels and user paths across platforms (coming soon)
- Visualization: Interactive charts and dashboards with drill-down capabilities
- SQL Access: Query product analytics data directly using SQL, with AI assistance available
Getting Started
- Set up Authentication: Get your API key and configure authentication
- Install an SDK: Install the JavaScript or React SDK for your application
- Track Events: Start capturing product events using Altertable's SDKs or API
- Identify Users: Set up user identification to track users across sessions
- Query Your Data: Use SQL or the REST API to query product analytics tables
- Combine with Other Data: Connect additional data sources to join with product analytics
All product analytics data is immediately queryable via SQL, making it easy to combine with your existing data workflows and answer questions that span both product behavior and business outcomes.