Conversion Analytics Refactor
November 12th, 2024
  • Conversion analytics is refactored to do calculations only at BE.
  • arguments:
access_token: sometoken
start_date: 2023-08-07
end_date: 2024-08-15
conversion_v3[office_id]: 1626
conversion_v3[campaign_filter]: 12 (optional)

  • sample response
{
  "1626": {
    "i_applied_count_to_accepted_count_7": 61.54,
    "o_applied_count_to_accepted_count_7": 61.54,
    "o_applied_count_to_accepted_count_9": 60.0,
    "i_applied_count_to_accepted_count_8": 38.89,
    "i_applied_count_to_accepted_count_9": 60.0,
    "o_applied_count_to_accepted_count_8": 38.89,
    "total_applied_count_to_accepted_count": 51.22,
    "o_accepted_count_to_approved_count_7": 100.0,
    "i_accepted_count_to_approved_count_8": 100.0,
    "i_accepted_count_to_approved_count_9": 100.0,
    "i_accepted_count_to_approved_count_7": 100.0,
    "o_accepted_count_to_approved_count_9": 100.0,
    "o_accepted_count_to_approved_count_8": 100.0,
    "total_accepted_count_to_approved_count": 100.0,
    "i_approved_count_to_realized_count_7": 50.0,
    "i_approved_count_to_realized_count_8": 57.14,
    "i_approved_count_to_realized_count_9": 33.33,
    "o_approved_count_to_realized_count_8": 57.14,
    "o_approved_count_to_realized_count_9": 33.33,
    "o_approved_count_to_realized_count_7": 50.0,
    "total_approved_count_to_realized_count": 47.62,
    "i_applied_to_accepted_time_9": 0,
    "i_applied_to_accepted_time_8": 0,
    "i_applied_to_accepted_time_7": 0,
    "o_applied_to_accepted_time_9": 0,
    "o_applied_to_accepted_time_8": 0,
    "o_applied_to_accepted_time_7": 0,
    "total_applied_to_accepted_time": 0,
    "i_accepted_to_approved_time_9": 0,
    "i_accepted_to_approved_time_8": 0,
    "i_accepted_to_approved_time_7": 0,
    "o_accepted_to_approved_time_7": 0,
    "o_accepted_to_approved_time_8": 0,
    "o_accepted_to_approved_time_9": 0,
    "total_accepted_to_approved_time": 0,
    "i_approved_to_realized_time_8": 0,
    "i_approved_to_realized_time_7": 0,
    "i_approved_to_realized_time_9": 0,
    "o_approved_to_realized_time_9": 0,
    "o_approved_to_realized_time_7": 0,
    "o_approved_to_realized_time_8": 0,
    "total_approved_to_realized_time": 0,
    "total_sign_up_to_applied_count": 13.79,
    "total_sign_up_to_applied_time": 0
  },
  "489": {
    "i_applied_count_to_accepted_count_8": 0.0,
    "i_applied_count_to_accepted_count_9": 100.0,
    "total_applied_count_to_accepted_count": 50.0,
    "i_accepted_count_to_approved_count_9": 100.0,
    "total_accepted_count_to_approved_count": 100.0,
    "i_approved_count_to_realized_count_9": 0.0,
    "total_approved_count_to_realized_count": 0.0,
    "total_applied_to_accepted_time": 0,
    "total_accepted_to_approved_time": 0,
    "total_approved_to_realized_time": 0,
    "total_sign_up_to_applied_count": null
  },
  "506": {
    "i_applied_count_to_accepted_count_9": 100.0,
    "total_applied_count_to_accepted_count": 100.0,
    "i_accepted_count_to_approved_count_9": 100.0,
    "total_accepted_count_to_approved_count": 100.0,
    "i_approved_count_to_realized_count_9": 0.0,
    "total_approved_count_to_realized_count": 0.0,
    "total_applied_to_accepted_time": 0,
    "total_accepted_to_approved_time": 0,
    "total_approved_to_realized_time": 0,
    "total_sign_up_to_applied_count": 0.0
  }
}
  • field types:
  1. count field - show percentage of one status to other.
  2. time field - show number of days for changing status.
  • How to display field data on FE:
    • example field: i_applied_count_to_accepted_count_9
      • first character i display incoming or outgoing application
      • last character 9 displays programme id. it will always be 7, 8, 9
      • applied_count_to_accepted_count, denotes <intial status name>_count_to_<final status name>_count
    • example field: i_approved_to_realized_time_8
      • same logic for first and last character.
      • approved_to_realized_time, denotes <intial status name>_to_<final status name>_time
    • example field: total_approved_count_to_realized_count
      • denotes total count for one status change to another
      • total_<intial status name>_count_to_<final status count>_count
    • example field: total_approved_to_realized_time
      • denotes total time in days for one status change to another
      •  total_<intial status name>_to_<final status count>_time

NOTE: sign up to applied will only have total count and total days, programme id aggregation is not possible for it.
X
Crafted by