Updating multiple subscription statuses from a file
This example illustrates how to import a file containing profiles and update their subscription to several services specified in the file. After importing the file, a reconciliation needs to be carried out so that the data imported can be identified as being profiles with a link to services. To ensure that the file does not contain any duplicates, a deduplication activity will be executed on the data.
The workflow is presented as follows:
- A Load file activity loads the profile file and defines the structure of the imported columns.For this example, the file loaded is in the .csv format and contains the following data:
lastname;firstname;email;birthdate;service;operation jackman;megan;email@example.com;07/08/1975;SVC2;sub phillips;edward;firstname.lastname@example.org;09/03/1986;SVC3;unsub weaver;justin;email@example.com;11/15/1990;SVC3;sub martin;babeth;firstname.lastname@example.org;11/25/1964;SVC3;unsub reese;richard;email@example.com;02/08/1987;SVC3;sub cage;nathalie;firstname.lastname@example.org;07/03/1989;SVC3;sub xiuxiu;andrea;email@example.com;09/12/1992;SVC4;sub grimes;daryl;firstname.lastname@example.org;12/06/1979;SVC3;unsub tycoon;tyreese;email@example.com;10/08/1971;SVC2;subAs you may have noticed, the operation is specified in the file as "sub" or "unsub". The system expects a Boolean or Integer value to recognize the operation to perform: "0" to unsubscribe and "1" to subscribe. To match this requirement, a remapping of values is performed in the detail of the "operation" column.If your file already uses "0" and "1" to identify the operation, you don't need to remap those values. Only make sure that the column is processed as a Boolean or Integer in the Column definition tab.
- A Reconciliation activity identifies the data from the file as belonging to the profile dimension of the Adobe Campaign database. Through the Identification tab, the email field of the file is matched to the email field of the profile resource.In the Relations tab, a link is created with the service resource to allow the service field of the file to be recognized. In this example, the values match the name field of the service resource.
- A Deduplication based on the email field of the temporary resource (resulting from the reconciliation) identifies duplicates. It is important to eliminate duplicates since the subscription to a service will fail for all data in case of duplicates.
- A Subscription Services activity identifies the services to update as coming from the transition, through the link created in the Reconciliation activity.The Operation type is identified as coming from the operation field of the file. Only Boolean or Integer fields can be selected here. If the column of your file that contains the operation to perform does not appear in the list, make sure that you have correctly set your column format in the Load file activity, as explained earlier in this example.