3033868 - Campaign Export File Has Duplicated Contacts

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.

SAP Marketing Cloud

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.

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.

campaign export file, export definitions, file export multiline , KBA , CEC-MKT-EXP , Export Definitions , How To

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions