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 |
