Hi everyone,
I have a query activity with a column named "Feature_Name" (containing feature1, feature2, and feature as values) scheduled to run daily. This activity fetches records for users who have any of these features purchased. each feature purchased is going to be a new entry in the schema
For example, if a user has purchased only feature1 and qualifies for today's run, they receive an email. If they purchase an additional feature after receiving the email, I have another activity where I query the broadlog table and exclude those records using the primary key when they qualify for a second or third feature purchase.
I'm seeking guidance on configuring my query activity or workflow to include users who purchase feature2 or feature3 after feature1.
Currently, I'm using a query activity and enrichment activity with lines set to retrieve three features.
Please suggest
