Query consent service dataset

4 replies
1414 views
Translate All

How can I query the consent service dataset to retrieve opt-ins/out to subscription lists?

consent service dataset

Get Started with Datasets | Adobe Journey Optimizer

Journey Optimizer

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

SatheeskannaKAccepted solution

Adobe Champion, Community Advisor, UG Leader

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

SatheeskannaK

Accepted solution

Adobe Champion, Community Advisor, UG Leader

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

Translate

Thanks, Sathees

campaignapAuthor

Level 3

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?

Translate

SatheeskannaK

Adobe Champion, Community Advisor, UG Leader

@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.

Translate

Thanks, Sathees

Sign up

Login with SSO

Login to the community

Login with SSO