Emergency: Data Mishap Caused Enriched Contacts and Credit Loss!

My client just pushed additional data to a different table and it totally zeroed out all enriched contacts and it also blew thru a ton of credits. Help!!!

44 comments

Jeanne M.
·
·
https://app.clay.com/workspaces/11130/tables/t_effJMNpDfgd5/views/gv_U8rwm0mkXBJM
Jeanne M.
·
·
Also isnt there a way to stop it writing??
Clay Team
APP
·
·
Hey Jeanne, appreciate your patience! Taking a look now
Clay Team
APP
·
·
Also, how many credits did it go through?
Jeanne M.
·
·
~1100. It was at 10K and it’s now at 8919
Jeanne M.
·
·
When I was with him to rerun the apollo since the google one messed it up and he deleted it, It’s now rerunning every credit
Jeanne M.
·
·
He upgraded his plan too
Clay Team
APP
·
·
I see, yep. That's the current behavior of workflows to be aware of, when something changes in a source that could affect or even change the values of other columns that depend on this source it will re-run them.To prevent this, you can turn the table 'off'
ea92ba6f-4318-44e5-b7bd-ecc50d5c13c9.png(8 kB)
Clay Team
APP
·
·
Or you can also turn each individual column off instead
57bab2c9-1938-4d1f-9095-59fb71c4303b.png(101 kB)
Jeanne M.
·
·
even if it’s in the “other data” section? For exmaple, he was trying to get the phone number from the mid metros to push to a new column for a company phone in the people
Clay Team
APP
·
·
Quick note, if things or inputs change, the following values may become outdated and that's why they re-run because they're trying to stay up to date but if the input didn't change at all it shouldn't run.
Clay Team
APP
·
·
When you're trying to push new columns with Write to table it unfortuantely doesn't work as a lookup to append existing records and it will only create new ones below in the target table.
Jeanne M.
·
·
gotcha. So how would he push that one only then? Just unselect auto update?
Jeanne M.
·
·
How does he fix the ones it blew thru?
Clay Team
APP
·
·
I see they're just duplicates so we can just remove those. If you click on a column that likely has the duplicate values, the dropdown should have a Dedupe option.
8feba45a-4bb8-4fdc-bea9-7ca95b0bae7d.png(19 kB)
Clay Team
APP
·
·
I'll refund the credits though, it won't do it automatically because the providers already processed the request.
Jeanne M.
·
·
OK So essentially he has to rerun the whole page?
Jeanne M.
·
·
I guess i dont understand why it zeroed out the entire sheet?
Clay Team
APP
·
·
Not necessarily, there is a lookup integration that could help in cases like that.
Clay Team
APP
·
·
I'll try to find something to match it to in both tables and use it instead to pull the other columns
Jeanne M.
·
·
all the rows were complete yesterday
Clay Team
APP
·
·
No worries, if it's easier, I'll just re-do and refund. That's probably less messy
Clay Team
APP
·
·
what data points did he need to push over, or what column are they from?
Jeanne M.
·
·
https://app.clay.com/workspaces/11130/tables/t_effJMNpDfgd5/views/gv_U8rwm0mkXBJM This column from this table
👍1
Jeanne M.
·
·
thank you!
✨1
Clay Team
APP
·
·
Okay, sorry for the delay. Had to modify a few things to ensure it was properly passed over and to make sure the email waterfall only runs after apollo does
Clay Team
APP
·
·
Due to Apollo's very low rates though, it has be ran for the remaining rows every so often, manually.
Jeanne M.
·
·
K i hear ya. I’m confused - all these people were enriched yesterday?
Jeanne M.
·
·
That whole column in peoople
Clay Team
APP
·
·
Yep, since we had to re-do this, unfortunately, there are no current options to restore the table version or history :/... If you'd like to skip that step and still get emails from the other providers while the rate limits for Apollo refresh then let me know
Jeanne M.
·
·
How do I get it to fill back in basically is what i’m trying to figure out
Clay Team
APP
·
·
You can click on the play button on top of the column header to re-run once Apollo allows the API to run again in a few moments.. Example screenshot
Jeanne M.
·
·
ok great. thanks!
Jeanne M.
·
·
He reran it and all set! So if he wants to add a column in the new worksheet from Apollo enrich that says if it’s the primary location / HQ, he’d
1.
Add a column to the https://app.clay.com/workspaces/11130/tables/t_q6XyciPQeCDr/views/gv_Rc17bKtH4ybD
2.
How would you add HQ
✨1
Clay Team
APP
·
·
Nice!
Clay Team
APP
·
·
So for that, you can follow the part of the video I sent where it explains the write to table setup. You have to add the empty column in the target table, then map it in Write to table so it includes it in the export process.
Jeanne M.
·
·
and it wont delete all the other enrichment?
Clay Team
APP
·
·
No, it shouldn't since it only maps out the selected columns, all other columns that exist there should remain and only run when the input is available. The data will be lost if the rows or columns are deleted though
Clay Team
APP
·
·
And if the input that those enrichments depend on changes, that's when they also re-run
Jeanne M.
·
·
and to confirm its here at min 5:19? https://www.loom.com/share/dd806edd91dc4927a4fa9a00b98a73d0
Clay Team
APP
·
·
yep, that would be it
Jeanne M.
·
·
He tried a few different ways and cannot see how to get HQ https://app.clay.com/workspaces/11130/tables/t_effJMNpDfgd5/views/gv_U8rwm0mkXBJM Why would that have not worked? He also tried via apollo but could not find HQ or primary location
Jeanne M.
·
·
Any thoughts?
Clay Team
APP
·
·
Hmm, if Apollo is not returning that information but if it can find a company's LinkedIn URL, then you could Enrich Company via LinkedIn instead. Otherwise, a google search or another Claygent column could browse the web and get that for you

Emergency: Data Mishap Caused Enriched Contacts and Credit Loss! | Clay