Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks

SFMC TIP | How to Link Journey to Delivery

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

Adobe Campaign post
Adobe Campaign, Marketing Automation

ACC | Track dynamic links

3 minutes read

Some email campaign send outs can have links dynamically rendered in the content. Such links are not visible by Adobe Campaign personalization engine and thus will not be tracked. The good thing is that we can use a workaround to make dynamic links trackable and also on top of all workarounds Adobe itself has provided … Read more

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

SFMC TIP | HTTP post content type encoding

1 minute read

Recently, while working with the double opt-in process that employs an API to trigger messages, I encountered an issue where Latin characters were not captured correctly in the triggered send data extension. I have found that the SFMC HTTPPost uses, by default, WindowsCodePage 1252 encoding, which can cause issues with accented characters such as ž, … Read more

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

SMFC TIP | NULL value comparison in IF statement

less than a minute read

If you have field in DE that its value is not always populated for a particular row (customer) and you test field value against any value cloud page will throw an 500 – internal server error. To fix this you will need to add another AND-condition to test field value for NULL

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

ACC TIP | How To Convert Base64 to PDF attachment

1 minute read

In this article, I will provide a simple trick for converting Base64 encoded data to PDF using JSAPI in Adobe Campaign Classic. Due to AC’s inability to attach Base64-encoded files directly to emails, this method can prove to be highly useful. Base64 data format that would be easy to use when supperted by Adobe Campaign … Read more

Continue reading
Adobe Campaign post
Adobe Campaign, Marketing Automation

ACC | Add action button to the form view

2 minutes read

Have you ever wondered how to add new button with custom functionality to form view. I will show you step by step how to do it. In my example I will create signatures used in email campaigns, which will be dependent on the recipient’s profile information such as language, country etc. The way how I … Read more

Continue reading