TrackPMS connector

Kaivo is a fully managed data platform that syncs your TrackPMS data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your data from TrackPMS instead of moving it.

What is the TrackPMS connector

Sync your Track PMS property management data into BigQuery with Kaivo to analyse bookings, charges, and accounting.

Category	Other
Authentication	API key
Setup	Self-service

Getting started with the TrackPMS connector

1. Sign up for Kaivo and create a workspace.
2. Connect your TrackPMS account.
3. Choose which tables to sync.
4. Wait for the initial sync to finish.
5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticating TrackPMS

Authenticate with your API Secret.

Field	Description
API Secret
The Server API Secret shown alongside the Key when it is created. Copy it immediately, as it is shown only once.

|

Configuring the TrackPMS connector

When you set up the connector, you provide:

Field	Description
Customer Domain
Your Track HS domain, e.g. yourcompany.trackhs.com — the part before /api/ in your account URL.

| | API Key |

The Server API Key. In Track HS go to Configuration → Company Setup → API Keys and click “+ Server Key” to get the Key and Secret.

|

Tables and columns synced from TrackPMS

Kaivo syncs 76 tables from TrackPMS into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accounting_accounts (31 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
code	STRING
name	STRING
bank_name	STRING
category	STRING
is_active	BOOL
parent_id	FLOAT64
created_at	STRING
… and 21 more columns

accounting_bills (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
memo	STRING
terms	STRING
amount	STRING
balance	STRING
due_date	STRING
txn_date	STRING
bill_type	STRING
… and 14 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• accounting_bills__lines (15 columns)
• accounting_bills__lines__bill_charges (33 columns)
• accounting_bills__lines__bill_charges__charge__lines (17 columns)

accounting_charges (41 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
memo	STRING
amount	STRING
unit_id	FLOAT64
txn_date	STRING
currency	STRING
is_voided	BOOL
parent_id	FLOAT64
… and 31 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• accounting_charges__lines (21 columns)

accounting_deposits (13 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
memo	STRING
token	STRING
amount	STRING
txn_date	STRING
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
… and 3 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• accounting_deposits__transaction_ids (4 columns)

accounting_deposits_payments (14 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
description	STRING
id	STRING
date	STRING
amount	STRING
folio_id	STRING
owner_id	STRING
is_pending	STRING
owner_name	STRING
… and 4 more columns

accounting_items (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
is_taxable	BOOL
unit_price	STRING
updated_at	STRING
… and 6 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• accounting_items__item_categories (4 columns)

accounting_transactions (60 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
memo	STRING
payer	STRING
terms	STRING
amount	STRING
unit_id	FLOAT64
balance	STRING
due_date	STRING
… and 50 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• accounting_transactions__lines (21 columns)
• accounting_transactions__lines__bill_charges (33 columns)
• accounting_transactions__lines__bill_charges__charge__lines (16 columns)

booking_fees (35 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
name	STRING
value	STRING
is_active	BOOL
_embedded__revenue_account__description	STRING
_embedded__revenue_account__id	FLOAT64
_embedded__revenue_account__code	STRING
_embedded__revenue_account__name	STRING
… and 25 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• booking_fees__node_ids (4 columns)
• booking_fees__type_ids (4 columns)

charges (72 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
name	STRING
amount	STRING
item_id	FLOAT64
fee_type	STRING
is_active	BOOL
post_date	STRING
rate_type	STRING
… and 62 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• charges___embedded__item__item_categories (4 columns)
• charges___embedded__date_group__dates (5 columns)
• charges__reservation_type_ids (4 columns)

companies (35 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
fax	STRING
name	STRING
email	STRING
notes	STRING
phone	STRING
tax_id	STRING
postal	STRING
… and 25 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• companies__tags (5 columns)

contacts (43 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
fax	STRING
name	STRING
is_dnr	BOOL
is_vip	BOOL
notes	STRING
tax_id	STRING
custom__custom_1	STRING
custom__custom_2	STRING
… and 33 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• contacts__tags (5 columns)
• contacts__references (5 columns)

contacts_companies (7 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company_id	FLOAT64
contact_id	FLOAT64
owner_type	STRING
owner_split	STRING
is_primary_contact	BOOL
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

contacts_pii_redacted (43 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
fax	STRING
name	STRING
is_dnr	BOOL
is_vip	BOOL
notes	STRING
tax_id	STRING
custom__custom_1	STRING
custom__custom_2	STRING
… and 33 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• contacts_pii_redacted__tags (5 columns)
• contacts_pii_redacted__references (5 columns)

contracts (19 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
description	STRING
id	FLOAT64
code	STRING
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
… and 9 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• contracts__commission_values (7 columns)

crm_company_attachment (14 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
size	FLOAT64
file_url	STRING
file_type	STRING
is_public	BOOL
mime_type	STRING
created_at	STRING
created_by	STRING
… and 4 more columns

crm_tasks (14 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
due_at	STRING
title	STRING
unit_id	FLOAT64
user_id	FLOAT64
priority	FLOAT64
created_at	STRING
created_by	STRING
… and 4 more columns

custom_fields (22 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
name	STRING
entity	STRING
sub_type	STRING
created_at	STRING
created_by	STRING
is_visible	BOOL
reference	STRING
… and 12 more columns

date_groups (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• date_groups__dates (5 columns)

documents (19 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
name	STRING
content	STRING
subject	STRING
auto_send	BOOL
from_name	STRING
is_active	BOOL
created_at	STRING
… and 9 more columns

folios (34 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
name	STRING
parent	FLOAT64
status	STRING
end_date	STRING
sub_type	STRING
pos_allow	BOOL
pos_limit	STRING
… and 24 more columns

folios_logs (9 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
message	STRING
folio_id	FLOAT64
created_at	STRING
created_by	STRING
type_label	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

folios_rules (21 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
code	STRING
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
… and 11 more columns

folios_transactions (338 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
memo	STRING
payer	STRING
amount	STRING
unit_id	FLOAT64
txn_date	STRING
currency	STRING
folio_id	FLOAT64
… and 328 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• folios_transactions__lines (18 columns)
• folios_transactions___embedded__unit__roles (4 columns)
• folios_transactions___embedded__unit__bed_types (4 columns)
• folios_transactions___embedded__unit___embedded__type__roles (4 columns)
• folios_transactions___embedded__unit___embedded__type__custom (4 columns)
• folios_transactions___embedded__unit___embedded__type__bed_types (4 columns)
• folios_transactions___embedded__unit___embedded__type__gateways_ids (4 columns)
• folios_transactions___embedded__unit___embedded__type__amenities_ids (4 columns)
• folios_transactions___embedded__unit___embedded__type__documents_ids (4 columns)
• folios_transactions___embedded__unit___embedded__type__guarantee_policies_ids (4 columns)
• folios_transactions___embedded__unit___embedded__type__insurance_products_ids (4 columns)
• folios_transactions___embedded__unit___embedded__type__cancellation_policies_ids (4 columns)
• folios_transactions___embedded__unit___embedded__node__roles (4 columns)
• folios_transactions___embedded__unit___embedded__node__gateways_ids (4 columns)
• folios_transactions___embedded__unit___embedded__node__amenities_ids (4 columns)
• folios_transactions___embedded__unit___embedded__node__documents_ids (4 columns)
• folios_transactions___embedded__unit___embedded__node__guarantee_policies_ids (4 columns)
• folios_transactions___embedded__unit___embedded__node__insurance_products_ids (4 columns)
• folios_transactions___embedded__unit___embedded__node__cancellation_policies_ids (4 columns)
• folios_transactions___embedded__unit___embedded__clean_status___links (4 columns)
• folios_transactions___embedded__unit__composites (5 columns)
• folios_transactions___embedded__unit__gateways_ids (4 columns)
• folios_transactions___embedded__unit__amenities_ids (4 columns)
• folios_transactions___embedded__unit__documents_ids (4 columns)
• folios_transactions___embedded__unit__guarantee_policies_ids (4 columns)
• folios_transactions___embedded__unit__insurance_products_ids (4 columns)
• folios_transactions___embedded__unit__cancellation_policies_ids (4 columns)
• folios_transactions___embedded__children (30 columns)
• folios_transactions___embedded__children__lines (18 columns)
• folios_transactions___embedded__reservation___embedded__unit__roles (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__bed_types (4 columns)
• folios_transactions___embedded__reservation___embedded__unit___embedded__clean_status___links (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__composites (5 columns)
• folios_transactions___embedded__reservation___embedded__unit__gateways_ids (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__amenities_ids (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__documents_ids (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__guarantee_policies_ids (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__insurance_products_ids (4 columns)
• folios_transactions___embedded__reservation___embedded__unit__cancellation_policies_ids (4 columns)

fractionals (18 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
unit_id	FLOAT64
end_date	STRING
time_unit	STRING
created_at	STRING
created_by	STRING
start_date	STRING
updated_at	STRING
… and 8 more columns

fractionals_inventory (372 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
end_date	STRING
owner_id	FLOAT64
_embedded__owner_reservation__id	FLOAT64
_embedded__owner_reservation__uuid	STRING
_embedded__owner_reservation___links__self__href	STRING
_embedded__owner_reservation__nights	FLOAT64
_embedded__owner_reservation__source	STRING
_embedded__owner_reservation__status	STRING
… and 362 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• fractionals_inventory___embedded__owner_reservation___embedded__unit__roles (5 columns)
• fractionals_inventory___embedded__owner_reservation___embedded__folio___embedded__contact__tags (5 columns)
• fractionals_inventory___embedded__owner_reservation___embedded__contact__tags (5 columns)
• fractionals_inventory___embedded__owner_reservation___embedded__rate_type__channel_id (4 columns)

fractionals_owners (15 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
shares	FLOAT64
end_date	STRING
owner_id	FLOAT64
created_at	STRING
created_by	STRING
start_date	STRING
updated_at	STRING
updated_by	STRING
… and 5 more columns

groups (62 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
code	STRING
name	STRING
status	STRING
end_date	STRING
drop_date	STRING
pos_allow	BOOL
_embedded__contact__id	FLOAT64
… and 52 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• groups___embedded__contact__tags (5 columns)

groups_blocks (9 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
unit_id	FLOAT64
end_date	STRING
estimate	STRING
group_id	FLOAT64
start_date	STRING
reservation_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

groups_tags (12 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
name	STRING
color	STRING
group_id	FLOAT64
created_at	STRING
created_by	STRING
related_to	STRING
updated_at	STRING
… and 2 more columns

housekeeping_clean_types (35 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
code	STRING
name	STRING
is_active	BOOL
_embedded__item__description	STRING
_embedded__item__id	FLOAT64
_embedded__item__name	STRING
_embedded__item___links__self__href	STRING
… and 25 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• housekeeping_clean_types___embedded__item__item_categories (4 columns)
• housekeeping_clean_types___embedded__item__revenue_accounts (24 columns)

housekeeping_task_list (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• housekeeping_task_list___embedded__tasks (13 columns)

housekeeping_work_orders (52 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
cost	STRING
is_turn	BOOL
status	STRING
unit_id	FLOAT64
user_id	FLOAT64
owner_id	FLOAT64
comments	STRING
is_manual	BOOL
… and 42 more columns

lodging_types (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
homeaway_type	STRING
… and 6 more columns

maintenance_problems (4 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

maintenance_work_orders (58 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
source	STRING
status	STRING
unit_id	FLOAT64
user_id	FLOAT64
owner_id	FLOAT64
summary	STRING
priority	FLOAT64
… and 48 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• maintenance_work_orders__problems (5 columns)
• maintenance_work_orders__assignees (14 columns)
• maintenance_work_orders__assignees__assignable (4 columns)

nodes (48 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
phone	STRING
custom	JSON
postal	STRING
region	STRING
type_id	FLOAT64
country	STRING
max_pets	FLOAT64
… and 38 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• nodes__roles (5 columns)
• nodes__gateways_ids (4 columns)
• nodes__amenities_ids (4 columns)
• nodes__documents_ids (4 columns)
• nodes__guarantee_policies_ids (4 columns)
• nodes__insurance_products_ids (4 columns)
• nodes__cancellation_policies_ids (4 columns)

nodes_types (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
name	STRING
is_active	BOOL
is_online	BOOL
is_owners	BOOL
is_report	BOOL
created_at	STRING
created_by	STRING
… and 6 more columns

owners (45 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
fax	STRING
name	STRING
email	STRING
notes	STRING
phone	STRING
tax_id	STRING
postal	STRING
… and 35 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• owners__tags (5 columns)

owners_contracts (19 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
description	STRING
id	FLOAT64
code	STRING
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
… and 9 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• owners_contracts__commission_values (7 columns)

owners_pii_redacted (45 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
fax	STRING
name	STRING
email	STRING
notes	STRING
phone	STRING
tax_id	STRING
postal	STRING
… and 35 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• owners_pii_redacted__tags (5 columns)

owners_statements (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
net	STRING
year	FLOAT64
paid_in	STRING
period	FLOAT64
charges	STRING
owner_id	FLOAT64
paid_out	STRING
revenue	STRING
… and 14 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• owners_statements__splits (12 columns)

owners_statements_transactions (182 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
memo	STRING
payer	STRING
amount	STRING
unit_id	FLOAT64
txn_date	STRING
currency	STRING
is_voided	BOOL
… and 172 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• owners_statements_transactions__lines (21 columns)
• owners_statements_transactions___embedded__transaction__lines (13 columns)
• owners_statements_transactions___embedded__transaction___embedded__unit__roles (5 columns)

owners_units (14 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
unit_id	FLOAT64
end_date	STRING
owner_id	FLOAT64
tax_mode	STRING
created_at	STRING
created_by	STRING
start_date	STRING
updated_at	STRING
… and 4 more columns

promo_codes (27 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
code	STRING
name	STRING
is_active	BOOL
is_public	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
… and 17 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• promo_codes__date_constraints (7 columns)
• promo_codes__date_constraints__date_group__dates (6 columns)
• promo_codes__unit_constraints (7 columns)
• promo_codes__unit_constraints__params__values (4 columns)
• promo_codes__custom_dates_constraint (5 columns)
• promo_codes__custom_blackout_dates_constraint (5 columns)

quotes (307 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
uuid	STRING
total	STRING
_links__self__href	STRING
source	STRING
type_id	FLOAT64
unit_id	FLOAT64
net_rent	STRING
guest_adr	STRING
… and 297 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• quotes__rates (7 columns)
• quotes__taxes (7 columns)
• quotes___embedded__unit__roles (5 columns)
• quotes___embedded__unit__composites (5 columns)
• quotes___embedded__unit__gateways_ids (4 columns)
• quotes___embedded__unit__amenities_ids (4 columns)
• quotes___embedded__unit__documents_ids (4 columns)
• quotes___embedded__unit__guarantee_policies_ids (4 columns)
• quotes___embedded__unit__insurance_products_ids (4 columns)
• quotes___embedded__unit__cancellation_policies_ids (4 columns)
• quotes___embedded__contact__tags (5 columns)
• quotes___embedded__contact__references (5 columns)
• quotes___embedded__rate_type__channel_id (4 columns)
• quotes___embedded__rate_type__conditions__in__unit_type (4 columns)
• quotes___embedded__promo_code__date_constraints (7 columns)
• quotes___embedded__promo_code__date_constraints__date_group__dates (6 columns)
• quotes___embedded__promo_code__unit_constraints (7 columns)
• quotes___embedded__promo_code__unit_constraints__params__values (4 columns)
• quotes___embedded__promo_code__custom_dates_constraint (5 columns)
• quotes___embedded__promo_code__custom_blackout_dates_constraint (5 columns)
• quotes___embedded__guarantee_policy__breakpoints (9 columns)
• quotes___embedded__cancellation_policy__breakpoints (12 columns)
• quotes__guest_fees (18 columns)
• quotes__occupants (10 columns)
• quotes__insurance_products (8 columns)

rate_types (42 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
cta__friday	BOOL
cta__monday	BOOL
cta__sunday	BOOL
cta__tuesday	BOOL
cta__saturday	BOOL
cta__thursday	BOOL
cta__wednesday	BOOL
… and 32 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• rate_types__channel_id (4 columns)
• rate_types__overrides (11 columns)
• rate_types__conditions__in__unit_type (4 columns)

reservations (242 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
uuid	STRING
nights	FLOAT64
source	STRING
status	STRING
type_id	FLOAT64
unit_id	FLOAT64
user_id	FLOAT64
alt_conf	STRING
… and 232 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• reservations___embedded__promo_code__date_constraints (7 columns)
• reservations___embedded__promo_code__date_constraints__date_group__dates (6 columns)
• reservations___embedded__promo_code__unit_constraints (7 columns)
• reservations___embedded__promo_code__unit_constraints__params__values (4 columns)
• reservations___embedded__promo_code__custom_dates_constraint (5 columns)
• reservations___embedded__promo_code__custom_blackout_dates_constraint (5 columns)
• reservations___embedded__travel_agent__tags (5 columns)
• reservations__folio_breakdown__fees (7 columns)
• reservations__folio_breakdown__rates (6 columns)
• reservations__folio_breakdown__taxes (6 columns)
• reservations__quote_breakdown__fees (9 columns)
• reservations__quote_breakdown__rates (7 columns)
• reservations__quote_breakdown__taxes (6 columns)
• reservations__quote_breakdown__charges (5 columns)

reservations_cancellation_policies (32 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
code	STRING
name	STRING
charge_as	STRING
is_active	BOOL
post_date	STRING
priority	FLOAT64
_embedded__date_group__description	STRING
_embedded__date_group__id	FLOAT64
… and 22 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• reservations_cancellation_policies___embedded__date_group__dates (5 columns)
• reservations_cancellation_policies__breakpoints (12 columns)

reservations_cancellation_reasons (15 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
handle	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
airbnb_type	STRING
… and 5 more columns

reservations_discount_reasons (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
handle	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

reservations_guarantee_policies (28 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
description	STRING
id	FLOAT64
name	STRING
amount	STRING
is_active	BOOL
priority	FLOAT64
created_at	STRING
created_by	STRING
… and 18 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• reservations_guarantee_policies__breakpoints (9 columns)

reservations_types (39 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
code	STRING
name	STRING
is_owner	BOOL
is_active	BOOL
is_locked	BOOL
created_at	STRING
created_by	STRING
… and 29 more columns

reservations_v2 (203 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
uuid	STRING
nights	FLOAT64
source	STRING
status	STRING
type_id	FLOAT64
unit_id	FLOAT64
user_id	FLOAT64
folio_id	FLOAT64
… and 193 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• reservations_v2___embedded__promo_code__date_constraints (7 columns)
• reservations_v2___embedded__promo_code__date_constraints__date_group__dates (6 columns)
• reservations_v2___embedded__promo_code__unit_constraints (7 columns)
• reservations_v2___embedded__promo_code__unit_constraints__params__values (4 columns)
• reservations_v2___embedded__promo_code__custom_dates_constraint (5 columns)
• reservations_v2___embedded__promo_code__custom_blackout_dates_constraint (5 columns)
• reservations_v2___embedded__travel_agent__tags (5 columns)
• reservations_v2__occupants (11 columns)
• reservations_v2__alternates (5 columns)
• reservations_v2__guest_breakdown__taxes (6 columns)
• reservations_v2__guest_breakdown__guest_fees (9 columns)
• reservations_v2__owner_breakdown__owner_fees (9 columns)
• reservations_v2__insurance_products (10 columns)
• reservations_v2__travel_insurance_products (9 columns)

reviews (28 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
handle	STRING
unit_id	FLOAT64
unit_name	STRING
channel_id	FLOAT64
created_at	STRING
guest_name	STRING
updated_at	STRING
auto_review	FLOAT64
… and 18 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• reviews__channel_reviews (10 columns)
• reviews__channel_reviews__review_ratings (6 columns)
• reviews__channel_review_response (5 columns)

roles (288 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
is_system	BOOL
privileges__crm__tags	BOOL
privileges__crm__text	BOOL
privileges__crm__leads	BOOL
privileges__crm__sales	BOOL
privileges__crm__company	BOOL
privileges__crm__inquiry	BOOL
… and 278 more columns

suspend_code_reasons (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
reason	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
allow_removal	BOOL
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

tags (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
name	STRING
color	STRING
created_at	STRING
created_by	STRING
related_to	STRING
updated_at	STRING
updated_by	STRING
… and 1 more columns

tax_districts (15 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
tax_markup	BOOL
updated_at	STRING
updated_by	STRING
breakpoint	FLOAT64
… and 5 more columns

tax_policies (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• tax_policies__tax_ids (4 columns)

taxes (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type	STRING
id	FLOAT64
tax	STRING
name	STRING
end_date	STRING
is_active	BOOL
rate_type	STRING
rent_type	STRING
account_id	FLOAT64
… and 14 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• taxes__channel_tax_remittance (4 columns)

travel_insurance_products (27 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
split	STRING
percent	STRING
is_active	BOOL
provider	STRING
created_at	STRING
created_by	STRING
updated_at	STRING
… and 17 more columns

units (81 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
area	FLOAT64
name	STRING
phone	STRING
tax_id	STRING
custom__pms_units_ski_locker	STRING
custom__pms_units_owner_notes	STRING
custom__pms_units_hyatt_message	STRING
custom__pms_units_source_unit_id	STRING
… and 71 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units__roles (5 columns)
• units__bed_types (6 columns)
• units__composites (5 columns)
• units__gateways_ids (4 columns)
• units__amenities_ids (4 columns)
• units__documents_ids (4 columns)
• units__guarantee_policies_ids (4 columns)
• units__insurance_products_ids (4 columns)
• units__cancellation_policies_ids (4 columns)

units_amenities (18 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
group__name	STRING
group_id	FLOAT64
is_public	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
… and 8 more columns

units_amenity_groups (8 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

units_bed_types (14 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
is_active	BOOL
created_at	STRING
created_by	STRING
updated_at	STRING
updated_by	STRING
airbnb_type	STRING
homeaway_type	STRING
… and 4 more columns

units_blocks (49 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
notes	STRING
unit_id	FLOAT64
end_date	STRING
reason_id	FLOAT64
_embedded__reason__description	STRING
_embedded__reason__id	FLOAT64
_embedded__reason__code	STRING
_embedded__reason__name	STRING
… and 39 more columns

units_channel (198 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description	STRING
id	FLOAT64
unit_id	FLOAT64
headline	STRING
sync_mode	STRING
_embedded__channel__id	FLOAT64
_embedded__channel__name	STRING
_embedded__channel___links__self__href	STRING
_embedded__channel__handle	STRING
… and 188 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_channel___embedded__cancellation_policy___embedded__date_group__dates (5 columns)
• units_channel___embedded__cancellation_policy__breakpoints (12 columns)

units_daily_pricing_parent (81 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
area	FLOAT64
name	STRING
phone	STRING
tax_id	STRING
custom__pms_units_ski_locker	STRING
custom__pms_units_owner_notes	STRING
custom__pms_units_hyatt_message	STRING
custom__pms_units_source_unit_id	STRING
… and 71 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_daily_pricing_parent__roles (5 columns)
• units_daily_pricing_parent__bed_types (6 columns)
• units_daily_pricing_parent__composites (5 columns)
• units_daily_pricing_parent__gateways_ids (4 columns)
• units_daily_pricing_parent__amenities_ids (4 columns)
• units_daily_pricing_parent__documents_ids (4 columns)
• units_daily_pricing_parent__guarantee_policies_ids (4 columns)
• units_daily_pricing_parent__insurance_products_ids (4 columns)
• units_daily_pricing_parent__cancellation_policies_ids (4 columns)

units_daily_pricing_v2 (4 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
unit_id	FLOAT64
rate_type_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_daily_pricing_v2__rates (8 columns)

units_taxes (8 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
tax_id	FLOAT64
unit_id	FLOAT64
unit_id	FLOAT64
business_tax_id	STRING
tot_registration_id	STRING
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

units_taxes_parent (81 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
area	FLOAT64
name	STRING
phone	STRING
tax_id	STRING
custom__pms_units_ski_locker	STRING
custom__pms_units_owner_notes	STRING
custom__pms_units_hyatt_message	STRING
custom__pms_units_source_unit_id	STRING
… and 71 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_taxes_parent__roles (5 columns)
• units_taxes_parent__bed_types (6 columns)
• units_taxes_parent__composites (5 columns)
• units_taxes_parent__gateways_ids (4 columns)
• units_taxes_parent__amenities_ids (4 columns)
• units_taxes_parent__documents_ids (4 columns)
• units_taxes_parent__guarantee_policies_ids (4 columns)
• units_taxes_parent__insurance_products_ids (4 columns)
• units_taxes_parent__cancellation_policies_ids (4 columns)

units_types (44 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
area	FLOAT64
name	STRING
custom	JSON
updated__content	STRING
updated__pricing	STRING
updated__availability	STRING
bedrooms	FLOAT64
is_active	BOOL
… and 34 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_types__amenities_ids (4 columns)

units_types_daily_pricing_parent (44 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
area	FLOAT64
name	STRING
custom	JSON
updated__content	STRING
updated__pricing	STRING
updated__availability	STRING
bedrooms	FLOAT64
is_active	BOOL
… and 34 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_types_daily_pricing_parent__amenities_ids (4 columns)

units_types_daily_pricing_v2 (4 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
rate_type_id	FLOAT64
unit_type_id	FLOAT64
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• units_types_daily_pricing_v2__rates (8 columns)

users (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
email	STRING
phone	STRING
is_active	BOOL
username	STRING
vendor_id	FLOAT64
created_by	STRING
updated_by	STRING
… and 1 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• users__assignable (4 columns)

users_pii_redacted (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	FLOAT64
name	STRING
email	STRING
phone	STRING
is_active	BOOL
username	STRING
vendor_id	FLOAT64
created_by	STRING
updated_by	STRING
… and 1 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• users_pii_redacted__assignable (4 columns)

How the TrackPMS sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where TrackPMS supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

Frequently asked questions

How long does the initial sync take for TrackPMS?

It depends on how much history is in your TrackPMS account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Can I sync only some tables or columns?

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when TrackPMS’s schema changes?

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in TrackPMS, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in TrackPMS instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the TrackPMS connector in Kaivo and all of its synced data is deleted with it.

Common use cases for TrackPMS data

Revenue and charges

Use charges and accounting_transactions to track revenue and fees over time.

Booking analysis

Join contacts with charges to understand guest activity and spend.

Accounting reporting

Use accounting_accounts and accounting_bills to report on your books.

Use TrackPMS data in your AI and BI tools

Once TrackPMS data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with TrackPMS data.

Claude

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query’s BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for TrackPMS connector pricing and plan details.

Related connectors

• Demo: Sync Demo to BigQuery.
• Care Quality Commission: Sync Care Quality Commission to BigQuery.
• DingConnect: Sync DingConnect to BigQuery.
• CIMIS: Sync CIMIS to BigQuery.
• Navan: Sync Navan to BigQuery.
• Eventbrite: Sync Eventbrite to BigQuery.