You're in the demo. Made-up data for a sample product, with problems planted on purpose. Click anything: approve improvements, create issues, check results. Nothing reaches GitHub or Mixpanel.Back to Նշիր
02 · Insights

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

Step s4 ×
  1. I7OpportunityNot sure yet (low confidence)

    Firefox users on desktop come back on day 2 more often than everyone else

    57% of Firefox users on desktop who reached "Finish the first test" went on to "Come back on day 2" (20 of 35), compared with 44% of everyone else. This is based on 35 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 and how we know

    Possible reasons (not confirmed yet)

    • Something about how Firefox users on desktop use the product helps them reach "Come back on day 2".
      Likely if: The difference also shows up in the month before. Unlikely if: The difference disappears with more people.

    Measured numbers

    Finish the first test → Come back on day 2: platform=desktop, browser=firefox 57.1% (20 of 35) vs 44.2% 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.

    S8 · segment_gap · sample 35 · 2026-09-29 to 2026-10-27

    The query behind it
    -- segment_step_gap.sql
    -- params: ["nshir","2026-09-29T00:00:00.000Z","2026-10-27T00:00:00.000Z",["internal_qa_1","internal_qa_2"],"test_finished","session_started",1]
    -- 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