blog post

Explore your LinkedIn Marketing Ads KPI with PowerBI : how-to, templates and metrics

Florian Cabirol
November 28, 2023
Explore your LinkedIn Marketing Ads KPI with PowerBI : how-to, templates and metrics

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

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

  1. Get informations from the data integration from our LinkedIn Ads 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 Ads 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 Ads report with Looker Studio:

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

  1. Get informations from the data integration from our LinkedIn Ads 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 Ads at the end of the page.

The tutorial

Quick steps to create a LinkedIn Ads report with PowerBI:

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

  1. Get informations from the data integration from our LinkedIn Ads 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 Ads at the end of the page.

The tutorial

This detailed tutorial is designed for marketing professionals aiming to bridge the gap between LinkedIn Ads data and PowerBI's robust visualization capabilities. By the conclusion of this guide, you'll be able to effortlessly transfer key marketing metrics from LinkedIn Ads to PowerBI, transforming raw data into actionable insights.

How to connect your LinkedIn Ads account to PowerBI

Add a source on Catchr

Begin by navigating to the Catchr homepage. Look to your left and click on Source, then, spot the Add a Source button at the top right corner and click on it. Now, select LinkedIn Ads as your desired platform. You'll have to pass through an authentication process to link LinkedIn Ads with Catchr.

Adding a LinkedIn Ads source on Catchr

Create the request to transfer LinkedIn Ads data to PowerBI

  • Within Catchr, find and click on the API option in the left menu.
API Option on Catchr
  • Transition the export setting to "PowerBI" for smooth data compatibility.
Switching export format to PowerBI
  • In the "Source" tab, pick LinkedIn Ads as the platform to extract data.
Selecting LinkedIn Ads as Source
  • Choose the account(s) where your data resides. Multiple selections are allowed.
Selecting LinkedIn Ads account for data
  • Decide which metrics and dimensions are relevant for your analysis. It's possible to choose more than one.
Selecting metrics and dimensions Step 1
Selecting metrics and dimensions Step 2
  • Important: When employing one of Catchr's templates, include every required dimension and metric as outlined on the template's page. If followed precisely, your template should automatically populate with the selected data, ready for further customization.
  • For time-based data extraction from LinkedIn Ads, set your preferred timespan. Options range from preset to custom durations.
Setting the data extraction period
  • Enhance your data extraction precision by applying filters as needed.
Adding filters to data request
  • Some platform-specific selections may be beneficial to your data request. Explore these options.
Additional options for data extraction
  • Post-configuration, an URL will present itself - a gateway for PowerBI to fetch your data. "Preview" is available if a sneak peek is desired.
URL for data transfer
Data preview
  • Found satisfaction with your setup? Grab that URL; it's your ticket to connecting LinkedIn Ads to PowerBI.
Copying the data transfer URL

Import the LinkedIn Ads data and KPI to PowerBI

PowerBI Desktop

  • Initiate the data import by selecting Get Data, then opt for the Web.
Getting data from Web in PowerBI
  • In basic mode, paste that URL from Catchr into the provided field. Hit OK.
Pasting the data transfer URL into PowerBI
  • It may require a moment, but PowerBI will diligently incorporate your data. Following importation, delve into PowerBI Query to tailor your query and field types. Proceed to construct a dashboard laden with LinkedIn Ads insights, and distribute it amongst your team or clients as needed.

PowerBI Web App

Transition your data sets from desktop to browser via publication. Once in the PowerBI Web App, click on New Report to select a published data set. This holds the key to your previous analytics efforts, primed for a new report.

In conclusion, with the seamless Catchr integration and PowerBI's advanced analytics, you've now unlocked a powerful toolset for making data-driven marketing decisions. Relish in the newfound clarity and depth your data provides.

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

With PowerBI integration, LinkedIn Ads becomes a treasure trove of insights. Consider the granularity of data like daily impressions or yearly engagements to track campaign longevity and resonance. Observe member company sizes to understand with which business your content hits the mark, and refine targeting accordingly. Additionally, LinkedIn Ads provides a current of behavioral data—member job functions, industries, and even company holds immense strategic value when mapped out visually in PowerBI.

Fathom how specific job titles or functions interact with your ads, granting the ability to sculpt campaigns more personally or professional roles. Or harness geographical pivots by deploying rich, layered geographical data visualizations, which could lead to sharpening or expanding your market focus.

Finally, the inclusion of direct CTA metrics like action clicks tells a tale of efficacy, while the progressive watch times on video ads unveil how well your content retains attention. Each datapoint not only measures performance but, through the multidimensional lens of PowerBI, germinates strategic pivots and optimizations.

Find a comprehensive list of all the metrics you can utilize at Catchr's LinkedIn Ads metrics page.

Bonus : Your free Template LinkedIn Ads - Leads Performance Template

In this LinkedIn Ads 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 Ads OverviewTemplate for PowerBI

In this LinkedIn Ads 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 Ads

Explore your LinkedIn Marketing Ads KPI with PowerBI : how-to, templates and metrics

Learn how to connect LinkedIn Ads to PowerBI for enhanced data visualization and analytics in this comprehensive guide, transforming LinkedIn metrics into strategic insights.

Florian Cabirol

Decoding LinkedIn Ads KPIs: A Comprehensive Guide to Boosting Conversions and CTR

LinkedIn Ads KPIs give you valuable insights into how well your ad campaigns are performing. Learn more about LinkedIn KPIs, along with the right ones to track.

Florian Cabirol

LinkedIn Ads to Google Sheets: Effortlessly Export Your Data for Enhanced Analysis

Learn how to effortlessly export your LinkedIn Ads data to Google Sheets using the Catchr Add-on for enhanced analysis, better decision-making, and improved campaign performance.

Florian Cabirol

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

Learn how to create a LinkedIn Ads report in Looker Studio and get a free template!

Johan Chemin