Analyze User Engagement Drop After Feature Release

Welcome to your interview.

The question is on your right: Analyze User Engagement Drop After Feature Release. Take a moment with it first.

Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.

Business Context

TechCorp recently launched a new feature in their mobile app aimed at enhancing user engagement. However, since the release, daily active users (DAU) have dropped from 1.2 million to 1.02 million, marking a 15% decline. The Product Manager is concerned about this trend as it directly impacts user retention and revenue.

Available Data

Data Source	Description	Granularity
user_engagement	Daily engagement metrics including DAU, session length, and feature usage	Daily
feature_usage	Detailed logs of how users interact with the new feature	Per session
user_profiles	User demographics and historical engagement data	Per user
feedback	User feedback and ratings for the new feature	Per feedback entry

Task

Define 'user engagement' and outline the metrics used to measure it.
Decompose the drop in DAU to identify potential causes.
Propose hypotheses for why engagement has declined since the feature release and how to test them.
Recommend actionable strategies to improve user engagement based on your findings.
Identify key metrics to monitor moving forward to ensure engagement improves.

Constraints

The analysis needs to be completed within two weeks to inform the upcoming product strategy meeting.
You have access to a SQL-queryable data warehouse with the tables mentioned above.