Microsoft Power BI Facebook Ads Marketing Report Template

Comprehensive Power BI Facebook Ads Marketing Report

Exploring a wide range of Facebook Ads metrics was always a challenge. Now, with this .pbix template, you can go deep into the data and discover the relationships between different conversion metrics. When you connect your data and apply your API Key, you can start analyzing your data. Advanced Power BI users using this format, can explore the data in more depth.

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

Date
Campaign
Action Type including
- App Conversions
- Onsite Conversions
- Offsite Conversions
- Omni Conversions

There is a list of close to 300 metrics and dimensions available once you start customizing the report. To find the full list head to Available metrics and dimensions.

It queries the data through our connector and makes it available in real-time. 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.

To get started with the Power BI Facebook Ads Marketing Report Template

Connect your Facebook Ads Data to Windsor.ai here. Register or login if you already have an account.
Select at least one Facebook Ads account from the dropdown and remember to grant access
Copy the API Key on the top right corner of the Onboard form page.
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.
In the Facebook Ads ROAS Power BI template on the start screen, paste your API Key from step 3 like here and Load the data

Api Key

You can watch this “How to visualize your marketing data in Power BI using WindsorAI” video to help you start.

Available metrics and dimensions

Name	Type	Description
Ad ID	Dimension	The unique ID of the ad that you’re viewing in reporting.
Ad name	Dimension	The name of the ad that you’re viewing in the report.
Campaign ID	Dimension
Campaign name	Dimension
Ad set ID	Dimension	The unique ID of the ad set you’re viewing in reports.
Ad set name	Dimension	The name of the ad set that you’re viewing in reporting.
Account currency	Dimension
Date	Dimension	Date, e.g. 20170131
Day of week	Dimension
Month	Dimension	Month, e.g. 6
Account name	Dimension
Account ID	Dimension
Engagement Rate Ranking (text)	Dimension	Ad’s expected engagement rate compared with ads competing for the same audience.
Conversion Rate Ranking (text)	Dimension	Ad’s expected conversion rate compared with ads that had the same optimisation goal and competed for the same audience.
Week (Mon-Sun)	Dimension	ISO week number, e.g. 51
Week (Sun-Sat)	Dimension	US week number, e.g. 51
Year	Dimension	Year, e.g. 2017
Year & month	Dimension	Year and month, e.g. 2017\|06
Year of week (Mon-Sun)	Dimension
Year of week (Sun-Sat)	Dimension
Year & week (Sun-Sat)	Dimension	Year and week for US weeks, e.g. 2017\|08
Year & week (Mon-Sun)	Dimension	Year and week for ISO weeks, e.g. 2017\|08
Mobile app achievements unlocked	Metric
Mobile app sessions	Metric
Mobile app adds of payment info	Metric
Mobile app adds to cart	Metric
Mobile app adds to wishlist	Metric
Mobile app registrations completed	Metric
Mobile app content views	Metric
Mobile app checkouts initiated	Metric
Mobile app levels completed	Metric
Mobile app purchases	Metric
Mobile app ratings submitted	Metric
Mobile app searches	Metric
Mobile app credits spent	Metric
Mobile app tutorials completed	Metric
Other mobile app actions	Metric
Desktop app engagements	Metric
Desktop app installs	Metric
Desktop app story engagements	Metric
Desktop app uses	Metric
Check-ins	Metric
Post comments	Metric
Credit spends	Metric
Game plays	Metric
Leads (form)	Metric
Page likes	Metric
Link clicks	Metric
Mobile app installs	Metric
Page engagements	Metric
Photo views	Metric
Post shares	Metric
Post engagements	Metric
Post reactions	Metric
Event responses	Metric
Page subscribes	Metric	Page subscribe actions
Credits spent conversion value	Metric
Mobile app checkouts conversion value	Metric
Mobile app purchases conversion value	Metric
Mobile app credits spent conversion value	Metric
Conversion value within 1 day of click	Metric
Conversion value within 1 day of view	Metric
Conversion value within 28 days of click	Metric
Conversion value within 28 days of view	Metric
Conversion value within 7 days of click	Metric
Conversion value within 7 days of view	Metric
Clicks to play video	Metric
Three-second video views	Metric
Actions	Metric
Conversions within 1 day of click	Metric
Conversions within 1 day of view	Metric
Conversions within 28 days of click	Metric
Conversions within 28 days of view	Metric
Conversions within 7 days of click	Metric
Conversions within 7 days of view	Metric
Total action value	Metric
Mobile app adds to cart conversion value	Metric	The conversion value of cart adds made on mobile platforms
Blocked message conversations	Metric
Avg. canvas view ratio	Metric	The average percentage of the Facebook Canvas that people saw. Canvas is a screen that opens on mobile after a person clicks the Canvas link in your ad. It may include a series of interactive or multimedia components, including video, images, product catalogs and more.
Avg. canvas view time	Metric	The average total time, in seconds, that people spent viewing a Facebook Canvas. Canvas is a screen that opens on mobile after a person clicks the Canvas link in your ad. It may include a series of interactive or multimedia components, including video, images, product catalogs and more.
Clicks (all)	Metric
Cost per ten-second video view	Metric
Cost per three-second video view	Metric
Cost per app install	Metric
Cost per check-in	Metric
Cost per credit spend action	Metric
Cost per desktop app engagement	Metric
Cost per desktop app install	Metric
Cost per desktop app story engagement	Metric
Cost per desktop app use	Metric
Cost per estimated ad recall lift (people)	Metric	The average cost for each estimated ad recall lift. This Metric is only available for assets in the Brand Awareness Objective.
Cost per event response	Metric
Cost per game play	Metric
Cost per landing page view	Metric
Cost per lead (form)	Metric
Cost per messaging reply	Metric
Cost per mobile app achievement unlocked	Metric
Cost per mobile app add to basket	Metric
Cost per mobile app add to wishlist	Metric
Cost per mobile app checkout initiated	Metric
Cost per mobile app content view	Metric
Cost per mobile app credit spent	Metric
Cost per mobile app install	Metric
Cost per mobile app level completed	Metric
Cost per mobile app payment info add	Metric
Cost per mobile app purchase	Metric
Cost per mobile app rating submitted	Metric
Cost per mobile app registration completed	Metric
Cost per mobile app search	Metric
Cost per mobile app tutorial completed	Metric
Cost per new messaging conversation	Metric
Cost per website checkout initiated (conversion tracking pixel) (Deprecated)	Metric	Please note that this field will be removed on 2019-05-13.
Cost per website lead (conversion tracking pixel) (Deprecated)	Metric	Please note that this field will be removed on 2019-05-13.
Cost per website registration (conversion tracking pixel) (Deprecated)	Metric	Please note that this field will be removed on 2019-05-13.
Cost per website checkout initiated	Metric	Cost per website checkout initiated.
Cost per on-Facebook purchase	Metric
Cost per workflow completion on Facebook	Metric
Cost per other mobile app action	Metric
Cost per other unique mobile app action	Metric
Cost per page engagement	Metric
Cost per page like	Metric
Cost per photo view	Metric
Cost per post comment	Metric
Cost per post engagement	Metric
Cost per post reaction	Metric
Cost per post share	Metric
Cost per store visit	Metric
Cost per ThruPlay	Metric	The average cost for each ThruPlay.
Cost per unique page engagement	Metric
Cost per unique check-in	Metric
Cost per unique credit spend action	Metric
Cost per unique desktop app engagement	Metric
Cost per unique desktop app install	Metric
Cost per unique desktop app story engagement	Metric
Cost per unique desktop app use	Metric
Cost per unique event response	Metric
Cost per unique game play	Metric
Cost per unique mobile app achievement unlocked	Metric
Cost per unique mobile app action	Metric
Cost per unique mobile app add to basket	Metric
Cost per unique mobile app add to wishlist	Metric
Cost per unique mobile app checkout initiated	Metric
Cost per unique mobile app content view	Metric
Cost per unique mobile app credit spent	Metric
Cost per unique mobile app install	Metric
Cost per unique mobile app level completed	Metric
Cost per unique mobile app payment info add	Metric
Cost per unique mobile app purchase	Metric
Cost per unique mobile app rating submitted	Metric
Cost per unique mobile app registration completed	Metric
Cost per unique mobile app search	Metric
Cost per unique mobile app tutorial completed	Metric
Cost per unique page like	Metric
Cost per unique photo view	Metric
Cost per unique post comment	Metric
Cost per unique post engagement	Metric
Cost per unique post reaction	Metric
Cost per unique post share	Metric
Cost per website add of payment info	Metric
Cost per website add to cart	Metric
Cost per website add to wishlist	Metric
Cost per website registration completed	Metric
Cost per website conversion	Metric
Cost per website custom conversion	Metric
Cost per website lead	Metric
Cost per website purchase	Metric
Cost per website search	Metric
Cost per website content views	Metric
Cost per any action	Metric
CPC (all)	Metric
CPC (link)	Metric
CPM	Metric	The average cost for 1,000 impressions.
Cost per outbound click	Metric
Cost per 1000 people reached	Metric
CTR (all)	Metric
Estimated ad recall lift rate	Metric	The rate at which an estimated number of additional people, when asked, would remember seeing your ads within 2 days. This Metric is only available for assets in the Brand Awareness Objective.
Estimated ad recall lift (people)	Metric	An estimate of the number of additional people who may remember seeing your ads, if asked, within 2 days. This Metric is only available for assets in the Brand Awareness Objective.
Frequency	Metric	The average number of times each person saw your ad.
Impressions	Metric	The number of times your ads were on screen
Inline link clicks	Metric	The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window.
Inline post engagement	Metric	The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.
Landing page views	Metric
CTR (link)	Metric
New messaging conversations within 7 days	Metric
Website conversion value	Metric
Website adds of payment info conversion value	Metric
Website adds to cart conversion value	Metric
Website adds to wishlist conversion value	Metric
Website registrations completed conversion value	Metric
Website custom conversions value	Metric
Website checkouts initiated conversion value	Metric
Website leads conversion value	Metric
Website purchases conversion value	Metric
Website searches conversion value	Metric
Website content views conversion value	Metric
Website conversions	Metric
Website adds of payment info	Metric
Website adds to cart	Metric
Website adds to wishlist	Metric
Website registrations completed	Metric
Website custom conversions	Metric
Website checkouts initiated	Metric
Website leads	Metric
Website purchases	Metric
Website searches	Metric
Website content views	Metric
Conversion value of purchase on Facebook	Metric
On-Facebook purchases	Metric
On-Facebook workflow completion	Metric
Conversion value of workflow completion on Facebook	Metric
Outbound clicks	Metric	The number of clicks on links that take people off Facebook-owned properties.
Outbound CTR	Metric
Quality ranking	Metric	Ad’s perceived quality compared with ads competing for the same audience.
Reach	Metric	The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people.
Relevance score	Metric	A rating from 1 to 10 that estimates how well your target audience is responding to your ad. This score is shown after your ad receives more than 500 impressions.
Return on ad spend (ROAS)	Metric
Social spend	Metric
Account amount spent	Metric
Cost per unique click (all)	Metric
Cost per unique link click	Metric
Cost per unique outbound click	Metric
Unique CTR (all)	Metric
Unique payment info adds	Metric	The estimated number of people who submitted payment info
Unique adds to cart	Metric	The estimated number of people who added items to their cart
Unique adds to wishlist	Metric	The estimated number of people who added items to their wishlist
Unique mobile app actions	Metric
Unique mobile app achievements unlocked	Metric
Unique mobile app sessions	Metric
Unique mobile app adds of payment info	Metric
Unique mobile app adds to cart	Metric
Unique mobile app adds to wishlist	Metric
Unique mobile app registrations completed	Metric
Unique mobile app content views	Metric
Unique mobile app checkouts initiated	Metric
Unique mobile app levels completed	Metric
Unique mobile app purchases	Metric
Unique mobile app ratings submitted	Metric
Unique mobile app searches	Metric
Unique mobile app credits spent	Metric
Unique mobile app tutorials completed	Metric
Other unique mobile app actions	Metric
Unique desktop app engagements	Metric
Unique desktop app installs	Metric
Unique desktop app story engagements	Metric
Unique desktop app uses	Metric
Unique check-ins	Metric
Unique post comments	Metric
Unique completed registrations	Metric	The estimated number of people who registered
Unique credit spends	Metric
Unique game plays	Metric
Unique initiated checkouts	Metric	The estimated number of people who initiated checkouts
Unique instagram profile engagements	Metric	The estimated number of people who engaged with instagram profile
Unique leads	Metric	The estimated number of people with lead events
Unique leads (form)	Metric
Unique page likes	Metric
Unique link clicks	Metric
Unique mobile app installs	Metric
Unique mobile app retentions	Metric	The estimated number of people who performed mobile app retention
Unique mobile app ROAS	Metric	The estimated number of people who generated mobile app purchase ROAS
Unique website conversions	Metric	The estimated number of people with offsite conversions
Unique website engagements	Metric	The estimated number of people with offsite engagements
Unique Omni achievement unlocks	Metric	The estimated number of people who unlocked achievement across all channels
Unique Omni app activations	Metric	The estimated number of people who activated app across all channels
Unique Omni adds to cart	Metric	The estimated number of people who added items to their cart across all channels
Unique Omni app installs	Metric	The estimated number of people who completed app installs across all channels
Unique Omni completed registrations	Metric	The estimated number of people who completed registration across all channels
Unique Omni custom actions	Metric	The estimated number of people who performed custom actions across all channels
Unique Omni initiated checkouts	Metric	The estimated number of people who initiated checkout across all channels
Unique Omni level completed	Metric	The estimated number of people who completed level across all channels
Unique Omni purchases	Metric	The estimated number of people who completed at least one purchase across all channels
Unique Omni rates	Metric	The estimated number of people who rated across all channels
Unique Omni searches	Metric	The estimated number of people who searched across all channels
Unique Omni credit spends	Metric	The estimated number of people who spent credits across all channels
Unique Omni completed tutorials	Metric	The estimated number of people who completed tutorials across all channels
Unique Omni content views	Metric	The estimated number of people who viewed content across all channels
Unique desktop adds to cart	Metric	The estimated number of people who added items to their cart on desktop app
Unique desktop purchases	Metric	The estimated number of people who completed at least one purchase on desktop app
Unique desktop content views	Metric	The estimated number of people who viewed content on desktop app
Unique conversions	Metric	The estimated number of people with onsite conversions
Unique web adds to cart	Metric	The estimated number of people who added items to their cart on web
Unique web app adds to cart	Metric	The estimated number of people who added items to their cart on web app
Unique web app events	Metric	The estimated number of people who engaged on web app
Unique web app purchases	Metric	The estimated number of people who completed at least one purchase on web app
Unique web app content views	Metric	The estimated number of people who viewed content on web app
Unique web purchases	Metric	The estimated number of people who completed at least one purchase on web
Unique web content views	Metric	The estimated number of people who viewed content on web
Unique page engagements	Metric
Unique page stories engagements	Metric	The estimated number of people who engaged with page stories
Unique photo views	Metric
Unique post shares	Metric
Unique post engagements	Metric
Unique post reactions	Metric
Unique post stories engagements	Metric	The estimated number of people who engaged with post stories
Unique purchases	Metric	The estimated number of people who completed at least one purchase
Unique event responses	Metric
Unique searches	Metric	The estimated number of people who searched
Unique store visits with dwell	Metric	The estimated number of people visited your stores, attributed to your ads with `Dwell time`
Unique subscribes	Metric	The estimated number of people with subscribe events
Unique clicks to play video	Metric
Unique three-second video views	Metric
Unique content views	Metric	The estimated number of people who viewed content
Unique conversions within 1 day of click	Metric
Unique conversions within 1 day of view	Metric
Unique conversions within 28 days of click	Metric
Unique conversions within 28 days of view	Metric
Unique conversions within 7 days of click	Metric
Unique conversions within 7 days of view	Metric
Unique inline link clicks	Metric	The number of people who performed an inline link click.
Unique outbound clicks	Metric	The number of people who performed an outbound click.
Unique outbound CTR	Metric
People taking action (unique actions)	Metric	The number of people who took an action that was attributed to your ads.
Unique clicks (all)	Metric
Ten-second video views	Metric	The number of times your video was watched for an aggregate of at least 10 seconds, or for nearly its total length, whichever happened first.
15-second video views (Deprecated)	Metric
30-second video views	Metric	The number of times your video was watched for an aggregate of at least 30 seconds, or for nearly its total length, whichever happened first.
Video average percentage watched	Metric	The average percentage of your video that people watched.
Video watches at 100%	Metric	The number of times your video was watched at 100% of its length, including watches that skipped to this point.
Video watches at 25%	Metric	The number of times your video was watched at 25% of its length, including watches that skipped to this point.
Video watches at 50%	Metric	The number of times your video was watched at 50% of its length, including watches that skipped to this point.
Video watches at 75%	Metric	The number of times your video was watched at 75% of its length, including watches that skipped to this point.
Video watches at 95%	Metric	The number of times your video was watched at 95% of its length, including watches that skipped to this point.
ThruPlay actions	Metric	The number of times your video was played to completion, or for at least 15 seconds.
Website purchase ROAS	Metric

Microsoft Power BI Facebook Ads Marketing Report Template

To get started with the Power BI Facebook Ads Marketing Report Template

You can watch this “How to visualize your marketing data in Power BI using WindsorAI” video to help you start.

You might also be interested in…

Available metrics and dimensions

Related Posts