Facebook Ads Google Data Studio Connector by Windsor.ai

facebook

+

data studio

About the Connector

The connector pulls Metrics and Dimensions for Facebook Ad Insights. The Insights are retrieved at Ad Level.

There are 300+ Metrics and Dimensions exposed by this connector. Once user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

The user should have a valid Facebook login ID and at least one ad account attached to that Facebook login ID.

Our privacy policy and terms of use: https://www.windsor.ai/privacy-statement/

Facebook Ads Google Data Studio Templates

Available metrics and dimensions

NameTypeDescription
Ad IDDimension
The unique ID of the ad that you’re viewing in reporting.
Ad nameDimension
The name of the ad that you’re viewing in the report.
Campaign IDDimension
Campaign nameDimension
Ad set IDDimension
The unique ID of the ad set you’re viewing in reports.
Ad set nameDimension
The name of the ad set that you’re viewing in reporting.
Account currencyDimension
DateDimension
Date, e.g. 20170131
Day of weekDimension
MonthDimensionMonth, e.g. 6
Account nameDimension
Account IDDimension
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
YearDimensionYear, e.g. 2017
Year & monthDimension
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 unlockedMetric
Mobile app sessionsMetric
Mobile app adds of payment infoMetric
Mobile app adds to cartMetric
Mobile app adds to wishlistMetric
Mobile app registrations completedMetric
Mobile app content viewsMetric
Mobile app checkouts initiatedMetric
Mobile app levels completedMetric
Mobile app purchasesMetric
Mobile app ratings submittedMetric
Mobile app searchesMetric
Mobile app credits spentMetric
Mobile app tutorials completedMetric
Other mobile app actionsMetric
Desktop app engagementsMetric
Desktop app installsMetric
Desktop app story engagementsMetric
Desktop app usesMetric
Check-insMetric
Post commentsMetric
Credit spendsMetric
Game playsMetric
Leads (form)Metric
Page likesMetric
Link clicksMetric
Mobile app installsMetric
Page engagementsMetric
Photo viewsMetric
Post sharesMetric
Post engagementsMetric
Post reactionsMetric
Event responsesMetric
Page subscribesMetric
Page subscribe actions
Credits spent conversion valueMetric
Mobile app checkouts conversion valueMetric
Mobile app purchases conversion valueMetric
Mobile app credits spent conversion valueMetric
Conversion value within 1 day of clickMetric
Conversion value within 1 day of viewMetric
Conversion value within 28 days of clickMetric
Conversion value within 28 days of viewMetric
Conversion value within 7 days of clickMetric
Conversion value within 7 days of viewMetric
Clicks to play videoMetric
Three-second video viewsMetric
ActionsMetric
Conversions within 1 day of clickMetric
Conversions within 1 day of viewMetric
Conversions within 28 days of clickMetric
Conversions within 28 days of viewMetric
Conversions within 7 days of clickMetric
Conversions within 7 days of viewMetric
Total action valueMetric
Mobile app adds to cart conversion valueMetric
The conversion value of cart adds made on mobile platforms
Blocked message conversationsMetric
Avg. canvas view ratioMetric
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 timeMetric
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 viewMetric
Cost per three-second video viewMetric
Cost per app installMetric
Cost per check-inMetric
Cost per credit spend actionMetric
Cost per desktop app engagementMetric
Cost per desktop app installMetric
Cost per desktop app story engagementMetric
Cost per desktop app useMetric
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 responseMetric
Cost per game playMetric
Cost per landing page viewMetric
Cost per lead (form)Metric
Cost per messaging replyMetric
Cost per mobile app achievement unlockedMetric
Cost per mobile app add to basketMetric
Cost per mobile app add to wishlistMetric
Cost per mobile app checkout initiatedMetric
Cost per mobile app content viewMetric
Cost per mobile app credit spentMetric
Cost per mobile app installMetric
Cost per mobile app level completedMetric
Cost per mobile app payment info addMetric
Cost per mobile app purchaseMetric
Cost per mobile app rating submittedMetric
Cost per mobile app registration completedMetric
Cost per mobile app searchMetric
Cost per mobile app tutorial completedMetric
Cost per new messaging conversationMetric
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 initiatedMetric
Cost per website checkout initiated.
Cost per on-Facebook purchaseMetric
Cost per workflow completion on FacebookMetric
Cost per other mobile app actionMetric
Cost per other unique mobile app actionMetric
Cost per page engagementMetric
Cost per page likeMetric
Cost per photo viewMetric
Cost per post commentMetric
Cost per post engagementMetric
Cost per post reactionMetric
Cost per post shareMetric
Cost per store visitMetric
Cost per ThruPlayMetric
The average cost for each ThruPlay.
Cost per unique page engagementMetric
Cost per unique check-inMetric
Cost per unique credit spend actionMetric
Cost per unique desktop app engagementMetric
Cost per unique desktop app installMetric
Cost per unique desktop app story engagementMetric
Cost per unique desktop app useMetric
Cost per unique event responseMetric
Cost per unique game playMetric
Cost per unique mobile app achievement unlockedMetric
Cost per unique mobile app actionMetric
Cost per unique mobile app add to basketMetric
Cost per unique mobile app add to wishlistMetric
Cost per unique mobile app checkout initiatedMetric
Cost per unique mobile app content viewMetric
Cost per unique mobile app credit spentMetric
Cost per unique mobile app installMetric
Cost per unique mobile app level completedMetric
Cost per unique mobile app payment info addMetric
Cost per unique mobile app purchaseMetric
Cost per unique mobile app rating submittedMetric
Cost per unique mobile app registration completedMetric
Cost per unique mobile app searchMetric
Cost per unique mobile app tutorial completedMetric
Cost per unique page likeMetric
Cost per unique photo viewMetric
Cost per unique post commentMetric
Cost per unique post engagementMetric
Cost per unique post reactionMetric
Cost per unique post shareMetric
Cost per website add of payment infoMetric
Cost per website add to cartMetric
Cost per website add to wishlistMetric
Cost per website registration completedMetric
Cost per website conversionMetric
Cost per website custom conversionMetric
Cost per website leadMetric
Cost per website purchaseMetric
Cost per website searchMetric
Cost per website content viewsMetric
Cost per any actionMetric
CPC (all)Metric
CPC (link)Metric
CPMMetric
The average cost for 1,000 impressions.
Cost per outbound clickMetric
Cost per 1000 people reachedMetric
CTR (all)Metric
Estimated ad recall lift rateMetric
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.
FrequencyMetric
The average number of times each person saw your ad.
ImpressionsMetric
The number of times your ads were on screen
Inline link clicksMetric
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 engagementMetric
The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.
Landing page viewsMetric
CTR (link)Metric
New messaging conversations within 7 daysMetric
Website conversion valueMetric
Website adds of payment info conversion valueMetric
Website adds to cart conversion valueMetric
Website adds to wishlist conversion valueMetric
Website registrations completed conversion valueMetric
Website custom conversions valueMetric
Website checkouts initiated conversion valueMetric
Website leads conversion valueMetric
Website purchases conversion valueMetric
Website searches conversion valueMetric
Website content views conversion valueMetric
Website conversionsMetric
Website adds of payment infoMetric
Website adds to cartMetric
Website adds to wishlistMetric
Website registrations completedMetric
Website custom conversionsMetric
Website checkouts initiatedMetric
Website leadsMetric
Website purchasesMetric
Website searchesMetric
Website content viewsMetric
Conversion value of purchase on FacebookMetric
On-Facebook purchasesMetric
On-Facebook workflow completionMetric
Conversion value of workflow completion on FacebookMetric
Outbound clicksMetric
The number of clicks on links that take people off Facebook-owned properties.
Outbound CTRMetric
Quality rankingMetric
Ad’s perceived quality compared with ads competing for the same audience.
ReachMetric
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 scoreMetric
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 spendMetric
Account amount spentMetric
Cost per unique click (all)Metric
Cost per unique link clickMetric
Cost per unique outbound clickMetric
Unique CTR (all)Metric
Unique payment info addsMetric
The estimated number of people who submitted payment info
Unique adds to cartMetric
The estimated number of people who added items to their cart
Unique adds to wishlistMetric
The estimated number of people who added items to their wishlist
Unique mobile app actionsMetric
Unique mobile app achievements unlockedMetric
Unique mobile app sessionsMetric
Unique mobile app adds of payment infoMetric
Unique mobile app adds to cartMetric
Unique mobile app adds to wishlistMetric
Unique mobile app registrations completedMetric
Unique mobile app content viewsMetric
Unique mobile app checkouts initiatedMetric
Unique mobile app levels completedMetric
Unique mobile app purchasesMetric
Unique mobile app ratings submittedMetric
Unique mobile app searchesMetric
Unique mobile app credits spentMetric
Unique mobile app tutorials completedMetric
Other unique mobile app actionsMetric
Unique desktop app engagementsMetric
Unique desktop app installsMetric
Unique desktop app story engagementsMetric
Unique desktop app usesMetric
Unique check-insMetric
Unique post commentsMetric
Unique completed registrationsMetric
The estimated number of people who registered
Unique credit spendsMetric
Unique game playsMetric
Unique initiated checkoutsMetric
The estimated number of people who initiated checkouts
Unique instagram profile engagementsMetric
The estimated number of people who engaged with instagram profile
Unique leadsMetric
The estimated number of people with lead events
Unique leads (form)Metric
Unique page likesMetric
Unique link clicksMetric
Unique mobile app installsMetric
Unique mobile app retentionsMetric
The estimated number of people who performed mobile app retention
Unique mobile app ROASMetric
The estimated number of people who generated mobile app purchase ROAS
Unique website conversionsMetric
The estimated number of people with offsite conversions
Unique website engagementsMetric
The estimated number of people with offsite engagements
Unique Omni achievement unlocksMetric
The estimated number of people who unlocked achievement across all channels
Unique Omni app activationsMetric
The estimated number of people who activated app across all channels
Unique Omni adds to cartMetric
The estimated number of people who added items to their cart across all channels
Unique Omni app installsMetric
The estimated number of people who completed app installs across all channels
Unique Omni completed registrationsMetric
The estimated number of people who completed registration across all channels
Unique Omni custom actionsMetric
The estimated number of people who performed custom actions across all channels
Unique Omni initiated checkoutsMetric
The estimated number of people who initiated checkout across all channels
Unique Omni level completedMetric
The estimated number of people who completed level across all channels
Unique Omni purchasesMetric
The estimated number of people who completed at least one purchase across all channels
Unique Omni ratesMetric
The estimated number of people who rated across all channels
Unique Omni searchesMetric
The estimated number of people who searched across all channels
Unique Omni credit spendsMetric
The estimated number of people who spent credits across all channels
Unique Omni completed tutorialsMetric
The estimated number of people who completed tutorials across all channels
Unique Omni content viewsMetric
The estimated number of people who viewed content across all channels
Unique desktop adds to cartMetric
The estimated number of people who added items to their cart on desktop app
Unique desktop purchasesMetric
The estimated number of people who completed at least one purchase on desktop app
Unique desktop content viewsMetric
The estimated number of people who viewed content on desktop app
Unique conversionsMetric
The estimated number of people with onsite conversions
Unique web adds to cartMetric
The estimated number of people who added items to their cart on web
Unique web app adds to cartMetric
The estimated number of people who added items to their cart on web app
Unique web app eventsMetric
The estimated number of people who engaged on web app
Unique web app purchasesMetric
The estimated number of people who completed at least one purchase on web app
Unique web app content viewsMetric
The estimated number of people who viewed content on web app
Unique web purchasesMetric
The estimated number of people who completed at least one purchase on web
Unique web content viewsMetric
The estimated number of people who viewed content on web
Unique page engagementsMetric
Unique page stories engagementsMetric
The estimated number of people who engaged with page stories
Unique photo viewsMetric
Unique post sharesMetric
Unique post engagementsMetric
Unique post reactionsMetric
Unique post stories engagementsMetric
The estimated number of people who engaged with post stories
Unique purchasesMetric
The estimated number of people who completed at least one purchase
Unique event responsesMetric
Unique searchesMetric
The estimated number of people who searched
Unique store visits with dwellMetric
The estimated number of people visited your stores, attributed to your ads with `Dwell time`
Unique subscribesMetric
The estimated number of people with subscribe events
Unique clicks to play videoMetric
Unique three-second video viewsMetric
Unique content viewsMetric
The estimated number of people who viewed content
Unique conversions within 1 day of clickMetric
Unique conversions within 1 day of viewMetric
Unique conversions within 28 days of clickMetric
Unique conversions within 28 days of viewMetric
Unique conversions within 7 days of clickMetric
Unique conversions within 7 days of viewMetric
Unique inline link clicksMetric
The number of people who performed an inline link click.
Unique outbound clicksMetric
The number of people who performed an outbound click.
Unique outbound CTRMetric
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 viewsMetric
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 viewsMetric
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 watchedMetric
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 actionsMetric
The number of times your video was played to completion, or for at least 15 seconds.
Website purchase ROASMetric