How To Import Contact Point Consent Records

*** NOTE: ALL INFORMATION IS ACCURATE AT DATE OF PUBLISHING ***

One of the most important things when it comes to Realtime Marketing in Customer Insights – Journeys is knowing that Contact Point Consent (CPC) records are what keep you compliant, making sure you aren’t emailing people who have already unsubscribed. If you have only ever used the marketing app in D365 for this, then you are likely OK as anyone who has clicked on your Unsubscribe link at the bottom of any emails will have then had a CPC record either created or updated. What if you’re moving from another platform that already has a list of people on a suppression list who’ve previously unsubscribed? This post is for you as it will walk through how to import contact point consent records as data from your suppression list and get those CPC records added to Realtime.

The first thing that is important is determining which Compliance profile you are linking this to. I would suggest that you create a CPC record for the main Commercial Purpose and a CPC record for each Topic you’ve got linked to the Commercial Purpose. You need to make sure that Purpose has a unique name as it will be used during the import to make sure the new records are linked correctly. Even if you only have one Compliance profile, it’s possible you have an inactive one that might already have a Purpose with the same name. So for mine, I have renamed the Commercial one to Main Commercial. If you have more than one named Commercial, your import will fail.

Next you need to create your import file as a CSV document. Ideally you can export all email addresses from your previous system as that is all you would need from there, everything else will be new columns you will need to add.

• Channel – this should either be Text Message or Email and worded exactly in that way
• Contact point – this is the email address or phone number you want to update for
• Consent type – either Purpose or Topic. If uploading Topics, this should be set to Topic, otherwise Purpose
• Purpose – the exact name of the Purpose record you wish to link the CPC records to
• Topic – this column can be left out if you are only uploading Purposes, otherwise if the Consent type is Topic, make sure this is the exact name of the Topic you wish to link the CPC records to
• Consent status – if you are uploading a suppression list, this should be Opted Out, otherwise Opted In (as per your needs)
• Reason – this is actually an option set (choice) field. You can pick one of the options from the list, but for me, No reasons works. You can always use one of the Opted Out ones, but again, the wording must match exactly to the Choice field options rather than trying to add one of your own
• Source – this needs to be Internal
• Who requested the change – you can add whatever you like here, but this can be used to add your own text to show that it was created as part of a suppression import if you wish

When we do the import, we will be creating a record for each row of the CSV file but ONLY if the email doesn’t already exist on a CPC record. If it does, the row will fail and you will need to find the existing CPC record and manually change it to Opted Out (or Opted In).

From the top of the Consent centre area, click on the arrow next to Import from Excel and then click Import from CSV. Note that if you see three dots with a menu, you might need to click on that in order to see the Import option.

Now browse out to your file and select it to upload.

You can skip past the next screen.

The last screen shows all of the mapping. You shouldn’t need to do anything if you have named the column headers the same as mine as it will select the correct column for you. However, if needed, you can go through and map to make sure you are adding the right values to the right fields. Once happy, click to continue and start the import. You will then have an option from the bottom of the side panel to track the progress.

From there you can see when the status is completed.

Any errors will be shown in the failures tab which should then give more information as to why those rows failed.

You should then see your successfully imported records in the Consent centre. Once you’ve done it for your Purpose, you can then do it again for each Topic, making sure to adjust or use a new CSV file with the correct Consent type in the file.

---

This is just 1 of 475 articles. You can browse through all of them by going to the main blog page, or navigate through different categories to find more content you are interested in. You can also subscribe and get new blog posts emailed to you directly.

---