Skip to main content

Product

For product managers and product analysts tracking feature adoption, user behavior, and retention.

Try These First​

Open the agent and ask:

Show me weekly active users by plan for the last 3 months
Which features have the highest adoption rate?
Build a monthly cohort retention analysis

Key Tables​

TableWhat's in it
eventsUser actions: page views, feature usage, exports
usersUser profiles with plan and signup date
feature_usageAggregated feature adoption per user
accountsAccount-level data with segment and ARR

Common Workflows​

Feature adoption analysis​

Ask the agent:

  • "What % of users have used the reports feature?"
  • "Show adoption curve for integrations feature by week"
  • "Compare feature usage between free and paid users"

Retention cohorts​

Build cohort analyses to understand user stickiness:

Build a cohort retention chart showing monthly retention
for users who signed up in the last 6 months

Funnel analysis​

Track conversion through your product:

Show me conversion from signup → first query → first saved notebook

Defining Product Metrics​

Save your key metrics to the semantic layer:

measures:
  - name: weekly_active_users
    type: count_distinct
    sql: user_id
    filters:
      - sql: "timestamp >= current_date - interval '7 days'"
    description: "Users with any activity in the last 7 days"

  - name: feature_adoption_rate
    type: number
    sql: "COUNT(DISTINCT CASE WHEN usage_count > 0 THEN user_id END)::float / COUNT(DISTINCT user_id)"
    description: "% of users who have used a feature at least once"

Next Steps​