Multi-value attributes in email content

[SauMaris]

We have a made a custom table containing customer children information. Obviously, each customer can have zero to many children. We have created a custom HANA view, which is calculating child’s next birthday. We use it in the segmentation for a target group definition.

We want now to put a child’s name in the email content. We have an attribute “kids name” that we are using, but, unfortunately, it is not returning the right name of a child that has a birthday based on a segmentation, but is returning all children names for a particular customer.

How is it possible to get a specific child's name in this particular scenario?

[former_member197728 · Accepted solution]

Hi Maris,

in addition to the "kids name" which I understand always returns all children for a particular customer, you can create a "kids name (birthday today)" attribute (you can come up with a better name).

This new attribute should have a dynamic filter on the custom table (pseudo code: next_birthday = today()) and only returns the children names of children having birthday today.

You can then use this new attribute in the email content.

Hope this helps!

Best regards,

Tim

[SauMaris · Accepted solution]

Unfortunately, it is not that simple, because emails are not sent on kid's birthday, but several days before. To make things more complicated, different "Marketing areas" (countries) are using different days in advance when they want to congratulate customers on their child's birthday.

In segmentation we have a new attribute "kids next birthday" that we use similar as "next birthday" for customers. We use it to segment customers whom kids have birthdays x days in advance. That relationship should be kept when we send an email, but unfortunately it isn't.

[former_member197728 · Accepted solution]

I understand.

In that case I would recommend that you either

a) create another table which holds the marketing area - number_of_days relationship, include this table in your view and extend the simple formula above OR

b) you try to add the country-specific logic fully inside the formula of the new attribute (if possible).

Still the approach would be similar to the original answer. You create a new attribute which gives the name of the filtered child (having birthday in configured X number of days) and use that attribute in the email content.

Best regards,

Tim

[SauMaris]

We will follow your suggestion and will create a new attribute with a logic in the HANA