Guide to visualising LinkedIn Networks with Google Drive / Docs


LinkedIn Business Pages offer insights about the company’s employee network but nothing about its followers other then viewing their public profiles if not connected. LinkedIn is expected to roll out analytics for followers ‘soon’ as customer service said:  ’… about the analytics page, this feature should be coming out very soon. I appreciate your patience in the meanwhile‘.

The current stats for a company’s employees offer info like:

  • previous company
  • location
  • who has the most recommendations in the network
  • ex employees and their former positions
  • shows you how connected you are with the company’s network of employees
  • what other companies do visitors view (nice way to spot competition)
Below is your network visualised by LinkedIn. Pretty and pretty useless.

Meanwhile, I still wanted to find out who the followers are for the company I’m working for, where they work, live, if they coincide with the employees or not and so on.

So I set out to scrape data off their profiles and use it as raw data for a network visualisation. The recipe is:

Google Drive (maiden name Docs) does the magic for you. Open a new spreadsheet, paste the links to the public profiles of the people you want to know more about in a column and the next columns will be the where the data is pulled in.

LinkedIn is very sensitive about privacy. Here is a reply from LinkedIn customer service:

If you are signed in to Linkedin.com, you can see the name and full LinkedIn profile of the members who are in your network. You can only see a shortened profile without name for the members who are out of your network. You can also see the email address of your 1st degree connections. 

So you can collect the information what you can see on your networks profile. I understand that you are the admin for your company page, however, the profile visibility will remain the same.

Formulas . This article really sorted me out (thank you for the tip, Dave Harte). It only gives you the formulas for the basic stuff like location, job description, number of connection, etc. but you can look for more formulas (there’s quite a nice community out there interested in ImportXML).

 

*set the cells right otherwise it won’t work. For example, this one only works for the link in cell A2 ‘=ImportXML(A2, “//a[@class='user']“)’*
Once you figured out how the formulas work and you had that magic moment when you drag the corner of a cell and it fills in with new data corresponding to a new link, you’ll notice that Google Spreadsheets limits the number of ImportXML functions to 50. What you can do is paste them in a offline spreadsheet. The data is not automatically refreshed; maybe there is a way of synchronising them.

 

*when pulling in job descriptions the text tends to spread over several columns. To pull all together in the same cell use this formula =+D2&”"&E2*

 

Here is a beginner’s guide to ImportXML (written in a lovely amusing way). The tool works on many other platforms so you can get creative with it.

 

Raw data. I had an attempt to visualise my data with Tableau Public. It produces interactive data visualisations, allowing the user to play with the data filters. However I found this platform a bit clunky and it would’ve taken me more time to figure out how to use it then to actually do the work. I felt they have a strong, passionate community very eager to help.

 

Something interesting I did with the job descriptions I scraped was running the text through this keyword density checker.

 Afterwards I selected the most used keywords and made a glossy word cloud with Image Chef. Wordle never seemed to work.
Data visualisation. I opted mainly for graphs in Excel (lame, I know) but for a rookie like me it worked perfectly. Besides, the people you are presenting the data to is very important in how you want to wrap the data. I was pitching to a corporate audience so the not very appealing, old school Excel graphs did the trick. Check out this article for great recommendations on Online Infographic generators.  So far I only tried Ease.ly and it is proper glossy.

 

Uses. If you have the patience to use it, it gives a real knowledge of the networks you are probing, helps identify the key influencers (number of connection, recommendations), it unearths trends (people leaving one company for another) and many more depending on what you set out to do.

 

I’m interested to discuss with you on more uses of this great tool, improvements to my first attempt described above and how you get on with LinkedIn for Businesses as I am currently trying to get my head around LinkedIn B2B very niche groups.

 

Cheers!
About these ads

Your comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s