Katkat
Back

Calculate and Compare Survey Response Rates for User Tenure

MetaData Scientist · Onsite
MediumData ScientistOnsiteData Manipulation (SQL/Python)

Last updated

This question evaluates proficiency in relational data manipulation and metric computation, including SQL joins, aggregation and cohort-based comparisons relevant to survey response analysis, and is categorized under Data Manipulation (SQL/Python) for a Data Scientist role.

Surveys

+--------+------------+--------------+----------+ | userid | date | survey_event | response | +--------+------------+--------------+----------+ | 101 | 2023-01-10 | notif_popup | 5 | | 102 | 2023-01-11 | notif_popup | 3 | | 101 | 2023-01-12 | notif_modal | 4 | +--------+------------+--------------+----------+

​

Users

+--------+------------+----------+ | userid | reg_date | country | +--------+------------+----------+ | 101 | 2022-12-20 | US | | 102 | 2023-01-05 | CA | | 103 | 2023-01-07 | US | +--------+------------+----------+

Scenario

Mobile app sends a post-notification survey to users; two tables (Surveys, Users) track responses and registration dates.

Question

Write SQL to compute the overall response rate to the survey. 2. Using SQL, determine whether newer users rate notifications higher than long-tenured users.

Hints

Join, aggregate, bucket users by tenure, compare average/median response.