Symptom
You are running a campaign that has a "Create Export File" action. After the campaign execution is finished, you download the file and notice the amount of contacts is greater than what you see on the Target Group page.
Environment
SAP Marketing Cloud
Cause
You are using an Export Definition that is configured with Export Profile "File Export Multiline" and some contact has more than one value for at least one of the fields of the export definition.
Resolution
You must change the Export Profile to "File Export" in order to avoid duplicates and make sure that all contacts occupy a single line of the table.
For example, let's simulate the behaviour for an export definition with the attributes "Full Name" and "Lead ID". We will use the contact "John Doe", who has two leads with different IDs(21 and 30) and for this demonstration.
If the profile is set to "File Export", the resulting file would look like the example below:
Full Name | Lead ID |
John Doe | 21,30 |
The different Lead IDs are listed using the separator which is also defined on the Export Definition configurations.
However, if you set the profile to "File Export Multiline", the file would look like the next example below:
Full Name | Lead ID |
John Doe | 21 |
John Doe | 30 |
Each different combination of "Full Name" and "Lead ID" will use a single line of the file.
Keywords
campaign export file, export definitions, file export multiline , KBA , CEC-MKT-EXP , Export Definitions , How To