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.
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:
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:
In the "Profile-Section" you can fill in:
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.
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:
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.
I don't have to explain it a third time, do I? Just do the same as for comments or impressions.
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 Aware this process happens completely automatic - no need to do anything.
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?!
Very easy to do. Just open the tab "My Network" and you will see the total amount on the top left side.
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.
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
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 🙂
You expected this, right? Us pitching Aware 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 Trial, too.
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 - start a free trial of Aware!
Aware offers you a comprehensive LinkedIn Analytics Dashboard to improve content performance. Sign up now and start for free.
Get Started FreeSure 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.
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.
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.
There you go buddy: https://docs.google.com/spreadsheets/d/15yuMsKozvbwGOWtnLpcYW7BFis1iyDfvQ5Y1pCFe-yk/edit?usp=sharing