Power BI Facebook Ads Report Dashboard Template

power bi facebook ads report 1

This Power BI Meta / Facebook Ads Overview Report template helps you to visualise your Facebook Ads performance in Power BI in a few clicks.

Follow the steps outlined below to get your data connected.

 

Main steps to get started with Power BI Facebook Ads Report Template

The template is available both as

 

 

Power BI Web Template

  1. Connect your Facebook Ads (Meta) Data to Windsor.ai

    Connect Facebook Ads

    Register or login if you already have an account.

  2. Choose Facebook Ads from the left-side menu, then click on “Grant Facebook Access”, login with your Facebook account and grant the required privileges.
  3. Select at least one Facebook Ads account from the drop-down.
  4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
  5. Install the Power BI Web App

    Install Power BI Web App: Facebook Ads Overview Report

  6. Click on Connect your data Facebook Ads - Connect your Data
  7. Enter your API key which you got in Step 4Power BI Facebook Ads Dashboard 4
  8. On the next screen click on Sign In
  9. Your data should be loading now. Depending on your data size this may take a minute or two.

 

Power BI Desktop

  1. Connect your Facebook Ads Data to Windsor.ai

    Connect Facebook Ads

    Register or login if you already have an account.

  2. Choose Facebook Ads from the left-side menu, then click on “Grant Facebook Access”, login with your Facebook account and grant the required privileges.
  3. Select at least one Facebook Ads account from the drop-down.
  4. Click on Preview and Destination, choose Power BI Web, then copy your API Key.
  5. Download the Desktop Template

    Download Power BI Desktop Template: Facebook Ads Overview Report

  6. In the template on the start screen, paste your API Key from step 4 like here:

Api Key

Important: You will need to change the fields to their types (e.g. date, decimals, whole numbers, …) to use them in aggregations (sums, averages, …) or date filters. For users in Europe and other countries where a comma is used for decimals please change the locale of the data to English.

 

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

 

Power BI Facebook Ads report template contains two pages.

Overview

Power BI Facebook Ads Overview Report Template

 

Breakdowns

Power BI Facebook Ads Breakdowns Template

 

The Power BI Facebook Ads report dashboard template can be customised with > 500 different dimensions, breakdowns and metrics. Head here to see a complete list: 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, you can explore the data in more 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

 

Follow the steps outlined below to connect your data. In case you are interested in the Power BI desktop file used to create the report, simply scroll down further.

 

  1. Connect your Facebook Ads Data to Windsor.ai here. Register or login if you already have an account.FB Ads ROAS Power Bi Template: Step 1
  2. Select at least one Facebook Ads account from the dropdown and remember to grant accessfacebook ads connector
  3. Copy the API Key on the top right corner of the Onboard form page.
  4. Download the latest version of the dashboard template in .PBIX format here. Please note that the source data are in US regional settings format (1234.56 and 2020-12-16), and if you are using the 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.
  5. In the Facebook Ads ROAS Power BI template on the start screen, paste your API Key from step 3 like here

FB Ads ROAS Power Bi Template: Step 3

6. Start analyzing your data.

 

You might also be interested in…