LinkedIn is a major channel in the advertising industry. Companies want to know their company’s social media presence and organic brand reach. LinkedIn allows companies to gain insights into their brand performance and organic reach.
Whether it’s company page posts or organic followers, reporting is super important. But these types of reporting can be a nightmare. With the right tools, you can manage data from LinkedIn to Google Sheets. It eliminates to manually transfer and update data in both systems. This makes it easier to track and measure every post that goes out.
Why Pay for Automation at All?
Automations solve huge problems in organizations. So, most automation tools are paid products. Yes, you can do everything manually for free to save money. But in perspective, you might want to spend a little to save time. The number of hours that you take back to avoid hellish and repetitive work is worth the price.
I hate a super cluttered desktop. You ever experienced a desktop full of spreadsheet files? I hate them. It increases stress and productivity comes to an all-time low. The amount of time I clicked the Export CSV button is unbearable. Automation avoids all of this and is useful when you’re tracking marketing campaigns.
How To Import LinkedIn Company Pages To Google Sheets
This article shows two options on how to import LinkedIn page insights to Google Sheets. Option 1 is using a Google Sheets add-on. Option 2 is using a third-party integration tool. Both don’t require coding skills. This article focuses on LinkedIn pages and not LinkedIn Ads.
1 – Go to your Google Drive workspace.
2 – Click + New then create a new Google Sheets file.
3 – At the top of your file, click on Extensions. Then click on Add-ons. Then click on Get add-ons.
4 – Search for Two Minute Reports. Then install it.
5 – You now have the extension installed on your Google Sheets file.
Import LinkedIn Page Data Source
1 – Launch the extension. A navigation pane on the right side appears.
2 – Click on Add + under Data Sources.
3 – Name your data source. Then select LinkedIn Ads.
4 – Log in to your LinkedIn account.
5 – Link your LinkedIn account to the tool. Go through the login process until the tool instructs you to close the tab since the sign-in is successful.
Import LinkedIn Page Data Query
This point in the process is importing data from the LinkedIn Analytics API to the spreadsheet.
1 – Click on the burger icon. Then click on Data Queries. And click on Add +.
2 – Name your data query. Find the LinkedIn source you imported earlier.
3 – Save on Sheet is the location of the sheet where the data is imported to. Add A1 under Cell.
4- Under Query, select the LinkedIn Ad Account you want to get data from.
5 – Select the date range with whatever you need.
6 – Select the Metrics you want to import (Impressions, Clicks, Company Page Clicks, Likes, Comments, etc).
7 – Select the Dimensions you want to import (Campaign name, Creative id, etc).
8 – Click on Run query.
Viola! You imported your LinkedIn ads data to Google Sheets hassle-free. You can create reporting templates from here depending on your business needs.
Schedule LinkedIn Page Reports
Two Minute Reports has a scheduling function. This means the spreadsheet refreshes the acquired data from the API. Reports are automated even more.
1 – Click on the burger icon. Then click on Schedule Refresh.
2 – Click on New +.
3 – Once inside, you can set the terms of the report schedule.
-Repeats: This is where you set how often the data refresh happens. Two Minute Reports can do hourly refreshes.
4 – You can also set the notification terms. Two Minute Reports can email you a PDF or Excel of the data. You can also decide to have the email contain the sheet content in the email body.
5 – Click on Save.
Scheduling helps when you need to report on overtime. No more copy and paste manual reports every day, or every week, or every month.
More articles on automation:
Import Facebook Page Insights to Google Sheets
Import LinkedIn Page post data to Google Sheets
Import LinkedIn Ads API data to Google Sheets
Import Google Analytics data to Google Sheets
Import Search Console Data to Google Sheets
Import WooCommerce data to Google Sheets
Import Facebook Ads data to Google Sheets
Import Google Ads data to Google Sheets
Import Mailchimp data To Google Sheets
Import Shopify data to Google Sheets
Import TikTok ads to Google Sheets
Import GA4 data to Google Sheets
Import ChatGPT to Google Sheets
Import JSON to Google Sheets
Export Gmail to Google Sheets
Conclusion: Build LinkedIn Company Page Reports Faster
Avoid import and export spreadsheet hell. Maintain everything in Google Sheets with tools if needed. Stop wasting time on repetitive tasks. With this automation, companies can understand how their campaigns are performing and make necessary changes faster. Start focusing on important stuff that impacts the business. Hire a digital analyst to help you.