Get all Emails used in Journey Builder in Salesforce Marketing Cloud
Cameron Robert steps through a SQL query that can be used to return a list of all emails that have been used in Journey Builder. This is a useful way to get a complete list of all emails that are currently being sent as part of your journeys.
Key Moments:
0:00 - Introduction
0:12 - Journey & Journey Activity Data Views
1:18 - Create a target Data Extension
3:00 - SQL to get all Emails in Journey Builder
11:48 - Use DISTINCT to DeDuplicate the results
12:27 - Checking the results
13:19 - Summary
📄 SFMC Data Views: https://dbdiagram.io/d/5ff259ed80d742...
📄 Get Journey Emails SQL Code: https://github.com/camrobert/Salesfor...
Contact:
/ camrobert
https://www.cameronrobert.com.au/
/ auscamrobert
Music: https://www.bensound.com