You’re offline. This is a read only version of the page.
Announcements
270
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 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.
#1
André Arnaud de Cal...
294,241
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
