Switching on the Sunday App x Airship connector means your customer and purchase data from Sunday App is automatically sent to your Airship database.
The integration runs once per day, bringing through the previous day's orders so your contact and purchase history stays up to date.
Getting started
From Airship, we will provide;
SFTP access where the daily files are delivered (host, username, password and folder path)
From Sunday, we will need:
The daily .CSV files for Products and Payments providing
Confirmation if you want historic orders processing, and Sunday can provide the backfill of the files to the SFTP
A list of your venues with their Sunday App business IDs, so we can map each to the correct Airship unit
You will need to confirm to Airship:
If you want a historic import running, and what date to backfill data from
What data is sent?
The following information is sent and stored against the Airship customer profile:
Email
Mobile number
Email marketing opt-in (set when the customer has given hard opt-in)
Venue
Purchase info
Order reference
Order date
Order type
Basket line items (product name, product code, quantity, value)
This data contributes to PoP (proof of presence).
Groups
When a contact is added to Airship, they are placed into a group based on their order type, using the format Order - {product type}, (i.e. PAT, C&C) inside the SundayApp folder.
How it works
Once a day (early hours), Airship retrieves the previous day's payments (and basket) files from Sunday App over SFTP.
For each payment we:
Add or update the contact profile
Record the purchase and its line items against the contact
Existing contacts are updated using protective consent rules, so Airship doesn't inadvertently change a customer's marketing permissions.
View your data in Airship
Once the connector is enabled, navigate to Contacts > Folders & Groups - select the location and open the SundayApp folder to see the contacts and groups created by the connector.