Introduction
The Database Exporter (previously called Audience Exporter) lets you download a list of your contacts based on any saved audience - great for when you need your data outside of Airship.
Because this involves personal data, access to this feature is intentionally limited to a small number of users on your account. The account owner gets access automatically and can grant it to others via Settings > Users & Roles > Manage Users. The permission to look out for is called Audience Exports Access.
Related guide: before you can use the exporter you will need to create a saved audience.
Running an export
From the dashboard sidebar click Database and then Export
Click the blue Create New button in the top right corner
Pick your saved audience from the dropdown
Give the export a name so you can find it easily
Tick Email me when this export is ready if you'd like a notification when it's done
Click to run the export
Can't see the Export feature? Email us at success@airship.co.uk and we'll get it set up or let you know who on your account has access.
Note: The export reflects your audience at the time of running the export - if more contacts fall into your saved audience you may need to re-run the export.
Checking your export is ready
For larger exports, it can take several hours to complete. You can check progress in two ways:
By email
If you ticked the "Email me when this export is ready" notification box, you'll get an email with the subject line "Your audience export is ready" with a View my export button.
In Airship
Head back to Database > Export and check whether the status has changed from Started to Completed. When it's completed the Download button will appear.
What's included in the export?
Each export comes as a CSV with the following fields:
Title - Contact's title (e.g. Mr, Mrs)
First Name - Contact's first name
Last Name - Contact's last name
Date of Birth - Contact's date of birth
Address Line 1 - First line of the contact's address
Address Line 2 - Second line of the contact's address
Address Line 3 - Third line of the contact's address
Town/City - Contact's town or city
County - Contact's county
Country - Contact's country
Mobile Number - Contact's mobile phone number
Home Number - Contact's home phone number
Work Number - Contact's work phone number
Email Address - Contact's email address
Created Time - When the contact was added to Airship
UID - Unique ID for the contact
Last Updated Time - When the contact record was last changed
Membership Number - The contact's membership number
Membership Type - The type of membership the contact holds
Allow SMS - Whether the contact has opted in to SMS
Allow Email - Whether the contact has opted in to email
Allow Mailer - Whether the contact has opted in to postal mail
Unsub SMS Time - When the contact unsubscribed from SMS
Unsub Email Time - When the contact unsubscribed from email
Email First Opt-in - When the contact first opted in to email
Allow Call - Whether the contact has opted in to calls
Unsub Call Time - When the contact unsubscribed from calls
Job Title - Contact's job title
Company - The company the contact works for
Name of local business - The venue or business linked to the contact