I would like to load data from a CSV (list of customers to be targeted in a delivery or activity in Campaign), map this list into the Adobe Campaign Recipients dimension. The CSV contains a field for reconciliation (customerID) which is identical to a field in our Recipient-dimension.
I have started with a data loading (file) activity in the workflow - and I am able to load the data from the CSV. The output from this activity belongs to a on-the-fly dimension temp:fileImport obviously generated by the import-Activity wizard. How do I proceed to pick Recipients in my Campaign database, based on the data in the import data?
I'm a campaign noob, so I am not very experienced with data imports, reconciliation acitivies or data dimensions, so I'll need detailed information to succeed.
You can simply connect the import activity to an update activity.
To configure the update settings open the activity by clicking on it:
Specify the operation (insert/update/delete, etc): in this case "insert or update" as we want to insert new records or update in case the data already exists in the destination table.
Select the table to insert the imported data into (recipients in this example)
Select 'Unsing reconciliation keys' as Recrod Identification method and define the reconciliation key(s). (keys for finding records) (email address in this example: "email" field from the recipient table to "EmailAddress" field of import file)
Then map the fields from your import file to the fields of the destination table under "fields to update":
So Campaign now tries to find an exising record based upon email-address (in this example) and updates the record when it finds one, otherwise inserts a new record.