Dear experts,

I have an interesting problem. So here is the scenario:

We extended the Marketing Cloud with a Custom Business Object to handle data coming from in integrated data source. Our customer sells products that have to be brought in for regular maintenance and all the relevant data is put into this CBO. The key field for the CBO is the DB_KEY and the contacts have a 1:N relationship with the CBO, every line inside the CBO representing one sold product.

The goal is to send automated notifications to the customer that a maintenance is due soon and we want to personalize the e-mail with the serial number of the product so they know which one needs attention.

Here's the problem: when you create a Target Group it's basically a list of contact keys and while sending out the emails the personalization engine pulls all of the CBO entries with the contacts key, no matter if just one is up for maintenance or all of them.

My first idea would be to create a Segmentation Object based on the CBO to reverse this relationship: segmenting based on the CBO because one customer can have multiple products but every product can only have one owner.

Would a new Segmentation Object be the way to go here and if yes, do you know any good ressources on the matter? The SMC documentation is very thin in this regard and I haven't really understood the topic of Segmentation Objects.