Hooray! We just launched a direct integration with 🛍   BigCommerce 🛍! Check it out Hooray—Panoply now offers direct integration with BigCommerce!

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.