Skip to Content

Hybris Marketing Cloud Segmentation by interaction count

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 27 at 11:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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