Skip to content

promotions

The discount codes that appear on bookings and sales. One row is one promotion window.

One row is
one promotion window
Columns
7
Rows in Sample
6
Rows in Standard
6
Rows in Full
6

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
promotion_idkeyintegerUnique id for the row.
promo_codetextThe code as it appears in bookings.promo_code and transactions.discount_code.MOBILE5; PASSHOLDER; STAYPLAY20
promotion_nametextName.Annual pass holder discount; Mobile order offer test; Stay and Play hotel package
applies_totextWhat it discounts.food and merchandise purchases; hotel bookings; mobile food orders
discount_pctdecimalPercent off.10 to 20
start_datedateFirst day it applied.2018-01-01 to 2024-08-18
end_datedateLast day it applied.2019-09-30 to 2025-12-31

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

promotion_idpromo_codepromotion_nameapplies_todiscount_pctstart_dateend_date
1STAYPLAY20Stay and Play hotel packagehotel bookings202019-08-182019-09-30
2STAYPLAY20Stay and Play hotel packagehotel bookings202020-01-122020-02-13
3STAYPLAY20Stay and Play hotel packagehotel bookings202023-01-082023-02-16
4STAYPLAY20Stay and Play hotel packagehotel bookings202024-08-182024-09-30
5PASSHOLDERAnnual pass holder discountfood and merchandise purchases102018-01-012025-12-31

Download from Kaggle