Stephen M.

Found a great video walkthrough from Mallory Lee showing how it works: https://www.linkedin.com/posts/mallorylee_claypartner-sponsored-learnclay-activity-7301018407552851968-8GBE/

Okay, so effectively a vlookup (excel) but in Clay. I haven't tried it, but you could try Clay's Lookup feature. I assume it will give you a column with the match data, and you can extract the account ID into a new column for all the matching rows. It doesn't look like it will fuzzy match (offers "equals" and "contains" operators) so I'd recommend instead of matching of company name, match the company domain but have Clay normalize the domains first.

So you have a list of 26000 companies, each with an ID, and you have a table of contacts and you want to add the appropriate company ID for each contact based on what company they're with?

I added a waterfall step using Apollo, which uses my API key from my paid Apollo account, but that also has a limit of 10 results per row. I can't really break this list smaller

Also, I'm on a paid "Explorer" plan

Thank you, yeah, figured I'd have to do something along those lines, aka how I should've approached it in the beginning. Given I already had both in Clay, with the non-CRM list enriched already, I was hoping I could achieve it within Clay

Two lists from a couple of CSV uploads, one is CRM accounts, one is specific award winners that I did a bit of AI enrichment on before attempting to merge and dedupe the lists