The CSV file must contain a header row that maps the values contained in that column to a corresponding field in the MailUp system. In MailUp there are:
- Some special fields that are reserved for e-mail, mobile phone number, and mobile phone number + country code.
- Customizable personal data fields. Personal data fields (e.g. first name, last name, etc.) have a numeric ID that goes from 1 to 11 (1 to 40 if the Marketing+ package has been added to your account).
Special Fields
MailUp contains the following special fields, which cannot be modified.
Campo | ID |
E-mail address | 111 |
Mobile phone number's country code | 222 |
Mobile phone number | 333 |
Complete mobile phone number (country code + number) | 444 |
Personal Data Fields
This is just an example of personal data fields in MailUp. They are customizable, meaning that field #2 does not have to be the Last Name. In your MailUp admin console, you will find them under Manage > Personal Data Fields.
Field Name | Field ID |
E-mail address | 111 (cannot be altered, see above) |
First Name | 1 |
Last Name | 2 |
Company | 3 |
City | 6 |
Country | 8 |
Gender | 9 |
Date of Birth | 10 |
Let's say that your CSV file contains these columns:
Field Name | Position in the CSV file |
First Name | 1 |
Cognome | 2 |
Date of Birth | 3 |
Gender | 4 |
Country | 6 |
E-mail address | 7 |
City | 8 |
The columns in your CSV file need to be mapped to the corresponding fields in MailUp, so you will need to add a header row to the CSV file with the following values:
1,2,10,9,8,111,6
Note that the e-mail address will use the special value "111". The other columns use the ID of the corresponding field in MailUp.