Get Your Financial Reports in Order with Our New Quickbooks Connector 👉 Set it Up Get Your Financial Reports in Order with Our New Quickbooks Connector

Number of contacts by Source

This query counts how many contacts came from each source.

Related Integrations: All Integrations / HubSpot
SELECT source
	, count(contact_id) count_contacts
FROM hubspot_contacts_consolidated
GROUP BY 1
ORDER BY 2 DESC;

Query Results Dictionary

Column Description
source The source from which the contacts came.
count_contacts The number of Hubspot contacts that fall into the source groupings.

Requirements:

Usage:

This query can be used to create histogram of contacts in from each source.

Modifications:

Add filters on the number of contacts in each source using HAVING statement.