Using the HubSpot Marketing Query Builder to Access Smart List Contacts
The HubSpot Marketing Query Builder was built for the sole intention of improving our ability to pull Smart Lists into Databox. While it is a very simple query builder, you must understand how “Data Values” works.
There are two ways you may want to track the contacts in your smart list:
- Total number (Total Smart List Members) of contacts that are in your smart list during the specified date interval.
- Daily Values (New Smart List Members) of contacts added or deleted from your smart list during the specified date interval.
Here’s an example. Suppose it’s July and you’re focused on a datablock that has “This Month” selected as the date range. You want to pull in Smart List A from HubSpot Marketing. Smart List A has 50 contacts in it, and 4 were added in July. If you choose “Total” as the data value, you will see “50” in your datablock. If you choose “Daily Values” as the data value, you will see “4” in your datablock.
Here’s how you can set up a Smart List of your own:
You can now access this from the Designer by selecting “Custom” as the metric column and choosing the corresponding Smart List name.