Linkedin Company Insights Scraper

Linkedin Company Insights Scraper

Linkedin company insights scraper.

Extract company data for comprehensive analysis and buy intents.

Scrap data about:

• Employee count (with history and median tenure)
• Employee distribution and headcount growth by function
• Profile New hires
• Profile Notable company alumni (with exit date and their new position/company)
• Total job openings (with history)

Mandatory

Your linkedin account needs to be premium (or any kind of paid subscription)

How to extract cookies from your browser

• install EditThisCookie chrome extension
• login to your account and go to your clearbit home page
• Use the extension and click "export"
• Paste the cookies in the input "cookies" from the actor

The apify documentation has a tutorial on how to do it with screenshots, https://docs.apify.com/tutorials/log-in-by-transferring-cookies#export-your-cookies go to the export your cookies section

Output

Overview

1{
2  "url": "https://www.linkedin.com/company/google",
3  "people_url": "https://www.linkedin.com/company/google/people/",
4  "employee_6_months_growth_percent": 5,
5  "employee_12_months_growth_percent": 8,
6  "employee_24_months_growth_percent": 10,
7  "employees": 303026,
8  "employee_history": [
9    {
10      "employee": 276625,
11      "date": "01/11/2022",
12      "year": 2022,
13      "month": 11,
14      "day": 1
15    },
16    {
17      "employee": 276736,
18      "date": "01/12/2022",
19      "year": 2022,
20      "month": 12,
21      "day": 1
22    },
23    {
24      "employee": 277584,
25      "date": "01/01/2023",
26      "year": 2023,
27      "month": 1,
28      "day": 1
29    },
30    {
31      "employee": 277856,
32      "date": "01/02/2023",
33      "year": 2023,
34      "month": 2,
35      "day": 1
36    },
37    {
38      "employee": 275245,
39      "date": "01/03/2023",
40      "year": 2023,
41      "month": 3,
42      "day": 1
43    },
44    {
45      "employee": 274011,
46      "date": "01/04/2023",
47      "year": 2023,
48      "month": 4,
49      "day": 1
50    },
51    {
52      "employee": 274968,
53      "date": "01/05/2023",
54      "year": 2023,
55      "month": 5,
56      "day": 1
57    },
58    {
59      "employee": 276372,
60      "date": "01/06/2023",
61      "year": 2023,
62      "month": 6,
63      "day": 1
64    },
65    {
66      "employee": 277414,
67      "date": "01/07/2023",
68      "year": 2023,
69      "month": 7,
70      "day": 1
71    },
72    {
73      "employee": 276974,
74      "date": "01/08/2023",
75      "year": 2023,
76      "month": 8,
77      "day": 1
78    },
79    {
80      "employee": 277664,
81      "date": "01/09/2023",
82      "year": 2023,
83      "month": 9,
84      "day": 1
85    },
86    {
87      "employee": 279405,
88      "date": "01/10/2023",
89      "year": 2023,
90      "month": 10,
91      "day": 1
92    },
93    {
94      "employee": 280533,
95      "date": "01/11/2023",
96      "year": 2023,
97      "month": 11,
98      "day": 1
99    },
100    {
101      "employee": 280617,
102      "date": "01/12/2023",
103      "year": 2023,
104      "month": 12,
105      "day": 1
106    },
107    {
108      "employee": 282785,
109      "date": "01/01/2024",
110      "year": 2024,
111      "month": 1,
112      "day": 1
113    },
114    {
115      "employee": 284191,
116      "date": "01/02/2024",
117      "year": 2024,
118      "month": 2,
119      "day": 1
120    },
121    {
122      "employee": 284902,
123      "date": "01/03/2024",
124      "year": 2024,
125      "month": 3,
126      "day": 1
127    },
128    {
129      "employee": 286184,
130      "date": "01/04/2024",
131      "year": 2024,
132      "month": 4,
133      "day": 1
134    },
135    {
136      "employee": 289037,
137      "date": "01/05/2024",
138      "year": 2024,
139      "month": 5,
140      "day": 1
141    },
142    {
143      "employee": 291843,
144      "date": "01/06/2024",
145      "year": 2024,
146      "month": 6,
147      "day": 1
148    },
149    {
150      "employee": 294845,
151      "date": "01/07/2024",
152      "year": 2024,
153      "month": 7,
154      "day": 1
155    },
156    {
157      "employee": 296446,
158      "date": "01/08/2024",
159      "year": 2024,
160      "month": 8,
161      "day": 1
162    },
163    {
164      "employee": 298973,
165      "date": "01/09/2024",
166      "year": 2024,
167      "month": 9,
168      "day": 1
169    },
170    {
171      "employee": 301524,
172      "date": "01/10/2024",
173      "year": 2024,
174      "month": 10,
175      "day": 1
176    },
177    {
178      "employee": 303026,
179      "date": "01/11/2024",
180      "year": 2024,
181      "month": 11,
182      "day": 1
183    }
184  ],
185  "median_employee_tenure": "4.5 years",
186  "employee_distribution": [
187    {
188      "name": "Business Development",
189      "count": 12040,
190      "percentage": 4,
191      "last_6_months_growth_percent": 2,
192      "last_12_months_growth_percent": 4
193    },
194    {
195      "name": "Arts and Design",
196      "count": 12355,
197      "percentage": 4,
198      "last_6_months_growth_percent": 10,
199      "last_12_months_growth_percent": 17
200    },
201    {
202      "name": "Program and Project Management",
203      "count": 12271,
204      "percentage": 4,
205      "last_6_months_growth_percent": 1,
206      "last_12_months_growth_percent": 1
207    },
208    {
209      "name": "Product Management",
210      "count": 6630,
211      "percentage": 2,
212      "last_6_months_growth_percent": 0,
213      "last_12_months_growth_percent": -1
214    },
215    {
216      "name": "Operations",
217      "count": 9559,
218      "percentage": 3,
219      "last_6_months_growth_percent": 7,
220      "last_12_months_growth_percent": 10
221    },
222    {
223      "name": "Media and Communication",
224      "count": 77333,
225      "percentage": 26,
226      "last_6_months_growth_percent": 9,
227      "last_12_months_growth_percent": 15
228    },
229    {
230      "name": "Marketing",
231      "count": 12980,
232      "percentage": 4,
233      "last_6_months_growth_percent": 3,
234      "last_12_months_growth_percent": 2
235    },
236    {
237      "name": "Sales",
238      "count": 14495,
239      "percentage": 5,
240      "last_6_months_growth_percent": 2,
241      "last_12_months_growth_percent": 2
242    },
243    {
244      "name": "Information Technology",
245      "count": 14653,
246      "percentage": 5,
247      "last_6_months_growth_percent": 1,
248      "last_12_months_growth_percent": 1
249    },
250    {
251      "name": "Engineering",
252      "count": 80062,
253      "percentage": 26,
254      "last_6_months_growth_percent": 2,
255      "last_12_months_growth_percent": 2
256    },
257    {
258      "name": "Education",
259      "count": 6788,
260      "percentage": 2,
261      "last_6_months_growth_percent": 18,
262      "last_12_months_growth_percent": 34
263    },
264    {
265      "name": "Other",
266      "count": 43860,
267      "percentage": 15
268    }
269  ],
270  "date_headcount": "01/11/2024",
271  "hires_history": [
272    {
273      "total_hires": 3319,
274      "senior_hires": 23,
275      "date": "01/11/2022"
276    },
277    {
278      "total_hires": 1740,
279      "senior_hires": 5,
280      "date": "01/12/2022"
281    },
282    {
283      "total_hires": 2490,
284      "senior_hires": 12,
285      "date": "01/01/2023"
286    },
287    {
288      "total_hires": 1391,
289      "senior_hires": 5,
290      "date": "01/02/2023"
291    },
292    {
293      "total_hires": 1287,
294      "senior_hires": 5,
295      "date": "01/03/2023"
296    },
297    {
298      "total_hires": 1154,
299      "senior_hires": 8,
300      "date": "01/04/2023"
301    },
302    {
303      "total_hires": 2950,
304      "senior_hires": 6,
305      "date": "01/05/2023"
306    },
307    {
308      "total_hires": 2477,
309      "senior_hires": 4,
310      "date": "01/06/2023"
311    },
312    {
313      "total_hires": 2309,
314      "senior_hires": 7,
315      "date": "01/07/2023"
316    },
317    {
318      "total_hires": 2093,
319      "senior_hires": 5,
320      "date": "01/08/2023"
321    },
322    {
323      "total_hires": 2126,
324      "senior_hires": 7,
325      "date": "01/09/2023"
326    },
327    {
328      "total_hires": 1872,
329      "senior_hires": 2,
330      "date": "01/10/2023"
331    },
332    {
333      "total_hires": 1412,
334      "senior_hires": 3,
335      "date": "01/11/2023"
336    },
337    {
338      "total_hires": 962,
339      "senior_hires": 4,
340      "date": "01/12/2023"
341    },
342    {
343      "total_hires": 1896,
344      "senior_hires": 5,
345      "date": "01/01/2024"
346    },
347    {
348      "total_hires": 1056,
349      "senior_hires": 4,
350      "date": "01/02/2024"
351    },
352    {
353      "total_hires": 1372,
354      "senior_hires": 5,
355      "date": "01/03/2024"
356    },
357    {
358      "total_hires": 1629,
359      "senior_hires": 2,
360      "date": "01/04/2024"
361    },
362    {
363      "total_hires": 2767,
364      "senior_hires": 1,
365      "date": "01/05/2024"
366    },
367    {
368      "total_hires": 2263,
369      "senior_hires": 1,
370      "date": "01/06/2024"
371    },
372    {
373      "total_hires": 2434,
374      "senior_hires": 4,
375      "date": "01/07/2024"
376    },
377    {
378      "total_hires": 1782,
379      "senior_hires": 4,
380      "date": "01/08/2024"
381    },
382    {
383      "total_hires": 1679,
384      "senior_hires": 2,
385      "date": "01/09/2024"
386    },
387    {
388      "total_hires": 1352,
389      "senior_hires": 3,
390      "date": "01/10/2024"
391    },
392    {
393      "total_hires": 574,
394      "senior_hires": 2,
395      "date": "01/11/2024"
396    }
397  ],
398  "total_hires_history": 46386,
399  "total_senior_hires_history": 119,
400  "job_opening_distribution": [
401    {
402      "name": "Business Development",
403      "count": 361,
404      "percentage": 5,
405      "last_3_months_growth_percent": 37,
406      "last_6_months_growth_percent": 70
407    },
408    {
409      "name": "Arts and Design",
410      "count": 158,
411      "percentage": 2,
412      "last_3_months_growth_percent": -17,
413      "last_6_months_growth_percent": 82
414    },
415    {
416      "name": "Program and Project Management",
417      "count": 756,
418      "percentage": 10,
419      "last_3_months_growth_percent": 24,
420      "last_6_months_growth_percent": 63
421    },
422    {
423      "name": "Product Management",
424      "count": 429,
425      "percentage": 6,
426      "last_3_months_growth_percent": 10,
427      "last_6_months_growth_percent": 95
428    },
429    {
430      "name": "Operations",
431      "count": 437,
432      "percentage": 6,
433      "last_3_months_growth_percent": 33,
434      "last_6_months_growth_percent": 71
435    },
436    {
437      "name": "Media and Communication",
438      "count": 113,
439      "percentage": 1,
440      "last_3_months_growth_percent": 19,
441      "last_6_months_growth_percent": 69
442    },
443    {
444      "name": "Marketing",
445      "count": 267,
446      "percentage": 3,
447      "last_3_months_growth_percent": 15,
448      "last_6_months_growth_percent": 105
449    },
450    {
451      "name": "Support",
452      "count": 185,
453      "percentage": 2,
454      "last_3_months_growth_percent": 11,
455      "last_6_months_growth_percent": -21
456    },
457    {
458      "name": "Sales",
459      "count": 391,
460      "percentage": 5,
461      "last_3_months_growth_percent": -4,
462      "last_6_months_growth_percent": 1
463    },
464    {
465      "name": "Information Technology",
466      "count": 865,
467      "percentage": 11,
468      "last_3_months_growth_percent": 24,
469      "last_6_months_growth_percent": 79
470    },
471    {
472      "name": "Research",
473      "count": 154,
474      "percentage": 2,
475      "last_3_months_growth_percent": 11,
476      "last_6_months_growth_percent": 152
477    },
478    {
479      "name": "Engineering",
480      "count": 2817,
481      "percentage": 37,
482      "last_3_months_growth_percent": 14,
483      "last_6_months_growth_percent": 56
484    },
485    {
486      "name": "Other",
487      "count": 753,
488      "percentage": 10
489    }
490  ],
491  "job_history": {
492    "Engineering": {
493      "01/09/2024": {
494        "percent": 37,
495        "count": 2817
496      },
497      "01/06/2024": {
498        "percent": 38,
499        "count": 2465
500      },
501      "01/03/2024": {
502        "percent": 37,
503        "count": 1805
504      }
505    },
506    "Information Technology": {
507      "01/09/2024": {
508        "percent": 11,
509        "count": 865
510      },
511      "01/06/2024": {
512        "percent": 11,
513        "count": 695
514      },
515      "01/03/2024": {
516        "percent": 10,
517        "count": 483
518      }
519    },
520    "Program and Project Management": {
521      "01/09/2024": {
522        "percent": 10,
523        "count": 756
524      },
525      "01/06/2024": {
526        "percent": 9,
527        "count": 611
528      },
529      "01/03/2024": {
530        "percent": 9,
531        "count": 464
532      }
533    },
534    "Other": {
535      "01/09/2024": {
536        "percent": 10,
537        "count": 753
538      },
539      "01/06/2024": {
540        "percent": 9,
541        "count": 590
542      },
543      "01/03/2024": {
544        "percent": 10,
545        "count": 481
546      }
547    },
548    "Operations": {
549      "01/09/2024": {
550        "percent": 6,
551        "count": 437
552      },
553      "01/06/2024": {
554        "percent": 5,
555        "count": 329
556      },
557      "01/03/2024": {
558        "percent": 5,
559        "count": 255
560      }
561    },
562    "Product Management": {
563      "01/09/2024": {
564        "percent": 6,
565        "count": 429
566      },
567      "01/06/2024": {
568        "percent": 6,
569        "count": 389
570      },
571      "01/03/2024": {
572        "percent": 4,
573        "count": 220
574      }
575    },
576    "Sales": {
577      "01/09/2024": {
578        "percent": 5,
579        "count": 391
580      },
581      "01/06/2024": {
582        "percent": 6,
583        "count": 407
584      },
585      "01/03/2024": {
586        "percent": 8,
587        "count": 389
588      }
589    },
590    "Business Development": {
591      "01/09/2024": {
592        "percent": 5,
593        "count": 361
594      },
595      "01/06/2024": {
596        "percent": 4,
597        "count": 263
598      },
599      "01/03/2024": {
600        "percent": 4,
601        "count": 212
602      }
603    },
604    "Marketing": {
605      "01/09/2024": {
606        "percent": 3,
607        "count": 267
608      },
609      "01/06/2024": {
610        "percent": 4,
611        "count": 233
612      },
613      "01/03/2024": {
614        "percent": 3,
615        "count": 130
616      }
617    },
618    "Support": {
619      "01/09/2024": {
620        "percent": 2,
621        "count": 185
622      },
623      "01/06/2024": {
624        "percent": 3,
625        "count": 166
626      },
627      "01/03/2024": {
628        "percent": 5,
629        "count": 235
630      }
631    },
632    "Arts and Design": {
633      "01/09/2024": {
634        "percent": 2,
635        "count": 158
636      },
637      "01/06/2024": {
638        "percent": 3,
639        "count": 191
640      },
641      "01/03/2024": {
642        "percent": 2,
643        "count": 87
644      }
645    },
646    "Research": {
647      "01/09/2024": {
648        "percent": 2,
649        "count": 154
650      },
651      "01/06/2024": {
652        "percent": 2,
653        "count": 139
654      },
655      "01/03/2024": {
656        "percent": 1,
657        "count": 61
658      }
659    },
660    "Media and Communication": {
661      "01/09/2024": {
662        "percent": 1,
663        "count": 113
664      },
665      "01/06/2024": {
666        "percent": 1,
667        "count": 95
668      },
669      "01/03/2024": {
670        "percent": 1,
671        "count": 67
672      }
673    }
674  },
675  "total_job_openings": 7686,
676  "total_job_openings_3_months_ago": 6573,
677  "total_job_openings_6_months_ago": 4889,
678  "total_job_openings_3_months_growth": 17,
679  "total_job_openings_6_months_growth": 57
680}

Profile New Hires

1{
2  "profile_hires_hire_date": "Vice President of Product - Google Workspace",
3  "profile_hires_hired_position": "01/11/2024",
4  "profile_hires_network_distance": "3rd",
5  "profile_hires_linkedin": "https://www.linkedin.com/in/ACoAAACUuVgBUURzO6NaA9N4AQmRZ3erwXG4R74",
6  "profile_hires_full_name": "George Kwon",
7  "profile_hires_picture": "https://media.licdn.com/dms/image/v2/D5603AQFDDu76w3E97g/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1671122499496?e=1738195200&v=beta&t=_5YKVwagWMDt8SElyyfPsXYKZ_xDkWeHZz_YvR3Cw44",
8  "profile_hires_profile_type": "HIRES",
9  "profile_hires_input_url": "https://www.linkedin.com/company/google"
10}

Profile Alumni

1{
2  "profile_alumni_exit_date": "Previously Senior Director / Distinguished Software Engineer - Bard at Google ",
3  "profile_alumni_exited_position": "01/11/2024",
4  "profile_alumni_network_distance": "3rd",
5  "profile_alumni_linkedin": "https://www.linkedin.com/in/ACoAAAAxP3oBNUT0GlG8KLYHXlYdtwFVETxlBtk",
6  "profile_alumni_full_name": "Alex Gruenstein",
7  "profile_alumni_picture": "https://media.licdn.com/dms/image/v2/C5603AQEA3_lJ4JAdqQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1587925287367?e=1738195200&v=beta&t=2zyDyksvNekXybL8juHHMyYxri_WoTUTLEovpKnJ1Vg",
8  "profile_alumni_profile_type": "ALUMNI",
9  "profile_alumni_input_url": "https://www.linkedin.com/company/google"
10}