Delete contacts ranked by Last Interaction Date

[JoycaVervinckt]

Hello all,

I would want to set up an application job to delete contacts via target group,

which deletes all contacts up to a certain threshold, but ranked by interaction date.

In other words: if I have 506.000 contacts but want to stay below 500.000 contacts in total,

I need to delete 6.000 of them. And I would want to delete the ones with the oldest last interaction date. And I want to automate this.

I tried using a "secondary distinction entity" with Last Interaction date, so the operator "reduce randomly by last interaction date" but that didn't provide the required result...

Any ideas on how to achieve this?

Kr

Joyca

[Former Member · Accepted solution]

One opt would be to model your requirements using a SAP HANA calculated view.

1. Join the two tables CUAND_CE_IC_ROOT and CUAND_CE_IA_RT.
2. Identify the latest interaction of each contact using a RANK element
3. Then use another RANK element and create a dynamic rank column based on the interaction date.
4. Upload the view and define the rank column as a segmentation attribute
5. Finally you can create a target group to delete contacts automatically as required

[JoycaVervinckt · Accepted solution]

Thx for the input Christian.

Was hoping for something not involving HANA Modeling (as it takes so much time on a Cloud system to export the views etc, setup your local HANA Studio, making the model without access to the actual data and being able to test the rank, uploading the view to Marketing, etc...).

But I suppose there'd be no other way. I made a SAP Influence item for it to perhaps become a standard segmentation option to "reduce by ranking attribute" https://influence.sap.com/sap/ino/#/idea/229401

Kr

Joyca