How to verify Net New Smart List Contacts in Databox vs HubSpot

This document outlines how to verify the Data Choice: Net New Smart List Members from Databox's Query Builder for HubSpot Marketing (Smart Lists). To do this, we'll walk through an example in order to verify Net New Smart List Members for the Smart List called "Premier Partners (ALL)" and the Date Range: Last Month. 

Within Databox, the Custom Metric is set up as follows: 

We can then pull the Custom Metric onto a Databoard to see the total Net New Smart List Members for Last Month (October). 

1
 In HubSpot, navigate to Contacts > Lists
2
 Once you find the Smart List you're focusing on, click More > View list performance
3
 On the graph called List size over time, set the Date range to match the Date Range you're viewing in Databox
4
 When you hover over the graph, you can see daily Smart List member values. This is what's being synced with Databox
5
 To calculate Net New Smart List Members, subtract the Count of Contacts on the first day of the Date Range from the Count of Contacts on the last day of the Date Range
6
 When you hover over the graph, you can see daily Smart List member values. This is what's being synced with Databox

For our example, we would do 59 - 56 = 3 Net New Smart List Members Last Month. This matches what we see within Databox, so we were successfully be able to verify the New Smart List Members value in Databox vs HubSpot. 

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us