In order to know what column of incoming data should be stored in what field in MA Professional, you create a data format in MA Professional to store that mapping.
NOTE: If you're just uploading a list of email addresses, MA Professional provides a default data format that assumes that the first column is the email address.
Before you dive in and create a data format, take a few minutes to understand the data you'll be bringing into MA Professional. If you're getting ready for a mailing and you simply want to personalize the mailing with...
Dear %%First Name%%
...you only need to upload email address and first name. Easy.
But thinking beyond this immediate need, what might be useful in the next few weeks? Would knowing the state that your subscriber lives in allow you to reference that state in a story or subject line, therefore making the content more personalized for them? Would knowing the number of years that they've been with your organization factor into how you would write a story about the same topic?
Any data that you upload can be used for personalization or targeting. Doing a little bit of planning will set you up to create a better experience for your subscribers.
Uploading Email Addresses
If your data file contains only email address, all you need to do is follow the Default data format on Step 1 of the Subscriber Upload.
Uploading Multiple Fields
Each column in your data file will map to a profile info field in Professional. Remove any blank columns between columns with data. As shown in the image below, it's fine to have empty cells when there's no data in the field for a particular subscriber.
We recommend that the first column of the data file be the email address. Although Professional can support having email addresses in any column, it's a good way to standardize your data-file format with email address as the first column.
When working with date fields, consistently use the same date format. Whether you use the American format (mm/dd/yyyy) or the British format (dd/mm/yyyy), just use it consistently. The subscriber upload process doesn't do any date conversion, so all incoming data is processed as a string.
Create a Data Format
- Navigate to Subscribers > Upload > Data Formats.
- Click Add Data Format.
- Give your data format a name. If there are six fields or less, it's a good practice to name the data format with those field names; if you're uploading a longer list of fields coming from a standard process, then you can use a more descriptive name. Make sure that everyone on the team understands which data format is appropriate to use. All of the fields included in the data format are displayed in the X column in case there's ever a question as to what this data format works with.
NOTE: By default, Tab is the selected column delimiter. Professional prefers this delimiter.
- Select the fields that correspond to the columns on the incoming data file. A single click moves the field from the Available Columns list to the Columns In Data Format List. The top to bottom order matches the left to right order of columns in the data file.
- Fields can be reordered using the green handle on the field and dragging and dropping to a new location. Do this when you realize that the field order in the data format doesn't match the left to right order of the columns in your data file.
- Click Save when done.