HubSpot CRM holds contacts, companies and deals, with a few hundred company properties, some of them filled by HubSpot itself. Its search API returns an error past 10,000 results, so a full export needs date windows or the list endpoint. Check the customer, churn and attribution fields against your own records before you trust them.
We ran our pipeline on HubSpot through 2026 and exported the whole portal through the API in September. We wanted to know three things: what HubSpot stores, how to get all of it out, and which fields hold up when checked against other records.
HubSpot CRMPublished capabilities- HubSpot's MCP server couldn't run our CRM queries: `query_crm_data` failed on a missing scope. A private-app token over the REST API worked.
- Searching companies by domain with `EQ` missed `www.` forms and subsidiary domains. Normalise domains before matching.
Which hubs and seat types are in the quote, and what changes at renewal?
Check product scope ↗What it holds
Contacts, companies and deals, each with standard and custom properties. Our portal had a few hundred company properties. HubSpot Insights fills some company properties, such as industry, annual revenue, founded year, web technologies and description, from HubSpot's own company data. Integrations and reps write the rest.
Our export read values, not where they came from, so we can't say which values Insights filled. What we can say is that many more company fields were filled than our own sync had been reading; CRM data enrichment covers what that saved us.
Getting data out: the 10,000-result cap
The CRM v3 search endpoint returns a generic HTTP 400 once a query passes 10,000 results. The error doesn't mention the cap, so it looks like a bad request. We split the query into quarterly createdate windows, each under 10,000 records, and paged each window. The list endpoint has no cap and pages through every record, with fewer filters.
Two more things from the export, September 2026:
- HubSpot's MCP server couldn't run our CRM queries:
query_crm_datafailed on a missing scope. A private-app token over the REST API worked. - Searching companies by domain with
EQmissedwww.forms and subsidiary domains. Normalise domains before matching.
Fields to check before you trust them
These reflect how our portal was set up and fed as much as HubSpot itself. Check yours the same way.
| Field | What we found | What to use instead |
|---|---|---|
hs_current_customer |
True on almost every company we checked | Your billing system |
| Churn flag | Wrong in both directions on a sample we checked by hand | Deal and subscription history |
| An inherited customer flag | Set by name matching; wrong in both directions | A domain match against billing |
first_touch_* attribution |
Almost always blank; two sync tools wrote the same fields | Find every integration writing them first |
hs_role |
Empty | jobtitle, which was filled and parseable |
Company total_revenue |
Unreliable | A recurring-revenue property, if you keep one |
| Industry | Useful when it says yes, weak when blank | Treat a blank as unknown |
Pricing
The CRM records come free. Sales, Marketing and Service hubs are sold per seat and edition. We did not capture HubSpot's prices for this site, so check HubSpot's pricing page; the sales side is covered at HubSpot Sales Hub.
Who it suits
| If you | Look at |
|---|---|
| Already run marketing in HubSpot | Stay, and export every property before buying data |
| Want a sales-only CRM with fewer fields | Pipedrive, Attio or Close |
| Plan to leave | Migrating a sales CRM and HubSpot CRM alternatives |
Questions buyers ask
What is the HubSpot search API limit?
10,000 results per query. Past that the v3 search endpoint returns a generic 400 error. Split the query by createdate windows or page through the list endpoint, which has no cap.
Does HubSpot enrich company data for free?
It fills some company properties from HubSpot Insights. Our export found many more filled fields than we had been reading, but it couldn't tell Insights values from ones integrations wrote.
Can you trust HubSpot's customer and churn fields?
Check them first. In our portal the current-customer flag was true on almost every company and the churn flag was wrong in both directions on a hand-checked sample.
Is HubSpot CRM free?
The CRM records are free and the paid hubs are sold per seat. We didn't capture current prices, so check HubSpot's pricing page.
Sources
Compare alternatives
Compare the part of the workflow you want to replace, including scope, billing and operating responsibility.
HubSpot CRM alternatives →