Table: Daily Home Offer Displayed

The mrt_native__daily_home_offer_displayed table provides detailed insights into the display of home offers within the native application. It captures data on the frequency and position of offer displays, as well as associated user interactions such as consultations. This table is crucial for understanding user engagement and the effectiveness of offer placements on the home screen.

Table description

name	data_type	description
event_date		The date when the event occurred, used for partitioning the data.
offer_id		Unique identifier for the offer.
module_id		The identifier for the module associated with the consultation.
entry_id		The identifier for the entry associated with the consultation.
offer_category_id		Identifier for the category of the offer.
venue_id		Unique identifier for the venue.
venue_name		Name of the venue.
venue_macro_density_label		Macro density label of the venue's location (urbain, rural)
module_type		The type of the module in which the entry is displayed (algolia, recommendation, video...)
module_name		The name of the module in which the entry is displayed.
offer_subcategory_id		Identifier for the subcategory of the offer.
offerer_id		Unique identifier of the offerer.
venue_type_label		Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list.
venue_density_label		Detailed density label of the venue's location.
partner_id		Unique identifier of the partner.
offerer_name		Name of the offerer.
total_displays		The number of distinct display occurences of an offer on home on a given date.
total_position_0_3_displays		The number of unique times an offer is displayed in positions 0 to 3 of the home playlist on a specific date.
total_position_4_10_displays		The number of unique times an offer is displayed in positions 4 to 10 of the home playlist on a specific date.
total_position_11_20_displays		The number of unique times an offer is displayed in positions 11 to 20 of the home playlist on a specific date.
total_position_21_30_displays		The number of unique times an offer is displayed in positions 21 to 30 of the home playlist on a specific date.
total_position_31_40_displays		The number of unique times an offer is displayed in positions 31 to 40 of the home playlist on a specific date.
total_position_41_50_displays		The number of unique times an offer is displayed in positions 41 to 50 of the home playlist on a specific date.
total_consultations		The number of distinct consultation occurences of an offer from home playlists on a given date.
total_position_0_3_consultations		The number of distinct consultation occurences of an offer from home playlists diplayed in positions 0 to 3 on a given date.
total_position_4_10_consultations		The number of distinct consultation occurences of an offer from home playlists diplayed in positions 4 to 10 on a given date.
total_position_11_20_consultations		The number of distinct consultation occurences of an offer from home playlists diplayed in positions 11 to 20 on a given date.
total_position_21_30_consultations		The number of distinct consultation occurences of an offer from home playlists diplayed in positions 21 to 30 on a given date.
total_position_31_40_consultations		The number of distinct consultation occurences of an offer from home playlists diplayed in positions 31 to 40 on a given date.
total_position_41_50_consultations		The number of distinct consultation occurences of an offer from home playlists diplayed in positions 41 to 50 on a given date.