campaigns
Marketing campaigns across every channel. One row is one campaign.
- One row is
- one campaign
- Columns
- 8
- Rows in Sample
- 78
- Rows in Standard
- 78
- Rows in Full
- 78
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 |
|---|---|---|---|
| campaign_idkey | integer | Unique id for the row. | |
| campaign_name | text | Name. | |
| channel | text | Where it ran. | broadcast; direct mail; display; email; paid search; paid social |
| objective | text | What it was meant to drive. | bookings; event attendance |
| target_market | text | Who it was aimed at. | all markets; drive market; local; past guests |
| start_date | date | First day. For email, the day it was sent. | 2018-01-01 to 2025-10-15 |
| end_date | date | Last day. | 2018-01-23 to 2025-12-31 |
| total_cost | decimal | Total spend in dollars. | 11,004.27 to 3,452,168.99 |
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.
| campaign_id | campaign_name | channel | objective | target_market | start_date | end_date | total_cost |
|---|---|---|---|---|---|---|---|
| 9001 | Paid Search 2018 | paid search | bookings | all markets | 2018-01-01 | 2018-12-31 | 2489710.46 |
| 9002 | Paid Social 2018 | paid social | bookings | all markets | 2018-01-01 | 2018-12-31 | 1512882.69 |
| 9003 | Display and Retargeting 2018 | display | bookings | all markets | 2018-01-01 | 2018-12-31 | 667035.38 |
| 9004 | Regional TV and Radio 2018 | broadcast | bookings | all markets | 2018-01-01 | 2018-12-31 | 2374689.16 |
| 9005 | Spring Break Early Booking 2018 | bookings | past guests | 2018-01-10 | 2018-01-23 | 13889.52 |