PM Assignments

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 -

  1. 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)
  2. Define 3 more metrics for this screen, write the reasoning behind them and calculate the metrics you defined
  3. Make 3 hypotheses for drop offs on this screen
  4. 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