User Retention Analysis (Cohort Report)
Databases & SQL
Goal:
To analyze user activity over 6 months and identify when users stop using the platform.
What I did:
Data Cleaning: Standardized dates and fixed formatting issues in the raw events log.
SQL Processing: Connected "Users" and "Events" tables to calculate the time difference between registration and return.
Analysis: Created a Pivot Table in Google Sheets to group users into monthly cohorts.
Heatmap: Built a Retention matrix (as seen in the screenshot) to visualize user drop-off.
Results:
The report clearly shows the Retention Rate for each cohort, helping to pinpoint exactly which months have the highest churn.
Tools: PostgreSQL, SQL, Google Sheets.
To analyze user activity over 6 months and identify when users stop using the platform.
What I did:
Data Cleaning: Standardized dates and fixed formatting issues in the raw events log.
SQL Processing: Connected "Users" and "Events" tables to calculate the time difference between registration and return.
Analysis: Created a Pivot Table in Google Sheets to group users into monthly cohorts.
Heatmap: Built a Retention matrix (as seen in the screenshot) to visualize user drop-off.
Results:
The report clearly shows the Retention Rate for each cohort, helping to pinpoint exactly which months have the highest churn.
Tools: PostgreSQL, SQL, Google Sheets.