Table: Recommendable Offer

The ml_reco__recommendable_offer table contains the offers that can be recommended to the user with the retrieval API. To be recommended an offer need to comply with some requeriments like, among others, having stock and an image.

Table description

name	data_type	description
item_id		Identifier for the item associated with the offer used internally by the data science team.
offer_id		Unique identifier for the offer.
topic_id		Cluster id from the unconstrained_item_cluster.
cluster_id		Cluster id from the default_item_cluster.
category		Identifier for the category of the offer. Determined by the cultural partner via a list of pre-set options in a drop down menu.
subcategory_id		Identifier for the subcategory of the offer. Determined by the cultural partner via a list of pre-set options.
search_group_name		Legacy: Category displayed in the application
is_numerical		Indicates if the offer is digital (based on an url).
is_geolocated		Indicates if the offer is geolocated.
offer_is_duo		Indicates if the offer can be booked as a duo.
offer_type_domain		Deprecated: The offer's category type,as many metadata info are specific to certain
		offer types. Can be either "BOOK", "MUSIC", "SHOW" or "MOVIE".
offer_type_label		Deprecated: Defines the offer genre for music, books and movies. Defines the offer
		show type for shows.
gtl_id		Unique identifier of the Genre Tite Live (GTL) associated to this offer.
gtl_l1		Name of the level 1 GTL associated to this offer (for example, "Littératurefor a
		book or "Pop" for music.)
gtl_l2		Name of the level 2 GTL associated to this offer (for example, "Poésie" for a book
		or "Brit Pop" for music.)
gtl_l3		Name of the level 3 GTL associated to this offer (for example, "Haiku" for a book).
		Only available for books.
gtl_l4		Name of the level 4 GTL associated to this offer. Only available for books.
booking_number		Total number of bookings for a given item.
booking_number_last_7_days		Total number of bookings for a given item made during the last 7 days.
booking_number_last_14_days		Total number of bookings for a given item made during the last 14 days.
booking_number_last_28_days		Total number of bookings for a given item made during the last 28 days.
is_underage_recommendable		Indicates if the item is recommendable for underage users.
is_sensitive		Indicates if the item is considered sensitive.
is_restrained		Indicates if the item is restrained.
offer_creation_date		Date when the offer was created.
stock_beginning_date		Timestamp of the beginning of the event. Only for event offers.
stock_price		Price of the stock. O if free.
total_offers		Indicates the number of offers for a give item.
semantic_emb_mean		Mean value of the semantic embedding for a given item.
booking_trend		Trend of bookings for a given item.
stock_date_penalty_factor		Penalty factor based on the stock date of the item.
creation_date_penalty_factor		Penalty factor based on the creation date of the item.
example_offer_name		Example name of an offer for the item.
example_offer_id		Example ID of an offer for the item.
example_venue_id		Example ID of a venue for the item.
example_venue_longitude		Longitude of the example venue for the item.
example_venue_latitude		Latitude of the example venue for the item.
booking_release_trend		Trend of booking releases for a given item.
booking_creation_trend		Trend of booking creations for a given item.