Query N:1 relationship for Marketing Segments

(0) Share

Report

Posted on by Crownd

Dear Forum,

I am trying to query a N:1 relationship for a Segment in Outbound Marketing but fail to do so. Here is a quick and abstract diagramm of the Entities involved.

We have a custom entity named /realestate_object,/ which is linked to leads who are buyers for these real estate properties (realestate_buyer).
Additionally, I have established a custom one-to-many (1:N) relationship for leads who have connections with other leads through personal relationships (personal_relationship).

For my segment, I want to create a query that retrieves all the leads who have a connection (personal_related) to buyers of specific real estate properties. In essence, it would be structured as follows:
realestate_object -> Leads (Buyers) -> Leads (personally_related) -> Contact (parentof)

This is the query in Dynamics Outbound Marketing (sorry only in German)

I seem to be encountering a problem in the logic when navigating from /Leads (Buyers)/ to /Leads (personally_related)./ How can I modify the query to access the /many (N)/ part of the relationship and not the one (1)?

I hope this question makes somewhat sense.

All responses (3)

Answers (0)

Crownd 36 on at

Like (0)

Report

Query N:1 relationship for Marketing Segments

HI Leah Ju,

This is somewhat true, however, we have a workaround in place that every lead is mapped to a contact. Thus, this should not be the problem.

But I fail to query the right leads in the first place.
Leah Ju Microsoft Employee on at

Like (0)

Report

Query N:1 relationship for Marketing Segments

Hi Crownd,

For my segment, I want to create a query that retrieves all the leads who have a connection (personal_related) to buyers of specific real estate properties.

Based on your description, you need return leads through query, but the audience for outbound marketing is just contacts.

The Microsoft documentation said:

A market segment is a collection of contacts that you target with a customer journey.
Crownd 36 on at

Like (0)

Report

Query N:1 relationship for Marketing Segments

Maybe for clarity.
I am only able to query 1:N but not N:1