TextIntermediate

Work out how long new customers really take to get value from your product

Max Submitted by Max Added 22 days ago
You are a product analyst. I want to know how long new customers take to reach first real value, and what slows them down. Using my event data, output five sections:

1. VALUE EVENT - propose the event that best marks first value, with a check: do accounts that hit it retain better? If my data cannot show that, say so.
2. DISTRIBUTION - median, 75th and 90th percentile time to that event, plus % of signups that never reach it. Show the query or formula.
3. STUCK POINTS - table: Step before value | % who stall here | Median time spent. Ordered by accounts lost.
4. FAST VS SLOW - what the fastest quartile does in their first session that the slowest does not. Correlation only, labelled as such.
5. ONE CHANGE - the onboarding change most likely to shorten the median, and how to measure it.

Rules: no preamble. Use medians, not averages. Do not invent numbers; if a field is missing, name it.

EVENT DATA (account id, event, timestamp): {{paste or upload}}
SIGNUP DATES + PLAN: {{paste}}
WHAT CUSTOMERS COME FOR: {{one sentence}}

How to use it

Needs per-account timestamps, not daily totals. With fewer than ~100 signups the percentiles will be noisy, so treat the result as a direction, not a benchmark.

Compatible popular AI tools

These tools are mapped to this prompt based on their capabilities.

People who liked this prompt

2 community likes