How to Exclude Stale Data from New Column Runs in Your Table

Hey team, is there any way that I can keep stale data in my table and exclude all those rows from the new column runs? Use case: I added an HTTP enrichment which wiped out all company domains from an existing table cause I exported the data from my HTTP output to an existing column. Now that cause all data in my Apollo enrichment to go stale. The thing is that I don't need to rerun that data since I don't use the data in that table in my process once it's used and I've qualified leads. So, now I need to add more leads into that same table and run the rest of the enrichments, including Apollo, for the new leads, but I'm afraid if I do that, all the stale data will start updating as well. Any advice on how I can get out of this issue without burning my credits and Apollo API

4 comments

Channeled
APP
·
·
To exclude stale data from new column runs and prevent unnecessary credit usage, you can use conditional runs and turn off auto-update. Here's how: 1. Use conditional formulas: Set up conditions to run enrichments only on specific rows. This way, you can exclude stale data from updates. 2. Turn off auto-update: Disable auto-update for the entire table or specific columns. This prevents automatic enrichment of new rows. 3. Filter new rows: When you need to run enrichments, filter for only the new rows and run the enrichment on that filtered view. By implementing these strategies, you can avoid updating stale data and save credits, including those for Apollo API calls.
Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University Guide: Ways to save Clay credits | Documentation | Clay University
Aamir
·
·
I guess the only viable solution is the first one, since my process is automated, I can't so manual runs on this
Channeled
APP
·
·
To exclude stale data from new column runs in an automated process, you can use conditional formulas. Here's how: 1. In the enrichment panel, scroll down to "Run Settings". 2. Use the AI-powered formula generator by clicking "Use AI". 3. Type your condition, using "/" to reference columns. For example: "Only run if /last_updated is empty" or "Only run if /is_new_lead is true". 4. Click "Generate Formula" to create the conditional formula. This approach allows you to run enrichments only on specific rows, saving credits and preventing updates to stale data. You can set conditions based on any column in your table, such as date added, last updated, or custom flags.
Sources: Conditional Formulas Clearbit integration overview | Documentation | Clay University
Channeled
APP
·
·

How to Exclude Stale Data from New Column Runs in Your Table | Clay