How to Upload CSV and Use Domain as Join Key for Data Enrichment

Eliot S.

hey - does anybody know how to upload a CSV and use domain as a join key to enrich columns with data?

4 comments

Channeled
APP
·
·
Here's how to upload your CSV and enrich it using domain as a join key: 1. First, import your CSV: • Go to your workspace home and select "Create new" • Choose "Import from CSV" • Upload your CSV file • Select "New blank table" • Click "Complete import" 2. Once your data is imported, you can enrich it using various integrations. For example, with DropContact: • Click "Actions" in your table • Select the "Find Company Name from Company Domain" action • Choose your DropContact account • Select your domain column as the input 3. To map the enriched data: • Use the "Write to Other Table" feature to map the enriched data to your desired columns • You can set up auto-update to keep the data fresh • Optionally, set conditions for when the enrichment should run
Sources: DropContact integration overview | Documentation | Clay University Import a File Upload CSV to your table - Clay University Write to Other Table | Documentation | Clay University
Eliot S.
·
·
This doesn't work, it creates new rows instead of adding column values based on Domain matching
Daniel K.
·
·
Hey there, thanks for reaching out! ☺️ So what you'll want to do here is import the CSV file to a Clay table. You can do this by selecting "create table" in your workspace's homepage and the selecting "import from csv":
(786 kB)
You'll want to create a new table to host your company name data. The following step will be to run a waterfall enrichment to return the company domains. Here's how you can set this up: https://cln.sh/btTSxcQL Finally, I suggest that you use Claygent, our AI webscraping agent, to reason on the domain's contents and identify the companies' ICP. There are a few templates which should help you set this up:
(128 kB)
Here's a video showing you how to use Claygent at its full potential: https://www.clay.com/university/lesson/claygent-ai-web-scraper-clay-101. I hope this was helpful. If there's anything else I can assist you with, please let me know!
Channeled
APP
·
·