DATA REQUIREMENTS
1) All data must be in one single file, either comma separated (.csv) or Excel (.xls) type.
2) Column headers must be ordered consistently between updates.
Example:
| FIRST NAME | LAST NAME | COMPANY |
| Bob | Clicker | MemberClicks |
| Becky | Clicker | MemberClicks |
If your file looks like the example, each subsequent update should be consistently ordered (
i.e. the order of the column headers should remain FIRST NAME then LAST NAME then COMPANY).
ADDING ATTRIBUTES
Should you wish to add additional attributes at a later date, they should be formatted with the first column of new attributes immediately following the last column of the old attributes. MemberClicks Support must be notified with the added attributes specifically identified in the update request. Once this has been done the new file (with the added columns) becomes the standard expected file layout for all future uploads.
Old File:
| FIRST NAME | LAST NAME | COMPANY |
| Bob | Clicker | MemberClicks |
| Becky | Clicker | MemberClicks |
Sample Email:
MemberClicks Support,
We're adding the following attribute(s) to our Mothership:
EMAIL
PHONE
New File:
| FIRST NAME | LAST NAME | COMPANY | EMAIL | PHONE |
| Bob | Clicker | MemberClicks | bob@email.com | 800.111.2222 |
| Becky | Clicker | MemberClicks | becky@email.com | 800.333.4444 |
DELETING ATTRIBUTES
Likewise should you wish to delete Mothership attributes, MemberClicks Support must be notified in the same manner as above with the deleted attributes specifically identified in the update request. Please supply us with a new file, removing the corresponding columns for the deleted attributes. This file will become the standard expected file layout for all future uploads.
Old File:
| FIRST NAME | LAST NAME | COMPANY | EMAIL | PHONE |
| Bob | Clicker | MemberClicks | bob@email.com | 800.111.2222 |
| Becky | Clicker | MemberClicks | becky@email.com | 800.333.4444 |
Sample Email:
MemberClicks Support,
We're deleting the following attribute(s) from our Mothership:
EMAIL
New File:
| FIRST NAME | LAST NAME | COMPANY | PHONE |
| Bob | Clicker | MemberClicks | 800.111.2222 |
| Becky | Clicker | MemberClicks | 800.333.4444 |
