1

We would like to exit leads from a journey based on a event that occurs in the Sales Cloud. After a Wait event in a journey, we need to check the current value of a field on the Lead object before deciding to continue or exit. This is easy with Synchronized Data Sources. However, it is significant overkill to synchronize the whole Leads table for the few cases in which we need to check the value of the field. We cannot predict which Lead we will need, so cannot selectively synchronize.

With Marketing Cloud Connector, it is simple to create journey entry criteria based on real-time Sales Cloud data, and simple to create and update records in the Sales Cloud. But I cannot find a way to read the value of a single field in the Sales Cloud without a Synchronized Data Source. I must be overlooking something obvious?

0

This is exactly why Synchronised Data Extensions exist and unless you store sensitive information on Leads that shouldn't be seen by SFMC users, there is no downsides to synchronising your SF object(s) over.

Other options are very script heavy, typically not re-usable and prone to errors. If you want to solve this use case by using UI tools and not code, then you will need to use Synchronised Data Extensions.

  • Alternative 1: Develop a custom Journey Activity that will check the Contact upon reaching this step, retrieve the latest values from Salesforce via API by LeadID match and then exit the Contact if criteria is met.

  • Alternative 2: Set up an automation that checks for your Journey entry DE, copies over the records to a separate DE used for processing. AMPScript/SSJS script activity that checks for SF records by matching the LeadID and looks for the the latest values and writes them to the same processing Data Extension. Link this Data Extension in your Contact Builder to be able to use it for Decision Splits.

  • Thank you so much. We will look at one of those alternatives and then I'll update this thread. There is a downside for us to synchronizing. If we synchronize all the leads we might need to check, we will overrun our contracted limits. The cost to increase them is not justified by the very small percentage of records we will need to check, and we do not know ahead of time which records those will be – Arlene Jul 13 at 13:23

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.