Mailjet Variables
Mailjet variables help you customise Mailjet templates, which when connected with Ventrata, can be linked to Campaigns. Use of the current set of variables below to customise your Mailjet template:
{{var:BOOKING_ACTIVE_FROM_ISO8601:""}} - shows since when the booking is active in ISO 8601 format
{{var:BOOKING_ACTIVE_TO_ISO8601:""}} - shows until when the booking is active in ISO 8601 format
{{var:BOOKING_CANCELLED_AT:""}} - shows when the booking was cancelled in dd/mm/yyyy format
{{var:BOOKING_CARD_TOTAL:""}} - shows total value based on the used payment form
{{var:BOOKING_CASH_TOTAL:""}} - shows total value based on the used payment form
{{var:BOOKING_CHARITY_ROUNDUP:""}} - shows the charity roundup
{{var:BOOKING_COMMISSION:""}} - shows the commission on a booking
{{var:BOOKING_CODE:""}} - use for imported booking codes
{{var:BOOKING_COST:""}} - shows the cost of the booking
{{var:BOOKING_CREATED_AT:""}} - shows the time the booking was created
{{var:BOOKING_CREATED_AT_DOW:""}} - shows the day of the week of booking creation tx/ticket/group
{{var:BOOKING_CREATED_AT_TIME:""}} - shows the time of booking creation tx/ticket/group
{{var:BOOKING_DATE:""}} - shows the travel date
{{var:BOOKING_DISCOUNT:""}} - shows the discount on a booking if applied
{{var:BOOKING_DROPOFF_TIME:""}} - shows the drop-off time based on booking preferences
{{var:BOOKING_DURATION:""}} - shows the booking duration in minutes / hours / days
{{var:BOOKING_MARGIN:""}} - shows the margin on a booking
{{var:BOOKING_MEETING_POINT:""}} - shows the meeting point
{{var:BOOKING_MEETING_TIME:""}} - shows the meeting time
{{var:BOOKING.NOT_REDEEMED_WARNING:""}} - this should only show on tickets, so that drivers/sellers know that they shouldn’t accept anyone boarding with this ticket as it:
a) has not yet been redeemed
b) may be a discarded redeemed ticket and the ticket has already been redeemed
{{var:BOOKING_OPEN_DATED:""}} - indicates whether it is an open dated booking (yes / no)
{{var:BOOKING_OPENING_HOURS:""}} - shows the opening hours based on product settings
{{var:BOOKING_OTHER_TOTAL:""}} - shows the total value based on the used payment form
{{var:BOOKING_PASS:""}} - if the product is inside a pass this returns the reference of the pass
{{var:BOOKING_PDF_URL:""}} - dynamic variable; generates a download page url which contains the order ID
{{var:BOOKING_PKPASS_URL:""}} - dynamic variable; generates a download page url which contains the order ID
{{var:BOOKING_PICKUP_NOTES:""}} - shows any notes regarding pickup
{{var:BOOKING_PICKUP_TIME:""}} - shows pickup time (for bookings with pickups)
{{var:BOOKING_PICKUP_REQUESTED:""}} - indicates whether the customer requested a pickup (yes / no)
{{var:BOOKING_PRIMARY:""}} - indicates whether it is the primary product (the first one that was added) in an order (yes / no)
{{var:BOOKING_PRIVATE_NOTES:""}} - shows private notes added by concierge / reseller agents
{{var:BOOKING_PUBLIC_NOTES:""}} - shows notes added by concierge / reseller agents when booking on behalf of a client (eg a vegetarian option for lunch)
{{var:BOOKING_PURCHASES:""}} - shows booking purchases
{{var:BOOKING_QUESTION_ANSWERS:""}} - shows answers to assigned questions
{{var:BOOKING_REDEEMED_AT:""}} - shows the date of redemption in the dd/mm/yyyy format
{{var:BOOKING_REDEEMED_AT_DOW:""}} - shows on which day of the week was the booking redeemed
{{var:BOOKING_REDEEMED_AT_TIME:""}} - shows the time of redemption
{{var:BOOKING_REFERENCE:""}} - Ventrata generated unique identifier for the booking
{{var:BOOKING_RESELLER_REFERENCE:""}} - Ventrata generated unique identifier for the booking reseller
{{var:BOOKING_RESOURCE_ALLOCATIONS:""}} - shows allocated resources
{{var:BOOKING_STATUS:""}} - shows the bookings status in Ventrata
{{var:BOOKING_SIZE:""}} - shows the number of adults, children, etc. for one ticket per booking
{{var:BOOKING_TICKETS:""}} - shows the count of tickets by tier
{{var:BOOKING_TIERS:""}} - shows the number of individual booking tiers
{{var:BOOKING_TOTAL:""}} - shows the total price for a booking
{{var:BOOKING_TOTAL_NO_TAX:""}} - shows the booking total without tax applied
{{var:BOOKING_TOUR_GROUP:""}} - shows the name of the tour group
{{var:BOOKING_UPDATED_AT:""}} - shows when the booking was updated in dd/mm/yyyy format
{{var:BOOKING_UNITS:""}} - shows the number of individual booking units
{{var:BOOKING_UPGRADES:""}} - shows booking upgrades
{{var:BOOKING_VOUCHER_TOTAL:""}} - shows the total value based on the used payment form
{{var:BOOKING_VALID_FROM:""}} - shows booking validity start date
{{var:BOOKING_VALID_UNTIL_DATE:""}} - valid until a date
{{var:BOOKING_VALID_FROM_DATE:""}} - valid from a date
{{var:BOOKING_VALID_UNTIL_TIME:""}} - valid until which time
{{var:BOOKING_VALID_FROM_TIME:""}} - valid from which time
{{var:BOOKING_VALID_UNTIL_DOW:""}} - valid until day of week
{{var:BOOKING_VALID_FROM_DOW:""}} - valid from day of week
{{var:CUSTOMER_FULL_NAME:""}} - name and surname of the customer
{{var:CUSTOMER_FIRST_NAME:""}} - first name of the customer
{{var:CUSTOMER_LAST_NAME:""}} - last name of the customer
{{var:CUSTOMER_EMAIL:""}} - valid email address
{{var:CUSTOMER_MOBILE:""}} - phone number, preferably in international format
{{var:CUSTOMER_COMPANY:""}} - name of the company the customer works for
{{var:CUSTOMER_NOTES:""}} - notes entered by the customer
{{var:CUSTOMER_LANGUAGE:""}} - preferred language of the customer
{{var:CUSTOMER_COUNTRY:""}} - customer's country of residence
{{var:CUSTOMER_ADDRESS:""}} - street name, number and city where the customer resides
{{var:CUSTOMER_POSTAL_CODE:""}} - postal code of the city where the customer resides
{{var:DROPOFF_NAME:""}} - name of the drop-off
{{var:DROPOFF_INSTRUCTIONS:""}} - instructions for drop-off
{{var:PICKUP_NAME:""}} - name of the pickup
{{var:PICKUP_ADDRESS:""}} - street name, number and city of the pickup location
{{var:PICKUP_DIRECTIONS:""}} - directions to pickup location
{{var:HOTEL_NAME:""}} - name of the hotel, if listed as pickup location
(You can add a product logo)
{{var:OPTION_CODE:""}} - code of the option
{{var:OPTION_DESCRIPTION:""}} - brief summary of the option
{{var:OPTION_LANGUAGE:""}} - language of the option
{{var:OPTION_MEETING_POINT:""}} - meeting point of the option
{{var:OPTION_MEETING_TIME:""}} - meeting time of the option
{{var:OPTION_NAME:""}} - option name
{{var:PRODUCT_BOOKING_TERMS:""}} - booking terms of the product; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_CANCELLATION_POLICY:""}} - the cancellation policy of the product; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_CAPTION:""}} - a short one sentence marketing caption; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_CODE:""}} - product code
{{var:PRODUCT_DESCRIPTION:""}} - a short one paragraph description; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_DESTINATION:""}} - destination to which product belongs to
{{var:PRODUCT_INCLUSIONS:""}} - product inclusions
{{var:PRODUCT_MEETING_POINT:""}} - meeting point of the product
{{var:PRODUCT_MEETING_TIME:""}} - meeting time of the product
{{var:PRODUCT_NAME:""}} - product name
{{var:PRODUCT_OPERATOR_ADDRESS:""}} - the operator address
{{var:PRODUCT_OPERATOR_EMAIL:""}} - the operator email
{{var:PRODUCT_OPERATOR_MOBILE:""}} - the operator mobile
{{var:PRODUCT_REDEMPTION_INSTRUCTIONS:""}} - instructions to redeem a pass for the product; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_USAGE_INSTRUCTIONS:""}} - instructions on the correct usage of the product; scroll down the product page to locate the appropriate text fields
{{var:PROMOTION_NAME:""}} - name of the applied promotion
{{var:PROMOTION_CODE:""}} - code of the applied promotion
{{var:PROMOTION_DISCOUNT:""}} - discounted value after the promotion
{{var:TOUR_TIME:""}} - time of the tour
{{var:TOUR_CODE:""}} - unique name or identifier of the tour, for example, flight number
{{var:DATE:""}} - day and date of the tour
{{var:TOUR_MEETING_POINT:""}} - meeting point of the tour
{{var:TOUR_MEETING_TIME:""}} - meeting time of the tour
{{var:AGENT_NAME:""}} - the name of the concierge agent (for reseller sales)
{{var:RESELLER_NAME:""}} - the reseller name
Big Text will print a larger font size (so it stands out more)
You can add images, such as discount badges to be presented or sponsor logos, like Calem
Split text will format left-justified column text and an adjacent right-justified column of text
When adding a map, enter an address and it will print a picture of a map with a pin showing a location. This can be added to online or reseller's vouchers and tickets (eg the location to redeem voucher)
Booking Details
{{var:BOOKING_ACTIVE_FROM_ISO8601:""}} - shows since when the booking is active in ISO 8601 format
{{var:BOOKING_ACTIVE_TO_ISO8601:""}} - shows until when the booking is active in ISO 8601 format
{{var:BOOKING_CANCELLED_AT:""}} - shows when the booking was cancelled in dd/mm/yyyy format
{{var:BOOKING_CARD_TOTAL:""}} - shows total value based on the used payment form
{{var:BOOKING_CASH_TOTAL:""}} - shows total value based on the used payment form
{{var:BOOKING_CHARITY_ROUNDUP:""}} - shows the charity roundup
{{var:BOOKING_COMMISSION:""}} - shows the commission on a booking
{{var:BOOKING_CODE:""}} - use for imported booking codes
{{var:BOOKING_COST:""}} - shows the cost of the booking
{{var:BOOKING_CREATED_AT:""}} - shows the time the booking was created
{{var:BOOKING_CREATED_AT_DOW:""}} - shows the day of the week of booking creation tx/ticket/group
{{var:BOOKING_CREATED_AT_TIME:""}} - shows the time of booking creation tx/ticket/group
{{var:BOOKING_DATE:""}} - shows the travel date
{{var:BOOKING_DISCOUNT:""}} - shows the discount on a booking if applied
{{var:BOOKING_DROPOFF_TIME:""}} - shows the drop-off time based on booking preferences
{{var:BOOKING_DURATION:""}} - shows the booking duration in minutes / hours / days
{{var:BOOKING_MARGIN:""}} - shows the margin on a booking
{{var:BOOKING_MEETING_POINT:""}} - shows the meeting point
{{var:BOOKING_MEETING_TIME:""}} - shows the meeting time
{{var:BOOKING.NOT_REDEEMED_WARNING:""}} - this should only show on tickets, so that drivers/sellers know that they shouldn’t accept anyone boarding with this ticket as it:
a) has not yet been redeemed
b) may be a discarded redeemed ticket and the ticket has already been redeemed
{{var:BOOKING_OPEN_DATED:""}} - indicates whether it is an open dated booking (yes / no)
{{var:BOOKING_OPENING_HOURS:""}} - shows the opening hours based on product settings
{{var:BOOKING_OTHER_TOTAL:""}} - shows the total value based on the used payment form
{{var:BOOKING_PASS:""}} - if the product is inside a pass this returns the reference of the pass
{{var:BOOKING_PDF_URL:""}} - dynamic variable; generates a download page url which contains the order ID
{{var:BOOKING_PKPASS_URL:""}} - dynamic variable; generates a download page url which contains the order ID
{{var:BOOKING_PICKUP_NOTES:""}} - shows any notes regarding pickup
{{var:BOOKING_PICKUP_TIME:""}} - shows pickup time (for bookings with pickups)
{{var:BOOKING_PICKUP_REQUESTED:""}} - indicates whether the customer requested a pickup (yes / no)
{{var:BOOKING_PRIMARY:""}} - indicates whether it is the primary product (the first one that was added) in an order (yes / no)
{{var:BOOKING_PRIVATE_NOTES:""}} - shows private notes added by concierge / reseller agents
{{var:BOOKING_PUBLIC_NOTES:""}} - shows notes added by concierge / reseller agents when booking on behalf of a client (eg a vegetarian option for lunch)
{{var:BOOKING_PURCHASES:""}} - shows booking purchases
{{var:BOOKING_QUESTION_ANSWERS:""}} - shows answers to assigned questions
{{var:BOOKING_REDEEMED_AT:""}} - shows the date of redemption in the dd/mm/yyyy format
{{var:BOOKING_REDEEMED_AT_DOW:""}} - shows on which day of the week was the booking redeemed
{{var:BOOKING_REDEEMED_AT_TIME:""}} - shows the time of redemption
{{var:BOOKING_REFERENCE:""}} - Ventrata generated unique identifier for the booking
{{var:BOOKING_RESELLER_REFERENCE:""}} - Ventrata generated unique identifier for the booking reseller
{{var:BOOKING_RESOURCE_ALLOCATIONS:""}} - shows allocated resources
{{var:BOOKING_STATUS:""}} - shows the bookings status in Ventrata
{{var:BOOKING_SIZE:""}} - shows the number of adults, children, etc. for one ticket per booking
{{var:BOOKING_TICKETS:""}} - shows the count of tickets by tier
{{var:BOOKING_TIERS:""}} - shows the number of individual booking tiers
{{var:BOOKING_TOTAL:""}} - shows the total price for a booking
{{var:BOOKING_TOTAL_NO_TAX:""}} - shows the booking total without tax applied
{{var:BOOKING_TOUR_GROUP:""}} - shows the name of the tour group
{{var:BOOKING_UPDATED_AT:""}} - shows when the booking was updated in dd/mm/yyyy format
{{var:BOOKING_UNITS:""}} - shows the number of individual booking units
{{var:BOOKING_UPGRADES:""}} - shows booking upgrades
{{var:BOOKING_VOUCHER_TOTAL:""}} - shows the total value based on the used payment form
{{var:BOOKING_VALID_FROM:""}} - shows booking validity start date
{{var:BOOKING_VALID_UNTIL_DATE:""}} - valid until a date
{{var:BOOKING_VALID_FROM_DATE:""}} - valid from a date
{{var:BOOKING_VALID_UNTIL_TIME:""}} - valid until which time
{{var:BOOKING_VALID_FROM_TIME:""}} - valid from which time
{{var:BOOKING_VALID_UNTIL_DOW:""}} - valid until day of week
{{var:BOOKING_VALID_FROM_DOW:""}} - valid from day of week
Customer
{{var:CUSTOMER_FULL_NAME:""}} - name and surname of the customer
{{var:CUSTOMER_FIRST_NAME:""}} - first name of the customer
{{var:CUSTOMER_LAST_NAME:""}} - last name of the customer
{{var:CUSTOMER_EMAIL:""}} - valid email address
{{var:CUSTOMER_MOBILE:""}} - phone number, preferably in international format
{{var:CUSTOMER_COMPANY:""}} - name of the company the customer works for
{{var:CUSTOMER_NOTES:""}} - notes entered by the customer
{{var:CUSTOMER_LANGUAGE:""}} - preferred language of the customer
{{var:CUSTOMER_COUNTRY:""}} - customer's country of residence
{{var:CUSTOMER_ADDRESS:""}} - street name, number and city where the customer resides
{{var:CUSTOMER_POSTAL_CODE:""}} - postal code of the city where the customer resides
Pickups
{{var:DROPOFF_NAME:""}} - name of the drop-off
{{var:DROPOFF_INSTRUCTIONS:""}} - instructions for drop-off
{{var:PICKUP_NAME:""}} - name of the pickup
{{var:PICKUP_ADDRESS:""}} - street name, number and city of the pickup location
{{var:PICKUP_DIRECTIONS:""}} - directions to pickup location
{{var:HOTEL_NAME:""}} - name of the hotel, if listed as pickup location
Product
(You can add a product logo)
{{var:OPTION_CODE:""}} - code of the option
{{var:OPTION_DESCRIPTION:""}} - brief summary of the option
{{var:OPTION_LANGUAGE:""}} - language of the option
{{var:OPTION_MEETING_POINT:""}} - meeting point of the option
{{var:OPTION_MEETING_TIME:""}} - meeting time of the option
{{var:OPTION_NAME:""}} - option name
{{var:PRODUCT_BOOKING_TERMS:""}} - booking terms of the product; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_CANCELLATION_POLICY:""}} - the cancellation policy of the product; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_CAPTION:""}} - a short one sentence marketing caption; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_CODE:""}} - product code
{{var:PRODUCT_DESCRIPTION:""}} - a short one paragraph description; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_DESTINATION:""}} - destination to which product belongs to
{{var:PRODUCT_INCLUSIONS:""}} - product inclusions
{{var:PRODUCT_MEETING_POINT:""}} - meeting point of the product
{{var:PRODUCT_MEETING_TIME:""}} - meeting time of the product
{{var:PRODUCT_NAME:""}} - product name
{{var:PRODUCT_OPERATOR_ADDRESS:""}} - the operator address
{{var:PRODUCT_OPERATOR_EMAIL:""}} - the operator email
{{var:PRODUCT_OPERATOR_MOBILE:""}} - the operator mobile
{{var:PRODUCT_REDEMPTION_INSTRUCTIONS:""}} - instructions to redeem a pass for the product; scroll down the product page to locate the appropriate text fields
{{var:PRODUCT_USAGE_INSTRUCTIONS:""}} - instructions on the correct usage of the product; scroll down the product page to locate the appropriate text fields
{{var:PROMOTION_NAME:""}} - name of the applied promotion
{{var:PROMOTION_CODE:""}} - code of the applied promotion
{{var:PROMOTION_DISCOUNT:""}} - discounted value after the promotion
{{var:TOUR_TIME:""}} - time of the tour
{{var:TOUR_CODE:""}} - unique name or identifier of the tour, for example, flight number
{{var:DATE:""}} - day and date of the tour
{{var:TOUR_MEETING_POINT:""}} - meeting point of the tour
{{var:TOUR_MEETING_TIME:""}} - meeting time of the tour
Reseller
{{var:AGENT_NAME:""}} - the name of the concierge agent (for reseller sales)
{{var:RESELLER_NAME:""}} - the reseller name
Other
Big Text will print a larger font size (so it stands out more)
You can add images, such as discount badges to be presented or sponsor logos, like Calem
Split text will format left-justified column text and an adjacent right-justified column of text
When adding a map, enter an address and it will print a picture of a map with a pin showing a location. This can be added to online or reseller's vouchers and tickets (eg the location to redeem voucher)
NEXT: Mailjet Campaigns
Updated on: 22/03/2024
Thank you!