LinkedIn Ads & Power BI: How to integrate your data and template

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.

Create the request to transfer LinkedIn Ads data to PowerBI

• Within Catchr, find and click on the API option in the left menu.

• Transition the export setting to "PowerBI" for smooth data compatibility.

• In the "Source" tab, pick LinkedIn Ads as the platform to extract data.

• Choose the account(s) where your data resides. Multiple selections are allowed.

• Decide which metrics and dimensions are relevant for your analysis. It's possible to choose more than one.

• 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.

• Enhance your data extraction precision by applying filters as needed.

• Some platform-specific selections may be beneficial to your data request. Explore these options.

• Post-configuration, an URL will present itself - a gateway for PowerBI to fetch your data. "Preview" is available if a sneak peek is desired.

• Found satisfaction with your setup? Grab that URL; it's your ticket to connecting LinkedIn Ads to PowerBI.

Import the LinkedIn Ads data and KPI to PowerBI

PowerBI Desktop

• Initiate the data import by selecting Get Data, then opt for the Web.

• In basic mode, paste that URL from Catchr into the provided field. Hit OK.

• 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.

‍