.png){kind=logo}
Filter New Leads Based on Existing Customers in Airtable
So we have a list that updated constantly with new leads we have existing customer list Both in airtable - how do we skip processing of new leads if they are already present in the other list?
To skip processing new leads in Airtable if they're already in your existing customer list, you can use Clay's "write to table" feature and table exclusions. Here's how: 1. Use the "write to table" feature to import both your new leads and existing customer list from Airtable into separate Clay tables. 2. When creating a new table for processing leads, use the "Exclude" section to select your existing customer table as an exclusion source. 3. Choose matching criteria like email address or domain to identify duplicates. 4. Generate results that automatically exclude matches from your existing customer table. This approach will streamline your prospecting by removing existing contacts from your new lead processing.
Sharan··The steps are not clear on how to do this, can you share some information on this?
Sure, I can provide more detailed steps on how to skip processing new leads in Airtable if they're already in your existing customer list using Clay. Here's a clearer breakdown: 1. Use our "write to table" feature to import both your new leads and existing customer list from Airtable into separate Clay tables. 2. Create a new table in Clay for processing leads. 3. In this new table, use the "Exclude" section to select your existing customer table as an exclusion source. 4. Choose matching criteria (e.g., email address or domain) to identify duplicates. 5. Set up AI formulas and conditional runs to only process contacts that are confirmed as new. 6. Run your enrichment. Clay will automatically exclude matches from your existing customer table, ensuring you only process new leads. This approach helps streamline your prospecting by automatically removing existing contacts from your new lead processing.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.