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

Announcements

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Add contacts connected to an account to a segment based on account field

(0) ShareShare
ReportReport
Posted on by 337

Hello!

Let's say I have book clubs in my marketing module as Accounts. Each of these Accounts have a field for what kind of books, genres or authors the book clubs are interested in.

Each of these book clubs have Contacts to them, or members in this case.

I want to make a segment for these members, so that the members of each book club receive emails based on the interests of the book club. Let's say one book club is interested in Sci-Fi, and another is interested in Romance.

I want to take the members of these book clubs into a segment based on if they are interested in Sci-Fi or Romance, so that I can send relevant mails about new releases or news about the genre to the members.

I assume I can start the segment query by looking for Accounts where their "interests" field contains Sci-fi. However, it becomes challenging for me to retrieve the contacts and putting them into a segment for some reason. 

Each of these Contacts also have the Account name connected to their Contact.

TLDR:

How can I make a segment query to include all contacts connected to an account based on the value of a field in the account? 

I have the same question (0)
  • Suggested answer
    Hagru Profile Picture
    337 on at

    I figured it out.

    You can do this by creating a new empty dynamic segment.

    Add a new query block, and select Contact in the first dropdown.

    Under Contact, remove the first "Select attribute" dropdown, and click Add > Add related entity

    Select "Account (Contact -> Account (Company Name))

    Then click Add > Add condition to Account

    Add the condition you want, in this example > Interests - Contains - Sci-Fi

    That's it. Contacts connected to the accounts that go through this filter will be added to the segment.

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…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 53 Super User 2026 Season 1

#2
Eugen Podkorytov Profile Picture

Eugen Podkorytov 49

#3
Fiona_Tiernan Profile Picture

Fiona_Tiernan 22 Moderator

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans