Expand my Community achievements bar.

Adobe Campaign User Groups are live now. Join our Adobe Campaign User Groups and connect with your local leaders!

Query activity & Enrichment activity

Avatar

Level 5

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies