hard20 pts · first answer countsproduct-analyticssqlretention
Off-by-one in day counts
A team counts a user as "Day 1 retained" if DATE_DIFF(activity_date, signup_date) = 1. Another team uses activity within 24 hours of the signup timestamp. Why do their numbers differ?
Discussion 0
Join free to post in the discussion.
Related questions
- Calculating churnProduct Manager
- Gross revenue retentionProduct Manager
- From churn to retentionProduct Manager
- Events and propertiesProduct Manager
- User property or event propertyProduct Manager
- Why write a tracking planProduct Manager
- Users or eventsProduct Manager
- Conversion window in a funnelProduct Manager