Query consent service dataset | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SatheeskannaK

Hi @campaignap,

 

You can start with the below query and build it up to your needs. Below looks for profiles part of the given subscription list.

select
*
from cjm_email_tracking_experience_event_dataset
where _experience.customerJourneyManagement.messageInteraction.subscription.subscriptionListID = '<<SubscriptionName>>'

 

Refer to this documentation for more information: https://experienceleague.adobe.com/tools/ajo-schemas/schema-dictionary.html?lang=en

1 reply

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
June 30, 2023

Hi @campaignap,

 

You can start with the below query and build it up to your needs. Below looks for profiles part of the given subscription list.

select
*
from cjm_email_tracking_experience_event_dataset
where _experience.customerJourneyManagement.messageInteraction.subscription.subscriptionListID = '<<SubscriptionName>>'

 

Refer to this documentation for more information: https://experienceleague.adobe.com/tools/ajo-schemas/schema-dictionary.html?lang=en

Thanks, Sathees
    campaignap
    campaignapAuthor
    Level 3
    June 30, 2023

    Thanks for reply @satheeskannak.

     

    When I run the query, an error is returned:

    '"cjm_email_tracking_experience_event_dataset" does not exist'.

     

    Do you know why this could be?

    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    July 1, 2023

    @campaignap, I ran the query on another instance where we don't have a lot of profiles and don't have events generated. I got the same error. Looks like you don't have any experience events generated on the profiles that already exist. Try creating a subscription list and subscribe yourself then run the query to see if it returns results.

    Thanks, Sathees
    Terms & ConditionsAccessibility statement

    Loading footer...