Certain field types require a specific format to import with the best results. Learn how to format each of your field types and which ones are required for which feature.

Before you start

  • Email Address is a required field for all imports. Other fields are optional but needed for certain features such as insights, segmentation, personalization and messaging.
  • Columns can be arranged in any order for import.
  • You will need to match the column heading in your file with the field type in Audience Republic, so ensure your headings are clear.
  • How to prepare the CSV file to import contacts or ticket sales.

Email Address

Email is a required field type to import any file. It must be in the format: example@example.com

A contact will not be imported if any of these errors are found.

  • Missing information - A part of the email address is missing. For example, example@example is missing the .com and examaple@examplecom is missing the dot.
  • Extra Spaces - Sometimes when exporting data extra spaces are added in before, after or sometimes in the middle of and address. To remove these spaces try to the TRIM function in excel.

First Name and Last Name

This is an optional field for import, but required for personalisation.

They should be split into 2 seperate columns, one for first name and one for last name.

Mobile Number

This is an optional field for import, but required to use SMS messaging. Mobile numbers should include:

  • International Country Calling code
  • Local Area code
  • Local Phone number
  • Numbers and '+' symbol accepted
  • Spaces and dashes will be ignored

Gender

This is an optional field for import, but required for the Insights menu and segmentation. It can be formatted as either:

  • M / F
  • Male / Female

Date of Birth

This is an optional field for import, but required for the Insights menu and segmentation. The date can be formatted as either:

  • US Date Format - MM/DD/YYYY
  • Non-US Date Format - DD/MM/YYYY

Start / End Date & Time

This is a required field to mass import events. It can be formatted as either US Format or Non-US Format.

  • US Format - MM/dd/YYYY HH:mm:ss a
  • Non-US Format - YYYY-MM-dd HH:mm:ss (also known as ISO 8601)

For the best results we recommend using ISO 8601.

Event ID

This is a required field to mass import orders against events. Each event should have a unique Event ID so we can map the correct orders to it. If Event IDs are not available, you can import each event individually. The event ID can have any of the below characters:

  • Numbers
  • Upper and lower case letters
  • underscores, hyphens, and other symbols

Order ID

The is a required field to mass import orders. The order ID can have any of the below characters:

  • Numbers
  • Upper and lower case letters
  • underscores, hyphens, and other symbols

Order date / time

This is an optional field but required for the ticket sales graphs to populate.

*Note this field will ask for a timezone. You should select the timezone the data your importing has NOT the timezone you are in. Most typically order date and time is given in UTC, though occasionally is has been translated to your local time. If you are unsure we recommend contacting your ticketing provider.

It can be formatted as either US Format or Non-US Format.

  • US Format - MM/dd/YYYY HH:mm:ss a
  • Non-US Format - YYYY-MM-dd HH:mm:ssZ (also known as ISO 8601)

For the best results we recommend using ISO 8601.

Total Paid

This is a required field to import orders. This field should have:

  • The total value of the order
  • Numbers and decimals only,
  • All other characters will be ignored

Email Marketing opt in

This is an optional field that says if the person has opted into email marketing. It can be formatted as any of the below:

  • Y/N
  • Yes/No
  • True/False
  • 0/1

Country

This is an optional field for import, but required to populate location insights. For best results we recommend ISO 3166 2 letter codes, but any format is accepted. Best practice is to ensure all data uses the same format prior to import.

  • US - the 2 letter iso code for United States and recommended format for all countries
  • United States and USA - all formats are accepted, best practice is to ensure all data is imported using the same format
Did this answer your question?