Skip to content
DocumentationProduct Analytics
Product Analytics
Query product data with SQL

Query product data with SQL

Use SQL when you need a custom analysis or want to join product behavior with another catalog. Use the identity-resolved views for analysis that should apply identity mappings.

Inspect available data

Before writing a query, inspect the table schema in SQL Explorer or ask your agent to describe it. Start with a bounded query:

SQL
SELECT * FROM product_analytics.analytics.events LIMIT 10;

Use product_analytics.main.events when you need the raw records received by the tracking endpoint. Choose the view based on whether you want raw or identity-resolved data.

Analyze with an agent

Agent prompt
Read https://altertable.ai/docs/product-analytics/query.md for context. Inspect my Product Analytics schema and help me analyze signup conversion. Confirm the event names, identity mapping, time range, and funnel definition before writing the query. Explain any missing data or assumptions.

For visual analyses, use segmentation, funnels, or retention. For an interactive application, build a data app.