Loan Amount Screen Event Analytics
JAR · PA Intern
Analyse event logs for a fintech loan amount-selection screen: compute conversion metrics, define new metrics, form drop-off hypotheses and propose fixes.
Assignment - Analytics on amount selection screen
Overview
- A fintech app has a lending product where they offer digital loans to users
- The first screen that the user encounters when they click on the Loans Option is an amount screen where they can choose the amount they want to take a loan for
- The possible actions a user can take on this screen are -
- Click the continue button - takes them to the next screen
- Click the back button - takes them back to home screen
- Click the need help button - to initiate a complaint to customer support
- Move the amount slider - to change the amount selection
- Each action that a user takes will be stored as an event with certain properties. Read more about event based analytics
- Main properties of each event (these are properties that an event must have)
- event_name - name of the event
- user_id - unique identity of the user who did the action that triggered the event
- session_id - a unique identity of a session (a session starts when a user launches the app, ends when they close the app, each session has a different session_id even for the same user)
- timestamp - the timestamp at which event was triggered
- Additional properties (these can be added to an event depending on the requirement)
- e.g - In the event for clicking continue button, we can store the amount that was selected
- The names of the events that a user can trigger on this screen -
- screen_shown
- continue_clicked
- back_clicked
- need_help_clicked
- slider_moved
- A log of all events triggered by users and the properties attached to these events are shared in the Excel sheet attached in the email
- Note -
- Events trigger every time a user performs a particular action
- One user can do an action any number of times
- Explore the dataset before starting the assignment
Problem Statement
You are a product analyst and are tasked with generating insights on the amount. You will need to -
- Calculate the following metrics for this screen -
- a. Conversion % (conversion is when a user clicks continue)
- b. Median time taken in seconds to convert (for the first time)
- c. Median amount selected when a user converts (for the first time)
- Define 3 more metrics for this screen, write the reasoning behind them and calculate the metrics you defined
- Make 3 hypotheses for drop offs on this screen
- Propose 3 possible solutions to improve the performance of this screen
PS - To analyse the data you can use any tools you are comfortable with - excel, sheets, python, sql