Cohort and Retention Analysis
Time-based cohorts, cohort retention, RFM analysis, customer segmentation, churn prediction
1What is a cohort in data analysis?
What is a cohort in data analysis?
Answer
A cohort is a group of users who share a common characteristic over a given period, most commonly the date of their first action (signup, first purchase). Grouping users into cohorts allows comparing their behavior over time and identifying trends across acquisition periods. It is a fundamental tool for measuring retention and evaluating the impact of product changes.
2What is the most common criterion for defining a time-based cohort?
What is the most common criterion for defining a time-based cohort?
Answer
The most common criterion for defining a time-based cohort is the date of first signup or first purchase. Grouping by acquisition period (week, month, quarter) enables objective comparison of user behavior across different acquisition moments. This helps isolate the effect of time and detect improvements or degradations linked to product or marketing changes.
3How to read a cohort retention table?
How to read a cohort retention table?
Answer
A cohort retention table is read with cohorts as rows (by acquisition period) and subsequent periods as columns (Month 0, Month 1, etc.). Each cell shows the percentage of users from that cohort still active at that period. The first column is always 100%, and values naturally decrease over time. This format allows visual comparison of retention across cohorts.
What is the difference between Day-N retention and rolling retention?
Why is retention considered a more reliable metric than the number of active users?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Fundamentals
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
BigQuery - Fundamentals
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Python & Pandas - Fundamentals
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Google Tag Manager and Tracking
APIs and Webhooks
dbt - Fundamentals
AB Testing and Applied Statistics
Looker Studio (Google Data Studio)
Power BI - Fundamentals
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free