Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Discrepancy in Company Counts Between HubSpot and Clay Tables | Clay

Discrepancy in Company Counts Between HubSpot and Clay Tables

·Jul 16, 2025 10:19 AM·

Hi Clay S. I have a Clay table with a Hubspot Active List as source. But the number of companies are not the same In the Hubspot I have more companies than in the Clay Tables. SL BE-big People HubSpot: 8209 VS Clay: 5277 SL NL-big People HubSpot: 24330 VS Clay: 23454 Why is this happening?

Loading attachments

10 comments

· Sorted by Oldest

Clay
APP
·
·
This discrepancy occurs because limits are likely being applied during the import process. When importing from HubSpot, search filters or restrictions (such as limiting the number of records per company) can reduce the final import count even though the source shows more records. To resolve this, check your import settings for any applied limits or restrictions before importing. You can also try refreshing your data by re-running the import using the "Update Now" option in your table's Sources section to pull the most recent updates.
Patrícia S.
·
·
I have tried the "Update Now" didn´t change the differences
Patrícia S.
·
·
Clay table link: https://app.clay.com/workspaces/310064/workbooks/wb_0syira1kTmQzzssmYcS/tables/t_0sz6n82ApKGDxZUvpr8/views/gv_0syirb4rnWEyfuHcuvA
Hari K.
·
·
Hey Patricia! Looking into this now
Hari K.
·
·
Just to confirm, the hubspot list ID "6853" that you are pulling from should be returning 8209 rows?
1
Hari K.
·
·
Patrícia - Sorry for this, it looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more!
Patrícia S.
·
·
Hi Hari K. ok, please update asap, I need this to move on with a campaign
Hari K.
·
·
Hey Patricia - We are working on the bug on our end, but I wanted to share a quick work-around to get you unblocked. If you attach the source to a new table and re-run it with manual triggers, I believe all of your records should populate. Hope this helps!
Patrícia S.
·
·
Hey Hari, not really, because I want to make a weekly update and have to create new tables every week is not effective and will be hard to manage.
Hari K.
·
·
Hey Patricia, I definitely understand that. We are hard at work on this and I'll have a more comprehensive update soon!