Clay Icon

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

  • Avatar of Channeled
    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.

  • Avatar of Aamir
    Aamir
    Β·
    Β·

    I guess the only viable solution is the first one, since my process is automated, I can't so manual runs on this

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·