Hybris Marketing Cloud Segmentation by interaction count

[former_member556067]

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

[former_member226]

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

[former_member556067]

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

[former_member226]

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

[former_member556067]

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

[vervinckt_joyca]

Hi, this is an interesting case! I don't know immediately a way to do this... Did you find a solution?

Kr,

Joyca

[Former Member]

Hi Philip,

You can try with a new hana view which takes aggregation of your customer key + Interaction Type and a new calculated field which uses aggregation as "Count". based on this view you will get count for all the interaction type + Customer id combination. Expose this new field to segmentation and try to use it after you filter on Interaction Type and Date so that only one particular type of interactions are left. You should then use the new field and select value greater than 5. We have had a similar requirement where we wanted the recent interaction data in a window of 7 days and used the aggregation logic as Max on timestamp, Not sure if this is apt for your requirement but worth a try.

Thanks

Vineet