Lead Upload Timing Issues in Data Enrichment Process | Clay

Lead Upload Timing Issues in Data Enrichment Process | Clay

Channeled
APP
·
·
To ensure leads are fully enriched before uploading to Instantly, you can use conditional runs in Clay. Here's how: 1. Add an Instantly enrichment to your Clay table. 2. In the enrichment settings, configure it to add leads to your campaign. 3. Set up conditional runs using AI formulas to filter rows based on specific criteria. 4. Include all necessary fields you want to sync (e.g., email, first name, last name, company name). 5. Use the "!!" operator in your condition to check if fields are populated. For example, your condition might look like: !!{{Cleaned Company Name}} && !!{{Cleaned Job Title}} && !!{{Primary Niche}} This ensures the enrichment only runs when all required fields are populated, preventing premature uploads to Instantly.
Sources: Guide: Ways to save Clay credits | Documentation | Clay University Push Data To Your Email Sequencer [Automated Outbound] - Clay University Trouble with Clay and Instantly Integration: Leads Not Syncing Properly | Clay Push Data To Your Email Sequencer [Automated Outbound] - Clay University
Michael L.
·
·
No I do not think this is working for me based on what I just explained
Bruno R.
·
·
Hi Michael, thanks for your message and sorry about the delay here! Happy to take a closer look at the run conditions for the instantly column you're describing here. Could you share the url to the table where you're seeing this issue pop up in?
Michael L.
·
·
Hi Bruno R. thanks for getting back to me on this. I DM'd you the URL
Bruno R.
·
·
Thank you Michael - for the future, feel free to drop table links in the chat directly, noone else will be able to access your table but the team at Clay. Can you clarify the exact conditions that you want to meet with your formula to run the instantly push here? That would be something along the lines of: if "PS Line generation" is empty then run column etc.
Michael L.
·
·
Okay, thanks for the clarification and taking a look at my table. I would only like the Instantly enrichment to run (or push the leads) if all other enrichment's (or columns) have finished running
Michael L.
·
·
The formula screenshot that I sent was my attempt to achieve this. My thought was to have some sort of condition that states "Only run if xyz is NOT empty" or something along the lines of that
Michael L.
·
·
But what I have experienced here is that the instantly Enrichment pushed the data into Instantly before all the columns were finished running and left out some of those "persoanlization" columns that I needed to have as custom fields in my campaign
Michael L.
·
·
Then I supposed, when the columns (for those specific rows) finished running, it tried pushing those leads to Instantly again and ran into the "Skipped, already in..." and did not update the leads data fields
Bruno R.
·
·
Got it! It looks like you're on the right track here:
(139 kB)
I suggest that you list the exhaustive columns which you want to be completed before you run the instantly push in this AI prompt - the run conditions for this should be met once you add all the required inputs to run, and click on generate formula. Let me know if you run into any issues with configuring this!
Michael L.
·
·
I am not sure what you mean by exhaustive columns? The column that I created from the JSON data that came from the enrichment or the enrichment column itself?
Michael L.
·
·
And what I had done in the formula is list out all the JSON data that come from the enrichment's. Those are the columns that need to have data in them before any rows are pushed to Instantly.
Michael L.
·
·
So, if you are referring to creating a list from the JSON data the comes in from the enrichments for the ones I want to be "completed" before running the instantly push, I have the coulumns listed there in the screenshot you sent. How would you suggest I edit the formula or change it?
Bruno R.
·
·
Hi Michael, sorry about the confusion here, I mean all columns for which runs you want to wait to be completed before pushing data to instantly. Let me know if this makes sense.
Michael L.
·
·
Yes it does, I have them listed there