All Collections
Integrations
Booking Platforms
How to set up the SevenRooms Airship connector
How to set up the SevenRooms Airship connector

How to automatically send booking and purchase data from SevenRooms to your Airship database

A
Written by Anthony Moore
Updated over a week ago

Switching on the SevenRooms x Airship connector means that each time a customer makes or updates a booking the customer and booking data will be automatically sent to your Airship database.

The integration will run once per day, and bring all the new and updated bookings, with any purchases data (if available) from the previous day into Airship.


Getting Started

To get started, provide confirmation in writing to your SevenRooms Account Manager that your data can be shared with Airship.

From here, SevenRooms will need to provide us with;

  • Client ID

  • Client Secret

  • venue_group_id(s)

  • venue_ids

As the client, you will need to provide us with;

  • Any SevenRooms tags you would like us to create groups for

  • Historic Import File (if required)


What data is sent?

The following information will be sent and stored against the Airship customer profile;

  • Title

  • First Name

  • Surname

  • Gender

  • Email Opt-in

  • Mobile Opt-in

  • Venue

  • Dynamic Fields

    • SevenRooms spend per visit

    • SevenRooms total spend

    • SevenRooms spend

  • Booking info

    • Reservation confirmation number

    • Reservation date/time

    • Enquiry date/time

    • Booking status

    • Booking source

    • Party Size

    • Booking notes

  • Purchases

    • Purchase transaction reference

    • Basket items

      • Menu item name

      • Menu item price

      • Menu item quantity

      • Menu item PLU

This data contributes to PoP (proof of presence).

Note, Purchase information is only available if SevenRooms is integrated with your POS. Please contact your SevenRooms account manager if you have any questions around this.


How it works

Once a day we will request all reservations that have been updated the previous day, for all Venue Groups or Venues configured.

When a booking is processed by Airship, we perform a check to see if the booking is New, or already exists. If the booking is new, we will;

  • Add / update the contact profile

  • Associate the booking to the contact profile

If the booking already exists, Airship will;

  • Update the booking details

  • Update all contact details except any marketing preference

Airship will not update Marketing Preferences as part as a 'Booking Update' action, to ensure that Airship doesn't inadvertently opt customers in after a booking is attended / updated.

Groups / Tags

Within SevenRooms, there are a number of tags which can be applied to a Contact / Reservation. When we receive the reservation / contact from SevenRooms, we can automatically place the customers into a 'Group' based on if they have a Tag assigned. This can be used to ensure anyone tagged with 'Birthday', ends up in a 'Birthday' group in Airship and can be Segmented / Targeted.

By default no tags will be setup, and all customers will go into a group called 'Sevenrooms'. If you would like any other Tags setting up, please contact your Airship Customer Success contact.

Dynamic Fields

The following Dynamic Fields will be created, and visible against the customer (where supplied by SevenRooms)

  • SevenRooms spend per visit

  • SevenRooms total spend

  • SevenRooms spend

Note, these values are only based on the data which SevenRooms provide. Any spend / transactions provided to Airship via POS / Order & Pay products will not impact these values.


View your data in Airship

Once the connector is enabled, you will be able to see data flowing into your Airship account, by navigating to Folders & Groups.

To access your Contact Folders in Airship, scroll down to “Contacts” in the main menu and select “Folders & Groups”.

You’ll be able to select your 'Sevenrooms' Group to see contacts within that Group that have been added via the SevenRooms connector. If you have defined any additional Groups / Tags as part of the integration, these can also be seen here (i.e. Birthday in the below example)

To view the booking or purchase data, open a contact record and click “View bookings” or "View EPOS Data". This screen will show the transaction record details for the customer.


Historic Imports

It is not currently possible for us to import historic data via the integration, however if a .CSV could be provided of all reservations & contact data, we can manually import this as part of the setup. Please talk to your contact in Customer Success to get this imported.


Did this answer your question?