Number of contacts by Source

🥳 Introducing our new Flex Connector! 👉 Learn more Introducing our new Flex Connector!

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.