| booking_id |
string |
Unique booking identifier |
BK-00001 |
Format: BK-XXXXX |
| date_booked |
date |
Date the booking was made |
2024-03-15 |
YYYY-MM-DD |
| travel_start_date |
date |
First day of the trip |
2024-04-10 |
YYYY-MM-DD |
| travel_end_date |
date |
Last day of the trip |
2024-04-14 |
YYYY-MM-DD |
| tour_type |
string |
Type of tour booked |
Private Cultural Tour |
One of: Private Cultural Tour, Multi-Day Itinerary, Nile Cruise, Day Trip, Luxor Premium |
| traveler_country |
string |
Country of origin for the traveler |
United Kingdom |
ISO country name |
| group_size |
integer |
Number of travelers in the booking |
3 |
Range: 1-20 |
| marketing_channel |
string |
How the traveler says they found us |
Google |
One of: Google, Instagram, Print Ad, Travel Portal, Word of Mouth, Repeat Client. Self-reported by the traveler at booking time. This field may not accurately reflect how the traveler actually discovered Nile Compass Tours. |
| booking_value_egp |
integer |
Total booking value in Egyptian Pounds |
35000 |
Range varies by tour type |
| status |
string |
Booking status |
confirmed |
One of: confirmed, cancelled |
| review_score |
float |
Post-trip review score |
4.5 |
Scale 1.0-5.0. Null if trip not yet completed or no review left. |