Importing fan data into Openstage allows you to consolidate all your contacts in one place, whether they're from mailing lists, ticket sales, or pre-save campaigns. Just follow these steps:
(For importing Sales Data, go here.)
Before You Start
A couple things you should know..
All fan records must have either an email or phone number attached.
Include marketing permissions for GDPR compliance. If you are unsure of marketing permissions, we recommend the first campaign with Openstage is an "Opt-in/Data clean" campaign.
Step 1: Prepare Your Data
Use a blank sheet in a spreadsheet program like Excel or Sheets, exported as a comma separated value (CSV) file.
Be sure each fan record includes either an email address or phone number.
For phone numbers, format them in one of these ways:
E.164 (e.g., +12345678910)
RFC966 (e.g., +12-34-567-8910)
E.123 national (e.g., 12345678910)
It's important to clean your list. Only upload opted-in contacts, or include marketing permissions as a field for GDPR compliance.
For dates, ensure they are formatted for the UK, or select US dates within the import window.
⚠️ Please note: You must ensure data that's being ingested is being uploaded to the correct artist account.
Great care should be taken to avoid the cross contamination of fan data among the artists in your roster. Failure to do so will result in:
Inflated fan numbers that aren't representative of your data set
Greater chance of complaints from unhappy fans
Greater chance of fan unsubscribes
Step 2: Upload
Go to the Fans section and click "Import Fans." Choose either "Upload multiple fans" or "Create a single fan" based on your data.
Adding a single fan doesn't require a .CSV file.
When uploading multiple fans, the 'import tag' field is applied to all fan records present in the upload.
Step 3: Map Fields
Match each data field in your .csv to the correct Openstage field (e.g., email, name, city). You can also create any custom tags to help organize your fanbase. Once mapped, click "Import."
Step 4: Validate
The system validates your data in three stages: "Validating," "Ready to Upload," and "Errors." Review and fix any errors, such as misspelled email addresses or wrong country codes.
Common errors include:
Misspelled email addresses (e.g., @gamil.com, icolud.com)
Wrong country codes
Fields not mapped to the correct tag
Step 5: Finished
Once validated, click "Upload Fan Records." Your data will process, and your fan records will be added to Openstage!
Please Note: If numbers don’t add up, check for duplicates, invalid records, or compounded transactions. For help, contact us at hello@openstage.live.
Fan Import Key
