blog post

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

Florian Cabirol
September 11, 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.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on Google Sheets

Build Google Sheets dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data

Connect your LinkedIn Pages data to Google Sheets thanks to Catchr's no code connector!

Start your free trial!
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?

Unlock your free LinkedIn Company Page Overview dashboard template for Power BI from a collection of stunning designs. Elevate your data visualization!

Get it for free
Need a clearer view of your marketing data?

Unlock your free Template LinkedIn Company Pages Overview dashboard template for Looker Studio from a collection of +50 stunning designs. Elevate your data visualization!

Get it for free

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