Idea: Retention leaderboard

[paolodamico]

Is your feature request related to a problem?

As we were doing personas analysis (more context on https://github.com/PostHog/ops/issues/115 and this thread), we manually extracted a list of users and for how many weeks had they been retained. This helped identify the users that have retained for more periods, which is helpful to dive into these users and identify common traits, detect power usage, among other things. The inverse leaderboard is also helpful to identify problems with activation and churn.

Seems like this might be something that other people may have a use for, and we could use ourselves on a regular basis.

Describe the solution you'd like

This is still a very nascent idea, but we could have a simple leaderboard of user and number of days/weeks/months where the user has been retained. Some additional stuff that would be useful (using weeks to describe a period, but really it should work for any period:

• Number of weeks that the user has been registered.
  • Percentage of weeks for which the user has been retained.
• Avg. days per week for which the user has triggered the retaining event.

Describe alternatives you've considered

See above.

Additional context

SQL query we used (minus filters).

SELECT COUNT(*) as count,
     email
FROM (
          SELECT DISTINCT toStartOfWeek(e.timestamp) as event_date,
               pdi.person_id as person_id,
               JSONExtractString(person_props.properties, 'email') as email
          from events e
               JOIN (
                    SELECT person_id,
                         distinct_id
                    FROM person_distinct_id
                    WHERE team_id = 2
               ) pdi on e.distinct_id = pdi.distinct_id
               JOIN (
                    SELECT id,
                         properties
                    from person
                    where team_id = 2
               ) person_props ON pdi.person_id = person_props.id
          WHERE e.team_id = 2
          AND event = '$pageview'
)
GROUP BY email
ORDER BY count DESC

Thank you for your feature request – we love each and every one!

[posthog-bot]

This issue hasn't seen activity in two years! If you want to keep it open, post a comment or remove the stale label – otherwise this will be closed in two weeks.

[posthog-bot]

This issue was closed due to lack of activity. Feel free to reopen if it's still relevant.