Query activity & Enrichment activity | Community
Skip to main content
Level 5
February 12, 2024
Question

Query activity & Enrichment activity

  • February 12, 2024
  • 0 replies
  • 420 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.