- 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 account39 (it could be less than 39 for some subscription plans, please ask if you need an uprgade to 39).
MailUp contains the following special fields, which cannot be modified.
|Field Name||Field ID|
|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.
|E-mail address||111 (cannot be altered, see above)|
|Date of Birth||10|
A file to be imported shall contain a header row and one record for each recipient to be imported. The '|' (pipe) symbol is used as a separator and each row must contain exactly the same number of columns.
Basically, as soon as you respect the rules above, you are free to choose the type, order and number of columns you prefer. In this paragraph you can have a look at some examples,
Subscription on Email channel
Let's say that your CSV file contains these columns:
|Position in the CSV file|
|Date of Birth||3||10||1978-03-16|
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:
*MailUp personal field ID or special field ID (refer to previous table for special fields)
This is an example of the file content
1|2|10|9|8|111|6 Peter|Smith|1978-03-16|M|UKfirstname.lastname@example.org|London Maria|Rossi|1963-12-21|F|ITemail@example.com|Roma ...
Subscription on SMS channel
For international prefix and mobile number you can either use two separate fields or a single field
1|2|10|9|8|222|333|6 Peter|Smith|1978-03-16|M|UK|123000000|123000000|London ...
1|2|10|9|8|444|6 Peter|Smith|1978-03-16|M|UK|+44123000000|London ...
Subscription on both Email and SMS channels
Mixing the scenarios described above, here is an example with both email and SMS