Meta Ads data in Power BI

1. 1

   Ads Manager exports

   Export a campaign report from Ads Manager (CSV or Excel) with the breakdowns you need, save it to SharePoint or OneDrive, and load it with the Excel or Text/CSV connector so the Service can refresh it.

2. 2

   Certified third-party connectors

   Several certified connectors in Microsoft's list aggregate ad platforms (for example Funnel and Windsor). Confirm Meta is covered and check attribution settings in the vendor's tool.

3. 3

   Marketing API

   The Marketing API returns insights as paged JSON with rate limits. 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).

4. 4

   One cross-channel table

   Append Meta, Google Ads and LinkedIn Ads into one Ads fact table with a Platform column and the same column names, so one set of measures serves every channel.

Frequency = DIVIDE ( SUM ( MetaAds[Impressions] ), SUM ( MetaAds[Reach] ) )

CPM = DIVIDE ( SUM ( MetaAds[Spend] ), SUM ( MetaAds[Impressions] ) ) * 1000

CTR = DIVIDE ( SUM ( MetaAds[LinkClicks] ), SUM ( MetaAds[Impressions] ) )

Cost per Result = DIVIDE ( SUM ( MetaAds[Spend] ), SUM ( MetaAds[Results] ) )

ROAS = DIVIDE ( SUM ( MetaAds[PurchaseValue] ), SUM ( MetaAds[Spend] ) )

• Reach is de-duplicated per query; summing daily reach overstates people reached.
• Attribution windows (for example 7-day click) change results; record the window used in the column name.
• Results mean different things per objective; compare cost per result only within the same objective.

• Marketing template

  Marketing Campaign Performance

  Power BI marketing dashboard template: spend, CTR, leads, CPL and ROAS KPIs, spend vs leads trend, lead funnel and channel efficiency charts.

• Marketing template

  Web Analytics & SEO

  Dark 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 Performance

  Power BI social media dashboard template: followers and growth by network, engagement rate by content type, best day and time to post, and top posts.

• Marketing template

  Email Marketing

  Power BI email marketing template: open, click and unsubscribe rates, revenue per 1,000 emails, list growth, revenue by campaign type and sends.

More by department: Marketing templates

• Visual

  Funnel Chart

  Sales pipeline: leads → MQLs → SQLs → opportunities → closed won; Marketing funnel: impressions → clicks → landing page views → sign-ups

• Visual

  Bullet Chart

  Executive KPI scorecards (5-10 KPIs in a grid); Sales attainment across reps or regions

• Visual

  Heatmap

  Hour-of-day × day-of-week traffic or activity patterns; Correlation matrix between dozens of numeric metrics

• Visual

  Calendar Heatmap

  Daily sales or revenue intensity across the year; Website traffic patterns (day-of-week × week-of-year)

• No connector of its own in Microsoft's list

  Google Ads in Power BI

  Google Ads data in Power BI

• No connector of its own in Microsoft's list

  LinkedIn Ads in Power BI

  LinkedIn Ads data in Power BI

• Connector in Microsoft's list

  Google Analytics 4 in Power BI

  Google Analytics 4 in Power BI

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