Efficiently Building 350k Sales Hiring Tables with Clay

Just built 350k hiring for sales tables. Spent the day building hiring data for sales reps in Clay and learned a lot from it. At first I tried pulling everything in one go but realized that Clay has limits on how much data you can pull at once. So I changed the plan. I split the tables by U.S. states and checked how much data each one brought in. When a table reached around 20k to 25k rows, I stopped adding more states since Clay allows 25k per pull and a max of 50k per table. This setup keeps things organized and saves time later on. In the end I had • 10 TAM tables for Sales Associates • 11 TAM tables for BDRs, split by states (California alone had 19k open roles) • 1 TAM table for Sales Reps Really impressed by how smooth Clay made the whole process. It made working with large amounts of data feel simple and manageable.