Viewing import history
You can view details about each import to a list, Profile Extension, and Custom Table. Details include load name, completion dates, record counts, and a direct link to any rejected records.
To view import history:
- Navigate to the Manage Lists page
- Click Actions and select View Import History to open the Load History page.
About the import history details and analysis
The Load History page displays detailed information about all loads for the selected list, Profile Extension, or Custom Table.
- Click a load name to review and audit its details.
If any records were rejected, click Download Rejected Records
Correcting import issues
The load details shows the number of rejected rows. You can download the rejected records to a .csv file and review the reason for the rejection. You can then resolve any issues and re-load the records. To download rejected records, click Download Rejected Records.
Reasons for rejection
Records can be rejected during a list import for any of the following reasons.
- INVALID DATA FORMAT
For example, improper use of field separators and enclosing characters, such as enclosing quotation marks in another set of quotation marks.
- NOT UPDATED PER MERGE RULE. MUST HAVE VALID CUSTOMER ID OR EMAIL ADDRESS OR MOBILE NUMBER
The record doesn't match the merge rules.
- NOT UPDATED PER MERGE RULE. MATCH FIELD CANNOT BE EMPTY
There must be data in the match field to process the record.
- NOT UPDATED PER MERGE RULE. POSTAL_STREET_1_ FIELD CANNOT BE EMPTY
The postal street address value is missing.
- INVALID FORMAT FOR MOBILE NUMBER
Must have 6-15 digits: The mobile number is too long or too short.
-
NOT UPDATED PER MERGE RULE. MOBILE NUMBER FIELD CANNOT BE EMPTY
There is no mobile number field in the record and one is required by the merge rules.
-
INVALID FORMAT FOR MOBILE COUNTRY
Must have valid ISO2 country code-"+mobileCountryVal: International mobile campaigns require a country code.
- NOT UPDATED PER MERGE RULE. EMAIL ADDRESS IS EMPTY
The record has no email address.
- INVALID FORMAT FOR EMAIL ADDRESS
The email address is badly formatted, and may contain spaces or invalid characters; it may be missing the domain name). Or, top level domain names that are not listed (for example, lala_smith@lul.xyz). See the Internet Assigned Numbers Authority (IANA) for a list of all allowed domain extensions.
- VALUE TOO LONG FOR THE FIELD
The value exceeds the permitted limit in at least one field.
- LINK NAME IS EMPTY
- LINK NAME IS INVALID
- LINK URL IS EMPTY
- RECORD HAS NO MAPPED DATA
- NO VALID RECORDS TO MERGE
There are no records to upload.
- LOAD WAS ABORTED BY USER - NO VALID RECORDS TO MERGE
There are no records because the upload was aborted.
- REJECTED PER RULES + String.valueOf(this.totalSkipCnt)
For example: REJECTED PER RULES: 17 records. In this case, 17 represents the number of records that were skipped according to the do not insert or do not update rules.
Understanding Data and List Management
Understanding Filters