Activity Forums Salesforce® Discussions Can a Query Activity update a Data Extension in real time?

  • madhulika shah

    July 19, 2018 at 9:41 am

    Hi Chanchal,

    Yes, a query activity can update the data extension in real time. You would need to:

    1. Create a new data extension containing a subscriber/recipient field as the Primary Key and also add boolean fields for link1, link2, link3, etc.
    2. Create a Query Activity to update the Data Extension you created from Step 1 so that it updates the boolean fields in the DE for each recipient.
    3. Create a one-to-one cardinal relationship to the data extension you created in step 1 in Contact Builder, mapping the recipient identifer back to the Contact Key of the Contact Record.
    4. Now you can use Split conditions from journey builder to update the data extension.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos