Native Event
The mrt_native__event table captures detailed event data (screens seen, clicks, scrolls) from pass Culture native application and web app.
Only data from users who have accepted tracking cookies (approximately 75% of traffic) are recorded in this table. Data is tracked for various user categories:
- Beneficiary users: users who have received a grant.
- General public users: users who have created an account but have not received a grant.
- Non-registered or non-logged-in users: users browsing without an account or without being logged in.
Each row in this table corresponds to an event, an action triggered by the user while navigating the application.
The key actions, listed in the event_name column, include (but are not limited to):
- ConsultOffer: the user views an offer page.
- BookingConfirmation: the user makes a booking.
- PerformSearch: the user performs a search (e.g., for offers or locations).
- ConsultVenue: the user views a partner venue's page.
- ModuleDisplayedOnHomePage: a playlist (of offers or partner venues) is displayed on the application's homepage.
- ConsultVideo: the user views a video content.
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 booking_id of the booking made, the offer_id of the offer viewed, etc.) or the screen from which the action was initiated (column origin).
Table description
| name | data_type | description |
|---|---|---|
| event_date | The date when the event occurred, used for partitioning the data. | |
| event_name | The name of the event. For screen views, it concatenates the event name with the Firebase screen name. | |
| event_timestamp | The exact timestamp when the event was recorded. | |
| user_id | Unique identifier for a user. | |
| user_pseudo_id | A pseudo identifier for the user, used for tracking purposes. | |
| origin | The origin of the event, indicating where it was triggered from. | |
| platform | The platform on which the event was recorded, such as iOS or Android. | |
| app_version | The version of the application where the event was recorded. | |
| traffic_campaign | The name of the marketing campaign that generated the session. | |
| traffic_source | The source of the marketing campaign (Instagram, Snapchat ...) that generated the session. | |
| traffic_medium | The medium of the marketing campaign (email, push notification ...)that generated the session. | |
| offer_id | Unique identifier for the offer. | |
| 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. | |
| user_location_type | The type of geolocation used by the user during the session (via geolocation data, manually entered by the user, or information unavailable). | |
| query | The search query associated with the event, if applicable. | |
| venue_id | Unique identifier for the venue. | |
| booking_id | Unique identifier for a booking. | |
| booking_cancellation_step | The step in the booking cancellation process, if applicable. | |
| search_id | The identifier for the search associated with the event. | |
| module_name | The name of the module in which the entry is displayed. | |
| module_id | The identifier for the module associated with the consultation. | |
| entry_id | The identifier for the entry associated with the consultation. | |
| onboarding_user_selected_age | The age selected by the user during onboarding. | |
| offer_name | Name of the offer as it appears in the application. | |
| offer_category_id | Identifier for the category of the offer. | |
| offer_subcategory_id | Identifier for the subcategory of the offer. | |
| partner_id | Unique identifier of the partner. | |
| venue_name | Name of the venue. | |
| venue_type_label | Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list. | |
| content_type | The type of content associated with the event. | |
| user_current_deposit_type | Type of the user's current deposit. | |
| user_last_deposit_amount | Amount of the last deposit received by the user. | |
| user_first_deposit_type | Type of the user's first deposit (GRANT_18 or GRANT_15_17). | |
| user_first_deposit_amount | Amount of the user's first deposit received. |