Clay Icon
Join the Community
02 Support

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

Avatar of Tarek F.Tarek F.
·
·

Hey team! I was enriching this table with domain names, I had a lot of returns that were data providers domain emis.com, 6sense.com, northdata.com . 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 😞

9 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Tarek, thanks for reaching out, sorry for the extreme delay! Taking a look

  • Avatar of Clay Team
    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)

  • Avatar of Clay Team
    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 :)

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    I added a few credits back into the account too. Let me know if you have additional questions!

  • Avatar of Tarek F.
    Tarek F.
    ·
    ·

    Thank you Arturo O., 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?

  • Avatar of Tarek F.
    Tarek F.
    ·
    ·

    I'll keep your tip in mind, thank you for that 🙂

  • Avatar of Arturo O.
    Arturo O.
    ·
    ·

    Ah, sorry, I missed this reply

  • Avatar of Arturo O.
    Arturo O.
    ·
    ·

    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