booking_attribution
The marketing channel credited with each booking, by last click. One row is one booking.
- One row is
- one booking
- Columns
- 3
- Rows in Sample
- 19,324
- Rows in Standard
- 195,304
- Rows in Full
- 1,955,497
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| booking_idkey | integer | Unique id for the row. | |
| attributed_channel | text | Channel of the last marketing touch before the booking. | broadcast; direct; display; email; organic search; paid search; paid social; travel agent; walk-up |
| campaign_id | integer | The campaign credited, when the channel maps to one. Can be empty. |
How it connects
This table points to
- booking_id matches bookings.booking_id
- campaign_id matches campaigns.campaign_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| booking_id | attributed_channel | campaign_id |
|---|---|---|
| 6048598 | direct | |
| 6048698 | paid social | 9040 |
| 6048798 | direct | |
| 6048898 | organic search | |
| 6049025 | direct |