Mailjet Variables
Mailjet variables are used to customise your Mailjet templates used for Campaigns. They allow you to insert specific information on the template, which can vary from case to case. You can see the list of current variables below.
{{var:BOOKING.ACTIVE_FROM_ISO8601}} - shows since when the booking is active in ISO format
{{var:BOOKING.ACTIVE_TO_ISO8601}} - shows until when the booking is active in ISO 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.EXPIRES_ON:""}} - shows when the booking expires
{{var:BOOKING.MARGIN:""}} - shows the margin on a booking
{{var:BOOKING.MEETING_COORDINATES:""}} - shows the meeting point coordinates
{{var:BOOKING.MEETING_POINT:""}} - shows the meeting point
{{var:BOOKING.MEETING_TIME:""}} - shows the meeting time
{{var:BOOKING.NOTICES:""}} - shows booking notices (set in the dashboard)
{{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.PACKAGE:""}} - shows the name of the booked package
{{var:BOOKING.PACKAGE_OPTION:""}} - shows the name of the booked package option
{{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 resource allocations
{{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.SUPPLIER_REFERENCE:""}} - Ventrata generated unique identifier for the booking supplier
{{var:BOOKING.TAX:""}} - shows the tax added if the tax rate was set on the product
{{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 a day of a week
{{var:BOOKING.VALID_FROM_DOW:""}} - valid from a day of a week
{{var:DROPOFF.NAME:""}} - name of the drop-off
{{var:DROPOFF.INSTRUCTIONS:""}} - instructions for a drop-off
{{var:PICKUP.NAME:""}} - name of the pickup
{{var:PICKUP.ADDRESS:""}} - address of a pickup
{{var:PICKUP.DIRECTIONS:""}} - directions of a pickup
{{var:HOTEL.NAME:""}} - the hotel pickup name
(You can add a product logo)
{{var:COMBINATION.PRODUCT:""}} - if the product was purchased with a combination, the name the other product it was purchased with
{{var:COMBINATION.DISCOUNT:""}} - indicates the discount used for a product in combination
{{var:OPTION.CODE:""}} - code of the option
{{var:OPTION.DESCRIPTION:""}} - Option descriptions are set when editing options. This can be edited in Options
{{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 (editable on a product)
{{var:PRODUCT.CANCELLATION_POLICY:""}} - the cancellation policy of the product. This can be edited in Options
{{var:PRODUCT.CAPTION:""}} - a short one sentence marketing caption
{{var:PRODUCT.CODE:""}} - product code
{{var:PRODUCT.DESCRIPTION:""}} - a short one paragraph description (editable on a product)
{{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_COMPANY:""}} - the operator name
{{var:PRODUCT.OPERATOR_CONTACT:""}} - the operator contact
{{var:PRODUCT.OPERATOR_EMAIL:""}} - the operator email
{{var:PRODUCT.OPERATOR_MOBILE:""}} - the operator mobile
{{var:PRODUCT.REDEMPTION_INSTRUCTIONS:""}} - this can be edited in Options
{{var:PRODUCT.SUPPLIER_COMPANY:""}} - the operator name
{{var:PRODUCT.SUPPLIER_CONTACT:""}} - the supplier contact
{{var:PRODUCT.SUPPLIER_EMAIL:""}} - the supplier email
{{var:PRODUCT.SUPPLIER_ADDRESS:""}} - the operator address
{{var:PRODUCT.USAGE_INSTRUCTIONS:""}} - short instructions. This can be edited in Options
{{var:PROMOTION.NAME:""}} - shows the name of used promotion
{{var:PROMOTION.CODE:""}} - shows the code of a promotion
{{var:PROMOTION.DISCOUNT:""}} - shows the discounted value
{{var:TOUR.TIME:""}} - the time 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 format
{{var:BOOKING.ACTIVE_TO_ISO8601}} - shows until when the booking is active in ISO 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.EXPIRES_ON:""}} - shows when the booking expires
{{var:BOOKING.MARGIN:""}} - shows the margin on a booking
{{var:BOOKING.MEETING_COORDINATES:""}} - shows the meeting point coordinates
{{var:BOOKING.MEETING_POINT:""}} - shows the meeting point
{{var:BOOKING.MEETING_TIME:""}} - shows the meeting time
{{var:BOOKING.NOTICES:""}} - shows booking notices (set in the dashboard)
{{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.PACKAGE:""}} - shows the name of the booked package
{{var:BOOKING.PACKAGE_OPTION:""}} - shows the name of the booked package option
{{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 resource allocations
{{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.SUPPLIER_REFERENCE:""}} - Ventrata generated unique identifier for the booking supplier
{{var:BOOKING.TAX:""}} - shows the tax added if the tax rate was set on the product
{{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 a day of a week
{{var:BOOKING.VALID_FROM_DOW:""}} - valid from a day of a week
Pickups
{{var:DROPOFF.NAME:""}} - name of the drop-off
{{var:DROPOFF.INSTRUCTIONS:""}} - instructions for a drop-off
{{var:PICKUP.NAME:""}} - name of the pickup
{{var:PICKUP.ADDRESS:""}} - address of a pickup
{{var:PICKUP.DIRECTIONS:""}} - directions of a pickup
{{var:HOTEL.NAME:""}} - the hotel pickup name
Product
(You can add a product logo)
{{var:COMBINATION.PRODUCT:""}} - if the product was purchased with a combination, the name the other product it was purchased with
{{var:COMBINATION.DISCOUNT:""}} - indicates the discount used for a product in combination
{{var:OPTION.CODE:""}} - code of the option
{{var:OPTION.DESCRIPTION:""}} - Option descriptions are set when editing options. This can be edited in Options
{{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 (editable on a product)
{{var:PRODUCT.CANCELLATION_POLICY:""}} - the cancellation policy of the product. This can be edited in Options
{{var:PRODUCT.CAPTION:""}} - a short one sentence marketing caption
{{var:PRODUCT.CODE:""}} - product code
{{var:PRODUCT.DESCRIPTION:""}} - a short one paragraph description (editable on a product)
{{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_COMPANY:""}} - the operator name
{{var:PRODUCT.OPERATOR_CONTACT:""}} - the operator contact
{{var:PRODUCT.OPERATOR_EMAIL:""}} - the operator email
{{var:PRODUCT.OPERATOR_MOBILE:""}} - the operator mobile
{{var:PRODUCT.REDEMPTION_INSTRUCTIONS:""}} - this can be edited in Options
{{var:PRODUCT.SUPPLIER_COMPANY:""}} - the operator name
{{var:PRODUCT.SUPPLIER_CONTACT:""}} - the supplier contact
{{var:PRODUCT.SUPPLIER_EMAIL:""}} - the supplier email
{{var:PRODUCT.SUPPLIER_ADDRESS:""}} - the operator address
{{var:PRODUCT.USAGE_INSTRUCTIONS:""}} - short instructions. This can be edited in Options
{{var:PROMOTION.NAME:""}} - shows the name of used promotion
{{var:PROMOTION.CODE:""}} - shows the code of a promotion
{{var:PROMOTION.DISCOUNT:""}} - shows the discounted value
{{var:TOUR.TIME:""}} - the time 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)
Updated on: 30/11/2023
Thank you!