Power BI
Facebook Ads reporting template for Power BI
Use cases
Data sources
Optimize your campaigns with data-driven insights using this Facebook Ads reporting template for Power BI. See the instructions below and start using the template!
Get startedTrusted by 200,000+ companies in 120 countries
Insights at a glance
Deep dive into channel performance
Optimize your spend
- Log in to Supermetrics Hub .
- On the Power BI page in Supermetrics Hub, click "Create new query", pick Facebook Ads as the data source, and log in. You have now connected Supermetrics to Power BI.
- Next, you have to download the template. Click 'Get the template' below. The download will start automatically.
- Open the template in Power BI. Click 'Refresh' in Home Tab.
- If prompted, sign in to the same account you used in Supermetrics Hub. After this, the template will fetch all your data in the report, ready for you to derive insights.
Questions you can answer with this template
-
- What is the total spend on each platform?
- What are the overall impressions during last month?
- How’s the overall performance of your posts?
- What is the overall CTR, CPM, and CPC during a certain period of time?
-
- How many conversions were generated during the last month?
- What is the CVR% per publisher platform?
- What is the spend and cost per conversion by date?
- What is your ROAS?
-
- What are the top campaigns by spend?
- How did your key metrics look like by campaign or ad group?
- What are the top ad sets by spend?
- What’s the CPA per campaign?
-
- How does your video perform in general?
- How many people watched 50% of the video?
- What are your video views, impressions, and VTR?
- What are the top-performing video campaigns by views?
What our clients say
Don’t just take our word for it
See our other templates