blog post

Import your LinkedIn Page KPI to Google Sheets : How-to, metrics and more

Florian Cabirol
January 31, 2024
Import your LinkedIn Page KPI to Google Sheets : How-to, metrics and more

Quick steps to create a LinkedIn Pages report with Google Sheets:

You can easiliy create a LinkedIn Pages report following this step :

  1. Get informations from the data integration from our LinkedIn Pages connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your LinkedIn Pages data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a LinkedIn Pages report with Looker Studio:

You can easiliy create a LinkedIn Pages report following this step :

  1. Get informations from the data integration from our LinkedIn Pages connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for LinkedIn Pages at the end of the page.

The tutorial

Quick steps to create a LinkedIn Pages report with PowerBI:

You can easiliy create a LinkedIn Pages report following this step :

  1. Get informations from the data integration from our LinkedIn Pages connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for LinkedIn Pages at the end of the page.

The tutorial

Welcome to our step-by-step guide aimed at helping marketers harness the power of LinkedIn Page metrics by connecting them with Google Sheets via Catchr. By the end of this tutorial, you'll have a comprehensive understanding of how to seamlessly integrate LinkedIn Page data into Google Sheets for enhanced marketing analytics and decision-making capabilities.

How to connect your LinkedIn Pages account to Google Sheets

Add a source on Catchr

To begin, navigate to the Catchr homepage and locate the Source option in the left-side menu. Once there, click on Add a Source located at the top right corner of your screen. Choose LinkedIn Pages as your platform and proceed with the authentication steps to link Catchr with LinkedIn Pages.

Adding a LinkedIn Pages source

Create a New Query

Launch Google Sheets and access the Catchr feature from the menu bar. Click on New Query to initiate the process of importing your LinkedIn Pages data.

Select Your Data Source

In the query creator, you'll have the option to select LinkedIn Pages as your data source. If it isn't already listed, you can easily add it by selecting the "+" icon.

Selecting LinkedIn Pages as data source

Select Your Account(s)

Move to the Select account(s) section and pick the LinkedIn Pages account(s) whose data you wish to analyze.

Selecting LinkedIn Pages account

Choose Metrics and Dimensions

Continue to the Metrics and Dimensions section to select the specific data points you are interested in. Below are examples of metrics and dimensions you might find valuable:

Metrics:

  • Page Views: The total times your LinkedIn page was viewed.
  • Unique Page Views: How many unique users visited your LinkedIn page.
  • Total Follower Gain: Net increase in followers over a specified period.
Selecting metrics for LinkedIn Pages data

Dimensions:

  • Country: Visitor's country of origin.
  • Device Type: Device used for accessing your page (e.g., desktop, mobile).
  • Follower Industry: Industry classification of your followers.

Always select metrics and dimensions that align with your analytics and reporting goals.

Selecting dimensions for LinkedIn Pages data

Set Date Range

After choosing your metrics and dimensions, proceed to the Date Range option. Here, you can pick from predefined date ranges like "Last month" or set custom start and end dates for your analysis.

Setting date range for LinkedIn Pages data

Apply Filters

To refine your data, utilize filters in the Filters tab. For example:

  • Field: Country
  • Operator: Equals
  • Value: United States

This filter setup will ensure that only data for visitors from the United States is included in your query.

Applying filters to LinkedIn Pages data

Schedule & Customize Data Refreshness

Lastly, utilize the Options tab to schedule your data to refresh automatically. Additionally, you can enable features such as "Append rows" to add new data at the end of your selected range, or "Combine rows" for comprehensive updates.

Customizing data refreshness settings

This concludes the basic steps required to connect your LinkedIn Pages data to Google Sheets using Catchr. With this connection, you're now equipped to automate data extraction and enhance your analysis efficiency.

Example of Google Sheets you can create to use with LinkedIn Pages source

With LinkedIn Pages data at your fingertips in Google Sheets, the possibilities for advanced analytics and informed decision-making are virtually limitless. Here are some examples of practical Google Sheets you can create:

  • Content Performance Dashboard: By importing metrics like Post Engagement, Post Impressions Count, and Post Clicks, you can craft a detailed overview of how your content resonates with your audience.
  • Follower Growth Analysis: Utilize metrics such as Total Follower Gain, Organic Follower Gain, and Paid Follower Gain alongside dimensions like Time (e.g., Month, Quarter) to track and visualize your follower growth trends over time.
  • Recruitment Insights: For companies using LinkedIn Pages as part of their recruiting efforts, metrics on Careers Page Views and specific actions (e.g., Careers Page Jobs Clicks) can be invaluable in understanding potential candidate engagement.
  • Industry Benchmarking: By comparing your page's performance metrics against those of similar organizations in your industry, you can identify areas for improvement and craft strategies to enhance your page's impact.

Each of these examples leverages specific metrics and dimensions tailored to a particular aspect of LinkedIn Pages management and analytics. By integrating LinkedIn data with Google Sheets, marketing professionals can streamline processes, uncover insightful trends, and make data-driven decisions to boost their organization's online presence.

Bonus : Your free Template LinkedIn Company Pages Overview Template

In this LinkedIn Pages template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free LinkedIn Company Page OverviewTemplate for PowerBI

In this LinkedIn Pages template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about LinkedIn Pages

Import your LinkedIn Page KPI to Google Sheets : How-to, metrics and more

Explore the integration of LinkedIn Page metrics with Google Sheets through our detailed Catchr guide, designed to elevate your marketing analytics and strategic decision-making. Learn how to seamlessly connect your LinkedIn Pages account, select relevant metrics and dimensions, and analyze your data for enhanced insights. Perfect for marketing professionals seeking to optimize their LinkedIn strategy, track follower growth, and analyze content performance for more informed decisions.

Florian Cabirol

Explore your LinkedIn Pages KPI from PowerBi : How-to, templates and metrics

Discover how to integrate LinkedIn Pages data with PowerBI for advanced analytics in this guide. Transform LinkedIn metrics into powerful PowerBI dashboards for strategic insights.

Florian Cabirol

Connect your LinkedIn Pages to Looker Studio : How-to, templates and metrics

Connect and visualize all your data from your LinkedIn pages thanks to Looker Studio. Free templates included.

Florian Cabirol