Automated LinkedIn Report. Start for Free.

Your LinkedIn Analytics Reporting Template

Report your stats both for your Personal LinkedIn Account as well as for your Company Page. This Guide will show you how to do that as well as give you a Free Report to start with.

You need a LinkedIn reporting template for your personal account or business page, or to manage your clients?

Then you've come to the right place.

I have created a comprehensive reporting template for you to white label for your projects.

Follow me along as I do explain to you how to get the most out of the report.

How To Use The Reporting Template

LinkedIn Analytics Reporting Template in Google Sheets and Excel - free

For the impatient ones who want to go directly to the report, here is the link: Open and download the Reporting Template here.

I have made sure that the report not only includes the most important stats but also looks like something.

Now, let's have a look at what the dashboard shows:

Personal LinkedIn Account Reporting

In the first tab of the sheet, you will find the template for Personal LinkedIn Accounts. If you are like me and like to monitor your efforts on LinkedIn, this is the place to start.

In the "Content-Section" You can fill in:

  • LinkedIn Post Impressions
  • The Amount of Posts/ Articles posted
  • Comments under your Posts/ Articles
  • Reactions (such as likes, hearts, and claps)
  • The amount of shares
  • The Engagement-Rate of your Post/ Article

In the "Profile-Section" you can fill in:

  • Profile Views
  • LinkedIn Connections
  • LinkedIn Followers

Collecting The Data From LinkedIn

Now, not all of these metrics can easily be found/ observed. Let's take for example the Post impressions.

How do you make sure to only include the impressions that are new this week?

Well, there is an easy and hard way to do that.

Personal Accounts

Get LinkedIn Post Impressions

Do it manually - Hard Way (time-consuming)

You have to manually add together all the impressions of all your posts.

Example: You have 10 written posts, with these impression counts:

2300, 1200, 1100, 4600, 3250, 2300, 2600, 900, 1300, 3400.

Now you add them together the get the overall impression count of your posts.

2300 + 1200 + 1100 + 4600 + 3250 + 2300 + 2600 + 900 + 1300 + 3400 = 22950

This total count you will now keep until the next week to (eg. Monday) to compare it to next week's results.

This time you will do exactly the same thing. Maybe this time you have instead of 10 Posts, 12 Posts. So will have to count and add all of them together again.

Let's say you have now a total of 25400.

The discrepancy of this week vs next week would be 2450 impressions.

This is what you want to report in your sheet (I said it's hard).

Remember: To get accurate data you have to do this on the same day of the week at approximately the same time every week!

Automatically Report - Easy Way (no time needed)

After this messy start, I want to show you the easy way to handle this topic.

Get yourself an inlytics Account and set your time picker (top right side) to (1 week). Now you see exactly which Post or Article generates which amount of Impressions, Reactions, Comments...

Further, you can get all the post detailed stats like:

  • Correlation between Post Reach and Comments or Reactions
  • People viewing your content by Job and Company
  • The Location from which people viewed your content
  • The Engagement-Rate and more


Improve Your LinkedIn Profile - for free

inlytics offers you a comprehensive LinkedIn Analytics Dashboard to improve content performance.
Sign up now and start for free.

Get The Amount Of Comments

Here the same principles as for impressions apply: If you want to obtain precise numbers you have to calculate each week the number of total comments and then subtract it the next week.

An easy but not as precise way is to only obtain the values from your most recent 3 posts. So you save some time, but still: this way you have to do it manually.

On the other hand, you can use inlytics to automate this process. Feel free to get started with the Free-Plan.

Get The Amount Of Reactions

I don't have to explain it a third time, do I? Just do the same as for comments or impressions.

Get The Amount Of LinkedIn Shares

Now it gets a little more interesting. Shares are not observable with your LinkedIn stats. You have to count them when they occur.

That means you will get a notification as soon as someone shares your Post/ Article. This information can be used to fill out the sheet.

With inlytics this process happens completly automatic - no need to do anything.

Find Out The Amount Of Profile Views

This one is fairly simple yet a little tricky. You do know the page from where we will extract the data, do you? (Hint: It's this page: https://www.linkedin.com/me/profile-views/urn:li:wvmp:summary/)

Now LinkedIn is playing a little with its userbase so you may not be able to see your chart with the amount of views right now. I found out that right now several accounts see it (even on the Free-Plan) as well as others who do not see it.

In the case you have the stats: Nice. Just copy and paste last week's views.

If not: Use inlytics (you should anyway ;). Why? Because our app is capable of tracking your stats even doe you don't see them. Nice, isn't it?!

Get The Amount Of Connections

Very easy to do. Just open the tab "My Network" and you will see the total amount on the top left side.

See Your Followers On LinkedIn

A little harder to find are your followers. You have to open this page: https://www.linkedin.com/feed/followers/ to see the amount of current followers for your account. Just copy and past it into our white label template.

----

Done. This is how you fill in your Personal LinkedIn Content data into the template.

By the way: If you have trouble finding the metric within your LinkedIn Dashboard, I have written a very detailed Guide about how to find these metrics within LinkedIn.

Now let's move on to the Business Pages.

Business Pages

For the Business Page Report much is the same as for the Personal Report. The only difference is that it's easier to observe the data from LinkedIn.

LinkedIn will give you more detailed insights into your content performance when you have a company page.

To open your insights click on your company page and open the Analytics Report Tab in the top Nav-bar.

When you have the detailed Analytics report opened you can switch the time range as shown below

LinkedIn company page insights showing a chart with visitor analytics
You can change the date range just above the chart

Now, I'm not going to tell you how to extract each individual metric again, since I believe it's quite obvious at that point. Just copy and paste what you see within your template.

Alway's remember to set the right time range first 🙂

Last But Not Least: An Alternative To This Report

LinkedIn Analytics Dashboard - inlytics.io
Here we go - screenshot out of our current Beta

You expected this, right? Me pitching inlytics right here right now. And you'd be right. Well, we build this tool exactly for this purpose so you can save yourself time analyzing your LinkedIn content.

I invite you to join us and try it out for yourself. We have a Free Plan, yes.

Currently, we are also working on many more things that will make your life easier. Including:

  • LinkedIn Analytics Team Dashboards (Groups)
  • LinkedIn Content Scheduling (or in other words: a content planner)
  • LinkedIn Hashtag Analytics (been researching on this for a while)

Our goal is that you do not have to spend a whole lot of time figuring out what works for you.

Instead, we want you to get actionable insights in form of statements that we can give you based on your data and the benchmarking data of your industry peers.

Therefore we are working on a machine learning algorithm that finds insights you would normally overlook.

Give yourself a go - join inlytics, start for free!

WRITTEN BY

Tim Schmidbauer

I help startups to validate their critical assumptions, sharpen the business case and ultimately generate traction. https://www.linkedin.com/in/tim-schmidbauer/

LinkedIn IconTwitter IconInstagram IconFacebook IconWebsite link Icon

Want to become an author on this page? Write us here.

Frequently Asked Questions
About LinkedIn Analytics Reports

I answer the questions that you may still have

Is The Analytics Report Really Free?

Sure it its. Even do we provide an automated version of this report (called inlytics) you can still use the template provided for free. You can also use it to brand it with your own content.

Can I Export The Template To Excel?

Yes you can. The "tool" itself is build in Google Sheets but it's no problem to export it to Excel by the click of a button. You have to click on "File", then "Download" and then simply choose Excel. That's it.

Can I Automate The Process Of Filling In The Dashboard With Data?

This template can't be automatically filled - at least it's not intended for this purpose. BUT: inlytics (our tool) can and will do that automatically for you. If you are looking for an LinkedIn Analytics Tool to get always up-to-date data with Team and sharing abilities I recommend checking it out.

Where To Download The LinkedIn Reporting Template?

There you go buddy: https://docs.google.com/spreadsheets/d/15yuMsKozvbwGOWtnLpcYW7BFis1iyDfvQ5Y1pCFe-yk/edit?usp=sharing

All Your LinkedIn Data In One Place - Stop Guessing, Start Creating.