How to record LinkedIn post stats

How to log LinkedIn post stats

Log your LinkedIn post analytics in a spreadsheet so you can do more of what works

It’s important to know what works on LinkedIn so that you can post content that’s effective for your audience. Do text posts work best for you? Do you get more comments from video posts? What are your most popular posts?

This post shows how I record this information.

Did you know?

Your LinkedIn post analytics are available for 60 days from creation.

Your LinkedIn article analytics are available for 2 years from creation.

Video explainer: how I log my LinkedIn post stats

This video explains my process for recording LinkedIn post stats.

⬆️ Back to top

How the LinkedIn stats spreadsheet works

I use 2 tabs for recording my LinkedIn post stats:

  • Stats: all the details for each post
  • Summary: a calculated summary of performance

Stats tab

I’ll cover this tab in order of the columns.

URL column
I copy the link for each LinkedIn post and paste it here for future reference.

To get the URL of a post, click the ellipsis (…) menu in the top-right corner of the post and click Copy link to post.

Use the ellipsis (…) menu to copy the link to a post

Use the ellipsis (…) menu to copy the link to a post

Because LinkedIn URLs are long and not that nice to read in an Excel sheet, I narrow the column and set the text to fit the cells.

The text becomes unreadably small but that’s OK because clicking on any cell reveals the full text in the cell bar at the top of Excel.

To make sure I haven’t pasted in the wrong type of content into the cell, I use a conditional formatting rule on the first column. The rule says that if a cell contains ‘https’ (i.e. the start of a LinkedIn web address) then the cell is automatically coloured green.

Conditional formatting to highlight all cells containing HTTPS in green

Conditional formatting to highlight all cells containing HTTPS in green

Conditional formatting sounds fancy, but it’s just a way of applying simple rules to a range of cells.

Title column
I always start my LinkedIn posts with an emoji and a single line of text. I copy that single line of text into this column, and it acts as the title of my post.

Type column
The type of post: it’s always Text, Image, Video or Doc.

Views, Likes and Comments columns
These should be self-evident. Each post displays a count of the views, likes and comments. I take readings 2 weeks after I originally publish each post.

Shares column
When you click the view counter on LinkedIn desktop, a new panel opens that is meant to show how many times the post was shared. In practice, this often doesn’t work. The panel opens but doesn’t always reveal the share count.

The tricky bit is that this is the correct behaviour if the post hasn’t been shared. Rather than showing something sensible such as ‘Shares: 0’, LinkedIn opts not to show any share information at all.

But if the post has been shared and the data isn’t shown in the panel, you might think that there have been no shares. Frustrating!

The most reliable way to check for shares is to look at the same view stats panel on the LinkedIn mobile app.

Also, if you use a branded hashtag on your posts, searching LinkedIn for that hashtag will reveal shares of your posts. You can do this on LinkedIn desktop, which makes it a more convenient way of discovering shares.

Date posted column
The original date of publication.

Excel tip

Press Ctrl-; to insert the current date in a cell. Works on macOS and Windows.

Date checked column
I set this to 2 weeks after the Date posted date by using a formula that adds 14 (for days) to the Date posted cell value.

Add 14 days to the Date posted figure

Add 14 days to the Date posted figure

To make it easier for me to spot when those 2 weeks are up, I use more conditional formatting to say ‘if the date is today, mark the cell in gold’.

Setting the Date checked cells to gold if the date is today

Setting the Date checked cells to gold if the date is today

Additional info column
I use this to record any extra notes about the post, e.g. for posts that are published on the weekend (unusual for me).

Summary tab

This tab contains a table where the data is calculated via formulas.

The table displays average counts for likes, views, comments and shares for each of the post types.

The AVERAGEIF formula does the job here. Here’s an example of how it works:

  • Look in the Stats tab for all rows that are text posts.
  • Take an average of all the likes for those text posts.

This is what that formula looks like:

AVERAGEIF formula to calculate average likes, comments, views and shares

AVERAGEIF formula to calculate average likes, comments, views and shares

I then repeat this formula to do the same calculations for comments, views and shares for all post types.

Finally, I have a couple of extra columns to calculate the average views per like and views per comment. This shows how many views it takes on average to receive a like or comment on a given post type.

⬆️ Back to top

Free Excel template for recording LinkedIn post stats

This is the Excel template I use in the video above. I’ve left in some rows of example data so you can see how it works.

Update: 17 January 2019

In the Stats tab, I’ve added the document (Doc) post type.

In the Summary tab, I’ve added a Posts column to show how many of each post type have been analysed.

⬆️ Back to top

Automated stats via SHIELD Analytics

I’ve recently started using a third-party tool called SHIELD Analytics to log my LinkedIn stats. This takes away the manual effort for a low monthly cost. Check out my explainer video below.

SHIELD discount

Use coupon SHIELDLOVESJOHN on the SHIELD signup page to get 50% off your subscription for the first year.

On a personal annual plan, that’s only $4 per month for the first year.

PS. I’m not on commission here.

Meryl Evans

Meryl Evans
Digital marketer

John is a fantastic resource for things related to LinkedIn, websites, and writing. He lives up to his "relentlessly helpful writer" as he's always ready and willing to help.

He's one of the few writers with technical knowledge, whether it's tweaking WordPress or doing something a little more involved on LinkedIn.

Thank you for all you do, John! You're a super star!

Let’s wrap up

If you’re serious about improving your LinkedIn presence, track the performance of your posts and then do more of what works.

My Excel template should help you, but remember that any logging is better than none.

Need to up your LinkedIn game?

My profile reviews and 1-to-1 LinkedIn consultations are ideal if you're short on time and need direct support to improve your LinkedIn presence.

Find out more

John Espirian

John Espirian

I write the words that go on B2B websites: service pages, expert articles, case studies, you name it. I also offer LinkedIn profile critiquing and rewriting.

I'm a former software tester and quality assurance manager, and have been an independent writer since 2009.

Espirian Towers is nestled in a quiet corner of South Wales 🇬🇧

Pre-order my book, Content DNA

Join Espresso ☕️ for relentlessly helpful tips by email

Get tips to improve your writing and web presence.
Short and strong. And zero sales fluff.

💙 963 awesome people aboard. Are you next?
🔐 Yes, privacy assured