blog post

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

Florian Cabirol
November 28, 2023
Explore your LinkedIn Pages KPI from PowerBi : How-to, templates and metrics

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

Through this thorough guide, you’ll learn how to seamlessly bring your LinkedIn Pages data into the robust visualization environment of PowerBI. By the end of this tutorial, you'll be fully equipped to transform your marketing metrics into insightful dashboards that will inform your strategy and decision-making process.

How to connect your LinkedIn Pages account to PowerBI

Add a source on Catchr

Begin by navigating to the Catchr homepage. From there, look for the Source option within the left-side menu. Click this, and then choose Add a Source from the upper right section. Now, select 'LinkedIn Pages' as your platform of choice and proceed through the authentication steps to establish a connection between Catchr and LinkedIn Pages.

Adding a source on Catchr

Create the request to transfer LinkedIn Pages data to PowerBI

  • Within Catchr's dashboard, locate and click on API in the left-hand menu.
Catchr API section
  • Change the export format by selecting "PowerBI" from the available options.
Setting export format to PowerBI
  • In the "Source" tab, make sure 'LinkedIn Pages' is selected as the platform to export data from.
Selecting LinkedIn Pages as the data source
  • Pick the specific account whose data you wish to extract. It's possible to select multiple accounts if needed.
Selecting LinkedIn Pages accounts
  • Choose the metrics and dimensions you require for your data pull. You’re able to select more than one.
Selecting metrics and dimensions on Catchr
Further metrics and dimensions selection on Catchr
  • Warning: If utilizing a Catchr template, ensure all necessary dimensions and metrics are included as stated on the template details within Catchr. This action will trigger the template to populate with your selected data automatically, which you can then fine-tune to meet specific needs.
  • Determine the time frame for data extraction. Options include custom range or preset intervals.
Selecting a time frame for LinkedIn Pages data
  • Apply any necessary filters to your data query for more precise results, multiple filters can be applied.
Applying filters on data request
  • Now you can choose options for your request, with specifics varying by platform.
Adding options to data request
  • With your selections made, a URL will be generated at the top. You can visualize what your data will look like by clicking "Preview".
Previewing the data request result
Data preview after loading
  • Upon satisfaction with the preview, copy the provided URL—you'll use this soon in PowerBI.
Copy the data request URL for PowerBI

Import the LinkedIn Pages data and KPI to PowerBI

PowerBI Desktop:

In PowerBI Desktop, you access data from a multitude of resources. Here, we'll be importing using a web data source.

  • Click on Get Data and then Web.
Get Data from web in PowerBI Desktop
  • Remain in basic mode and paste the request URL from Catchr.
Pasting URL for web data
  • Hit OK.

Let PowerBI work its magic; once your data is imported, utilize the PowerBI Query Editor to refine your data types. Now you can embark on creating a compelling dashboard, laden with insights, ready to be published and shared with your team.

PowerBI Web App: After importing data to PowerBI Desktop, publish it to move your data online. Within the PowerBI web app, navigate to New Report and select from your published datasets to utilize them in crafting new reports.

In this tutorial, we've outlined the ways to enhance your marketing analysis by integrating LinkedIn Pages data into PowerBI. Applying these steps will allow you to capitalize on the detailed metrics provided by LinkedIn and the powerful data manipulation and visualization capabilities of PowerBI.

Example of metrics you can use with the PowerBI Integration for LinkedIn Pages

Exploring the comprehensive set of metrics available for LinkedIn Pages can propel your data visualization to new heights with PowerBI. Metrics such as follower demographics (including industry and region), engagement rates (like clicks and likes), and detailed content analytics (including post impressions and engagement) are just the tip of the iceberg.

You might, for example, create a customized report tracking your LinkedIn Pages' follower growth over time, dissected by industry, which can inform you about your most engaged sectors. Or maybe, you'd prefer a dashboard that showcases the performance of different post types, allowing you to fine-tune your content strategy based on real data-driven insights.

The power at your fingertips with PowerBI’s expansive visualization tools, married with the precise data extracted from your LinkedIn Pages, means you have all you need to maximize the impact of your social media efforts. Dive into the rich analytics and curate dashboards that not only tell a compelling story but also drive impactful business decisions.

Learn more about the diverse metrics for LinkedIn Pages that you can utilize within PowerBI by visiting Catchr's LinkedIn Pages Metrics Listing.

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

Best KPI to use for LinkedIn Pages

Do you want to expand your LinkedIn reach and grow your business? Measuring the best LinkedIn page KPIs is the way forward. Keep reading to learn more.

Florian Cabirol

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