I am looking for a way to extract the following information programmatically:

  1. For each job ID, what is the corresponding Data Extensions that was used for sending

enter image description here

  1. For that data extension, what is the filtering conditions used to create it

enter image description here

I have tried using both Data View and Tracking Extract tables but cannot find this information stored anywhere.


For #1, you likely won't be able to programmatically pull the historic information easily as the _Sent data view only gives you the ListId for the audience and you are sending to a data extension.

But what you can do going forward is to enable Send Logging and include the _DataSourceName which will give you the data extension name:

This value captures any audience object sent to. This covers lists, data extensions, groups, and filters.

Alternatively, you can also use an UpsertDE within the email to populate your own data extension.

For #2, the only advice I have is to convert your filter to a SQL query activity, as filters can be difficult to manage.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.