Introduction

You can analyse your reservations and guests in Bookboost Insights across a defined set of fields, with no extra setup. Knowing which fields are available up front saves time when you build a workbook or ask the Insights Agent a question. This article lists the reservation and guest fields available in the Reservations and Guests topics, what is not available today, and how common terms such as market segment, booking source, and demographic data map to the actual fields.

Reservation fields (Reservations topic)

The following reservation fields are available to filter, group, and measure in the Reservations topic.

Field	What it holds
`market_segment`	Market segment classification
`market_category`	Market category classification
`channel_category`	Booking source or channel category
`channel_segment`	Distribution channel segment
`rate_plan_name`, `rate_plan_code`, `rate_plan_description`	Rate plan details
`status`	Reservation status (for example confirmed, checked-in, checked-out)
`cancelled`	Whether the reservation was cancelled
`start_date`, `end_date`	Check-in and check-out dates
`arrival_date_time`, `departure_date_time`	Arrival and departure timestamps
`nights`	Number of nights
`number_of_adults`, `number_of_children`, `number_of_guests`	Guest counts on the reservation
`total_gross_amount`, `total_tax`, `currency`	Revenue, tax, and currency
`balance`	Outstanding balance
`lead_time_days`, `lead_time_seconds`	Time between booking and check-in
`booking_reference`	External booking reference
`agency_name`	Booking agency name
`created_at`, `created_at_in_pms`	When the reservation was created, in Bookboost and in the PMS
`app_name`, `organisation_name`	Property and organisation scoping
OTA versus Direct flag	Whether the booking came through an OTA or direct
Company and travel agency data	Company name, type, and contact email, through the linked companies record

The following reservation fields are not confirmed for every PMS integration, so confirm availability for the specific PMS before relying on them: purpose (purpose of stay), transport_method (guest transport method), and number_of_units (number of rooms booked).

Guest fields (Guests topic)

The Guests topic is a dedicated set of guest profile fields. Access is scoped by organisation, like every other Insights topic.

Demographic data:

gender
nationality
birth_date
language (preferred language)
country (from the locale record)
title (for example Mr, Mrs)
occupation

Contact details:

email_address, secondary_email_addresses
phone_number, secondary_phone_numbers

Address data:

address_line_1, address_line_2
address_city, address_country, address_zip_code, address_type

Consent:

consent_status, consent_codes
Per consent detail: consent_name, consent_code, consent_description, consent_status

Loyalty:

programme_name, programme_code
level_name, level_code, level_description
external_membership_id

Tags:

tags, an array of Bookboost assigned tags, for example loyalty member tags

Guest and reservation relationship:

guest_types, the roles a guest holds on a reservation (for example Primary, Booker, Payer, Debtor)
primary_guest_type

Master Profiles:

Guests can be grouped into a Master Profile for deduplication and cross profile analysis.

You can also analyse reservations by guest and loyalty attributes directly in the Reservations topic, for example revenue by guest country or by loyalty status, programme, or level. For more on this, see Guest and loyalty data in Bookboost Insights.

How common terms map to fields

Customers often ask for a field by a name that differs from the Bookboost field. The most common mappings:

Market segment: available as market_segment and market_category in the Reservations topic.
Booking source or channel: available as channel_category and channel_segment, plus the OTA versus Direct flag.
Demographic data: gender, nationality, birth_date, language, and country, all in the Guests topic.

A guest classification scheme that is specific to a property and not part of the standard Bookboost data model is not available as a dedicated field. Where a property needs this, an unused supported field from the lists above can be mapped to carry that data so it becomes queryable. Contact Bookboost Support to arrange this.

What is not available in Bookboost Insights

The following are not exposed in the Insights topics today:

Custom PMS fields and non standard PMS attributes that are not part of the standard Bookboost data model
Room type and room number, which are not exposed as dedicated fields in the current data model
Folio and charge line item detail
Pre-arrival form responses, which are stored separately and are not surfaced in the Insights topics today

Field availability and your PMS

Which fields carry data depends on your PMS integration and what your PMS actually sends to Bookboost. If a field appears empty, check whether your PMS populates it before assuming the field is unavailable.

Configuration and Setup

No setup is required. The reservation and guest fields are available in the Reservations and Guests topics by default, subject to your PMS integration sending the underlying data.

Support

Please contact us through the 'Talk to Us' option on the left menu in the platform, or through the Bookboost Support email at support@bookboost.io if you have questions or need additional support.

Reservation and guest fields available in Bookboost Insights