We have a custom object in Sales/Service cloud and I have synchronized those objects in Marketing cloud using Marketing cloud connect.
Now, We want to start a journey when we create a new record in our custom record.
We have created Data Extension with exact same fields as out synchronized custom object because we cant use Synchronized data extension directly into journey builder.
I want to SQL activity to load data from Synchronized data extension to data extension but I am not sure how and where to write this.
Please let me know.
Thanks!
Best Answer
Navigate to Automation Studio > Activities and create a new SQL Query.
Create Activity
.Your query will look something like this:
You may need more to this query depending on what
WHERE
statements you need for new records. Please update/post a new question when you get there.