Marketing Cloud - how to find previous target group members

[vervinckt_joyca]

Dear,

We have a dynamic target group that is assigned to a control group.

These are used in a periodic campaign. That means that at each recurrence of the campaign, the target groups are refreshed.

What we're trying to do now is make a segment with everyone who was in the Control Group of this campaign.

However; the segmentation attribute "target group" does not work; as it only takes the persons who are in the dynamic target group NOW. And not the ones who were in the target group for all the previous recurrences.

In an onpremise system; I could find this, as CUAN_D_TG_ROOT table contains the target group name and ID; and with the DB_KEY I look up the members in CUAN_D_TG_MEMBER table. In that table there's a column "version" and "deletion_version" by which you can tell which members are in there NOW and which were in there in a previous iteration.

But on a cloud system; is there a CDS view available that already contains this data? Or how could we make this data available?

Kr,

Joyca

[former_member197728]

Hi Joyca,

It highly depends what you want to achieve.

For segmentation, you need to work with custom HANA view(s) to build the custom segmentation attribute "is/was in control group of campaign".

For reporting, you can build your custom CDS view using these standard CDS Views available:

• I_MKT_TargetGroup contains information such as TargetGroupUUID, TargetGroupIsControlGroup, TargetGroupVersion and so on
• I_MKT_TgtGrpIntactnCntct tells you which interaction contacts (InteractionContactUUID) are in which target group (TargetGroupUUID). There is also a CreationDateTime. I assume this field tells you when the contact has been added to this target group.

Hope this helps!

Best regards,

Tim

[former_member572936]

You could create a HANA View based on the table CUAND_D_TG_ROOT.
Afterwards you should be able to import this view and use it in segmentation.
This blog entry is a good starting point for you purpose:

https://blogs.sap.com/2016/07/18/build-and-import-sap-hana-views-for-segmentation-in-s4hana-marketin...

As far as I know, there is no possibility to create a CSD view based on this table.