RE: How to retrieve contacts in a scheduled Customer Journey

As per this attached diagram, there are 2 marketing segments (1 static and 1 dynamic), 3 marketing emails and 3 customers journeys.
Now, CustomerJourney1 has started on Feb 15, 2020 and CustomerJourney2, CustomerJourney3 are scheduled to start on Mar 15 and Apr 01 respectively.
Now, for CustomerJourney1 (since it has been executed), I can go and find the insights at a contact level from the interactions data stored in the blob storage https://docs.microsoft.com/en-us/dynamics365/marketing/custom-analytics. Using this data, I can know which contact belonged to which custmer journey, which marketing email was sent to which contact, etc.
But for CustomerJourney2 and CustomerJourney3, how do I know which segments belong to each customer journey (and therefore which contacts) and which marketing email is scheduled to send to which contacts.
i.e. I want to get the information like below table:
scheduled start, marketing email, marketing segment, contact, emailsent, emaildelivered, emailopened, emailclicked
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail1 |
MarketingSegment1 |
contact1 |
Feb 15, 2020 |
Feb 15, 2020 |
Feb 16, 2020 |
Feb 16, 2020 |
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail1 |
MarketingSegment1 |
contact2 |
Feb 15, 2020 |
Feb 15, 2020 |
Feb 15, 2020 |
|
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail1 |
MarketingSegment1 |
contact3 |
Feb 15, 2020 |
Feb 15, 2020 |
|
|
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail1 |
MarketingSegment1 |
contact4 |
Feb 15, 2020 |
Feb 15, 2020 |
Feb 19, 2020 |
Feb 19, 2020 |
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact1 |
Feb 15, 2020 |
Feb 15, 2020 |
|
|
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact3 |
Feb 15, 2020 |
Feb 15, 2020 |
|
|
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact5 |
Feb 15, 2020 |
Feb 15, 2020 |
|
|
CustomerJourney1 |
Feb 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact9 |
Feb 15, 2020 |
Feb 15, 2020 |
Feb 15, 2020 |
Feb 15, 2020 |
|
|
|
|
|
|
|
|
|
CustomerJourney2 |
Mar 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact1 |
|
|
|
|
CustomerJourney2 |
Mar 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact3 |
|
|
|
|
CustomerJourney2 |
Mar 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact5 |
|
|
|
|
CustomerJourney2 |
Mar 15, 2020 |
MarketingEmail2 |
MarketingSegment2 |
contact9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment1 |
contact1 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment1 |
contact2 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment1 |
contact3 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment1 |
contact4 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment2 |
contact1 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment2 |
contact3 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment2 |
contact5 |
|
|
|
|
CustomerJourney3 |
Apr 1, 2020 |
MarketingEmail3 |
MarketingSegment2 |
contact9 |
|
|
|
|
For the highlighted first 8 rows, since the customer journey has already been executed, I'm able to get the data from the marketing interactions data in blob storage.
How do I get the information for the CustomerJourney2 and CustomerJourney3 in this format.
Thanks,
Avinash Sonee