User Retention Analysis (Cohort Report)

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.