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

Confusion Over Company Row Counts and Source Data Discrepancy | Clay

Confusion Over Company Row Counts and Source Data Discrepancy

·Nov 06, 2025 02:52 PM·

I don't understand why I have 4 sources to find companies each with 25.000 rows, why when I put them together they're 50765? Shouldnt they be 100.000? Mind you, I have 20 sources to find companies to actual result should be 500.000 rows in the "Company table" Clay S.

Loading attachments

6 comments

· Sorted by Oldest

Clay Support
APP
·
·
The discrepancy occurs because Clay automatically deduplicates companies when combining sources. When you import from Find Companies sources, you can enable or disable auto-dedupe in the import options. [1]
Your 4 sources with ~25,000 rows each should total ~100,000, but the combined table shows 50,765 rows because duplicate companies across sources are being removed. This is normal behavior to prevent duplicate company records.
Also note that Clay tables have a 50,000-row limit per table, so even without deduplication, you'd hit this limit before reaching 100,000 rows.
Clay Support
APP
·
·
Is that what you were looking for?
Jelle O.
·
·
So I have to do 20 find company that get together in 10 tables (end result is 500.000 rows) ? Clay S.
Clay Support
APP
·
·
Yes, that's correct. Each table has a 50,000-row limit, so to get 500,000 rows total, you'd need 10 tables with 50,000 rows each.
For your 20 Find Company sources, you could organize them as 2 sources per table across 10 tables to stay within the limits. The Explorer plan allows 10 tables with 5 sources each, supporting up to 500,000 total search results across those tables.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help understanding how to organize your sources and tables, I’m here to assist. Would you like to provide more details about what you’re trying to achieve with your company data?