Txgb: Most-used fields#
The table below gives information about most-used fields that you can import from Txgb. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Description |
Use in Adverity |
|---|---|---|
ad_campaign_code |
A unique identifier (code) for a specific advertising campaign associated with a booking. |
dimension |
ad_campaign_id |
A unique numerical identifier for a specific advertising campaign associated with a booking. |
dimension |
ad_campaign_name |
The human-readable name of an advertising campaign associated with a booking. |
dimension |
ad_campaign_slogan |
A memorable phrase or motto used in an advertising campaign associated with a booking. |
dimension |
booking_date |
The date when the booking was created or made. |
dimension |
booking_state |
Current status of the booking, such as Confirmed, Cancelled, InError, or GeneralFailure. |
dimension |
booking_system_reference |
A unique reference ID assigned to the booking by the booking system. |
dimension |
booking_type |
Classification of the booking, such as Direct or OnAccount. |
dimension |
campaign_code |
A unique identifier (code) for a general marketing or promotional campaign associated with a booking. |
dimension |
campaign_id |
A unique numerical identifier for a general marketing or promotional campaign associated with a booking. |
dimension |
campaign_name |
The human-readable name of a general marketing or promotional campaign associated with a booking. |
dimension |
campaign_promo_code |
A specific promotional code used as part of a campaign, which may offer discounts or special offers on a booking. |
dimension |
campaign_slogan |
A memorable phrase or motto used in a general marketing or promotional campaign associated with a booking. |
dimension |
customer_address_line1 |
First line of the customer’s street address. |
dimension |
customer_address_line2 |
Second line of the customer’s street address, if applicable. |
dimension |
customer_city |
City of the customer’s address. |
dimension |
customer_country |
Country of the customer’s address. |
dimension |
customer_email |
Customer’s primary email address. |
dimension |
customer_first_name |
Customer’s given name. |
dimension |
customer_last_name |
Customer’s family name. |
dimension |
customer_postcode |
Postcode or ZIP code of the customer’s address. |
dimension |
customer_state |
State, province, or region of the customer’s address. |
dimension |
customer_telephone_home |
Customer’s home telephone number. |
dimension |
customer_telephone_mobile |
Customer’s mobile telephone number. |
dimension |
customer_telephone_work |
Customer’s work telephone number. |
dimension |
distributor_address_line1 |
First line of the distributor’s street address. |
dimension |
distributor_address_line2 |
Second line of the distributor’s street address, if applicable. |
dimension |
distributor_city |
City of the distributor’s address. |
dimension |
distributor_country |
Country of the distributor’s address. |
dimension |
distributor_email |
Distributor’s primary email address. |
dimension |
distributor_full_name |
Full legal name of the distributor. |
dimension |
distributor_id |
Unique identifier for the distributor. |
dimension |
distributor_postcode |
Postcode or ZIP code of the distributor’s address. |
dimension |
distributor_short_name |
Abbreviated or common name of the distributor. |
dimension |
distributor_state |
State, province, or region of the distributor’s address. |
dimension |
distributor_tax_id |
Tax identification number for the distributor. |
dimension |
distributor_telephone |
Distributor’s primary telephone number. |
dimension |
industry_category |
The category of the tourism product or service, such as Accommodation or Attraction. |
dimension |
merchant_address_line1 |
First line of the merchant’s street address. |
dimension |
merchant_address_line2 |
Second line of the merchant’s street address, if applicable. |
dimension |
merchant_city |
City of the merchant’s address. |
dimension |
merchant_country |
Country of the merchant’s address. |
dimension |
merchant_email |
Merchant’s primary email address. |
dimension |
merchant_full_name |
Full legal name of the merchant. |
dimension |
merchant_id |
Unique identifier for the merchant. |
dimension |
merchant_postcode |
Postcode or ZIP code of the merchant’s address. |
dimension |
merchant_short_name |
Abbreviated or common name of the merchant. |
dimension |
merchant_state |
State, province, or region of the merchant’s address. |
dimension |
merchant_tax_id |
Tax identification number for the merchant. |
dimension |
merchant_telephone |
Merchant’s primary telephone number. |
dimension |
num_adults |
The number of adult participants included in the booking. |
metric |
num_children |
The number of child participants included in the booking. |
metric |
num_concessions |
The number of concession-eligible participants included in the booking. |
metric |
payment_method |
The method used to pay for the booking (e.g., credit card, bank transfer). |
dimension |
product_cancelled |
Boolean indicator showing if the booked product or service was cancelled. |
dimension |
product_commencing_date |
The start date for the booked product or service. |
dimension |
product_concluding_date |
The end date for the booked product or service. |
dimension |
product_id |
Unique identifier for the booked product or service. |
dimension |
product_name |
Name of the booked product or service. |
dimension |
product_quantity |
The number of units of the product or service booked. |
metric |
product_refunded |
Boolean indicator showing if the booked product or service was refunded. |
dimension |
provider_address_line1 |
First line of the provider’s street address. |
dimension |
provider_address_line2 |
Second line of the provider’s street address, if applicable. |
dimension |
provider_city |
City of the provider’s address. |
dimension |
provider_country |
Country of the provider’s address. |
dimension |
provider_email |
Provider’s primary email address. |
dimension |
provider_full_name |
Full legal name of the provider. |
dimension |
provider_id |
Unique identifier for the provider. |
dimension |
provider_postcode |
Postcode or ZIP code of the provider’s address. |
dimension |
provider_short_name |
Abbreviated or common name of the provider. |
dimension |
provider_state |
State, province, or region of the provider’s address. |
dimension |
provider_tax_id |
Tax identification number for the provider. |
dimension |
provider_telephone |
Provider’s primary telephone number. |
dimension |
reservation_id |
A unique identifier for the specific reservation. |
dimension |
total_price |
The total price of the booking, including all extras and taxes. |
metric |
total_price_excluding_extras |
The total price of the booking, excluding any additional services or items. |
metric |
transaction_date |
The date when the financial transaction for the booking occurred. |
dimension |