New companies by month
Retrieves a list of new companies created each month from the HubSpot integration and groups them by month. The results are ordered by month.
- Grain
- See the notes
- Built from
- 1Raw tables
- 1Core
- 1Analytics
- Reads from HubSpot
- companies
- Ships as
- Weld and dbt SQL, open source on GitHub
1-- core.hubspot.new_companies_by_month
2-- New companies by month. Retrieves a list of new companies created each month from
3-- the HubSpot integration and groups them by month. The results are ordered by
4-- month.
5--
6-- From the weld.app template library. Not reconciled against HubSpot;
7-- check the output against the source before relying on it.
8
9select
10 date_trunc(createdAt, month) as month,
11 count(*) as companies
12from
13 {{raw.hubspot.companies}}
14group by
15 month
16order by
17 monthThis model and the 1 it depends on. Deploy them together; refs like {{staging.…}} resolve to the matching folders in Weld, and the dbt view uses source() and ref().
How it counts. And where it stops.
This SQL model allows you to easily track the number of new companies that have been added to your CRM each month. By using the date_trunc function, the SQL template groups the companies by month, providing you with a clear and concise overview of your company's growth over time. This information can be incredibly useful for businesses looking to track their progress and identify trends in their customer acquisition. With the New Companies by Month SQL template, you can gain valuable insights into your company's growth and make data-driven decisions to help your business succeed.
Raw tables it reads
- raw.hubspot.companies
Put HubSpot in front
of your agents.
Connect HubSpot, deploy the models, and ask questions in Claude, Cursor or ChatGPT. Free for 14 days, no credit card.