Facebook Ads reporting template for Power BI
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!
Insights at a glance
Deep dive into channel performance
Optimize your spend
How to use the template
To get started, make sure that you've got access to Facebook Ads and that you're logged in to Power BI. Note that connecting the template to Facebook Ads will start a 14-day free trial of Supermetrics for Power BI.
- Log in to Supermetrics Hub. If new to Supermetrics, connect to your data source via the Power BI page on Supermetrics Hub.
- Select and authenticate the data source for your template.
- Download and open the template in Power BI. Sign in if prompted. The template will automatically fetch and display your data.
- Change accounts (if needed). Open Query Editor in Power BI Desktop by clicking 'Transform data.' Modify the account settings in the Invoked Function step for each relevant table.
More instructions on How to use Supermetrics report templates in the Power BI article.
Questions you can answer with this template
Overall campaign performance
- 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?
Conversions
- 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?
Campaigns
- 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?
Videos
- 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?
Get started with Facebook Ads reporting template for Power BI
Try our free template and experience the power of insights with a 14-day free trial. No credit card required.
See our other templates
Stay in the loop with our newsletter
Be the first to hear about product updates and marketing data tips