Hubspot
First, create a folder somewhere in their ecosystem where all these lists can live. The reason we do this in lists rather than reports or views is so that they can get used to segmenting their database.
| Metric | How to build the list |
|---|---|
| Total Contacts in the Database | Record ID = Known |
| Marketable Contacts | Add filter where Marketing Contact Status = “Marketing Contact” OR if on old Enterprise deal, it matches contact count |
| Reachable Contacts | [Marketing Contact Status = “Marketing Contact” AND “Unsubscribed from all email” = “False”] OR [Marketing Contact Status = “Marketing Contact” AND “Unsubscribed from all email” = “Unknown”] |
| Unsubscribed Contacts | Contacts tab, add filter where “Unsubscribed from all email” = “True” |
| Hard Bounces | “Marketing emails bounced” is known |
| Opened Email Last 30 Days | Last marketing email open date is less than 30 days ago |
| Opened Email Last 60 Days | Last marketing email open date is less than 60 days ago |
| Opened Email Last 120 Days | Last marketing email open date is less than 120 days ago |
| Opened Email Last 180 Days | Last marketing email open date is less than 180 days ago |
| % of Reachable Database on personal domains | Reachable filters + Email Domain is equal to any of list below https://share.zight.com/mXuzdvKg, then divide |
| % of reachable database on work domains | Reachable filters + Email Domain is not equal to any of list below https://share.zight.com/mXuzdvKg, then divide |
| % of database opt-in | More nuanced view, but looking for form submissions, |
| % of database not opt-in | Offline sources from list building |
Customerio
gmail.com; yahoo.com; hotmail.com; aol.com; hotmail.co.uk; hotmail.fr; msn.com; yahoo.fr; wanadoo.fr; orange.fr; comcast.net; yahoo.co.uk; yahoo.com.br; yahoo.co.in; live.com; rediffmail.com; free.fr; gmx.de; web.de; yandex.ru; ymail.com; libero.it; outlook.com; uol.com.br; bol.com.br; mail.ru; cox.net; hotmail.it; sbcglobal.net; sfr.fr; live.fr; verizon.net; live.co.uk; googlemail.com; yahoo.es; ig.com.br; live.nl; bigpond.com; terra.com.br; yahoo.it; neuf.fr; yahoo.de; alice.it; rocketmail.com; att.net; laposte.net; facebook.com; bellsouth.net; yahoo.in; hotmail.es; charter.net; yahoo.ca; yahoo.com.au; rambler.ru; hotmail.de; tiscali.it; shaw.ca; yahoo.co.jp; sky.com; earthlink.net; optonline.net; freenet.de; t-online.de; aliceadsl.fr; virgilio.it; home.nl; qq.com; telenet.be; me.com; yahoo.com.ar; tiscali.co.uk; yahoo.com.mx; voila.fr; gmx.net; mail.com; planet.nl; tin.it; live.it; ntlworld.com; arcor.de; yahoo.co.id; frontiernet.net; hetnet.nl; live.com.au; yahoo.com.sg; zonnet.nl; club-internet.fr; juno.com; optusnet.com.au; blueyonder.co.uk; bluewin.ch; skynet.be; sympatico.ca; windstream.net; mac.com; centurytel.net; chello.nl; live.ca; aim.com; bigpond.net.au;