Highlighted

Query Regarding Offer Management

ketangp28686788

22-01-2018

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.

Replies

Highlighted

florentlb

02-02-2018

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