Reconcile a File audience with the database example--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:
code language-none 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 ÃÛ¶¹ÊÓƵ 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.