kapa.ai can metric trees connect to DWH data? if yes, how does it look like once connected? what kind of data do metric trees need (events, counts, something else)?
Metric Trees and Data Warehouse (DWH) Connections
Can Metric Trees connect to DWH data?
Yes, but indirectly. Mixpanel's Warehouse Connectors allow you to sync data from warehouses like Snowflake, BigQuery, Databricks, Redshift, and Postgres directly into Mixpanel. [Warehouse Connectors] Once that data is synced into Mixpanel, it becomes available to use in Metric Trees like any other Mixpanel data.
How does connecting data to a Metric Tree work?
Each metric card in the tree has a connect metric option. Clicking it opens a standard Mixpanel query panel — the same one used in Insights and other reports. From there, you can: [Metric Tree Quick Start]
Select a saved metric (recommended, especially for top-level metrics, to ensure standardized definitions and ownership)
Or build a new metric on the spot
Once connected, the metric card displays live values alongside trend sparklines and period-over-period comparisons (e.g., MoM, YoY). You can also drill into underlying reports, filter the entire tree (e.g., by platform or segment), and use the "As Of" control to view historical snapshots. [Metric Tree FAQ] Here's an example of what a connected metric tree looks like: thesignalprod.wpenginepowered.com/wp-content/…/mixpanel-metric-trees-overview…
What kind of data do Metric Trees need?
Metric Trees use Mixpanel metrics, which are built on top of event data and user/group profiles. Specifically, a metric is a combination of: [Insights Quick Start]
A behavior (events, funnel steps, retention patterns, or profiles/cohorts)
A measurement (e.g., unique users, total event count, aggregate property value)
So the underlying data format is event-based — things like "Account Created," "Subscription Started," or "Job Completed" with associated properties. If your DWH contains tables with unique identifiers and timestamps, Warehouse Connectors can model these as events in Mixpanel, making them usable in Metric Trees. [Tracking Schema Blog]
Tip: The Metric Tree docs strongly recommend saving top-level metrics as Saved Metrics in Lexicon so teams use consistent, verified definitions across the tree. [Metric Tree Quick Start]
Note: Metric Trees are a paid add-on, available only on the Enterprise Plan. [Metric Tree Docs]
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
