Clay Icon
Join the Community
02 Support

Filling Company Data in Contacts Table: Addressing Missing Information

Avatar of Michiel v.Michiel v.
·
·

I have created a Companies table, and created a second table using “Find contacts at company” In some of the results in the Contacts table, the Company Name is not filled because “Company Record ID is blank” and the Company Domain is also blank. How can I make sure this data gets filled? Without it, we don’t know at which company a person works

4 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To ensure the Company Name, Company Record ID, and Company Domain fields are filled in the Contacts table when using "Find contacts at company", follow these steps: 1. Use a reliable Company Identifier when searching for contacts. The best option is the Company LinkedIn URL, followed by the Company Domain. 2. If you're missing Company Names, consider using the "Find Company Name from Company Domain" action with DropContact. This can help fill in missing company names based on domains. 3. For missing Company Domains, use the "Find Company Name from Company Domain" action in reverse. Input the company name to retrieve the domain. 4. Ensure your initial Companies table has complete and accurate data before running the "Find contacts at company" action. If you're still experiencing issues after trying these steps, you may need further assistance. In that case, please request human support by clicking on "Talk to a person" in this chat.

  • Avatar of Michiel v.
    Michiel v.
    ·
    ·

    I am using the LinkedIn URL as the identifier, which is filled in every row in the source table

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    If you're using the LinkedIn URL as the identifier and still experiencing issues with missing data, try these steps: 1. Ensure the LinkedIn URL is correct and valid for each company. 2. Double-check that the "Company Identifier" field in the "Find contacts at company" action is set to use the column containing the LinkedIn URLs. 3. Verify that the LinkedIn URLs in your source table are in the correct format (e.g., https://www.linkedin.com/company/company-name). 4. If issues persist, consider using the "Enrich Company" action before running "Find contacts at company" to ensure comprehensive company data. If you're still experiencing problems after trying these steps, you may need further assistance. In that case, please request human support by clicking on "Talk to a person" in this chat.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.