Number of Contacts by City
This query counts how many contacts are from each city.
Related Connectors:
Our connectors /
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. |
View HubSpot docs
Edit on Github
