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

Number of Contacts by City

This query counts how many contacts are from each city.

Related Integrations: All Integrations / HubSpot
SELECT CASE WHEN city IS NULL THEN 'Unspecified' ELSE city END AS "City"
	, count(contact_id) AS count_contacts
FROM hubspot_contacts_consolidated
GROUP BY 1
ORDER BY 2 DESC;

Query Results Dictionary

Column Description
City The contact’s city.
count_contacts The number of Hubspot contacts that fall into the city groupings.

Requirements:

Usage:

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

Modifications:

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