SFMC TIP | How to Link Journey to Delivery

Marketing Automation, Salesforce Marketing Cloud, SFMC Tips & Tricks
1 minute read#data views #SQL

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.

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

SFMC TIP | Data views for transactional emails

1 minute read#data views #SQL

Data views in Salesforce Marketing Cloud are very handy, when it comes to getting data insights from various sources inside the platform. I will give you a quick start on how to get data insights for you transactional emails using data views. We will use data from _Sent, _Job, and _Subscriber view s.TriggererSendDefinitionObjectID – object […]

Continue reading
Link campaign to the delivery send in salesforce marketing cloud
Salesforce Marketing Cloud

SFMC | Link campaign to delivery send

3 minutes read#data views #programming #SQL #ssjs

Are you aware of Salesforce Marketing Cloud’s additional marketing feature known as Campaign? This tool allows you to group similar journeys together, providing greater organization for your marketing activities. However, one drawback is that the campaign information is not available in the data views. While waiting for a fix from Salesforce, you can establish a […]

Continue reading