How to segment records who open Sales Sequence email or Marketing email

Our sales and Marketing team both are on same platform.

They Target different records to send Marketing Emails using workflow. They also use Sales Sequences to send emails.

As a a manager I would like to create a Global filter which all members can see and focus on.

We want to find records who are opening our emails (marketing or sales) more than 3 times

And then we want to send them one to one personal emails for more engagement.

Shall we use Lists or View for above Purpose? Or report

How can we filter them so all users can easily access it?

Thank you

Hi @keshukeshvala,

If you want to create a view, you could use a filtered view: Create and manage saved views

As far as filters go, you could leverage these properties:

  • Marketing emails opened: the number of marketing emails opened. This value is incremented at most once per email so if the same email is opened multiple times, this value will only increase by one. Transactional email interactions do not count towards opens.
  • Recent sales email open date: the date of the last time that the contact opened a sales email. This property does not update for emails that were sent to more than one contact.

There is no contact property that counts how many sales emails were opened.

If you want to see contacts with a certain level of engagement, you could also create an engagement score: Edit, turn off, or delete lead scores

In the score settings, you can define how many points you want to award to a contact for opening marketing emails or sales emails. Once you have the score, you could also filter for it.

Best regards!

Hey @keshukeshvala
For the marketing side, it’s pretty straightforward you can create an Active List with a filter like “Marketing email open count is greater than 3”. That’ll dynamically track anyone engaging heavily with marketing emails.

The sales side, though, takes a bit more effort. Since HubSpot doesn’t natively track the number of times a contact opens sales sequence emails, you’ll need a workaround. The best way is to first create a custom number property like Sales Email Open Count. Then, build a simple workflow that triggers every time a sales email is opened and increments that number by one. Over time, that gives you a solid way to track high engagement on the sales side too.

Once both sides are set up, you can create a combined Active List that pulls in contacts who’ve opened either type of email more than three times. From there, it’s easy to build a dashboard with two reports one showing marketing engagement and the other for sales sequences and share that with the team. Everyone gets visibility, and your reps can then send one-to-one emails to those warm contacts directly from the list.

@karstenkoehler and @Wesimplifi_ for a solution this serves purpose for us.

Thank you for replies. We have prepared custom property and now using workflow to update it. so we get number of sales emails open.

Hi @keshukeshvala and thanks for sharing with the HubSpot Community what works for you, this is really useful!
Have a lovely day!
Bérangère