.png){kind=logo}
Avoiding Excessive Credit Usage with Conditional Runs
Anyone have a good conditional run to avoid excessive credit usage with this? https://www.loom.com/share/75b73065bc9848279e6f402905c90d81?sid=5178b621-c380-4d90-99c6-4f6469e98aad
To set up a conditional run and save credits, you can use the "Run Settings" feature: 1. Go to the Run Settings of your enrichment column. 2. Find the "Only run if" box. 3. Add a conditional formula to specify when the enrichment should run. For easy setup, use the "Use AI" button: 1. Click "Use AI" in the Run Settings. 2. Type your condition in plain language, e.g., "Only run if /headcount is greater than 40". 3. Click "Generate Formula" to create the conditional formula. This ensures enrichments only run when necessary, saving credits on irrelevant rows.
Extract a Unique List of Companies Create a new table in Clay. Use the "Find Unique Values" function on the company column in your Find Jobs table. This will generate a list of unique companies, removing duplicates. Enrich Company Data Once Per Company In the new unique company table, add an "Enrich Company Details" source. Configure the source to pull relevant company data. Run the enrichment once per company in this table. Link the Enriched Data Back to the Jobs Table In your Find Jobs table, add a lookup column to match the company name with the enriched data from the unique company table. This will attach enriched data to all job listings without running multiple enrichments. Conditional Enrichment (Only If Relevant Contacts Exist) In your Find People table, filter for companies where relevant contacts exist. Create a column in the unique company table to check if a company has contacts. Use an IF condition to trigger enrichment only for companies that have relevant people....hope this will help u.
To set up conditional enrichment in Clay and save credits, you can use the "Conditional Runs" feature: 1. Go to the Run Settings of your enrichment column. 2. Find the "Only run if" box. 3. Add a conditional formula to specify when the enrichment should run. For easy setup, use the "Use AI" button: 1. Click "Use AI" in the Run Settings. 2. Type your condition in plain language, e.g., "Only run if company size is greater than 50 employees". 3. Click "Generate Formula" to create the conditional formula. This ensures enrichments only run when necessary, saving credits on irrelevant rows. You can create custom conditions based on specific criteria like company size, industry, or location.