how to query or export AJO subscription list | Community
Skip to main content
Level 2
May 10, 2024
Solved

how to query or export AJO subscription list

  • May 10, 2024
  • 2 replies
  • 1534 views

Hello everyone,

I'm looking for guidance on Subscription List in Adobe Journey Optimizer. Specifically, I'd like to know how to:

  1. How to Query or export the list of subscribers and un-subscribers from a subscription list.
  2. How to Import new subscriber profiles into a subscription list.

Any insights or examples on how to achieve these tasks would be greatly appreciated.

Thank you!

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

@kabeiro Take a look at this thread on how to pull subscription list data using query service. Refer to this thread for how to import profiles into a subscription list.

2 replies

SatheeskannaK
Community Advisor
SatheeskannaKCommunity AdvisorAccepted solution
Community Advisor
May 10, 2024

@kabeiro Take a look at this thread on how to pull subscription list data using query service. Refer to this thread for how to import profiles into a subscription list.

Thanks, Sathees
KabeiroAuthor
Level 2
May 10, 2024

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 exist

the subscription list I am querying do have records, and i can get the number by creating an audience targeting that subscription list.

Thanks for the Import method, it works.
And what about export certain subscription list? are these info also included in the consent export, so i have to manually process the data after export the whole consent data?


Mohan_Dugganab
Adobe Employee
Adobe Employee
May 10, 2024
For every subscription list, OOTB/System generated segment is created for it. You can export that segment.
OR
Query the profile snapshot dataset to specifically look for the below path
 

 

"marketing": { "email": { "reason": "<reason>", "subscriptions": { "DemoSubscriptionList": { "val": "y", "type": "yes", "subscribers": { "test@test.com": { "source": "source-test", "time": "{{$isoTimestamp}}" } } } }, "time": "{{$isoTimestamp}}", "val": "y" }, "preferred": "email" }

 

 
For imports, you can create a streaming http api pointing to the consent dataset and have the corresponding records imported. https://experienceleague.adobe.com/en/docs/platform-learn/tutorials/sources/streaming-ingestion-http-api