How to Export Over 500K Accounts from Salesforce Effectively

I want to pull 500k+ accounts from Salesforce. Salesforce report only limit to 2000 Is there a way?

· Sorted by Oldest

Clay Support
APP
·
·
Yes! The 2,000 record limit applies only to Salesforce reports, not lists. [1]
Solution: Import from a Salesforce list instead of a report to bypass this limitation.
Steps:
1.
Create a new list view in your Salesforce Account object
2.
Add filters matching your original report configuration using SOQL-compatible logic (avoid "contains" - use =, <, >, >=, <= operators)
3.
Save the view and import it to Clay as a list
For Enterprise scale: Our new Bulk Enrichment feature supports enriching millions of Salesforce records in a single workflow. [2]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help with pulling large amounts of data from Salesforce or using our Bulk Enrichment feature, I’m here to assist. Would you like to share more about what you’re trying to achieve or any specific challenges you’re facing?

Clay Support
APP
·
·
Yes! The 2,000 record limit applies only to Salesforce reports, not lists. [1]
Solution: Import from a Salesforce list instead of a report to bypass this limitation.
Steps:
1.
Create a new list view in your Salesforce Account object
2.
Add filters matching your original report configuration using SOQL-compatible logic (avoid "contains" - use =, <, >, >=, <= operators)
3.
Save the view and import it to Clay as a list
For Enterprise scale: Our new Bulk Enrichment feature supports enriching millions of Salesforce records in a single workflow. [2]
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you need any more help with pulling large amounts of data from Salesforce or using our Bulk Enrichment feature, I’m here to assist. Would you like to share more about what you’re trying to achieve or any specific challenges you’re facing?