Track waitlist to activation

See which waitlist cohorts convert after invite, where they stall, and whether invite timing changes activation quality.

Published

difficulty beginner · time to value 4 minutes
#analytics #waitlist #activation #onboarding #acquisition #product

Start from this 

Analyze waitlist conversion: joined waitlist, invited, accepted invite, signed up, activated, and retained by cohort and acquisition source.

Why this matters

Waitlists create demand, but delayed access can cool intent. This recipe shows whether your invite cadence turns demand into activation.

What you get

  • Waitlist cohort conversion
  • Invite acceptance and signup rate
  • Activation after invite
  • Source quality and timing effects

Walk through it

You

How well does our waitlist convert after invites?

Agent

I’ll build a waitlist-to-activation funnel by cohort and source.

POST /v1/projects/:project_id/analytics/query {
  project_id: "default",
  hogql: "SELECT properties.cohort AS cohort, properties.source AS source, countIf(event = 'waitlist_joined') AS joined, countIf(event = 'invite_accepted') AS accepted, countIf(event = 'activated') AS activated FROM events WHERE event IN ('waitlist_joined','invite_accepted','activated') GROUP BY cohort, source ORDER BY joined DESC"
}

The output

The agent returns cohort conversion and recommends whether to invite faster, change messaging, or segment by source.

Setting it up

Emit waitlist and invite lifecycle events. Preserve source and cohort through signup and activation.

Variations

  • “Compare invites sent within 7 days vs after 30 days.”
  • “Find sources with high waitlist joins but low activation.”
  • “Publish this for launch planning.”

Related recipes

growth 2 minutes

Build a signup funnel and find where users drop off

One prompt builds the full funnel from landing → activation, publishes it as a public dashboard, and ranks drop-off steps by severity.

growth 5 minutes

Measure landing-page source quality

Compare acquisition sources by activation, retention, and paid conversion instead of only measuring clicks or signups.

growth 2 minutes

Find your magic activation moment

Discover which first-24h action correlates highest with day-30 retention. Most teams can't answer this. You'll answer it in 90 seconds.

Try this recipe in your own agent.

Ask your agent to adapt the starter prompt to your saved signal map and live events, then run it against your data.

Install agentry.sh/install.md for me
Agent will onboard itself and then your app
← all recipes