How to create a report of email validation results in HubSpot using the Koalify properties

Koalify – Email Validation adds custom properties to your HubSpot CRM that record the outcome of every email check: whether an address is valid, why it failed, and when it was last validated. By using these properties in HubSpot reports, you can: 

• See the overall health of your email data at a glance: how much of your database is valid, invalid, or unknown
• Understand why addresses are failing (the reason behind each invalid result)
• Track validation results over time and spot when bad emails are entering your CRM
• Decide when a bulk clean-up or a re-validation is due

The four reports below cover the essentials. Email validation runs on the object that holds the email address, so in most portals these are Contact reports.

1. Email Validation Status breakdown (pie chart)

See the share of your contacts that are valid, invalid, and risky in a single view.

• Create a single object report (Contact)
• Data — properties
  • Koalify – Email Validation Status
• Filters (optional)
  • Koalify – Email Validation Status is known
• Visualisation
  • Pie chart
• Displaying
  • Koalify – Email Validation Status
  • Measured by (Count) Contacts

2. Email Validation Details breakdown (pie chart)

Go one level deeper than status to see the reason behind each result — for example undeliverable, mailbox not found, or accept-all domain.

• Create a single object report (Contact)
• Data — selected properties
  • Koalify – Email Validation Status Details
• Filters (Optional)
  • Koalify – Email Validation Status Details is known
• Visualisation
  • Pie chart
• Displaying
  • Koalify – Email Validation Status Details
  • Measured by (Count) Contacts

3. Email Validation Status over time (column chart)

Track how your validation results trend over time, based on when each contact was last checked. This is the report to watch if you want to catch bad emails entering the CRM rather than reacting to a backlog.

• Create a single object report (Contact)
• Data — selected properties
  • Koalify – Last Email Validation Date
  • Koalify – Email Validation Status
• Filters
  • Koalify – Email Validation Status is known
  • Specific timeframe (Optional)
• Visualisation
  • Column chart
  • Frequency: Weekly / Monthly
• Displaying
  • Koalify – Email Validation Status
  • Koalify – Last Email Validation Date
  • Measured by (Count) Contacts

4. Email Validation Details over time (column chart)

The same time view as above, but broken down by the reason emails are failing — useful for spotting whether a specific source or integration is introducing a particular type of bad address.

• Create a single object report (Contact)
• Data — selected properties
  • Koalify – Last Email Validation Date
  • Koalify – Email Validation Details
• Filters
  • Koalify – Email Validation Status Details is known
  • Specific timeframe (Optional)
• Visualisation
  • Column chart
  • Frequency: Weekly / Monthly
• Displaying
  • Koalify – Email Validation Details
  • Koalify – Last Email Validation Date
  • Measured by (Count) Contacts