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.