Retention Queries

Every product analytics interview asks retention; the pivot is the hard part

Every product analytics interview asks retention; the pivot is the hard part

Category

SQL

Difficulty

advanced

Duration

25 minutes

Challenges

0 hands-on challenges

Topics covered: "What Percent Came Back?" Is a Retention Query, The Cohort Self-Join, Pivoting Retention into a Matrix, Bounded vs Unbounded Retention, Retention at Scale: Approximate and Incremental

Lesson Sections

1. "What Percent Came Back?" Is a Retention Query

   Content coming soon.

2. The Cohort Self-Join

   Content coming soon.

3. Pivoting Retention into a Matrix

   Content coming soon.

4. Bounded vs Unbounded Retention

   Content coming soon.

5. Retention at Scale: Approximate and Incremental

   Content coming soon.