1

I need to create a automation that extracts and drops a entire list onto the FTP each day.

My issue is that the data lies within a list.

Is it possible to create a query that populates a data extension with the contents of a list?

If this isn't possible are there other options?

Thanks everyone

2 Answers 2

8

Tony is correct. Just to add to this, for Enterprise 2.0 accounts (which current editions fall under) you can access the _EnterpriseAttribute data view to return the custom profile attributes for the subscribers on the list:

Data View: EnterpriseAttribute

Sample usage would be along these lines:

SELECT
  l.SubscriberKey,
  l.Status,
  e.MyProfileAttribute1,
  e.MyProfileAttribute2
FROM
  _ListSubscribers l WITH (NOLOCK) INNER JOIN
  _EnterpriseAttribute e WITH (NOLOCK)
    ON  l.SubscriberID = e._SubscriberID
WHERE
  l.ListID = 123456
2
  • Thanks Andrew! So "e.MyProfileAttribute1" would just be whatever the name of the fields under "Profile Management" for lists are? Feb 10, 2017 at 2:51
  • Yes. There's no abstraction or obfuscation. "MyProfileAttribute1" is just the name of the profile attribute - exactly as you see it in the UI.
    – Macca
    Feb 10, 2017 at 4:36
5

You can query a list, but only the default/out of the box fields, noted below:

Data View: ListSubscribers

Any additional/custom fields within a list would not be returned and/or your query would fail when referencing list field names that are not noted within the help documentation linked above.

In that case, the extract and import based automation you originally noted is the alternative. This documentation will help guide you to make the most appropriate selections for your data extract (tracking extract type) needs:

Using Tracking Extracts

3
  • Thanks Tony! I'd need the custom fields as well. Forgive what may be a silly question but to setup a "tracking extract" does a send have to occur to this list or if I just tick "Include All List Members" will it include all lists in this Business Unit? Feb 9, 2017 at 5:13
  • My pleasure! You've got it exactly right - if you check that box it would then include all records, even those not sent to in the period specified. It would also include all lists (sent to or not) but if you check "Extract Lists" you should be able to filter the output by the ListID or Name columns. help.marketingcloud.com/en/documentation/exacttarget/… Feb 9, 2017 at 5:22
  • Okay excellent. Thanks again Tony. That's working perfectly now. Feb 9, 2017 at 23:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .