1

Is there a way to create a data extension using a filter which filters against the Profile Attributes in the All Subscribers List.

I know I can create groups filtering the All Subs List and I can create Data Ext filtering other Data Ext but I haven't seen away to create a Data Ext filtering the Profile Attributes in the All Subs list.

SELECT 
SS.EmailAddress,
SS.[Order Submitted Date],
SS.[First order for this Contact],
SS.[Active PG Member],
SS.[LL Kit],
SS.[LL Fed],
SS.[LL State] 

FROM _Subscribers SS 

WHERE SS.Domain = 'YAHOO.COM'
Improve this question

1 Answer 1

Reset to default
1

You can create a data extension and use an SQL query activity to populate it based on the criteria that you're looking for.

https://help.salesforce.com/articleView?id=mc_es_best_practices_data_extensions_query_activities.htm&type=5

Improve this answer
3
  • I'm trying to go after profile attributes which we have created and so far I have been unable to query or retrieve any data using user added attributes. Last attempt I tried putting brackets around the attributes but it just tells me the columns are invalid. SELECT SS.EmailAddress ,SS.[Order Submitted Date] ,SS.[First order for this Contact] ,SS.[Active PG Member] ,SS.[LL Kit] ,SS.[LL Fed] ,SS.[LL State] FROM _Subscribers SS WHERE SS.Domain = 'YAHOO.COM'
    – Lenny
    Jan 25, 2018 at 20:55
  • Can you add your full query to the post?
    – Tom Callahan
    Jan 25, 2018 at 21:04
  • Are the attributes like First order for this contact living on the All Subscribers table?
    – Tom Callahan
    Mar 19, 2018 at 14:05

You must log in to answer this question.

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