0

I have a Journey that from time to time will receive some Contacts. One day will receive 2,000 contacts, two weeks after can receive other 2,000 contacts (the time and number of contacts can vary).

The Journey has a duration of a month and a half. I need to analyze, make report and check the success (opening, bounced back...) in each group of contacts inserted and not all the journey and all contacts in it. How can I do it?

1 Answer 1

4

You can use data views to get the click, open, bounce,.. data based on EventDate and TriggeredSendCustomerKey fields.

Example: get subscribers who opened the email with TriggeredSendCustomerKey= 'XXXXX' on '2019-10-10'

SELECT 
  s.SubscriberKey,
  s.EventDate AS Sent_Date
FROM _Sent s
INNER JOIN _Open o ON s.SubscriberKey = o.SubscriberKey
WHERE 
CAST(o.EventDate AS DATE) = CAST('2019-10-10' AS DATE) 
AND s.TriggeredSendCustomerKey = 'XXXXX'

You can use the JourneyActivity and Journey data views to get data related to a specific journey instead of a specific email.

2
  • 2
    I agree. It's better to key off of the TriggeredSendCustomerKey in the _Sent data view since the JobIds change every time you make a new version or change any journey email definitions. The TriggeredSend Definitions are republished in both cases, which means new JobIds. Jun 4, 2019 at 14:07
  • Thanks, I've updated my answer accordingly Jun 4, 2019 at 14:30