web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Unanswered

Query N:1 relationship for Marketing Segments

(0) ShareShare
ReportReport
Posted on by 19
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.

 
I have the same question (0)
  • Crownd Profile Picture
    19 on at
    Query N:1 relationship for Marketing Segments
    Maybe for clarity. 
    I am only able to query 1:N but not N:1
     
     
  • Leah Ju Profile Picture
    Microsoft Employee on at
    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 Profile Picture
    19 on at
    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.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 138 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 107

#3
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 89

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans