Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

How to Link Journey to Delivery in SFMC

SFMC tips and tricks

In Salesforce Marketing Cloud, you can link the customer journey to delivery using data views. Custom views that contain e.g. all tracking information. Here are some steps you can follow to link the journey to delivery using data views:

  1. Identify the tables: The first step is to identify the tables that contain the data you need. In this case, you will need the journey data from the Journey Builder and the delivery data from the Tracking Extract.
  2. Create a SQL: Create a SQL that combines the data from data views. You can use SQL code to join the tables and select the fields you need. For example, you can use the following SQL code as a starter:
SELECT 
  j.SubscriberKey, 
  j.EventDate, 
  j.JourneyName, 
  j.ActivityName, 
  d.TriggeredSendDefinitionName, 
  d.TriggeredSendExternalKey, 
  d.DeliveredTime, 
  d.OpenedTime, 
  d.ClickedTime 
FROM 
  _JourneyActivity AS j 
  INNER JOIN _Sent AS s 
    ON j.JourneyActivityObjectID = s.TriggeredSendCustomerKey 
  INNER JOIN _Job AS j2 
    ON s.JobID = j2.JobID 
  INNER JOIN _TrackingExtract AS d 
    ON j.SubscriberKey = d.SubscriberKey 
WHERE 
  j.JourneyName = 'Journey Name' 
  AND j.ActivityName = 'Activity Name' 
  AND j2.EmailName = 'Email Name' 

This SQL view will return data such as the subscriber key, event date, journey and activity names, triggered send name and external key, and delivery, open, and click times.

  1. Where to use this : Once you have created the SQL you are happy with, you can use it in reports and dashboards to analyze the customer journey and delivery data together. You can use it to create custom audiences and send targeted emails based on the journey and delivery data.

Linking the journey to delivery data using SQL views in Salesforce Marketing Cloud can provide valuable insights into your customer’s behavior and help you optimize your email campaigns for better engagement and conversions.

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

#data views #SQL
Marcel Szimonisz
Marcel Szimonisz
MarTech consultant As a marketing automation consultant, I specialize in solving problems, automating processes, and driving innovation in my clients' marketing platforms.

I hold certifications in Adobe Campaign v6 (3x certified) and Salesforce Marketing Cloud (5x certified).

Additionally, I serve as a community advisor for Adobe Campaign, offering expert insights and guidance.

In addition to my professional pursuits, I also enjoy exploring various programming languages, CMSs, and frameworks, further enhancing my technical expertise and staying at the forefront of industry advancements.
Take a look at our subscription offering in case you are looking for a Marketing Automation Consultant.

Leave a comment

Your email address will not be published. Required fields are marked *

Similar posts that you may find useful

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

The Top 5 Stress-Busting Tips I have Learnt

3 minutes read

Working with any marketing automation platform, especially Salesforce Marketing Cloud, can provide a great user experience and a sense of accomplishment. However, it can also entail many stressful hours dedicated to solving seemingly easy issues. Here are my top 5 tips that made my daily work less stressed and saved me lots of cursing this […]

Continue reading
Salesforce Marketing Cloud Tips
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

How to bulk change data extension fields

less than a minute read

As a Salesforce Marketing Cloud admin, you will learn that certain operations on data extensions are better handled via Email Studio, while others are more suited for Contact Builder. Today, I will explain when to use each method for adding or changing fields in a data extension. My preferred way to add or change fields […]

Continue reading
Salesforce Marketing Cloud vs Adobe Campaign
Adobe Campaign, Marketing Automation, Salesforce Marketing Cloud

Salesforce Marketing Cloud vs Adobe Campaign

1 minute read

Both Salesforce Marketing Cloud and Adobe Campaign Classic are powerful marketing automation platforms that offer a wide range of features to help businesses manage their marketing campaigns. The choice between these two tools ultimately depends on your specific business needs and preferences. Here are some factors to consider when deciding between Salesforce Marketing Cloud and […]

Continue reading
SFMC tips and tricks
Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

Redirect 500 internal server error inside try catch SSJS block

1 minute read

If you have Redirect function inside the try catch block, either as mixture of SSJS with AMPScript or only in SSJS, it will throw an 500 – Internal Server Error. Let’s take a look on few examples what can create an error that will take you some quality debugging time to figure it out. And […]

Continue reading
Adobe campaign tips and tricks
ACC Tips & Tricks, Adobe Campaign, Marketing Automation

Escalate any user rights to admin

1 minute read

Normally web apps run under the web app user (which is anonymous and has very little to zero rights by default) and for certain operations you would need to require to grant additional access, or even grant full admin. To grant full admin for web app user is not solution to go with. Instead I […]

Continue reading