Marketing and analytics · data source guide
LinkedIn Ads data in Power BI
Connector status
No connector of its own in Microsoft's list
Microsoft's index has no LinkedIn Ads (Campaign Manager) connector. It does list LinkedIn Sales Navigator (Preview) and LinkedIn Learning, which are different products and don't return ad data.
Checked against Microsoft Learn's Power Query connector list on 5 November 2026. Connectors change; check the list before you build.
How to get LinkedIn Ads data into Power BI
In order of preference for a report that refreshes on its own.
- 1
Campaign Manager exports
Export campaign performance from Campaign Manager as CSV, store it in SharePoint or OneDrive, and load it with the Text/CSV connector.
- 2
Lead-gen form leads into the CRM
Sync lead-gen form submissions into your CRM and report leads from there, where they can be followed to opportunities.
- 3
Third-party connectors
Certified marketing-data connectors in Microsoft's list may cover LinkedIn Ads; confirm coverage and pricing with the vendor.
- 4
Marketing API
LinkedIn's Marketing API needs an approved developer application. Power BI's Web connector can call a REST API, but paging, authentication tokens and scheduled refresh in the Service take care: dynamic URLs built from parameters may not refresh in the Service unless the base URL is static (use Web.Contents with RelativePath and Query).
Typical LinkedIn Ads KPIs
Table and column names in the DAX are illustrative: rename them to match your model.
Cost per lead
Spend divided by lead-gen form leads.
Cost per Lead = DIVIDE ( SUM ( LinkedInAds[Spend] ), SUM ( LinkedInAds[Leads] ) )Lead-form completion rate
Leads divided by lead-form opens.
Form Completion = DIVIDE ( SUM ( LinkedInAds[Leads] ), SUM ( LinkedInAds[FormOpens] ) )CTR
Clicks divided by impressions.
CTR = DIVIDE ( SUM ( LinkedInAds[Clicks] ), SUM ( LinkedInAds[Impressions] ) )Cost per opportunity
Spend divided by CRM opportunities sourced from LinkedIn campaigns.
Cost per Opp = DIVIDE ( SUM ( LinkedInAds[Spend] ), CALCULATE ( COUNTROWS ( Opportunity ), Opportunity[LeadSource] = "LinkedIn" ) )Engagement rate
Clicks, reactions, comments and shares divided by impressions.
Engagement Rate = DIVIDE ( SUM ( LinkedInAds[Engagements] ), SUM ( LinkedInAds[Impressions] ) )Modelling notes for LinkedIn Ads
- Campaign names change; join on campaign ID, not name.
- Demographic breakdowns are aggregated and thresholded by LinkedIn; don't expect them to sum to totals.
- Lead counts in Campaign Manager and the CRM differ; show both with clear labels or pick one source.
Templates for LinkedIn Ads data
Free page layouts with a background, theme JSON and PBIP project. Swap the sample tables for your own queries.
Sales template
Regional Sales PerformancePower BI regional sales dashboard template: a large sales map, four KPIs, revenue by region bars and a top-accounts table on one page.
Sales template
Sales PipelinePower BI sales pipeline dashboard template with pipeline value, win rate and cycle-time KPIs, a stage funnel, pipeline creation trend and closing deals.
Marketing template
Marketing Campaign PerformancePower BI marketing dashboard template: spend, CTR, leads, CPL and ROAS KPIs, spend vs leads trend, lead funnel and channel efficiency charts.
Sales template
Sales Rep Quota AttainmentDark Power BI sales quota attainment template: a rep leaderboard, bookings vs quota by month, attainment distribution, win rate and deal size per rep.
Marketing template
Web Analytics & SEODark Power BI web analytics and SEO template: sessions by channel, engagement and conversions, top landing pages, query position vs CTR and visitor countries.
Marketing template
Social Media PerformancePower BI social media dashboard template: followers and growth by network, engagement rate by content type, best day and time to post, and top posts.
Power BI visuals for Sales · More by department: Marketing templates · Sales templates
Visuals for LinkedIn Ads KPIs
Chart types that suit these KPIs, with data shapes and example prompts.
Visual
Funnel ChartSales pipeline: leads → MQLs → SQLs → opportunities → closed won; Marketing funnel: impressions → clicks → landing page views → sign-ups
Visual
Bullet ChartExecutive KPI scorecards (5-10 KPIs in a grid); Sales attainment across reps or regions
Visual
Sankey DiagramCustomer journey: acquisition channel → onboarding step → conversion or churn; Budget cascade: total revenue → segment → cost bucket → net margin
Visual
KPI CardExecutive dashboard KPI row (revenue, customers, NPS, churn); SaaS metrics card (MRR, ARR, logo growth)
LinkedIn Ads and Power BI: questions
Does the LinkedIn Sales Navigator connector return ad data?
No. Sales Navigator is a prospecting product; its connector (Preview) doesn't return Campaign Manager advertising data.
What's the simplest refreshable setup?
A scheduled CSV export saved to SharePoint or OneDrive, loaded with the Text/CSV or Folder connector. The Service refreshes it without a gateway.
Related data sources
Other sources teams often combine with this one.
No connector of its own in Microsoft's list
Google Ads in Power BIGoogle Ads data in Power BI
No connector of its own in Microsoft's list
Meta Ads in Power BIMeta (Facebook, Instagram) Ads data in Power BI
No connector of its own in Microsoft's list
HubSpot in Power BIHubSpot data in Power BI
LinkedIn Ads is a trademark of its owner. Product names are used only to describe compatibility; VizForge is not affiliated with, endorsed by or sponsored by the owner or by Microsoft.
Design the LinkedIn Ads report page first
Lay out KPI cards and visual slots in the free Design Studio, then export the background, theme JSON and a PBIP project to bind to your data.
The design studio for Power BI. Free, in your browser, no sign-up.