Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Query Regarding Offer Management

ketangp28686788
Level 4
Level 4

Hi Team,

I want to configure a eligibility condition in one of the offer, I have to do some aggregation inside the eligibility tab of offer.

Objective :

Consider I have customer & transaction schema, I want to make this offer available for people who have done 3 orders consecutively in past 10 days

So I want to group by on customer id & count of order id is 3 in last 10 days.

So how do I configure this with the raw transactions without using workflows inside the offer tab only.

Thanks.

2 Replies
florentlb
Level 10
Level 10

Hi,

I've confirmed with engineering that this case is too advanced to serve with the filtering option available in the eligibility conditions of an offer. You'd have to use a workflow query to be able to do that, with a condition link on your transactions where you filter on the last 10 days, and then add an output filtering with count > 2.

Unfortunately it seems that one can't be done directly from the offer eligibility rules.

Florent