0

I have a Data extention containig a list of Subscribers with their email and subscriber key. I want to update the records in the Data extention to the All Subscribers list from the Data Extention on a regular frequency automatically.

Also, I'm using version 2.0 of Marketing cloud org and need to update the subscriber status from only the specified business unit where the Data extention is present.

How can we achieve this?

0

This can be accomplished by doing the following process:

  1. Data Extract of your Data Extension
  2. File Transfer to move this file output from Safehouse to SFMC SFTP
  3. Import Activity of that file output into All Subscribers list.

During this, keep in mind that statuses such as 'held' and 'bounce' will not be added in via this method, they are only editable internally by SFMC and cannot be changed in All Subscribers by users. I would recommend having it only be 'Active' and 'Unsubscribed'.

Another Caveat is that All Subscribers is usually shared at an enterprise level (unless you have the correct settings in place) so you might want to review this doc for more information on this.

Putting the above activities into an automation will allow you to schedule it to be run repeatedly.

4
  • thanks for your feedback. I'm following the same approach but the only thing which is not working here is the last step "Import Activity of that file output into All Subscribers list.". I have done all the correct configurations as per the documentation and also, when I download the file created from File transfer from FTP, the file format is also correct , ie, .csv file with the all the headers as well. But when we run the automation all the steps runs successfully but the last step does not update the "All Subscribers" list in the Child BU. Nov 23 '20 at 18:08
  • @JiteshGoel - Does not update them how? Nov 23 '20 at 18:18
  • the .csv file is correctly created on the FTP import folder. but when the Automation is complete the update on the All Subscribers list does not happen with updating the Status of the Subscriber to "Unsubscribed" or "Unsubscribe"'(tried both values.)(I hope this you were refering to this in the above comment) Nov 23 '20 at 18:31
  • If you are following the guidelines here (help.salesforce.com/…) then I would look at the rules/settings you have assigned to your BUs/Enterprise account to see if perhaps that is causing the discrepancy. Nov 23 '20 at 20:00
0

You can do this in a Script Activity if the volumes of rows are reasonable.

I've set up a few unsub-resub scripts that update All Subscribers with instructions from a Data Extension that's updated on an interval.

1
  • thanks for your feedback. Sems to be a good option but haven't implemented such kind of process in the past. Please can you share a reference doc or any refence screenshopt or anything which I can refer and implement it on our end. Nov 23 '20 at 17:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.