1

I have a question about the unsusbcribe in the all subscriber. When my customer decided to optout in the website of my client, the information of this unsubscribe goes up in service cloud, then in the data synchronised account of the BU and finish in my master DE. But the information does not go up in the all subscriber , the status of my customer stay "active".

So the customer is optin in the all sub but he is optout in the master DE and i would like to change this status to active from unsubscribe in the all sub.

How can I link my master DE with the all subscriber to update the all subscriber when a customer change is optin or optout? I need to do that for the four BU.

I did a test with my account, I am optout in the master DE and optin in the all sub, i tried this sql :

Select 
a.SubscriberKey as subkeyMAL,
a.PersonEmail,
'Unsubscribed' as Status,
a.DateLastNewsletterOptin__c,
a.DateLastNewsletterOptout__C,
a.NewsletterOptIn__c,
buUnsub.BusinessUnitID,
buUnsub.SubscriberID,
buUnsub.SubscriberKey,
buUnsub.UnsubDateUTC,
buUnsub.UnsubReason
FROM Master_DE a
LEFT JOIN ent._BusinessUnitUnsubscribes AS buUnsub  ON buUnsub.SubscriberKey = a.SubscriberKey
WHERE
buUnsub.BusinessUnitID = 'XXXX' 
and a.NewsletterOptIn__c = '0'
and and buUnsub.UnsubDateUTC is null

I have as a result 0 records therefor I'm optout in the master DE, so "newsletteroptin = 0" , but optin (active) in the all sub.

Do you have an idea to help me to solve this problem ?

Thanks

1 Answer 1

1

You'll need to do a Data Extract of the master data extension, File Transfer from the safehouse to the SFMC sFTP, and Import it in to All Subscribers. Put this all in an automation in Automation Studio and run it nightly.

You should only need these fields:

  • SubscriberKey
  • Email Address
  • Status of 'Unsubscribed'
6
  • Ok, thanks you for you answer , but how can i find customerss that i need to change their statu ? How can i find all of customers who are optout in the master DE but optin in the all sub ? My sql doesn't works , if you have an other idea .. Commented Sep 7, 2022 at 9:56
  • You'll have to query against the _Subscriber data view (help.salesforce.com/s/…) to get their current status. Then compare it with your Master_DE. Similar select statement that you have above but with left join _Subscribers s on a.SubscriberKey = s.SubscriberKey where s.Status = 'unsubscribed' Commented Sep 7, 2022 at 17:42
  • Hi , thanks for your answer. The information that I have in the all sub of each BU is different of the information that I have in the parent BU. Indeed we have a preference center for each BU and this preference update only the information in the child BU. So I can't use the data view Subscriber because their information comes from the parent BU. Yes my issue is verry complicated ... Commented Sep 8, 2022 at 7:40
  • Use the _Unsubscribe Dataview (help.salesforce.com/s/…) and the OYBAccountID field should give you the child BU MID Commented Sep 8, 2022 at 16:50
  • Hi , yes , but I need to get the clientes who have an "active" statu , who are optin in the all sub ... I don't have the information in the Unsub data view .. Commented Sep 12, 2022 at 7:50

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .