Outgoing Cohort
The mrt_native__outgoing_cohorts aims to compare the use of the pass based on the month of credit expiration among beneficiaries. It contains one row per cohort, segmented by month, gender, status, geographic data, and allocated credit.
Table description
| name | data_type | description |
|---|---|---|
| user_expiration_month | Month of the user's credit expiration | |
| total_deposit_amount | Total amount deposited by the user. | |
| user_is_priority_public | Boolean. Indicates if the user considered as a pass Culture priority public (users that are either residing in a rural area, in a QPV or are not in education). | |
| user_is_in_qpv | Boolean. Indicates if the user's registered address is in a priority neighborhood (QPV). | |
| user_is_unemployed | Boolean. Indicates if the user is unemployed as per its registered activity. | |
| user_is_in_education | Boolean. Indicates if the user is in education, based on their registered activity. According to the INSEE, a user is considered to be in education if they fall under one of the following categories: Middle school student (Collégien), High school student (Lycéen), University student (Étudiant), Apprentice (Apprenti), Work-study student (Alternant). | |
| user_density_label | String column.Density label (urban, rural) of the user's registered address. | |
| user_macro_density_label | Macro density label of the user's registered address. | |
| user_region_name | Region name of the user's registered address. | |
| user_department_code | Department code associated with the user's registered address. | |
| user_activity | User's registered activity (student, apprentice, unemployed etc). Registered at first grant deposit and updated when the user applies for its GRANT_18. | |
| user_civility | Registered civility of the user (male, female). | |
| user_is_theme_subscribed | Boolean. Indicates whether a user has subscribed to at least one theme. | |
| total_users | The total number of users. | |
| total_3_category_booked_users | The total number of users who made bookings in three categories or more. | |
| total_amount_spent | The total amount of credit spent by the user. | |
| total_theoretical_digital_goods_amount_spent | Total theoretical amount spent on digital goods by the user. | |
| total_non_cancelled_individual_bookings | Total number of non-cancelled individual bookings made by the user. | |
| total_non_cancelled_duo_bookings | Total number of non-cancelled duo bookings made by the user. | |
| total_free_bookings | Total number of free bookings made by the user. | |
| total_item_consulted | The total number of items consulted by the user. | |
| total_venue_consulted | The total number of venues consulted by the user. | |
| total_grant_18_subcategory_booked | The total number of subcategory booked on grant_18 deposit. | |
| total_grant_15_17_subcategory_booked | The total number of subcategory booked on grant_15_17 deposit. | |
| total_venue_type_label_consulted | The total number of venues type label consulted by the user. | |
| total_day_between_deposit_and_first_booking | The total number of days elapsed between the user deposit creation date and the user first booking date. | |
| total_diversification_score | The total diversification score of the users. | |
| total_venue_id_booked | The total number of distinct venues booked by the users. Virtual venues are excluded. | |
| total_venue_type_booked | The total number of distinct venue type booked by the users. | |
| total_category_booked | The total number of distinct categories booked by the users. |