Troubles with data enrichment and domain names: inconsistent formatting and no results from Owler billing

Tarek FAYED · 2024-01-15 20:03:23.21395+00

Hey team! I was enriching this table with domain names, I had a lot of returns that were data providers domain , , . Also, the formatting from revenue enrichment is not the same for Clay, Clearbit and Owler. Also, I got charged from Owler for the enrichment but with no results :disappointed:

Troubles with data enrichment and domain names: inconsistent formatting and no results from Owler billing | Clay

9 comments

· Sorted by Oldest

Tarek FAYED
·
·
https://app.clay.com/workspaces/45198/tables/t_jPvBwjxuHQql/views/gv_YX34C8x1ejft
Clay Team
APP
·
·
Hey Tarek, thanks for reaching out, sorry for the extreme delay! Taking a look
Clay Team
APP
·
·
Yep, about Owler, unfortunately, that's their policy to charge even when no data is found since they still consider that call a cost for them too:( -> (a few other providers have similar policies and in other cases, we eat up that cost and refund you but it's mainly for most sought out data points like emails and such)
Clay Team
APP
·
·
Optimal flow/suggestion, since you're finding domains for the same companies several times over when you have a list with multiple contacts from the same company in a CSV or whatever source. Import and create two tables, 1 table for company enrichments only and the other one for all contacts.In the company table, dedupe by company name (in this example) or depending on what repeat company value you have so you end up with 1 company per row. Then you enrich and save credits that way.Then you can pull all that new data you found over to the people table by using the Lookup Record in Other Table integration :)
Clay Team
APP
·
·
I added a few credits back into the account too. Let me know if you have additional questions!
Tarek FAYED
·
·
Thank you Arturo (Clay), I have just one question regarding the formatting of the revenue, it's not consistent between Clearbit, Owler and Clay, is there a way to unify it?
Tarek FAYED
·
·
I'll keep your tip in mind, thank you for that 🙂
Arturo (Clay)
·
·
Ah, sorry, I missed this reply
Arturo (Clay)
·
·
So, if all values are getting consolidated in a final column, you can ask the formula generator to return it in a specific format. Quick caveat, make sure the column type is set to text if you want it to include commas or other symbols... otherwise, if you just need the number without anything, you can also ask it to return the numbers only from any of those three sources and keep it as a number-type column in case you need to apply filters to it

Tarek FAYED
·
·
https://app.clay.com/workspaces/45198/tables/t_jPvBwjxuHQql/views/gv_YX34C8x1ejft
Clay Team
APP
·
·
Hey Tarek, thanks for reaching out, sorry for the extreme delay! Taking a look
Clay Team
APP
·
·
Yep, about Owler, unfortunately, that's their policy to charge even when no data is found since they still consider that call a cost for them too:( -> (a few other providers have similar policies and in other cases, we eat up that cost and refund you but it's mainly for most sought out data points like emails and such)
Clay Team
APP
·
·
Optimal flow/suggestion, since you're finding domains for the same companies several times over when you have a list with multiple contacts from the same company in a CSV or whatever source. Import and create two tables, 1 table for company enrichments only and the other one for all contacts.In the company table, dedupe by company name (in this example) or depending on what repeat company value you have so you end up with 1 company per row. Then you enrich and save credits that way.Then you can pull all that new data you found over to the people table by using the Lookup Record in Other Table integration :)
Clay Team
APP
·
·
I added a few credits back into the account too. Let me know if you have additional questions!
Tarek FAYED
·
·
Thank you Arturo (Clay), I have just one question regarding the formatting of the revenue, it's not consistent between Clearbit, Owler and Clay, is there a way to unify it?
Tarek FAYED
·
·
I'll keep your tip in mind, thank you for that 🙂
Arturo (Clay)
·
·
Ah, sorry, I missed this reply
Arturo (Clay)
·
·
So, if all values are getting consolidated in a final column, you can ask the formula generator to return it in a specific format. Quick caveat, make sure the column type is set to text if you want it to include commas or other symbols... otherwise, if you just need the number without anything, you can also ask it to return the numbers only from any of those three sources and keep it as a number-type column in case you need to apply filters to it