Clay Icon
Join the Community
02 Support

Mapping Linkedin Company Data to Glassdoor Ratings for Clay Integration

Avatar of Mark S.Mark S.
·
·

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

7 comments

  • Avatar of Clay T.
    Clay T.
    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 😉

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey Mark, Sorry for the delay! I am checking your table🙏🏽

  • Avatar of Mark S.
    Mark S.
    ·
    ·

    Hi Daniela. Any update please?

  • Avatar of Clay T.
    Clay T.
    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?

  • Avatar of Mark S.
    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

  • Avatar of Clay T.
    Clay T.
    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)