oh thanks there was a typo in the sqlshould be: select * from ajo_email_tracking_experience_event_dataset where _experience.customerJourneyManagement.messageInteraction.subscription.subscriptionListID = 'Adviser_Unsubscription_List'​ Thanks, I can work from here to get the data i needed.but is there...

Hey @SatheeskannaK Thanks for your reply, I had look of that thread eairer, and having the same issue:Relation "cjm_email_tracking_experience_event_dataset" does not existthe subscription list I am querying do have records, and i can get the number by creating an audience targeting that subscription...

the provided solution is for Classic not for standard. but can use enrichment, segment, test 3 steps to create a similar date checking process.

Hey Craig,Thanks for your reply I saw that one, but that is for AC Classic right? 

Thanks I've found another way to make the lp works.

Thanks, found it, it's "id of primary instance of delivery"