Follow the below article to create your own LinkedIn Analytics report as below.
1. Extract LinkedIn data
You will get an email within an hour with some datasets but will need to wait 24 hours to get a full zip folder of the below CSV’s.
2. Import into Power BI
Unzip the zip file named Complete_LinkedInDataExport_MM-DD-YYYY and import into Power BI.
The CSV files I have imported into Power BI are:
Also the Article folder of HTML files.
I usually try to share around 10am on a Tuesday although historically this definitely isn’t the case as it appears 9am Monday. When you filter on the last 3 months you can actually see I have been sticking to my strategy. Unfortunately LinkedIn doesn’t provide engagement numbers in there downloads but that would be amazing to analyse.
Looking at the last 6 calendar months it majority of my post where still 9am Wednesday. I connected to 65 people at the City of Casey and 36 at Microsoft. I connected with nearly 400 people in February but there is a clear downward trend towards 200 in June. Maybe you can help me rectify this in the coming 6 months? Connect with me here on LinkedIn and we will keep tabs on it!
People who I have messaged on LinkedIn seems pretty stable but something I can now monitor as ideally I would want that engagement to go up.
Over to you! Please download the pbix below and save your LinkedIn files in your downloads folder. My only ask is that I would love to see your amazing LinkedIn Power BI reports flooding LinkedIn. Please share and tag me on LinkedIn if you manage to get it working. I would also love to see your improvements and insights!