Why this matters
Referral programs can inflate signup volume without producing retained users. Quality matters more than invite count.
What you get
- Invite send and acceptance rates
- Activation and retention of referred users
- Best inviter cohorts and channels
- Whether referral rewards are attracting quality users
Walk through it
You
Are referrals bringing good users?
Agent
I’ll follow referred users from invite to activation.
Endpoint: POST /v1/projects/:project_id/analytics/query
Exact shape: /v1/openapi.json?path=%2Fv1%2Fprojects%2F%7Bproject_id%7D%2Fanalytics%2Fquery&method=post
Custom HogQL goes in the OpenAPI-defined `query` field.
Concept fields:
query: "SELECT properties.channel AS channel, countIf(event = 'referral_invite_sent') AS sent, countIf(event = 'referral_invite_accepted') AS accepted, countIf(event = 'activated') AS activated FROM events WHERE event IN ('referral_invite_sent','referral_invite_accepted','activated') AND timestamp > now() - INTERVAL 60 DAY GROUP BY channel ORDER BY accepted DESC"The output
The agent returns referral channels and inviter cohorts ranked by activation quality.
Setting it up
Emit referral lifecycle events with stable inviter and invitee identifiers. Preserve referral source onto activation.
Variations
- “Show referrals by power-user cohort.”
- “Find inviters whose referrals activate above average.”
- “Publish referral quality by channel.”