[SalesForce] Will Synchronized Data Extension also sync data from SFMC to Sales Cloud

Does Synchronize Data Extension also sync data from SFMC to Sales Cloud or is it just one-way? If yes, can we update Synchronized DE using query?

Best Answer

Only certain data points from SFMC get sent back to Sales Cloud. It's not a two-way sync of data.

Subscriber status, unsubscribes for SF sends and mapped profile attribute values are the only data points will update SF objects (aside from tracking data).

Here's an overview of the architecture.

Related Solutions

[SalesForce] How to send subscriber behavioral data back from SFMC to object in Sales Cloud

Unless I'm misunderstanding the question Tracking and Analytics are returned to Service Cloud by the Connector.

http://help.marketingcloud.com/en/documentation/integrated_products__crm_and_web_analytic_solutions/marketing_cloud_connector_v5/tracking/

[SalesForce] Create a data extension from a Synchronized Contact Data Extension

Having the use case would help for long term viability of the solution. But, assuming that you're going to make a one time copy of the original DE (or copy and overwrite in the future), and also assuming that all of your field names are exactly the same...

Create a SQL Query:

select * from DE1

Within the SQL settings, select the new data extension as the target, and choose to overwrite.

If you have re-labeled any fields in the new data extension, then you'll have to update the query to something like:

select Id, FirstName, email as 'email address', LastName from DE1

Note that, in the example above, 'email' is the field label in DE1 while 'email address' is the corresponding field label in DE2.

Life is made easier by keeping the field labels the same.

Best Answer

Related Solutions

[SalesForce] How to send subscriber behavioral data back from SFMC to object in Sales Cloud

[SalesForce] Create a data extension from a Synchronized Contact Data Extension

Related Topic