1. Navigate to Lists > Search > Saved Searches > New
2. Click the Customer link
3. On the Criteria Tab:
Choose Formula (Text) as the filter
In the pop-up window's Formula textbox, type: {subscription}
In the Formula (Text) dropdown, choose is. Then type the exact name of the subscription category in the next text field.
4. Add another Formula (Text) as the filter on the next row
In the pop-up window's Formula textbox, type {subscriptionstatus}
In the Formula(Text) dropdown, choose is. Then type F in the next textfield.
5. Click Save & Run. This should pull up a list of Customers who unsubscribed to that particular subscription category.
No comments:
Post a Comment