TrendsLatestUse settingPopularCalculating average session duration, time on site, and other session-based metricsNov 26, 2024Ian VanagasHow to analyze autocapture events with SQLJun 7, 2023Ian VanagasThe power of SQL’s sum() aggregationJun 6, 2023Ian VanagasHow to calculate DAU/MAU ratioMay 29, 2023Ian VanagasSubscribe to our newsletterProduct for EngineersRead by 60,000+ founders and buildersSubscribeWe'll share your email with SubstackUsing SQL for advanced breakdownsMay 16, 2023Ian VanagasHow to track new and returning users in PostHogApr 26, 2023Ian VanagasHow to identify and analyze power usersOct 31, 2022Ian VanagasHow to calculate and lower churn rate with PostHogOct 10, 2022Ian Vanagas