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
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| promotion_idkey | integer | Unique id for the row. | |
| promo_code | text | The code as it appears in bookings.promo_code and transactions.discount_code. | MOBILE5; PASSHOLDER; STAYPLAY20 |
| promotion_name | text | Name. | Annual pass holder discount; Mobile order offer test; Stay and Play hotel package |
| applies_to | text | What it discounts. | food and merchandise purchases; hotel bookings; mobile food orders |
| discount_pct | decimal | Percent off. | 10 to 20 |
| start_date | date | First day it applied. | 2018-01-01 to 2024-08-18 |
| end_date | date | Last day it applied. | 2019-09-30 to 2025-12-31 |
How it connects
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| promotion_id | promo_code | promotion_name | applies_to | discount_pct | start_date | end_date |
|---|---|---|---|---|---|---|
| 1 | STAYPLAY20 | Stay and Play hotel package | hotel bookings | 20 | 2019-08-18 | 2019-09-30 |
| 2 | STAYPLAY20 | Stay and Play hotel package | hotel bookings | 20 | 2020-01-12 | 2020-02-13 |
| 3 | STAYPLAY20 | Stay and Play hotel package | hotel bookings | 20 | 2023-01-08 | 2023-02-16 |
| 4 | STAYPLAY20 | Stay and Play hotel package | hotel bookings | 20 | 2024-08-18 | 2024-09-30 |
| 5 | PASSHOLDER | Annual pass holder discount | food and merchandise purchases | 10 | 2018-01-01 | 2025-12-31 |