Import data formatting requirements

When importing data into Audience Republic, the values in your import file must meet certain formatting requirements, or the import may not succeed.

When preparing your data for an import, thoroughly check that each field meets the outlined requirements:

Contact field requirements

Mobile number

• The cell format should be General or Text
• Mobile numbers must include:
  - International country calling code
  - Area code: See here for reformatting area codes.
  - Phone number

• The cell format should be General or Text
• Gender values can be entered as either:
  • M / F / O
  • Male / Female / Other

Date of birth

• The cell format should be Date: DD/MM/YYYY or YYYY/MM/DD

Country

• The cell format should be General or Text
• For best results we recommend ISO 3166 2 letter codes but other formats (e.g. United States or USA) are accepted. Best practice is to ensure all data uses the same format prior to import.

State

• Country must be included in your CSV file
• When mapping the fields during importing, ensure you select Country and State

Tags

• The cell format should be General or Text
• Only these character types will be imported for tags
  • Letters (abcdefg)
  • Numbers (12345)
  • Hyphen ( - )
  • Underscore ( _ )
• If there are multiple tags, each tag should be separated by a comma:

• Another acceptable format is tags separated by commas and also wrapped by quotes (This is the format MailChimp exports tags by default)

Event field requirements

Start or End date and time

• The cell format should be Custom: d/mm/yyyy h:mm

Event ID

• The cell format should be General or Text 
• Each Event ID must be unique
• Values can include numbers, upper and lower case letters and symbols

Ticket/order field requirements

Order date and time

• The cell format should be Custom: d/mm/yyyy h:mm
• Note that upon importing, you will be asked to identify a timezone for the Order date and time. You should select the timezone applicable to the data you are importing, not the timezone you are in. Typically, order date and time is provided in UTC, though some ticketing provider platforms may translate the date to your local time. If you are unsure we recommend contacting your ticketing provider.

Order ID

• The cell format should be General or Text 
• Each Order ID should be unique
• Values can include numbers, upper and lower case letters and symbols

Total paid

• The cell format should be Number, with 2 decimal places 

Related articles

Prepare ticket sales data for import

Prepare events data for import

How to reformat mobile numbers to include country codes

Troubleshooting: importing contacts to a list

Still need help?

Contact us at [email protected]