Pro Event
The mrt_pro__eventtable captures detailed event data (screens seen, clicks, scrolls) from pass Culture professional website 'Portail Pro' where cultural partners can manage their profile and create offers.
Table description
Only datas for professional users who have accepted tracking cookies (approximately 80% of traffic) are recorded in this table. Each row in this table corresponds to an event, an action triggered by the user while navigating the website.
The key actions, listed in the event_name column, include (but are not limited to):
- hasClickedOffer: the pro user clicks on an offer to consult it.
- hasClickedShowBooking: the pro user displays a booking on one of its offers.
For each recorded key event, additional event parameters are also stored to provide more context about the action. These parameters can include unique identifiers (e.g., the offer_id of the offer viewed, etc.) or the screen from which the action was initiated (column origin).
| name | data_type | description |
|---|---|---|
| event_name | The name of the event. For screen views, it concatenates the event name with the Firebase screen name. | |
| page_name | The name of the page where the event occurred, providing context for the event. | |
| user_pseudo_id | A pseudo identifier for the user, used for tracking purposes. | |
| user_id | Unique identifier for a user. | |
| event_date | The date when the event occurred, used for partitioning the data. | |
| event_timestamp | The exact timestamp when the event was recorded. | |
| session_number | The number of the session during which the visit occurred, indicating the sequence of user sessions. | |
| session_id | Deprecated: use unique_session_id. The session identifier during which the event was recorded. | |
| unique_session_id | A unique identifier for the session, ensuring no duplicates. | |
| origin | The origin of the event, indicating where it was triggered from. | |
| destination | The destination associated with the event, if applicable, indicating the target location or page. | |
| traffic_campaign | The name of the marketing campaign that generated the session. | |
| traffic_medium | The medium of the marketing campaign (email, push notification ...)that generated the session. | |
| traffic_source | The source of the marketing campaign (Instagram, Snapchat ...) that generated the session. | |
| platform | The platform on which the event was recorded, such as iOS or Android. | |
| user_device_category | The category of the user's device, such as mobile, tablet, or desktop. | |
| user_device_operating_system | The operating system of the user's device, such as Windows, macOS, iOS, or Android. | |
| user_device_operating_system_version | The version of the operating system on the user's device. | |
| user_web_browser | The web browser used by the user, such as Chrome, Firefox, or Safari. | |
| user_web_browser_version | The version of the web browser used by the user. | |
| page_location | The location of the page where the event occurred, typically a URL or path. | |
| url_path_extract | The extracted path from the URL where the event occurred. | |
| page_referrer | The referrer page that led to the current page where the event occurred. | |
| page_number | The number of the page in a sequence, if applicable. | |
| is_edition | Indicates whether the event is related to an edition or update. | |
| is_draft | Indicates whether the event is related to a draft version. | |
| offerer_id | Unique identifier of the offerer. | |
| venue_id | Unique identifier for the venue. | |
| offer_id | Unique identifier for the offer. | |
| offer_type | Deprecated. | |
| has_saved_query | Indicates whether the event is associated with a saved query. | |
| has_opened_wrong_student_modal | Indicates whether the wrong student modal was opened during the event. | |
| filled | Indicates whether the event form or data was filled. | |
| filled_with_errors | Indicates whether the event form or data was filled with errors. | |
| onboarding_selected_legal_category | The legal category selected during onboarding, if applicable. | |
| download_format | The format of the download associated with the event, if applicable. | |
| download_booking_status | The booking status of the download associated with the event, if applicable. | |
| url_path_agg | The aggregated URL path associated with the event. | |
| download_button_type | The type of download button used during the event, if applicable. | |
| download_file_type | The type of file downloaded during the event, if applicable. | |
| download_files_cnt | The count of files downloaded during the event, if applicable. | |
| offer_subcategory_id | Identifier for the subcategory of the offer. | |
| suggested_offer_subcategory_selected | Indicates whether a suggested offer subcategory was selected during the event. | |
| offerer_name | Name of the offerer. | |
| offerer_first_individual_offer_creation_date | The date when the offerer's first individual offer was created. | |
| offerer_first_collective_offer_creation_date | The date when the offerer's first collective offer was created. | |
| offerer_business_activity_label | The business activity label of the offerer. | |
| offerer_legal_category_label | The legal category label of the offerer. | |
| is_local_authority | Indicates if the offerer is a local authority or not. | |
| total_permanent_managed_venues | The total number of permanent venues managed by the local authority. | |
| is_synchro_adage | Indicates if the offerer is synchronized with adage. | |
| dms_accepted_at | Date when the offerer was accepted in DMS. | |
| first_dms_adage_status | First DMS adage status of the offerer. | |
| venue_name | Name of the venue. | |
| venue_has_siret | Indicates whether the venue has a SIRET. | |
| venue_is_permanent | Indicates if the venue is permanent. A permanent venue is a venue that can receive public permanently, that can propose offers, and that is managed by the partner. Permanent venues exemple : a library, a cinema. Non permanent venues example : a public garden that hosted a festival once, or a theater that hosted a concert once - it can be permanent for the partner who owns the theater, but not for the partner who is hosted once in this place. | |
| venue_type_label | Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list. | |
| partner_id | Unique identifier of the partner. | |
| partner_name | Name of the cultural partner. | |
| partner_type | Type of the cultural partner, derived from venue type or venue/offerer tags. | |
| partner_cultural_sector | Cultural sector associated with the partner type. | |
| total_partner_created_individual_offers | The total number of individual offers created by the partner. | |
| total_partner_created_collective_offers | The total number of collective offers created by the partner. | |
| image_creation_stage | Indicates the different stages of image upload while creating/editing an offer/a partner page. | |
| headline_offer_action_type | Indicates the different action types of headline offer feature. |