Issues with Clay Table: Missing URL Column and Data Location Anomalies | Clay

Issues with Clay Table: Missing URL Column and Data Location Anomalies

Hi Clay team- I have a clay table and am ready to "find people at companies" but the column with the domain url is not available to select. I only have the options of Company Name, Title and Location columns in the table. Why isn't the company url column available to select? Here's the table: https://app.clay.com/workspaces/507736/workbooks/wb_NFfNxS5AZDkx/tables/t_wkTTHdRoonAS/views/gv_J2hemjmiC5Z3 also, and this may be a question for apify as i pulled data from apify to create the table, but after setting the location for data to be in California i got 10 rows of CA location data and then 10 rows of data with Turkey as location. Any suggestions on why it pulled data from Turkey?

12 comments

Channeled
APP
·
·
I understand you're having trouble with the company URL column and location data in your Clay table. Let me address each issue: 1. Company URL column: Not all data points are available within the Find Companies modal. Some attributes, like the company URL, may require additional enrichment after building your initial list. You'll need to add this enrichment separately in the table after importing your data. 2. Location data from Turkey: It's unusual that Apify pulled data from Turkey when you set the location to California. This could be due to how the Apify actor is configured or potential limitations in the data source. To better assist you, could you provide more details about the specific Apify actor you used and any filters you applied during the data collection process?
Source: Find Companies [Clay 101] - Clay University
Adam G.
·
·
Here's the table: 736/workbooks/wb_NFfNxS5AZDkx/tables/t_wkTTHdRoonAS/views/gv_J2hemjmiC5Z3 Need to point the find people enrichment to the /company url column but do not have this option.
Bruno R.
·
·
Hi Adam, thanks for your message! You'll need to parse the domain which claygent found here into an individual column for the find people action to pick up on the unique identifier to run the search. Here's how you can do this::[https:://www.loom.com/share/fd48450d1bb14427a44fdf0da208cea0?sid=ec693828-4d05-4971-8110-9a3bddd0831b](https://www.loom.com/share/fd48450d1bb14427a44fdf0da208cea0?sid=ec693828-4d05-4971-8110-9a3bddd0831b) I hope this was helpful. If there's anything else I can assist you with, please let me know!
Adam G.
·
·
Bruno R. Thanks that was very helpful. So in general, to find people at companies, i need to take 1 more step to parse out the domain. I can't just point it to the ai generated company url column. Got it!
Adam G.
·
·
btw- was there audio in the loom you sent? If so, i was not able to hear it.
Bruno R.
·
·
Looks like my microphone was turned off during the video - let me know if I can support you with anything else here!
Adam G.
·
·
just dropped another question in the support channel Bruno R. and tagged you
Adam G.
·
·
Hi Clay Team- quick question- here's the table Bruno R. https://app.clay.com/workspaces/507736/workbooks/wb_NFfNxS5AZDkx/tables/t_wkTTHdRoonAS/views/gv_J2hemjmiC5Z3 want to filter on a column but do not get the right options in the filter box. It's a True/False column. Should be able to filter for true or false. Don't see the option in the column "ICP Company Hiring Guards" (edited) image.png
Bruno R.
·
·
Hi Adam, you'll need to parse out the results from the claygent column to actually filter the boolean values, in this case the outputs are still just text. Once you parse out the response in an individual column, you'll be able to filter by "true" or "false" accordingly.
(214 kB)
Adam G.
·
·
Bruno R. got it thx!
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Adam G.!