Excel LinkedIn Analytics: List of People and Updates from last week

What is it?

Next Analytics gets data from LinkedIn into a spreadsheet dashboard.  This dashboard is shows LinkedIn users in your network and provides a summary of the updates for each person in the network. 

Why Would I Use it?

The first question to answer is, what do you use LinkedIn for?  Mainly the networking.  This report lets you see lots of relevant detail about people in your network:

  • Who’s the most (and least) active in LinkedIn.  This might tell you the best way to communicate with them, give them a targeted message, or look for ways to group people.
  • Who’s making changes and in what area. Change means opportunity. When people announce a change, they are open to more communications. Use this to segment people in your network to choose how and what you communicate.
  • More generally, it’s nice to get a list of names in a spreadsheet! Lists are always convenient for prioritizing and communicating.

How Does It Work?

The LinkedIn updates are categorized into business user friendly groupings by Next Analytics. In doing this, Next Analytics converts and summarizes LinkedIn technical codes into business categories:

  • Jargon provided by LinkedIn is converted to its human friendly equivalent.
  • Things of similar purpose are combined.

Next Analytics automatically pivots the data into a crosstab. Crosstabs makes it easy to calculate a Total column, sort by that column, and even make an Excel chart.

blog linkedin user list with network updates in excel spreadsheet

While looking at the dashboard, users can click on the last name and a browser window opens to the person’s LinkedIn profile.

As it is shipped, this dashboard is limited the count to 500 names.  It’s very easy to expand or shrink this threshold by modifying a cell in the _actions worksheet.

Also, as it is shipped, this dashboard requests data for the “Past 1 Week”.  You can change this.  Your range of choices include:

  • From date to date
  • Yesterday
  • Today
  • DaysAgo N (you choose the value for N)
  • Past N weeks, months, years
  • LastCalendar N weeks, mediaweeks, months, years
  • ToDate N weeks, mediaweeks, months, years
  • Same time range but one year  ago
  • Same time range but previous period

You can also change it to exclude certain days such as: today, yesterday, 2daysago, and 3daysago.

To see this dashboard and to get a copy on your computer, just click this link: FirstImpressions-LinkedIn.xls

Just push a button to get your own data -- it’s very simple to use.

Next Analytics for Excel v3.0.17 or higher required.