SAP Knowledge Base Article - Public

3033868 - Campaign Export File Has Duplicated Contacts

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

Product

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