Traffic mix and seasons
Compare like with like when the users themselves changed.
Lesson 22 of 32~22 min of learningIncludes ~13 min for questions and tasks
Contents1 of 32 steps
Maya
You
Alex Tutor
Alex Tutor
Dataset · 78 rows
Weekly sign-up cohorts, June and July
New Halves users, weeks of 8 June to 27 July 2026. Version 5.0.0 was released on 6 July. Every cohort has its full days 8–14.
- Columns
- signup_week
- Monday of the sign-up week
- app_version
- Version installed: 4.9.0 in June, 5.0.0 in July
- channel
- invite, app_store_search, paid_social or partner_promo
- first_group_type
- Type of the first group the user joined: flat, couple or trip
- new_users
- New users in this cell
- active_days_8_14
- Of them, opened the app on at least one of days 8–14
Data
| signup_week | app_version | channel | first_group_type | new_users | active_days_8_14 |
|---|---|---|---|---|---|
| 2026-06-08 | 4.9.0 | invite | flat | 106 | 44 |
| 2026-06-08 | 4.9.0 | invite | couple | 64 | 31 |
| 2026-06-08 | 4.9.0 | invite | trip | 43 | 7 |
| 2026-06-08 | 4.9.0 | app_store_search | flat | 79 | 28 |
| 2026-06-08 | 4.9.0 | app_store_search | couple | 52 | 16 |
Show 73 more rows
| 2026-06-08 | 4.9.0 | app_store_search | trip | 32 | 5 |
| 2026-06-08 | 4.9.0 | paid_social | flat | 61 | 12 |
| 2026-06-08 | 4.9.0 | paid_social | couple | 37 | 15 |
| 2026-06-08 | 4.9.0 | paid_social | trip | 26 | 2 |
| 2026-06-15 | 4.9.0 | invite | flat | 106 | 44 |
| 2026-06-15 | 4.9.0 | invite | couple | 69 | 29 |
| 2026-06-15 | 4.9.0 | invite | trip | 46 | 5 |
| 2026-06-15 | 4.9.0 | app_store_search | flat | 86 | 39 |
| 2026-06-15 | 4.9.0 | app_store_search | couple | 49 | 23 |
| 2026-06-15 | 4.9.0 | app_store_search | trip | 34 | 9 |
| 2026-06-15 | 4.9.0 | paid_social | flat | 65 | 26 |
| 2026-06-15 | 4.9.0 | paid_social | couple | 38 | 11 |
| 2026-06-15 | 4.9.0 | paid_social | trip | 25 | 5 |
| 2026-06-22 | 4.9.0 | invite | flat | 105 | 57 |
| 2026-06-22 | 4.9.0 | invite | couple | 66 | 28 |
| 2026-06-22 | 4.9.0 | invite | trip | 45 | 9 |
| 2026-06-22 | 4.9.0 | app_store_search | flat | 82 | 37 |
| 2026-06-22 | 4.9.0 | app_store_search | couple | 52 | 20 |
| 2026-06-22 | 4.9.0 | app_store_search | trip | 32 | 6 |
| 2026-06-22 | 4.9.0 | paid_social | flat | 62 | 20 |
| 2026-06-22 | 4.9.0 | paid_social | couple | 37 | 12 |
| 2026-06-22 | 4.9.0 | paid_social | trip | 24 | 3 |
| 2026-06-29 | 4.9.0 | invite | flat | 106 | 60 |
| 2026-06-29 | 4.9.0 | invite | couple | 66 | 29 |
| 2026-06-29 | 4.9.0 | invite | trip | 42 | 8 |
| 2026-06-29 | 4.9.0 | app_store_search | flat | 85 | 46 |
| 2026-06-29 | 4.9.0 | app_store_search | couple | 50 | 21 |
| 2026-06-29 | 4.9.0 | app_store_search | trip | 33 | 5 |
| 2026-06-29 | 4.9.0 | paid_social | flat | 65 | 23 |
| 2026-06-29 | 4.9.0 | paid_social | couple | 38 | 14 |
| 2026-06-29 | 4.9.0 | paid_social | trip | 25 | 3 |
| 2026-07-06 | 5.0.0 | invite | flat | 89 | 45 |
| 2026-07-06 | 5.0.0 | invite | couple | 60 | 27 |
| 2026-07-06 | 5.0.0 | invite | trip | 100 | 18 |
| 2026-07-06 | 5.0.0 | app_store_search | flat | 65 | 28 |
| 2026-07-06 | 5.0.0 | app_store_search | couple | 40 | 17 |
| 2026-07-06 | 5.0.0 | app_store_search | trip | 71 | 16 |
| 2026-07-06 | 5.0.0 | paid_social | flat | 47 | 17 |
| 2026-07-06 | 5.0.0 | paid_social | couple | 29 | 9 |
| 2026-07-06 | 5.0.0 | paid_social | trip | 52 | 10 |
| 2026-07-13 | 5.0.0 | invite | flat | 84 | 38 |
| 2026-07-13 | 5.0.0 | invite | couple | 56 | 24 |
| 2026-07-13 | 5.0.0 | invite | trip | 93 | 29 |
| 2026-07-13 | 5.0.0 | app_store_search | flat | 60 | 26 |
| 2026-07-13 | 5.0.0 | app_store_search | couple | 43 | 17 |
| 2026-07-13 | 5.0.0 | app_store_search | trip | 68 | 11 |
| 2026-07-13 | 5.0.0 | paid_social | flat | 43 | 15 |
| 2026-07-13 | 5.0.0 | paid_social | couple | 29 | 12 |
| 2026-07-13 | 5.0.0 | paid_social | trip | 52 | 8 |
| 2026-07-13 | 5.0.0 | partner_promo | flat | 198 | 48 |
| 2026-07-13 | 5.0.0 | partner_promo | couple | 81 | 15 |
| 2026-07-13 | 5.0.0 | partner_promo | trip | 114 | 13 |
| 2026-07-20 | 5.0.0 | invite | flat | 88 | 53 |
| 2026-07-20 | 5.0.0 | invite | couple | 60 | 25 |
| 2026-07-20 | 5.0.0 | invite | trip | 92 | 17 |
| 2026-07-20 | 5.0.0 | app_store_search | flat | 62 | 25 |
| 2026-07-20 | 5.0.0 | app_store_search | couple | 40 | 15 |
| 2026-07-20 | 5.0.0 | app_store_search | trip | 68 | 11 |
| 2026-07-20 | 5.0.0 | paid_social | flat | 43 | 17 |
| 2026-07-20 | 5.0.0 | paid_social | couple | 31 | 17 |
| 2026-07-20 | 5.0.0 | paid_social | trip | 52 | 9 |
| 2026-07-20 | 5.0.0 | partner_promo | flat | 204 | 52 |
| 2026-07-20 | 5.0.0 | partner_promo | couple | 76 | 16 |
| 2026-07-20 | 5.0.0 | partner_promo | trip | 115 | 9 |
| 2026-07-27 | 5.0.0 | invite | flat | 87 | 41 |
| 2026-07-27 | 5.0.0 | invite | couple | 60 | 31 |
| 2026-07-27 | 5.0.0 | invite | trip | 98 | 19 |
| 2026-07-27 | 5.0.0 | app_store_search | flat | 62 | 25 |
| 2026-07-27 | 5.0.0 | app_store_search | couple | 43 | 21 |
| 2026-07-27 | 5.0.0 | app_store_search | trip | 72 | 13 |
| 2026-07-27 | 5.0.0 | paid_social | flat | 46 | 13 |
| 2026-07-27 | 5.0.0 | paid_social | couple | 31 | 13 |
| 2026-07-27 | 5.0.0 | paid_social | trip | 48 | 9 |
Alex Tutor
Question 1
What share of July (5.0.0) new users had trip as their first group type? Percent, two decimals. (In June it was 20.02%.)
Units: %
Alex Tutor
You
Alex Tutor
Theo
partner_promo rows.Alex Tutor
Alex Tutor
Question 2
What share of the new users who signed up on 5.0.0 (July) came through partner_promo? Percent, two decimals.
Units: %
Alex Tutor
Maya
Alex Tutor
Alex Tutor
Question 3
Without the partner_promo rows, what share of July flat users was active in days 8–14? Percent, two decimals. (June flats: 43.25%.)
Units: %
Alex Tutor
Alex Tutor
You
Maya
Alex Tutor
Alex Tutor
Question 4
Maya has to answer the team today. Which statement can she defend with this table?
You
Alex Tutor
Theo
Alex Tutor
partner_promo from day one. Judge the deal by users still active in week 2, not by sign-ups: 788 joined, 153 stayed. And agree the dates with Maya, so a release and a promo don’t start in the same fortnight.Alex Tutor
Question 5
July’s rate re-weighted to June’s mix of channel × group type is 38.89%. Which of these can still be hiding inside that number? Select all that apply.
Maya
Alex Tutor
You
Alex Tutor
Question 6Short answer · AI-checked task
Maya asks in the team channel: “Do we roll back 5.0.0?” Reply in 3–5 sentences: give the answer first, then the numbers behind it, then what the data can’t tell us.
Write your answer and get a score with feedback from our AI reviewer.
Log in to get AI feedbackAlex Tutor
That’s the lesson. You answered every task — nicely done.