Skip to Content
0

Hybris Marketing Cloud Segmentation by interaction count

Mar 27 at 08:46 AM

41

avatar image

Hi,

I am doing a segmentation using profile all contact to sort out customer for email campaign. One of our requirement is to sort out customer who have "Interaction type- Purchase" 5 times within this month.

I can already sort out who have purchase within this month using the IA type and interaction date, but how could I do the 5 purchase counting?

Thanks,

Philip

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Saurabh Kabra
Mar 27 at 11:17 AM
1

Hi,

1 Approach could be, You create a new field for storing the count in "Marketing : Interaction" context and then you implement a new BADI "Revise Interaction Data Before Import" for business context "Marketing : Interaction" via fiori app. Here in this BADI you can fill the count which then later be used in segmentation.

Note: I havent personally tested this approach but should work.

Thanks

Saurabh

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Saurabh,

I can create a new field in interaction and put a 1 in the new field through the BADI.

Problem is when using in segmentation, how could I filter the contact by "Sum" of this new field.

Thanks,

Philip

0

Hi Philip,

So this new field you will be updating with every interaction being created by increasing the count by 1. So in segmentation your custom field will always have the sum of interactions in last 30 days or so.

Thanks

Saurabh

0

Hi Saurabh,

Thank you for your suggestion. The solution you proposed may work for this case but a a bit limited. If user want to sum interaction in last 60 days, I end up need another field to do so. I am looking for a way to make a segmentation attribute like age. (e.g the database is stored the date of birth, but the system calculate the age real time when segmentation model create) Any idea how could I create a attribute like this?

Thanks,

Philip

0