Using Formula Fields in HubSpot Custom Reports to group contacts into buckets based on how many Marketing emails they've opened
This is an example of using Formula Fields (currently a Public Beta) in Custom Reports
There's other ways to do this (eg using calculated properties, or Operations Hub Enterprise functions) - this example doesn't use either of those ie no need for Operations Hub for this particular example.
The key is to use the mod operator (ie %) in the formula field - here's the formula from this particular example:
([CONTACT.hs_email_open] - ([CONTACT.hs_email_open] % 10))/10
Notes:
- Limitation: the buckets are all the same size (ie ranges of 10 in my example), they can't be mixed sizes eg 1-9, 10-49, 50-250, etc
- Limitation: the label on the report axis is just 1, 2, 3, etc - would be nice if they could be tailored
- The mod operator can be used with any number (doesn't have to be 10), just replace it in both places in the formula
HubShots = HubSpot in the real world
Real world portals. No demo stuff.
LINKS:
📚 Full show notes available at: [ Ссылка ]
📝 Subscribe to receive the show notes automatically in your inbox when a new episode is published: [ Ссылка ]
BE OUR FRIEND:
💌 Sign up to the shownotes - [ Ссылка ]
🌍 Our website - [ Ссылка ]
📸 Instagram - [ Ссылка ]
💙 LinkedIn - [ Ссылка ]
🧵 Threads - [ Ссылка ]
🇫 Facebook - [ Ссылка ]
🐦 Twitter - [ Ссылка ]
WHO WE ARE:
We're Ian Jacob and Craig Bailey, your hosts of HubShots.
HubShots is the downunder HubSpot focussed show for sales and marketing managers who use HubSpot.
Ian is CEO of Search and Be Found: [ Ссылка ]
Craig is CEO of XEN: [ Ссылка ]
GET IN TOUCH:
If you’d like to talk, we’d love to hear from you. Replying to Craig (when he sends the shownotes each week) is the quickest.
You can also connect with us personally on LinkedIn: [ Ссылка ]
[ Ссылка ]
CLARIFICATION:
For the sake of clarity, please note this is an independent podcast – we are not affiliated with, nor officially endorsed by HubSpot. But having said that, we get lots of support and ‘encouragement’ from them – Brian Halligan is a fan!)
![](https://s2.save4k.ru/pic/hIwUqxYBuRI/maxresdefault.jpg)