Trigger-based campaign not personalizing e-mail based on the triggering interaction

[vervinckt_joyca]

Hi,

I am using a trigger based campaign.

This is based on an interaction as trigger.

In my segmentation profile; many attributes of my interaction are also available for mail personalization.

For example; a custom field called "appointment date".

However, when I use this field in the mail personalization; and then trigger my campaign,

the "appointment date" field is not personalized with the ONE date from this triggering interaction. Instead there is a concatenation of ALL appointment dates that the contact receiving the email has EVER had over all his interactions.

How can I make sure that the mail personalization only uses the values from the interaction that triggers it?

PS; if I use a classic campaign with a target group; and add Interaction Date as an attribute on my segmentation model;

If one of my interactions with an appointment date was created yesterday; and the second interaction was created today; and I filter on Interaction Date = today;

When I use this target group in an email; then I do get ONE appointment date; namely the one from in the interaction of today, and not ALL appointment dates. So technically it is possible for the system to take into account filters from the segmentation model. So likewise, on a trigger based campaign, the filter should be to only take the current triggering interaction into account...

[SauMaris]

I always thought that for trigger based campaigns, which are happening on a trigger of a specific interaction, system should pick data from that particular interaction. What you are writing is a surprise to me and I would like to know the answer as well.

Maris

[hakan_kose · Accepted solution]

Hi Joyce,

We had exactly same issue. We solved it by changing segmentation key for our segmentation object. We changed it from "SAP_CONTACT_KEY" to "SAP_INTERACTION_KEY" and also did mappings according to db_key for interactions (not contact keys)

I hope this helps

Best wishes

[vervinckt_joyca · Accepted solution]

Hi Hakan,

It worked 🙂

But I now notice that I don't seem to be able to find this segmentation profile in the Score Builder?

Is this normal?

Kr,

Joyca

[former_member411753 · Accepted solution]

Hi Joyca,

Double Key 🙂

I'm facing the same with a trigger based campaign!

Catherine

[former_member498725]

Hi Joyca,

We also have similar requirement for our Onpremise 1809 SAP Marketing system. I am able to initiate trigger based campaign with personalization when we use Standard Segmentation Profile - ALL INTERACTIONS.

But for the Seg Profile which uses custom HANA View, trigger based campaign with personalization is not working even though INTERACTION_KEY is enabled in HANA View.

Can you let me know if you have faced such issue after remodeling the HANA View?

Regards,

Deepu Pankaj

[vervinckt_joyca]

Hi,

"But for the Seg Profile which uses custom HANA View, trigger based campaign with personalization is not working even though INTERACTION_KEY is enabled in HANA View."

Did you only enable it, or did you also mark on your Segmentation Object that it should use the Interaction Key as Segmentation Key?

Kr

Joyca

[former_member498725]

Hi Joyca,

Thank you for the response... Yes, I have marked Interaction Key as Segmentation key.

As you can see in the below screenshot. I have also kept secondary distinction entity with CONTACT_KEY. I have tried to mirror all the configuration similar to SAP_CE_INTERACTION Seg Object used by ALL INTERACTIONS Seg Profile.

In fact I have used same standard hana view in my custom data source. Is there any Authorization related issues?

Regards,

Deepu Pankaj

[vervinckt_joyca]

Then I don't know, best to contact SAP Support.

Maybe in your custom HANA view the data type of your "interaction key" field isn't exactly the same as the interaction key that's in the campaign, but I don't know enough about HANA modelling for that. Is it indicated in your config on your custom datasource which field corresponds to the key?

Kr

Joyca

[former_member498725]

Hi Joyca,

The issue was identified and resolved.

The issue was with respect to the Key which was defined for Segmentation Object. In my case it was DB_KEY. Underlying Datasource(HANA View) also had DB_KEY as Interaction key and this duplication was causing DUMP issue when trigger campaign job execute.

As you can see in the below screenshot I have changed the highlighted DB_KEY to ZDB_KEY and it started working.

Regards,

Deepu Pankaj

[vervinckt_joyca]

Thanks for the suggestions Catherine and Hakan. I'll try them out. The thing is that we'll have some rework because some of the datasources linked to our current segmentation object, do not have the interaction key in them; only the contact key (like SAP_CONTACT_EMAIL_AFFINITY, SAP_CONTACT_EMAIL_BEST_SEND_TM, SAP_CONTACT_ENGAGEMENT_IC_MA, even SAP_CONTACT_INTEREST_AFF_SP); so I guess we'll need to join these in HANA first to a view that does have an interaction key.

Kr,

Joyca

[vervinckt_joyca]

Hi,

We've been able to test with the all interactions profile and it looks promising.

This profile is one that indeed uses the interaction key instead of the contact key.

So now we still need to remodel to get all our used HANA views to have the interaction key in them.

Thanks to all!

[former_member411753]

Hi Joyca,

Have you tried to filter the interaction on the Hana view linked to the alias you are using for it?

If you do, you would not have this problem anymore.

Let me know!

Regards

Catherine

[former_member267312]

Hi Joyca,

Did you use the "All Interactions" segmentation profile for the personalization? Then it should work.

BR

Theo

[vervinckt_joyca]

Hello Theo,

"All interactions", is that the SAP_CE_INTERACTION profile based on object SAP_CE_INTERACTIONS?

This profile does not contain "Item of Interest" as available attribute, and also not my custom fields. (which are fields I am using in my personalized mail)

With the fiori app "Add custom Fields in segmentation"; the object SAP_CE_INTERACTIONS also does not appear so it's not possible to add my custom fields to it...

[former_member267312]

Hello,

Please try the following: go to Segmentation Configuration and add the following data source to the segmentation object "All Interactions": _SAP_CF_INTERACTION (view name: CA_INTERACTION_EXT_FIELDS).

This should add all your custom fields (for interaction/interaction product) as well as the item of interest.

Good luck!

Theo

[former_member397528]

Hi Theodor,

we have a very similar issue to what was described by Joyca. Our first approach was to use the "All Interactions" Segmentation Profile but when we create a new Target group from it, we are not able to create a campaign for it as the campaign option is not enabled. Do you know what can this be related to?

Kind Regards,

Antonio

[vervinckt_joyca]

Antonio,

I also have this behaviour.

However in my case I'm using a trigger-based campaign and not a target-group-based campaign, so I don't need to use target group on that profile.

Kr,

Joyca