Mapping Linkedin Company Data to Glassdoor Ratings for Clay Integration

Mark S. · 2024-03-04 07:59:07.838818+00

Hi, I am able to extract Linkedin company data but I am having trouble mapping this to Glassdoor company ratings. Although I can ingest the Glassdoor data, Clay does not recognise the company. Is there a way to map these to sources together? Thanks

Mapping Linkedin Company Data to Glassdoor Ratings for Clay Integration | Clay

7 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Mark S.
·
·
https://app.clay.com/workspaces/233153/tables/t_wH0lguWtou9y/views/gv_rJWb4aDXcawZ
Clay Team
APP
·
·
Hey Mark, Sorry for the delay! I am checking your table🙏🏽
Mark S.
·
·
Hi Daniela. Any update please?
Clay Team
APP
·
·
Hey Mark, So sorry for the delay here. Catching up on a number of threads🙏🏽 Just to confirm - you ran the LinkedIn enrichment and used the domains in that array to run the Glassdoor company data, but it's missing data for some companies enriched in the LinkedIn column?
Mark S.
·
·
I ran a LinkedIn search and tried enriching with Glassdoor but it doesn’t return the company rating so I wanted to import a csv of Glassdoor with rating and map that to LinkedIn data but both files can’t recognize the company name and it can only pick up company names off the url. So essentially I want to be able import companies from LinkedIn or Glassdoor but must have the Glassdoor company rating. Any suggestion on how to achieve this? Thanks
Clay Team
APP
·
·
Hey Mark, So sorry for the delay here. Can you share the csv files you're trying to import? Let me check.Also, another way that could work would be to create a recipe similar to what you have in your Indeed column. First step here would be to get the Glassdoor urls. You can do this via Google search by typing {Company Name} inurl: glassdoor.com/Reviews. The fields this pulls include the Company's overall Glassdoor rating (see screenshot) but if you want other data points you can create a recipe and run that against the glassdoor urls you pull via the Google search column.Let me know if this helps! Also you can share the csv files you tried to import and I'll test those as well. How to map out your own recipe: https://www.loom.com/share/31a83c83ce794dfa86a6a91a27d7dd08
ef81f6ee-69ae-4d06-956f-b5a73e743d97.png(110 kB)
0c90e43b-af69-44f1-8e21-8482a05624ae.png(38 kB)

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Mark S.
·
·
https://app.clay.com/workspaces/233153/tables/t_wH0lguWtou9y/views/gv_rJWb4aDXcawZ
Clay Team
APP
·
·
Hey Mark, Sorry for the delay! I am checking your table🙏🏽
Mark S.
·
·
Hi Daniela. Any update please?
Clay Team
APP
·
·
Hey Mark, So sorry for the delay here. Catching up on a number of threads🙏🏽 Just to confirm - you ran the LinkedIn enrichment and used the domains in that array to run the Glassdoor company data, but it's missing data for some companies enriched in the LinkedIn column?
Mark S.
·
·
I ran a LinkedIn search and tried enriching with Glassdoor but it doesn’t return the company rating so I wanted to import a csv of Glassdoor with rating and map that to LinkedIn data but both files can’t recognize the company name and it can only pick up company names off the url. So essentially I want to be able import companies from LinkedIn or Glassdoor but must have the Glassdoor company rating. Any suggestion on how to achieve this? Thanks
Clay Team
APP
·
·
Hey Mark, So sorry for the delay here. Can you share the csv files you're trying to import? Let me check.Also, another way that could work would be to create a recipe similar to what you have in your Indeed column. First step here would be to get the Glassdoor urls. You can do this via Google search by typing {Company Name} inurl: glassdoor.com/Reviews. The fields this pulls include the Company's overall Glassdoor rating (see screenshot) but if you want other data points you can create a recipe and run that against the glassdoor urls you pull via the Google search column.Let me know if this helps! Also you can share the csv files you tried to import and I'll test those as well. How to map out your own recipe: https://www.loom.com/share/31a83c83ce794dfa86a6a91a27d7dd08
ef81f6ee-69ae-4d06-956f-b5a73e743d97.png(110 kB)
0c90e43b-af69-44f1-8e21-8482a05624ae.png(38 kB)