how to query or export AJO subscription list

[Kabeiro]

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!

[SatheeskannaK · Accepted solution]

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

[Kabeiro]

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?

[Kabeiro]

oh thanks there was a typo in the sql
should 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 a default method to export the list? trying to see if there is a out-of-box/non-tech friendly way.

[dugganab]

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