Clay Icon

Struggling with Poor Contact Returns and Merging Tables Efficiently

ยท
ยท

I've run a clay table and found businesses using a google search. I enriched that to find people, and have found about a third of the businesses have contacts. From there I've found about a half of that have email addresses. I'm not sure why I'm getting such a poor return rate and if I'm doing something wrong. Also , how can I merge the two tables together without downloading them both to Google sheets and manually doing it? Someone tried to send me a loom of how they did it, but they forgot to turn their mic on and their mouse arrow didn't move in comprehensible ways for much of it.

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    You can merge columns using write to other table enrichment

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    Hey there, happy to help! 1. Find contacts from Google Search: Have you tried our "Use Google Maps to find local businesses and their contact information"? If it doesn't help you to find more people and email addresses, let me know (please share your table link) and I'm happy to dive deeper into it :) 2. Merging tables: You can use the "Write to other Table" integration. Here's how you can do it: 1. Linking your Clay API key correctly. 2. Setting up the 'Write to Table' enrichment column. 3. Choosing to parse your arrays into an existing table or create a new table. 4. Writing your array of objects into individual rows. 5. Specifying which objects from the array you want to write to the new table and mapping them to the appropriate columns. 6. Optionally, adding other column values to the table if needed. And here's a video guide: https://www.clay.com/university/lesson/write-to-table-clay-101 If there's anything else I can assist you with, please let me know! ๐Ÿ˜Š Have a great Monday, Daniel

  • Avatar of Nadine B.
    Nadine B.
    ยท
    ยท

    Thank you very much. I will give that a try. I started to try to figure out that feature, but this will help.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • 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.