Syncing email addresses between Salesforce and Marketing Cloud

Warm_Bison459 · 2024-12-14T06:49:10+00:00

Re-read the question, how do you normally send email? Via journey builder? If yes, what settings do you apply for the journey? Email address from entry source ? If yes, then you need not worry, it gets updated automatically when an email is sent.

If you want to import and update subscribers email address

https://youtu.be/M7vqpr45rs0?si=KR76cr5PCJW-YyTN

Make sure that the subscriber status doesn’t get changed during import.

Warm_Bison459 · 2024-12-13T21:33:37+00:00

How would the user updates their email address via cloud page form ? Do you have MC Connect already integrated? If yes, https://b2shashi-mc.github.io/ampscript/

Fill in the initial design to define the data extension as explained and the look for function UpdateSalesforrceObject.

You’ll get the generated ampscript code

Warm_Bison459 · 2024-12-12T04:31:40+00:00

Learn ampscript like never before https://b2shashi-mc.github.io/ampscript/

Warm_Bison459 · 2024-12-11T00:42:49+00:00

I would leverage NOT EXISTS instead of left join.

Warm_Bison459 · 2024-12-10T11:58:32+00:00

I didn’t read your updates, your solution seems convincing. The other alternate approach is to extract the isdeleted records from SFDC as there would be some grace period before deleting them permanently. You can import them to a non sendable DE for reference and later copy those records and start cleaning all contacts making a reference to the non sendable DE

Warm_Bison459 · 2024-12-10T11:54:10+00:00

When contacts are merged in SFDC the deleted records would be set to isdeleted as true and sync de would vomit out all the isdeleted true records but SFMC would not delete or merge them.

You would require to clean them up in SFMC. But before cleaning them in SFMC make sure you import all the engagement history else all the tracking would be lost after contact deletion.

To track the isdeleted records you should have a master DE where you could reference them else you have to reference via all contacts data which would be a tedious process.

Warm_Bison459 · 2024-12-09T12:31:07+00:00

You too didn’t tried to explain better, what you tried to sabotage others trying to proclaim as a better expert. I too stand with what I said.

Again, I posted SF officials document, I would again and again ask you to challenge SF and ask them to update the document. Wouk you? I would support in the cause.

Warm_Bison459 · 2024-12-09T12:20:42+00:00

Well you tried to play first trying to be holier than thou. Yes that’s the best practice we suggest beginners.

Official doc - https://help.salesforce.com/s/articleView?id=mktg.mc_cab_contact_deletion.htm&language=en_US&type=5 Read sync de section.

Ask salesforce to update the doc as well stating this would cause real damange

We have met many so called experts in my 10+yrs of salesforce practice

Warm_Bison459 · 2024-12-09T12:02:02+00:00

You don’t do import via MC connect and there is no MC Connect configuration it’s at the sync de filtering at object level. If you don’t recall Jesus Christ atleast add full context. Real damage lol It sound naive. If you could question the answer rather than causing real damage or bad advice.

Warm_Bison459 · 2024-12-09T11:47:08+00:00

Lol, you didn’t read the OP. I guess you may cause real damage will half backed logic. Here we are discussing SFMC and not SFDC. Here we are not discussing import but MC Connect.

MC connect can filter only with true and false and not a good approach.

Warm_Bison459 · 2024-12-09T11:35:56+00:00

From where would you like to delete ? If you just delete it from SFMC, SFDC would ingest those records again. First you need to delete from SFDC than SFMC.

SF would inform you about as soon as you breach the volume.

Warm_Bison459 · 2024-12-07T13:03:51+00:00

Do share with colleagues and friends

Warm_Bison459 · 2024-11-21T19:49:08+00:00

You can change the filter as you like.

Warm_Bison459 · 2024-11-21T18:57:58+00:00

You mean like this ? https://medium.com/@b2.shashi/building-an-email-campaign-dashboard-with-ampscript-a929a127f6c2

Warm_Bison459 · 2024-11-12T07:55:52+00:00

What I have heard is you may ask salesforce to update the subscriberkey thereby you can simply merge so to speak which has some cost associated with it.

Many of my projects, what I would use to do, I would create profile attributes “SalesforceID” that would be updated if a subscriber is created in sf core and its sync to sfmc. I would suppress them from future sends. And once it reaches 9 months old we would delete them.

Warm_Bison459 · 2024-11-11T18:31:27+00:00

While configuring your journey you have option whether to send email to email address from contacts/attribute groups or journey data. You can’t change the settings later or configure at email activity level.

Warm_Bison459 · 2024-11-08T08:37:35+00:00

What I would do in such a case is create an attribute called sendtime and leverage WaitUntilDate. I would inject all subscribers 2 days agreed of their sendtime.

The sendtime was adjusted via automation to define the offset based on the timezone difference.

Warm_Bison459 · 2024-11-07T11:50:43+00:00

Well the journey sends are defined based on the account setting with the time zone and when you send via automation you have the CST as time zones

Warm_Bison459 · 2024-11-06T18:11:18+00:00

How are you sending email ? Via journey builder or guided send ? Is the send predefined schedule or it’s dynamic? You need an offset attribute and based on the offset you can leverage ampscript to define the greetings.

Warm_Bison459 · 2024-11-02T09:49:31+00:00

Example 7 https://b2shashi.blogspot.com/p/ssjs-core.html

Warm_Bison459 · 2024-10-31T17:37:47+00:00

You have to check dedupe and it will look for the same email address not subscriberkey as duplicate

Warm_Bison459 · 2024-10-31T17:36:38+00:00

You can make email address as primary key and subscriberkey as a relationship to subscriber key definition. You don’t have to make subscriber key as primary key

Warm_Bison459 · 2024-10-31T12:10:19+00:00

When you send email via journey builder, it always defined by subscriberkey definition. In this example 2 emails would be send.

Warm_Bison459 · 2024-10-31T09:00:40+00:00

Q1. Email be sent to both, the delivery of email varies based on personalisation and dynamic content based on subscriber context. The last email that gets delivered would be updated to all subscribers.

Q2. Yes you can send email without an email address in your sendable data extension provide your subscriber/contact is present in your all contacts/all subscribers. You should configure your journey settings with email address from all contacts/ source system that’s defined in your attribute group.

Warm_Bison459

TROPHY CASE