LinkedIn is a key platform for B2B marketing. With the right strategy, you can increase your client’s reach, connect with the right audience, and build a strong reputation. To do this, tracking LinkedIn metrics is important.
LinkedIn’s built-in analytics gives some insights, but it can be limited if you manage multiple pages. TMR’s LinkedIn Pages Connector makes this easier. Once you connect your client’s LinkedIn account, TMR pulls the metrics, shows useful insights, and helps you make smarter decisions to grow faster.
Step 1: Install and Launch Two Minute Reports
Open Google Sheets and sign in with your associated Gmail ID. Go to Extensions > Add-ons > Get add-ons.
Search for Two Minute Reports and select Install.
Review the required permissions for Two Minute Reports. After accepting the terms and conditions, click Allow to grant access so the add-on can manage and work with your data.
Note: Allow access is mandatory for TMR to function and efficiently analyze your data.
Next, open Google Sheets, then go to Extensions > Two Minute Reports > Launch to start the add-on.
Once the Two Minute Reports sidebar opens, you can start creating connections and run queries.
Step 2: Connect LinkedIn Pages to Google Sheets
Click the Menu icon at the top left of the sidebar to navigate to the Connections section.
Click Add. A modal will open where you can select LinkedIn Pages as your connection type and click Next
Enter a name for your connection and click Sign in with LinkedIn. After connecting your LinkedIn account, click Yes to authenticate the login.
In the Select Accounts section, enable the account IDs you want to pull insights from and click Done.
Step 3: Getting LinkedIn Pages data in Google Sheets
To pull data from your LinkedIn Pages, go to the Data Queries section and create a new query.
Click Add and select the LinkedIn Pages account you want to analyze. You can manage multiple clients’ LinkedIn Pages in one place, simply choose one or more accounts to analyze their performance.
Alternatively, you can navigate to the Clients section. Add your client and map their corresponding LinkedIn Pages account.
Click “Manage Clients” and enter the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.
Note: You can add multiple clients and map their respective ad accounts. Doing so saves you tons of wasted hours from manually juggling numerous data sets. You can get a unified view of your client campaigns and track key metrics in a centralized dashboard. For further information, please read our guide – How to Create Queries Using Clients?
Next, add the metrics and dimensions to assess your LinkedIn Pages performance. For a better understanding, refer to the screenshot below.
Next, you have to configure your data reporting by choosing how to customize it.
Customize your data reporting by selecting the relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the information you need.
After completing the above steps, click Run Query to visualize the final output.
You can now use various Google Sheets features, such as Pivot Tables and VLOOKUP(), to extract key insights and create charts to visualize your campaign performance.
Pro TMR Tip: Run all your queries directly from the Extensions menu in Google Sheets. Go to Extensions > Two Minute Reports and select your desired quick action.
Step 4: Get automatic data updates via Schedule Refresh
After running a query in a Google Sheets report, you can schedule automatic updates to receive refreshed data. This feature is ideal for sending automated emails, keeping your spreadsheets up-to-date with live data, and using them as a dashboard.
Click Schedule Refresh, give your schedule a name, select the queries you want to include, and choose the refresh time along with your preferred timezone.
In the Email section, enter the recipient(s)’ email address(es) and save the new schedule.
You can also specify the reporting format. Options include inserting the sheet content directly into the email body, attaching the selected sheet as a PDF or Excel file, or attaching the entire spreadsheet as an Excel file.
Two Minute Reports’s schedule refresh or data refresh feature has other capabilities. For more information, please read our guide, “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. If you have any questions, please get in touch with our support team via chat or [email protected]