What we noticed
From Nshir's synthetic data, last 28 days. Each insight names the goal step it affects. Last run 19 Nov 2026, 17:21 UTC.
Demo data: connect Mixpanel for real events · Text written by templates, not Claude
From Nshir's synthetic data, last 28 days. Each insight names the goal step it affects. Last run 19 Nov 2026, 17:21 UTC.
Demo data: connect Mixpanel for real events · Text written by templates, not Claude
In the last 28 days, 288 people reached "Open a paid feature". 66 of them went on to "Send a paid-access request", so 222 stopped here.
Why it matters: This is one of the two biggest losses on the way to "More trial users ask for paid access". Everyone who stops here is lost for the goal.
Possible reasons (not confirmed yet)
Measured numbers
Open a paid feature → Send a paid-access request: 66 of 288 (22.9%) continue, 77.1% drop
How sure we are. Counted from reliable events over one period.
S1 · funnel_drop · sample 288 · 2026-09-29 to 2026-10-27
-- funnel_timelines.sql
-- params: ["nshir","2026-09-29T00:00:00.000Z","2026-10-27T00:00:00.000Z",["internal_qa_1","internal_qa_2"],"site_visited",["site_visited","test_started","test_finished","session_started","locked_feature_viewed","paid_access_requested"],"2026-10-27T00:00:00.000Z"]
-- Per-user timelines for the funnel. Cohort: users whose first entry event falls in [$2, $3).
-- $1 product_id, $2 cohort start, $3 cohort end, $4 excluded distinct_ids,
-- $5 entry event, $6 funnel event names, $7 horizon end (events after it are ignored)
with cohort as (
select distinct_id,
min(time) as first_time,
(array_agg(props->>'platform' order by time))[1] as platform,
(array_agg(props->>'browser' order by time))[1] as browser
from events
where product_id = $1 and name = $5 and distinct_id <> all($4::text[])
group by distinct_id
having min(time) >= $2::timestamptz and min(time) < $3::timestamptz
)
select c.distinct_id, c.platform, c.browser, e.name, e.time
from cohort c
join events e on e.product_id = $1 and e.distinct_id = c.distinct_id
where e.name = any($6::text[]) and e.time >= c.first_time and e.time < $7::timestamptz
order by c.distinct_id, e.time
Run run_9beac44cdca34f40 · context v1 · prompt S3/v2 · model offline-template
13% of iPhone users who reached "Open a paid feature" went on to "Send a paid-access request" (14 of 109), compared with 27% of everyone else.
Why it matters: IPhone users are 36% of people at this step. At everyone else's rate, about 16 more of them would reach "Send a paid-access request".
Possible reasons (not confirmed yet)
Measured numbers
Open a paid feature → Send a paid-access request: platform=ios 12.8% (14 of 109) vs 27.3% for everyone else
How sure we are. Enough people in this group; checked over one period.
S9 · segment_gap · sample 109 · 2026-09-29 to 2026-10-27
-- segment_step_gap.sql
-- params: ["nshir","2026-09-29T00:00:00.000Z","2026-10-27T00:00:00.000Z",["internal_qa_1","internal_qa_2"],"locked_feature_viewed","paid_access_requested",0]
-- Conversion from $5 to $6 per platform and browser. Users whose first $5 is in [$2, $3);
-- converted if $6 happens after it, at least $7 calendar days later, before $3.
-- $1 product_id, $4 excluded distinct_ids
with f as (
select distinct_id, min(time) as t,
(array_agg(props->>'platform' order by time))[1] as platform,
(array_agg(props->>'browser' order by time))[1] as browser
from events
where product_id = $1 and name = $5 and distinct_id <> all($4::text[])
group by distinct_id
having min(time) >= $2::timestamptz and min(time) < $3::timestamptz
),
c as (
select f.distinct_id
from f
join events e on e.product_id = $1 and e.distinct_id = f.distinct_id and e.name = $6
and e.time >= f.t and e.time < $3::timestamptz
and date_trunc('day', e.time) >= date_trunc('day', f.t) + make_interval(days => $7::int)
group by f.distinct_id
)
select coalesce(f.platform, 'unknown') as platform, coalesce(f.browser, 'unknown') as browser,
count(*)::int as n, count(c.distinct_id)::int as converted
from f left join c using (distinct_id)
group by 1, 2
order by 1, 2
Run run_9beac44cdca34f40 · context v1 · prompt S3/v2 · model offline-template
38% of Android users who reached "Open a paid feature" went on to "Send a paid-access request" (36 of 94), compared with 15% of everyone else. This is based on 94 people, fewer than the 100 we need to be sure.
Why it matters: If we learn what helps them, it may work for everyone. Treat this as a lead to check, not a fact.
Possible reasons (not confirmed yet)
Measured numbers
Open a paid feature → Send a paid-access request: platform=android 38.3% (36 of 94) vs 14.8% for everyone else
How sure we are. Fewer than 100 people in this group. Below the minimum sample of 100 users, so confidence stays Low.
S10 · segment_gap · sample 94 · 2026-09-29 to 2026-10-27
-- segment_step_gap.sql
-- params: ["nshir","2026-09-29T00:00:00.000Z","2026-10-27T00:00:00.000Z",["internal_qa_1","internal_qa_2"],"locked_feature_viewed","paid_access_requested",0]
-- Conversion from $5 to $6 per platform and browser. Users whose first $5 is in [$2, $3);
-- converted if $6 happens after it, at least $7 calendar days later, before $3.
-- $1 product_id, $4 excluded distinct_ids
with f as (
select distinct_id, min(time) as t,
(array_agg(props->>'platform' order by time))[1] as platform,
(array_agg(props->>'browser' order by time))[1] as browser
from events
where product_id = $1 and name = $5 and distinct_id <> all($4::text[])
group by distinct_id
having min(time) >= $2::timestamptz and min(time) < $3::timestamptz
),
c as (
select f.distinct_id
from f
join events e on e.product_id = $1 and e.distinct_id = f.distinct_id and e.name = $6
and e.time >= f.t and e.time < $3::timestamptz
and date_trunc('day', e.time) >= date_trunc('day', f.t) + make_interval(days => $7::int)
group by f.distinct_id
)
select coalesce(f.platform, 'unknown') as platform, coalesce(f.browser, 'unknown') as browser,
count(*)::int as n, count(c.distinct_id)::int as converted
from f left join c using (distinct_id)
group by 1, 2
order by 1, 2
Run run_9beac44cdca34f40 · context v1 · prompt S3/v2 · model offline-template