I am trying to update a filtered group, which is filtered on "All Subscribers". I want to exclude subscribers with status "Unsubscribed" from All Subscribers which cant be selected in the filter, when creating the group.

The goal is to have a filtered group with subscribers that is "Active"

Any ideas of how to achieve this?

As far as i know, it can be done by creating a measure, but i am not sure how to do this.

  • Is this a Marketing Cloud question? You might add some relevant tags or description to clarify - it's pretty opaque to non-MC Salesforce users like me. – David Reed May 1 '18 at 13:53
  • Yes this is a Marketing Cloud Question. Is this the wrong forum? – M-vad May 1 '18 at 13:57
  • Not at all! Just not everyone here knows or can immediately recognize MC content, so tagging can help attract the users who do have that expertise and let the rest of us know what's up. – David Reed May 1 '18 at 13:58

Your best bet is to write a SQL query on the _Subscriber data view or you can use _ListSubscribers using the ListID in a WHERE clause.

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.