Power BI Facebook Ads Report Dashboard Template

Designed for:

This Power BI Meta/Facebook Ads Overview Report template helps you visualise your Facebook Ads performance in Power BI in a few clicks with no complex technical configurations.

power bi facebook ads report 1
power bi facebook ads report 1

How to use this template: setup instructions

Prerequisites:

  • Facebook Ads account with the appropriate permissions
  • Active Windsor.ai account
  • Power BI Desktop/Web app

 

The template is available as:

1

Connect your Facebook Ads (Meta) data to Windsor.ai

Register or log in if you already have an account, and connect your Facebook Ads account. Select at least one Facebook Ads account from the drop-down.

connect facebook ads to bigquery
connect facebook ads to bigquery
power bi destination windsor
power bi facebook ads report 1
Power BI Facebook Ads Dashboard 4

Power BI Facebook Ads dashboard template: metrics, dimensions, and breakdowns

Dimensions

  • Campaigns
  • Ad set

Breakdowns

  • Country
  • Age
  • Gender
  • Objective
  • Device
  • Publisher (Facebook, Instagram, Audience Network, …)

Metrics

  • Cost
  • CPM
  • Impressions
  • Clicks (all)
  • CTR
  • CPC
  • Website Conversions
  • Website Purchases
  • Website Purchase Revenue
  • Cost per Website Conversion
  • Actions (overall)
  • Cost per Website Purchase
  • Cost

The Power BI Facebook Ads report template contains two pages:

1) Overview

Power BI Facebook Ads Overview Report Template

 

2) Breakdowns:

Power BI Facebook Ads Breakdowns Template

 

You can customize this Power BI Facebook Ads report dashboard template with > 500 different dimensions, breakdowns, and metrics. View a comprehensive list of available metrics and dimensions. It queries the data through our connector and makes it available in real-time.

To get started with the Facebook Ads ROAS Power BI template

This .pibx template will let you explore the data once you connect your data and apply your API Key. If you are an advanced Power BI user, using this format allows you to explore the data in greater detail.

This Facebook Ads ROAS Power BI Report template helps you to visualize and understand your ROAS data. Dimensions and metrics visualized in this report are:

  • Date
  • Campaign
  • Reach
  • Clicks
  • Impressions
  • Spend
  • Purchase Value and
  • ROAS

Download the latest version of the dashboard template in .PBIX format here and follow the steps outlined above to connect your data.

Please note that the source data is in US regional settings format (1234.56 and 2020-12-16), and if you are using different locale settings, you might need to transform numerical and date data. This will allow you to change the visuals and join the data with other data sets you might already have in your data setup.

FAQs

Where can I download this Facebook Ads Power BI template?

Just follow the links below to download the template in the necessary format:

  • For Power BI Web App:

Install Power BI Windsor.ai connector: Facebook Ads Overview Report

  • For Power BI Desktop:

Download Power BI Desktop Template: Facebook Ads Overview Report

Tired of manual Facebook Ads data exports? Try Windsor.ai today to automate your reporting

Access all your data from various sources in one place. Get started for free with a 30-day trial.
g logo
fb logo
big query data
youtube logo
power logo
looker logo