Reconcile a File audience with the database

This example shows how to use the Read audience activity to reconcile an audience directly created from a file import.

When performing a file import, you can directly save its content in an audience. This audience is a File audience and its data is not linked to any database resources.

The import workflow is designed as follows:

  • A Load file activity uploads a file containing profiles data that were extracted from an external tool.

    For example:

    lastname;firstname;birthdate;email;crmID
Smith;Hayden;23/05/1989;hayden.smith@example.com;124365
Mars;Daniel;17/11/1987;dannymars@example.com;123545
Smith;Clara;08/02/1989;hayden.smith@example.com;124567
Durance;Allison;15/12/1978;allison.durance@example.com;120987
Lucassen;Jody;28/03/1988;jody.lucassen@example.com;127634
Binder;Tom;19/01/1982;tombinder@example.com;128653
Binder;Tommy;19/01/1915;tombinder@example.com;134576
Connor;Jade;10/10/1979;connor.jade@example.com;132452
Mack;Clarke;02/03/1985;clarke.mack@example.com;149876
Ross;Timothy;04/07/1986;timross@example.com;157643

  • A Save audience activity saves the incoming data as an audience. As the data has not been reconciled yet, the audience is a File audience and its data is not recognized as profile data yet.

The reconciliation workflow is designed as follows:

  • A Read audience activity uploads the File audience created in the import workflow. The audience data is not yet reconciled with the Adobe Campaign database.
  • A Reconciliation activity identifies the incoming data as profiles through its Identification tab. For example by using the email field as reconciliation criteria.
  • An Update data activity inserts and updates the profiles resource of the database with the incoming data. As the data is already identified as profiles, you can select the Directly using the targeting dimension option and select Profiles in the Identification tab of the activity. Then, you simply have to add the list of fields that need to be updated in the according tab.

On this page