If your data has incorrect headings it could cost you extra!
All data needs to be correctly assigned to the right column so that we can identify it and use it appropriately. We have standard headings and columns that apply to everyone. Then you can create your own custom headings as well.
The following are the standard headings we have. We recommend using these as the headers for your data.
-
title
-
firstname
-
lastname
-
company
-
job_title
-
address1
-
address2
-
address3
-
city
-
state
-
country
-
zipcode
-
ref_id
When importing data to our platform it's best to check each of your columns to see if they've been mapped to the right heading.
Please note, if address line 1 and your zipcode have not been mapped correctly, the address will not validate on our system. This can mean it might cost more to send your mail as it does not match the US Postal Service's database.
As you can see if your heading is appropriately named it will automatically map to the right field. If the heading is slightly off it will default to "Custom Heading (Small text)". This heading is used for any custom variable fields that you might wish to add to your data, select this option to generate your custom field. If the column is a standard field, like Name, address, company, city, state and zipcode make sure to map it to one of our columns. If your data is not mapped correctly, you can simply change this here by clicking into the drop down.
You can also skip any columns that are not relevant to your mailing. Custom heading (small text) should be used for all variables by default. If you have a large volume of text and characters in your variable, Custom heading (large text) should be used. Please note when viewing your data in your mailing list you will not be able to see any custom large text.
When using custom variable fields we always recommend making the variable first in the column settings rather than generating it here.