How to filter out users based on their purchased features? | Community
Skip to main content
Level 5
February 26, 2024
Question

How to filter out users based on their purchased features?

  • February 26, 2024
  • 1 reply
  • 445 views

Hi there, 

please can someone address this on excluding the users based upon feature purchased

 

Within the feature schema, users can acquire up to three features, leading to the following scenarios:

  1. If a user purchases only one feature, they will receive an email containing that specific feature. This dynamic content personalization involves checking the feature name within an if condition to render the email accordingly.

  2. If a user purchases two features, they will receive an email with both features included, again based on the if condition check.

  3. If a user acquires all three features, they will receive an email reflecting all three features.

The goal is to address the following scenario: If a user buys one feature initially and then acquires another feature later, they should not receive the first feature again in subsequent emails, but only the new feature.

To achieve this, I am focusing on broadlogs that do not contain the feature IDs. My workflow involves the following steps:

 

  1. In the exclusion process, I attempt to pass the feature ID from the recipient table, which contains all the features the user has purchased. However, in this setup, my condition does not seem to function as intended.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

OscarGo
Level 3
June 25, 2024

Hi @rvnth 

Have you tried using Group By recipientID with a Count(features) column? With that in place you will only need a Split activity to check if Count(features) > 1, etc.