Skip to content
Menu
Home / Vendor profile

HubSpot CRM

HubSpot's CRM stores more company data than most teams read, but its search API stops at 10,000 results and several default fields mislead.

Product typeCustomer platform
PricingSee the vendor pricing page
Official sourcehubspot.com
Visit website ↗
Our testSep 2026 · full API export of one HubSpot portalAll our tests ↗
The short answer

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_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.

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 →
Sources and evidence behind this page