Skip to main content

Klaviyo Variables

Klaviyo variables help you customise Klaviyo templates with reusable Ventrata content.

Updated over 3 weeks ago

Supplier Details


Booking Details

Booking

  • booking_balance - outstanding amount for the booking

  • booking_code - imported booking code

  • booking_created_at - date and time when the booking was created

  • booking_created_at_dow - day of the week when the booking was created

  • booking_created_at_time - time when the booking was created

  • booking_date - travel date

  • booking_duration - duration of the tour

  • booking_notices - notices set in the dashboard

  • product_operator_mobile - operator phone number

  • booking_package - name of the booked package

  • booking_package_option - name of the package option

  • booking_paid - amount paid for the booking

  • booking_primary - indicates if it is the primary product in an order (Yes / No options)

  • booking_pass - reference for products inside a pass

  • booking_purchases - booking purchases

  • booking_redeemed_at - redemption date

  • booking_redeemed_at_dow - day of the week for redemption

  • booking_redeemed_at_time - time of redemption

  • booking_refunded - amount refunded to the customer

  • booking_reference - unique identifier for the booking

  • booking_supplier_reference - booking suppliers's unique identifier

  • booking_reseller_reference - booking reseller's unique identifier

  • booking_size - number of adults, children, etc_

  • booking_status - booking status in the dashboard

  • booking_tickets - number of tickets by tier

  • booking_tiers - ticket tiers

  • booking_units - list of booked units

  • booking_upgrades - booking upgrades (extras)

Booking Changes

  • booking_cancelled_at - date and time of booking cancellation

  • booking_updated_at - date and time of the last update
    ​
    ​

Booking Warning

  • booking_not_redeemed_warning - prints the NOT REDEEMED / NOT A TICKET message on a printed ticket when the associated booking was not redeemed
    ​



    πŸ“— TIP
    ​
    Use the not_redeemed_warning variable. It allows the system to automatically detect whether the booking_not_redeemed_warning or ticket_not_redeemed_warning variable should be applied.
    ​



    πŸ“’ NOTE
    ​
    This variable is intended for printed tickets only. It serves as an alert for drivers and sellers so they do not allow anyone boarding with unredeemed tickets. It also helps identify cases where the ticket may have already been redeemed and discarded.
    ​


Accounting

Meeting Point

Notes

  • booking_public_notes - notes by concierge / reseller agents when booking on behalf of a client

  • booking_private_notes - private notes by concierge / reseller agents

  • booking_pickup_notes - pickup notes

Payment Form

  • booking_card_total - value of card payment

  • booking_cash_total - value of cash payment

  • booking_voucher_total - value of voucher used as payment

  • booking_other_total - value of other forms of payment, such as bank transfer
    ​

Questions

  • booking_question_answers - question and answer(s) associated with the booking

  • booking_answers - only answer(s) to the question associated with the booking

  • booking_all_answers - answer(s) to the question(s) associated with every level of the order (order, booking, ticket)
    ​

Resources

  • booking_resource_allocations - resources allocated to the tour

  • booking_guide - guide assigned to the tour
    ​

Tours

  • booking_tour_group - product tour group

  • booking_opening_hours - opening hours

  • booking_pickup_time - pickup time (if pickup is available)

  • booking_pickup_requested - customer requested pickup (YES / NO)

  • booking_dropoff_time - dropoff time

Validity

  • booking_active_from_iso8601 - date since when the booking is valid in YYYY-MM-DD format

  • booking_active_to_iso8601 - date when the booking expires in YYYY-MM-DD format

  • booking_expires_on - booking expiry date

  • booking_open_dated - open dated booking (YES / NO)

  • booking_valid_from - valid from date

  • booking_valid_until_date - valid until date

  • booking_valid_from_date - valid from date

  • booking_valid_until_time - valid until time

  • booking_valid_from_time - valid from time

  • booking_valid_until_dow - valid until day of week

  • booking_valid_from_dow - valid from day of week

  • booking_valid_from_date_long - valid from date in DOW DD MM, YYYY format

  • booking_valid_until_date_long - valid until date in DOW DD MM, YYYY format
    ​



    πŸ“— TIP
    ​
    You can use valid_from_date_long or valid_until_date_long for both bookings and tickets. The system will automatically detect which version to display.
    ​


Vouchers

  • booking_pdf_url - voucher URL to a PDF file

  • booking_pkpass_url - voucher URL to a PKPASS file, which can be added to a digital wallet


Customer

  • customer_full_name - customer's complete name

  • customer_first_name - customer's first name

  • customer_last_name - customer's last name

  • customer_email - customer's email address

  • customer_mobile - customer's mobile phone number

  • customer_company - organisation where the customer is employed

  • customer_notes - customer's notes added during checkout

  • customer_language - customer's preferred language

  • customer_country - customer's country of residence

  • customer_state - state or province (in the USA or Canada) where the customer lives

  • customer_address - street name and number of the customer's residence

  • customer_postal_code - ZIP or postal code of customer's address

  • customer_tax_id - customer’s tax identification number

  • customer_tax_office - tax office where the customer files or reports their taxes


Pickups


Product


Item

  • item_name - item name

  • item_code - item code

  • item_destination - item destination

  • item_description - item description

  • item_category - item category

  • item_tax_label - item tax label

  • item_tax_rate - item tax rate


Ticket

Ticket Details

  • tickets - quantity and name(s) of the ticket tier(s)

  • ticket_code - ticket code (if imported)

  • ticket_date_dmy - travel date in DD-MM-YYYY format

  • ticket_date_mdy - travel date in MM-DD-YYYY format

  • ticket_reference - unique identifier for the ticket

  • ticket_size - number of PAX

  • ticket_tickets - ticket tiers

  • ticket_unit - list of units

Accounting

  • ticket_commission - sales commission on a ticket

  • ticket_cost - cost per ticket

  • ticket_discount - discount on a ticket

  • ticket_margin - margin per ticket

  • ticket_price - price per ticket

  • ticket_price_no_tax - price per ticket without tax

  • ticket_total - total price per ticket

  • ticket_total_no_tax - total price per ticket without tax

  • ticket_tax - tax per ticket

Payment Forms

  • ticket_card_total - value of card payment

  • ticket_cash_total - value of cash payment

  • ticket_voucher_total - value of voucher used as payment

  • ticket_other_total - value of other forms of payment, such as bank transfer

Ticket Changes

  • ticket_updated_at - date when the ticket was updated

  • ticket_created_at - date when the ticket was created

Ticket Warning

  • ticket_not_redeemed_warning - shows the NOT REDEEMED / NOT A TICKET message on a printed ticket when the associated ticket was not redeemed
    ​



    πŸ“— TIP
    ​
    Use the not_redeemed_warning variable. It allows the system to automatically detect whether the booking_not_redeemed_warning or ticket_not_redeemed_warning variable should be applied.
    ​



    πŸ“’ NOTE
    ​
    This variable is intended for printed tickets only. It serves as an alert for drivers and sellers so they do not allow anyone boarding with unredeemed tickets. It also helps identify cases where the ticket may have already been redeemed and discarded.
    ​


  • ticket_tier - ticket type

  • ticket_upgrades - ticket upgrades (extras)

Validity

  • ticket_valid_from_dow - valid from day of week

  • ticket_valid_from_time - valid from time

  • ticket_valid_from_date - valid from date

  • ticket_valid_until_dow - valid until day of week

  • ticket_valid_until_date - valid until date

  • ticket_valid_until_time - valid until time

  • ticket_valid_from_date_long - valid from date in DOW DD MM, YYYY format

  • ticket_valid_until_date_long - valid until date in DOW DD MM, YYYY format
    ​



    πŸ“— TIP
    ​
    You can use valid_from_date_long or valid_until_date_long for both bookings and tickets. The system will automatically detect which version to display.
    ​



Order

Accounting

Order Changes

  • order_cancelled_at - date and time of order cancellation

Order Details

  • order_checkout_url - send Pay now links or confirm quotes

  • order_code - order code (if imported)

  • order_confirmed_at - order date

  • order_created_at - date when the ticket was created

  • order_currency - currency in which the order was created

  • order_reference - unique identifier for the order

  • order_shift_sequence - shift sequence of the order

  • order_source - source of the order, for example web checkout, terminal, backoffice

  • order_ip_address - IP address of online bookings

  • order_latitude - location coordinates where the order was made (street sales)

  • order_longitude - location coordinates where the order was made (street sales)

  • order_notes - notes added during checkout

  • order_test - test order (YES / NO)

  • order_user_agent - browser client (online sales)

  • order_voucher_code - voucher code used to purchase the order

Questions

  • order_answers - question and answer(s) associated with the order

  • order_question_answers - only the answer(s) to the question associated with the order


Gift

  • created_at - time and date when the gift voucher was created

  • gift_amount - gift voucher value

  • gift_code - gift code

  • gift_message - message from the purchaser

  • recipient_full_name - recipient of the gift voucher

  • customer_full_name - purchaser of the gift voucher

  • gift_reference - unique identifier for the gift voucher

  • gift_instructions - instructions associated with the gift voucher

  • gift_expires_at - gift voucher expiry date

  • recipient_first_name - first name of the gift voucher recipient

  • recipient_last_name - last name of the gift voucher recipient

  • recipient_email - email of the gift voucher recipient

  • recipient_mobile - phone number of the gift voucher recipient

  • recipient_language - language of the gift voucher recipient

  • recipient_country - country of the gift voucher recipient

  • recipient_address - address of the gift voucher recipient
    ​


Seller

  • location_name - location name

  • seller_name - seller name (direct sales)

  • shift_date - shift date

  • shift_started_at - shift start time

  • shift_ended_at - shift end time

  • terminal_name - terminal name

  • user_name - Ventrata dashboard user name (backoffice sales)
    ​


Reseller


Purchase

  • purchase_reference - unique identifier of the purchase

  • purchase_total - total purchase price

  • purchase_total_no_tax - purchase price without tax

  • purchase_tax - purchase price with tax

  • purchase_updated_at - date and time of the last update

  • purchase_created_at - date and time of when the purchase was created

  • purchase_quantity - number of purchases
    ​


Other

  • checkout_name - name of the web checkout

Did this answer your question?