Connect Facebook Ads to Snowflake with Windsor.ai

facebook logo 1

+

snowflake

Stream all your marketing data from Facebook Ads to Snowflake

About Facebook Ads

Facebook Ads is a social media advertising platform which allows businesses and individuals to advertise to their target audiences on Facebooks social media platform.

About Snowflake

Snowflake is a cloud data warehouse. Contrary to on premise data bases it eliminates the need to maintain hardware infrastructure. I’s architecture allow it to scale dynamically depending on the resource consumption needed by the users. The outcome of working with a cloud data warehouse like Snowflake is a greatly increased productivity of end users working with Snowflake data.

Facebook Ads metrics and dimensions available for streaming into Snowflake

NameTypeDescription
CurrencyTEXTCurrency that is used by your ad account.
Account IDTEXTThe ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.
Account NameTEXTThe name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing.
Account ID (duplicate)TEXTThe ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. (duplicate)
Adds of Payment Info Conversion ValueNUMERICThe total value of adds of payment info tracked with the conversions objective.
Adds to Cart Conversion ValueNUMERICThe total value of adds to cart tracked with the conversions objective.
Adds to Wishlist Conversion ValueNUMERICThe total value of adds to wishlist tracked with the conversions objective.
Action Values App Custom Event.Fb Mobile Add To CartNUMERIC
Action Values App Custom Event.Fb Mobile Add To WishlistNUMERIC
Action Values App Custom Event.Fb Mobile Content ViewNUMERIC
Action Values App Custom Event.Fb Mobile Initiated CheckoutNUMERIC
Action Values App Custom Event.Fb Mobile PurchaseNUMERIC
Action Values App Custom Event.OtherNUMERIC
Registrations Completed Conversion ValueNUMERICThe total value of registrations completed tracked with the conversions objective.
Checkouts Initiated Conversion ValueNUMERICThe total value of checkouts initiated tracked with the conversions objective.
Leads Conversion ValueNUMERICThe total value of leads tracked with the conversions objective.
Website Adds of Payment Info Conversion ValueNUMERICThe total value of website adds of payment info conversions.
Website Adds to Cart Conversion ValueNUMERICThe total value of website add to cart conversions.
Website Adds to Wishlist Conversion ValueNUMERICThe total value of all website add to wishlist conversions.
Website Registrations Completed Conversion ValueNUMERICThe value of complete registration events tracked by the pixel on your website and attributed to your ads.
Website Checkouts Initiated Conversion ValueNUMERICThe total value of website checkout initiated conversions.
Website Leads Conversion ValueNUMERICThe total value of website leads conversions.
Website Purchases Conversion ValueNUMERICThe total value of website purchase conversions.
Website Searches Conversion ValueNUMERICThe total value of website searches conversions.
Website Content Views Conversion ValueNUMERICThe total value of website content views conversions.
Adds to Cart Conversion ValueNUMERICThe total value of adds to cart tracked with the conversions objective.
Registrations Completed Conversion ValueNUMERICThe total value of registrations completed tracked with the conversions objective.
Action Values Omni CustomNUMERIC
Checkouts Initiated Conversion ValueNUMERICThe total value of checkouts initiated tracked with the conversions objective.
Purchases Conversion ValueNUMERICThe total value of purchases tracked with the conversions objective.
Searches Conversion ValueNUMERICThe total value of search conversions.
Credit Spends Conversion ValueNUMERICThe total value of spend credits conversions.
Content Views Conversion ValueNUMERICThe total value of content views tracked with the conversions objective.
Action Values Onsite Conversion.PurchaseNUMERIC
Action Values Onsite Web Add To CartNUMERIC
Action Values Onsite Web App Add To CartNUMERIC
Action Values Onsite Web App PurchaseNUMERIC
Action Values Onsite Web PurchaseNUMERIC
Action Values PurchaseNUMERIC
Searches Conversion ValueNUMERICThe total value of search conversions.
Adds of Payment InfoNUMERICThe number of add payment info events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Adds to CartNUMERICThe number of add to cart events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Adds to WishlistNUMERICThe number of add to wishlist events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Mobile App ActivactionsNUMERICThe number of times your app was activated attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Actions App Custom Event.Fb Mobile Add Payment InfoNUMERIC
Actions App Custom Event.Fb Mobile Add To CartNUMERIC
Actions App Custom Event.Fb Mobile Add To WishlistNUMERIC
Mobile App Registrations CompletedNUMERICThe number of registrations in your mobile app that were recorded as app events and attributed to your ads.
Mobile Content ViewsNUMERICThe number of content views in your mobile app that were recorded as app events and attributed to your ads.
Actions App Custom Event.Fb Mobile Initiated CheckoutNUMERIC
Mobile App Levels CompletedNUMERICThe number of levels achieved in your mobile app that were recorded as app events and attributed to your ads.
Actions App Custom Event.Fb Mobile PurchaseNUMERIC
Actions App Custom Event.Fb Mobile SearchNUMERIC
Actions App Custom Event.Fb Mobile Tutorial CompletionNUMERIC
Mobile App - OtherNUMERIC
Check-InsNUMERICThe number of check-ins to your Facebook Page that are attributed to your ads. If your Page has a physical address associated with it, people can check in to your Page when they update their status in their Facebook News Feed or Timeline.
Post CommentsNUMERICThe number of comments on your ads.
Registrations CompletedNUMERICThe number of complete registration events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Checkouts InitiatedNUMERICThe number of initiate checkout events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Landing Page ViewsNUMERICThe number of times a person clicked on an ad link and then successfully loaded the destination webpage or Instant Experience. To report on landing page views, you must have created a Facebook pixel.
LeadsNUMERICThe number of leads attributed to your ads from Facebook-owned properties (including forms and Messenger) as well as off-Facebook leads tracked by one or more of your connected Facebook Business Tools.
Page LikesNUMERICThe number of likes of your Facebook Page attributed to your ads.
Link ClicksNUMERICThe number of clicks on links within the ad that led to destinations or experiences, on or off Facebook. For ads promoting Instagram profile views, link clicks include clicks on the ad header or comments that led to the advertiser's profile.
Mobile App InstallsNUMERICThe number of installs of your mobile app that were recorded as app events and attributed to your ads.
Website Adds of Payment InfoNUMERICThe number of add payment info events tracked by the pixel on your website and attributed to your ads.
Website Adds to CartNUMERICThe number of add to cart events tracked by the pixel on your website and attributed to your ads.
Website Adds to WishlistNUMERICThe number of add to wishlist events tracked by the pixel on your website and attributed to your ads.
Website Registrations CompletedNUMERICThe number of complete registration events tracked by the pixel on your website and attributed to your ads.
Custom EventsNUMERICThe number of custom events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Website Checkouts InitiatedNUMERICThe number of initiate checkout events tracked by the pixel on your website and attributed to your ads.
Website LeadsNUMERICThe number of lead events tracked by the pixel on your website and attributed to your ads.
Website PurchasesNUMERICThe number of purchase events tracked by the pixel on your website and attributed to your ads.
Website SearchesNUMERICThe number of search events tracked by the pixel on your website and attributed to your ads.
Website Content ViewsNUMERICThe number of view content events tracked by the pixel on your website and attributed to your ads.
Achievements UnlockedNUMERICThe number of unlock achievement events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
App ActivationsNUMERICThe number of times your app was activated attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Adds to CartNUMERICThe number of add to cart events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
App InstallsNUMERICThe number of app installs that were recorded as app events and attributed to your ads.
Registrations CompletedNUMERICThe number of complete registration events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Actions Omni CustomNUMERIC
Checkouts InitiatedNUMERICThe number of initiate checkout events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Levels AchievedNUMERICThe number of achieve level events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
PurchasesNUMERICThe number of purchase events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Ratings SubmittedNUMERICThe number of ratings submitted events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
SearchesNUMERICThe number of search events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Credit SpendsNUMERICThe number of spend credits events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. This does not refer to the total value of credits spent.
Tutorials CompletedNUMERICThe number of completed tutorial events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Content ViewsNUMERICThe number of view content events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
On-Facebook Workflow CompletionsNUMERICThe number of times a workflow was completed within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads.
On-Facebook Leads GroupedNUMERICThe number of leads submitted on Facebook-owned property (including forms and Messenger) and attributed to your ads.
Blocked Messaging ConnectionsNUMERICThe number of times that people blocked a messaging connection with your business, attributed to your ads.
New Messaging ConnectionsNUMERICThe number of people your business added as messaging connections, attributed to your ads.
Post SavesNUMERICThe total number of times your ad has been saved.
On-Facebook PurchasesNUMERICThe number of purchases made within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads.
Actions Onsite Web Add To CartNUMERIC
Actions Onsite Web App Add To CartNUMERIC
Actions Onsite Web App PurchaseNUMERIC
Actions Onsite Web PurchaseNUMERIC
Page EngagementNUMERICThe total number of actions that people took on your Facebook Page and its posts, attributed to your ads.
Photo ViewsNUMERICThe number of views of photos on your Page or posts that are attributed to your ads. Photo views are counted when people click on photos to view them.
Post SharesNUMERICThe number of shares of your ads. People can share your ads or posts on their own or friends' Timelines, in groups and on their own Pages.
Post EngagementNUMERICThe total number of actions that people take involving your ads.
Post ReactionsNUMERICThe number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: Like, Love, Haha, Wow, Sad or Angry.
Event ResponsesNUMERICThe number of people who responded Interested or Going to your Facebook event, attributed to your ads.
SearchesNUMERICThe number of search events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
3-Second Video PlaysNUMERICThe number of times your video played for at least 3 seconds, or for nearly its total length if it's shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video.
Content ViewsNUMERICThe number of view content events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Facebook Page IDTEXTUsed for Instagram Ads. Provide Instagram account ID used for running these ads.
ID of ad format assetNUMERICThe ID of the ad format asset involved in impression, click, or action.
Ad IDTEXTUnique ID of the ad being viewed in reporting
Ad NameTEXTThe name of the ad being viewed in reporting
Ad Set Name (duplicate)TEXTThe name the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting. This column does not apply to campaigns, only ad sets and ads. (duplicate)
Ad Set IDTEXTThe unique ID of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting. This column does not apply to campaigns, only ad sets and ads. (duplicate)
Ad IDTEXTUnique ID of the ad being viewed in reporting (duplicate)
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Ad Network RevenueNUMERICThe Ad Network Reported Revenue
AdSet Bid StrategyTEXTLowest cost is one of Facebook’s bid strategy options, meaning it tells us how to bid in the ad auction.
AdSet Daily BudgetTEXTThe daily budget of the set defined in your account currency.
AdSet Destination TypeTEXTDestination of ads in this Ad Set. Options include - Website, App, Messenger, INSTAGRAM_DIRECT.
AdSet End TimeDATEEnd time, in UTC UNIX timestamp
Ad Set IDTEXTThe unique ID of the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting. This column does not apply to campaigns, only ad sets and ads.
AdSet Lifetime BudgetTEXTThe lifetime budget of the set defined in your account currency.
Ad Set NameTEXTThe name the ad set you're viewing in reporting. An ad set is a group of ads that share the same budget, schedule, delivery optimization and targeting. This column does not apply to campaigns, only ad sets and ads.
AdSet Start TimeDATEStart time, in UTC UNIX timestamp
Age RangeTEXTThe age range of the people you've reached.
ID of body assetNUMERICThe ID of the body asset involved in impression, click or action.
Buying TypeTEXTThe method by which you pay for and target ads in your campaigns: through dynamic auction bidding, fixed-price bidding, or reach and frequency buying. This field is currently only visible at the campaign level. This column does not apply to ad sets or ads, only campaigns.
ID of call to action assetNUMERICThe ID of the call to action asset involved in impression, click, or action.
Campaign NameTEXTThe campaign name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.
Campaign Bid StrategyTEXTBid strategy for this campaign when you enable campaign budget optimization and when you use AUCTION as your buying type
Campaign Budget RemainingTEXTRemaining budget
Campaign Buying t ypeTEXTBuying type, possible values are - AUCTION default; - RESERVED for reach and frequency ads.
Campaign Created TimeDATEMerging of start_times for the ad sets belonging to this campaign.
Campaign Daily BudgetTEXTDaily budget of this campaign. All adsets under this campaign will share this budget.
Campaign IDTEXTThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.
Campaign Lifetime BudgetTEXTThe lifetime budget of the campaign.
Campaign ObjectiveTEXTCampaign's objective. If it is specified the API will validate that any ads created under the campaign match that objective.
Campaign Special Ad CategoryTEXTThe campaign's Special Ad Category. One of HOUSING, EMPLOYMENT, CREDIT, or NONE.
Campaign Special Ad CategoryTEXTA spend cap for the campaign, such that it will not spend more than this cap.
Campaign Start TimeDATEMerging of start_times for the ad sets belonging to this campaign.
Campaign Stop TimeDATEMerging of stop_times for the ad sets belonging to this campaign.
Campaign ID (duplicate)TEXTThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. (duplicate)
Instant Experience View PercentageNUMERICThe average percentage of the Instant Experience that people saw. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.
Instant Experience View TimeNUMERICThe average total time, in seconds, that people spent viewing an Instant Experience. An Instant Experience is a screen that opens after someone interacts with your ad on a mobile device. It may include a series of interactive or multimedia components, including video, images product catalog and more.
ClicksNUMERICThe number of clicks on your ads.
Cost per Adds of Payment InfoNUMERICCost per The number of add payment info events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Adds to CartNUMERICCost per The number of add to cart events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Adds to WishlistNUMERICCost per The number of add to wishlist events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Mobile App ActivactionsNUMERICCost per The number of times your app was activated attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Actions App Custom Event.Fb Mobile Add Payment InfoNUMERIC
Cost per Actions App Custom Event.Fb Mobile Add To CartNUMERIC
Cost per Actions App Custom Event.Fb Mobile Add To WishlistNUMERIC
Cost per Mobile App Registrations CompletedNUMERICCost per The number of registrations in your mobile app that were recorded as app events and attributed to your ads.
Cost per Mobile Content ViewsNUMERICCost per The number of content views in your mobile app that were recorded as app events and attributed to your ads.
Cost per Actions App Custom Event.Fb Mobile Initiated CheckoutNUMERIC
Cost per Mobile App Levels CompletedNUMERICCost per The number of levels achieved in your mobile app that were recorded as app events and attributed to your ads.
Cost per Actions App Custom Event.Fb Mobile PurchaseNUMERIC
Cost per Actions App Custom Event.Fb Mobile SearchNUMERIC
Cost per Actions App Custom Event.Fb Mobile Tutorial CompletionNUMERIC
Cost per Mobile App - OtherNUMERIC
Cost per Check-InsNUMERICCost per The number of check-ins to your Facebook Page that are attributed to your ads. If your Page has a physical address associated with it, people can check in to your Page when they update their status in their Facebook News Feed or Timeline.
Cost per Post CommentsNUMERICCost per The number of comments on your ads.
Cost per Registrations CompletedNUMERICCost per The number of complete registration events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Checkouts InitiatedNUMERICCost per The number of initiate checkout events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Landing Page ViewsNUMERICCost per The number of times a person clicked on an ad link and then successfully loaded the destination webpage or Instant Experience. To report on landing page views, you must have created a Facebook pixel.
Cost per LeadsNUMERICCost per The number of leads attributed to your ads from Facebook-owned properties (including forms and Messenger) as well as off-Facebook leads tracked by one or more of your connected Facebook Business Tools.
Cost per Page LikesNUMERICCost per The number of likes of your Facebook Page attributed to your ads.
Cost per Link ClicksNUMERICCost per The number of clicks on links within the ad that led to destinations or experiences, on or off Facebook. For ads promoting Instagram profile views, link clicks include clicks on the ad header or comments that led to the advertiser's profile.
Cost per Mobile App InstallsNUMERICCost per The number of installs of your mobile app that were recorded as app events and attributed to your ads.
Cost per Website Adds of Payment InfoNUMERICCost per The number of add payment info events tracked by the pixel on your website and attributed to your ads.
Cost per Website Adds to CartNUMERICCost per The number of add to cart events tracked by the pixel on your website and attributed to your ads.
Cost per Website Adds to WishlistNUMERICCost per The number of add to wishlist events tracked by the pixel on your website and attributed to your ads.
Cost per Website Registrations CompletedNUMERICCost per The number of complete registration events tracked by the pixel on your website and attributed to your ads.
Cost per Custom EventsNUMERICCost per The number of custom events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Website Checkouts InitiatedNUMERICCost per The number of initiate checkout events tracked by the pixel on your website and attributed to your ads.
Cost per Website LeadsNUMERICCost per The number of lead events tracked by the pixel on your website and attributed to your ads.
Cost per Website PurchasesNUMERICCost per The number of purchase events tracked by the pixel on your website and attributed to your ads.
Cost per Website SearchesNUMERICCost per The number of search events tracked by the pixel on your website and attributed to your ads.
Cost per Website Content ViewsNUMERICCost per The number of view content events tracked by the pixel on your website and attributed to your ads.
Cost per Achievements UnlockedNUMERICCost per The number of unlock achievement events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per App ActivationsNUMERICCost per The number of times your app was activated attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Adds to CartNUMERICCost per The number of add to cart events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per App InstallsNUMERICCost per The number of app installs that were recorded as app events and attributed to your ads.
Cost per Registrations CompletedNUMERICCost per The number of complete registration events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Actions Omni CustomNUMERIC
Cost per Checkouts InitiatedNUMERICCost per The number of initiate checkout events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Levels AchievedNUMERICCost per The number of achieve level events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per PurchasesNUMERICCost per The number of purchase events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Ratings SubmittedNUMERICCost per The number of ratings submitted events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per SearchesNUMERICCost per The number of search events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Credit SpendsNUMERICCost per The number of spend credits events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. This does not refer to the total value of credits spent.
Cost per Tutorials CompletedNUMERICCost per The number of completed tutorial events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Content ViewsNUMERICCost per The number of view content events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per On-Facebook Workflow CompletionsNUMERICCost per The number of times a workflow was completed within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads.
Cost per On-Facebook Leads GroupedNUMERICCost per The number of leads submitted on Facebook-owned property (including forms and Messenger) and attributed to your ads.
Cost per Blocked Messaging ConnectionsNUMERICCost per The number of times that people blocked a messaging connection with your business, attributed to your ads.
Cost per New Messaging ConnectionsNUMERICCost per The number of people your business added as messaging connections, attributed to your ads.
Cost per Post SavesNUMERICCost per The total number of times your ad has been saved.
Cost per On-Facebook PurchasesNUMERICCost per The number of purchases made within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads.
Cost per Actions Onsite Web Add To CartNUMERIC
Cost per Actions Onsite Web App Add To CartNUMERIC
Cost per Actions Onsite Web App PurchaseNUMERIC
Cost per Actions Onsite Web PurchaseNUMERIC
Cost per Page EngagementNUMERICCost per The total number of actions that people took on your Facebook Page and its posts, attributed to your ads.
Cost per Photo ViewsNUMERICCost per The number of views of photos on your Page or posts that are attributed to your ads. Photo views are counted when people click on photos to view them.
Cost per Post SharesNUMERICCost per The number of shares of your ads. People can share your ads or posts on their own or friends' Timelines, in groups and on their own Pages.
Cost per Post EngagementNUMERICCost per The total number of actions that people take involving your ads.
Cost per Post ReactionsNUMERICCost per The number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: Like, Love, Haha, Wow, Sad or Angry.
Cost per Event ResponsesNUMERICCost per The number of people who responded Interested or Going to your Facebook event, attributed to your ads.
Cost per SearchesNUMERICCost per The number of search events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per 3-Second Video PlaysNUMERICCost per The number of times your video played for at least 3 seconds, or for nearly its total length if it's shorter than 3 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video.
Cost per Content ViewsNUMERICCost per The number of view content events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools.
Cost per Estimated Ad Recall LiftNUMERICCost per 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, Post engagement and Video views Objectives.
Cost per Outbound ClicksNUMERICCost per The number of clicks on links that take people off Facebook-owned properties.
Cost per ThruPlaysNUMERICCost per The number of times your video was played to completion, or for at least 15 seconds.
Cost per Unique Adds of Payment InfoNUMERICCost per The estimated number of people who submitted payment info.
Cost per Unique Actions Add To CartNUMERIC
Cost per Unique Adds to WishlistNUMERICCost per The estimated number of people who added items to their wishlist.
Cost per Unique Actions App Custom EventNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Activate AppNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Add Payment InfoNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Add To CartNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Add To WishlistNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Complete RegistrationNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Content ViewNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Initiated CheckoutNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Level AchievedNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile PurchaseNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile SearchNUMERIC
Cost per Unique Actions App Custom Event.Fb Mobile Tutorial CompletionNUMERIC
Cost per Unique Actions App Custom Event.OtherNUMERIC
Cost per Unique Check-InsNUMERICCost per The number of people with check-ins to your Facebook Page that are attributed to your ads. If your Page has a physical address associated with it, people can check in to your Page when they update their status in their Facebook News Feed or Timeline.
Cost per Unique Post CommentsNUMERICCost per The number of people with comments on your ads.
Cost per Unique Registrations CompletedNUMERICCost per The estimated number of people who registered.
Cost per Unique Checkouts InitiatedNUMERICCost per The estimated number of people who initiated checkouts.
Cost per Unique Landing Page ViewsNUMERICCost per The number of people who caused a landing page view.
Cost per Unique LeadsNUMERICCost per The number of people with leads attributed to your ads from Facebook-owned properties (including forms and Messenger) as well as off-Facebook leads tracked by one or more of your connected Facebook Business Tools.
Cost per Unique Page LikesNUMERICCost per The number of people with likes of your Facebook Page attributed to your ads.
Cost per Unique Link ClicksNUMERICCost per The number of people who performed a link click.
Cost per Unique Mobile App InstallsNUMERICCost per The number of people with installs of your mobile app that were recorded as app events and attributed to your ads.
Cost per Unique Website ConversionsNUMERICCost per The number of unique people who with conversion events attributed to your ads (estimated)
Cost per Unique Website Adds of Payment InfoNUMERICCost per The number of people with add payment info events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website Adds to CartNUMERICCost per The number of people with add to cart events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website Adds to WishlistNUMERICCost per The number of people who performed add to wishlist events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website Registrations CompletedNUMERICCost per The number of people with complete registration events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website Checkouts InitiatedNUMERICCost per The number of people who initiated checkout events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website LeadsNUMERICCost per The number of people with lead events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website PurchasesNUMERICCost per The number of people with purchase events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website SearchesNUMERICCost per The number of people with search events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Website Content ViewsNUMERICCost per The number of people with view content events tracked by the pixel on your website and attributed to your ads.
Cost per Unique Achievements UnlockedNUMERICCost per The estimated number of people who unlocked achievements.
Cost per Unique App ActivationsNUMERICCost per The estimated number of people who performed app activations.
Cost per Unique Adds to CartNUMERICCost per The estimated number of people who added items to their cart.
Cost per Unique App InstallsNUMERICCost per The number of unique people who took this action attributed to your ads (estimated)
Cost per Unique Registrations CompletedNUMERICCost per The estimated number of people who registered.
Cost per Unique Actions Omni CustomNUMERIC
Cost per Unique Checkouts InitiatedNUMERICCost per The estimated number of people who initiated checkouts.
Cost per Unique Levels CompletedNUMERICCost per The estimated number of people who achieved levels.
Cost per Unique PurchasesNUMERICCost per The estimated number of people who completed at least one purchase.
Cost per Unique Ratings SubmittedNUMERICCost per The estimated number of people who submitted ratings.
Cost per Unique SearchesNUMERICCost per The estimated number of people who searched.
Cost per Unique Credit SpendsNUMERICCost per The estimated number of people who spent credits.
Cost per Unique Tutorials CompletedNUMERICCost per The estimated number of people who completed tutorials.
Cost per Unique Content ViewsNUMERICCost per The estimated number of people who viewed content.
Cost per Unique On-Facebook Workflow CompletionsNUMERICCost per The number of people who completed a workflow within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads.
Cost per Unique Blocked Messaging ConnectionsNUMERICCost per The number of people that blocked a messaging connection with your business, attributed to your ads.
Cost per Unique On-Facebook PurchasesNUMERICCost per The number of unique people who took this action attributed to your ads (estimated)
Cost per Unique Actions Onsite Web Add To CartNUMERIC
Cost per Unique Actions Onsite Web App Add To CartNUMERIC
Cost per Unique Actions Onsite Web App PurchaseNUMERIC
Cost per Unique Actions Onsite Web PurchaseNUMERIC
Cost per Unique Page EngagementNUMERICCost per The number of people who took action on your Facebook Page and its posts, attributed to your ads.
Cost per Unique Photo ViewsNUMERICCost per The number of unique people with views of photos on your Page or posts that are attributed to your ads. Photo views are counted when people click on photos to view them.
Cost per Unique Post EngagementNUMERICCost per The total number of people who took actions involving your ads.
Cost per Unique Post ReactionsNUMERICCost per The number of unique people who took this action attributed to your ads (estimated)
Cost per Unique Actions PurchaseNUMERIC
Cost per Unique Event ResponsesNUMERICCost per The number of people who responded Interested or Going to your Facebook event, attributed to your ads.
Cost per Unique Actions SearchNUMERIC
Cost per Unique 3-Second Continuous Video PlaysNUMERICCost per The number of unique people who took this action attributed to your ads (estimated)
Cost per Unique Content ViewsNUMERICCost per The estimated number of people who viewed content.
Cost per Unique ClicksNUMERICCost per The number of people who performed a click (all).
Cost per Unique Outbound ClicksNUMERICCost per The number of people who performed an outbound click.
Countries people are locatedTEXTThe countries where the people you've reached are located. This is based on information such as a person's hometown, their current city and the geographical location where they tend to be when they visit Facebook.
CPCNUMERICThe average cost for each click (all).
CPMNUMERICThe average cost for 1,000 impressions.
Cost per 1,000 People ReachedNUMERICThe average cost to reach 1,000 people.
CTRNUMERICThe percentage of times people saw your ad and performed a click (all).
Currency (duplicate)TEXTCurrency that is used by your ad account. (duplicate)
DateDATEThe dimension that determines how date-based data in a chart is handled (the time dimension).
Reporting StartsDATEThe start date for your data. This is controlled by the date range you've selected for your reporting view.
Reporting EndsDATEThe end date for your data. This is controlled by the date range you've selected for your reporting view.
ID of description assetNUMERICThe ID of the description asset involved in impression, click or action.
Device typeTEXTThe type of device, mobile or desktop, used by people when they viewed or clicked on an ad, as shown in ads reporting.
Designated Market AreaTEXTDMA (Designated Market Area) regions are the 210 geographic areas in the United States in which local television viewing is measured by The Nielsen Company.
Instagram Post IDTEXTThe ID of an Instagram post to use in an ad.
Instagram Story IDTEXTUsed for Instagram Ads. The ID of an Instagram post to display as an Instagram ad.
Facebook Post IDTEXTThe ID of a page post to use in an ad, regardless of whether it's an organic or unpublished page post
Estimated Ad Recall Lift RateNUMERICThe 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, Post engagement and Video views Objectives.
Estimated Ad Recall LiftNUMERICAn 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, Post engagement and Video views Objectives.
FrequencyNUMERICThe average number of times each person saw your ad.
Number of frequencyNUMERICThe number of times an ad in your Reach and Frequency campaign was served to each person.
GenderTEXTGender of people you've reached. People who don't list their gender are shown as 'not specified'.
Hourly breakdown aggregated by the time ads were delivered in the advertiser's time zone.TEXTHourly breakdown aggregated by the time ads were delivered in the advertiser's time zone. For example, if your ads are scheduled to run from 9 AM to 11 AM, but they reach audiences in multiple time zones, they may deliver from 9 AM to 1 PM in the advertiser's time zone. Stats will be aggregated into four groups 9 AM - 10 AM, 10 AM - 11 AM, 11 AM - 12 PM, and 12 PM - 1 PM.
Hourly breakdown aggregated by the time ads were delivered in the audiences' time zone.TEXTHourly breakdown aggregated by the time ads were delivered in the audiences' time zone. For example, if your ads are scheduled to run from 9 AM to 11 AM but they reach audiences in multiple time zones, they may deliver from 9 AM to 1 PM in the advertiser's time zone. Stats will be aggregated into two groups 9 AM - 10 AM and 10 AM - 11 AM.
ID of image assetNUMERICThe ID of the image asset involved in impression, click or action.
Ad Image URLTEXTA URL for the image for this creative. We save the image at this URL to the ad account's image library.
The device where your last ad was served to someoneTEXTThe device where your last ad was served to someone on Facebook. For example "iPhone" if someone viewed your ad on an iPhone.
ImpressionsNUMERICThe number of times your ads were on screen.
Instagram Page IDTEXTUsed for Instagram Ads. Provide Instagram account ID used for running these ads.
Instagram Post URLTEXTURL for a post on Instagram you want to run as an ad. Also known as Instagram media.
Ad Name (duplicate)TEXTThe name of the ad being viewed in reporting (duplicate)
Ad LinkTEXTThe link where the user is taken to upon clicking on the ad.
Link Clicks (duplicate)NUMERICThe number of clicks on links within the ad that led to destinations or experiences, on or off Facebook. For ads promoting Instagram profile views, link clicks include clicks on the ad header or comments that led to the advertiser's profile.(duplicate)
ID of the url assetNUMERICThe ID of the URL asset involved in impression, click or action.
Mobile App Purchase ROAS App Custom Event.Fb Mobile PurchaseNUMERIC
ObjectiveTEXTThe objective reflecting the goal you want to achieve with your advertising. It may be different from the selected objective of the campaign in some cases. This column does not apply to ad sets, only campaigns and ads.
Outbound CTRNUMERICThe percentage of times people saw your ad and performed an outbound click.
Outbound ClicksNUMERICThe number of clicks on links that take people off Facebook-owned properties.
The ID of the place pageNUMERICThe ID of the place page involved in impression or click.
Where your ad was shown within a platformTEXTWhere your ad was shown within a platform, for example on Facebook desktop News Feed, or Instagram Mobile News Feed.
Platform your ad was shownTEXTWhich platform your ad was shown, for example on Facebook, Instagram, or Audience Network.
ReachNUMERICThe 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.
Regions where the people you've reached are locatedTEXTThe regions where the people you've reached are located. This is based on information such as a person's hometown, their current city and the geographical location where they tend to be when they visit Facebook.
Amount SpentNUMERICThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule.
Thumbnail URLTEXTURL for a thumbnail image for this ad creative.
ID of the title assetNUMERICThe ID of the title asset involved in impression, click or action.
Amount Spent (duplicate)NUMERICThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. (duplicate)
Unique Adds of Payment InfoNUMERICThe estimated number of people who submitted payment info.
Unique Actions Add To CartNUMERIC
Unique Adds to WishlistNUMERICThe estimated number of people who added items to their wishlist.
Unique Actions App Custom EventNUMERIC
Unique Actions App Custom Event.Fb Mobile Activate AppNUMERIC
Unique Actions App Custom Event.Fb Mobile Add Payment InfoNUMERIC
Unique Actions App Custom Event.Fb Mobile Add To CartNUMERIC
Unique Actions App Custom Event.Fb Mobile Add To WishlistNUMERIC
Unique Actions App Custom Event.Fb Mobile Complete RegistrationNUMERIC
Unique Actions App Custom Event.Fb Mobile Content ViewNUMERIC
Unique Actions App Custom Event.Fb Mobile Initiated CheckoutNUMERIC
Unique Actions App Custom Event.Fb Mobile Level AchievedNUMERIC
Unique Actions App Custom Event.Fb Mobile PurchaseNUMERIC
Unique Actions App Custom Event.Fb Mobile SearchNUMERIC
Unique Actions App Custom Event.Fb Mobile Tutorial CompletionNUMERIC
Unique Actions App Custom Event.OtherNUMERIC
Unique Check-InsNUMERICThe number of people with check-ins to your Facebook Page that are attributed to your ads. If your Page has a physical address associated with it, people can check in to your Page when they update their status in their Facebook News Feed or Timeline.
Unique Post CommentsNUMERICThe number of people with comments on your ads.
Unique Registrations CompletedNUMERICThe estimated number of people who registered.
Unique Checkouts InitiatedNUMERICThe estimated number of people who initiated checkouts.
Unique Landing Page ViewsNUMERICThe number of people who caused a landing page view.
Unique LeadsNUMERICThe number of people with leads attributed to your ads from Facebook-owned properties (including forms and Messenger) as well as off-Facebook leads tracked by one or more of your connected Facebook Business Tools.
Unique Page LikesNUMERICThe number of people with likes of your Facebook Page attributed to your ads.
Unique Link ClicksNUMERICThe number of people who performed a link click.
Unique Mobile App InstallsNUMERICThe number of people with installs of your mobile app that were recorded as app events and attributed to your ads.
Unique Website ConversionsNUMERICThe number of unique people who with conversion events attributed to your ads (estimated)
Unique Website Adds of Payment InfoNUMERICThe number of people with add payment info events tracked by the pixel on your website and attributed to your ads.
Unique Website Adds to CartNUMERICThe number of people with add to cart events tracked by the pixel on your website and attributed to your ads.
Unique Website Adds to WishlistNUMERICThe number of people who performed add to wishlist events tracked by the pixel on your website and attributed to your ads.
Unique Website Registrations CompletedNUMERICThe number of people with complete registration events tracked by the pixel on your website and attributed to your ads.
Unique Website Checkouts InitiatedNUMERICThe number of people who initiated checkout events tracked by the pixel on your website and attributed to your ads.
Unique Website LeadsNUMERICThe number of people with lead events tracked by the pixel on your website and attributed to your ads.
Unique Website PurchasesNUMERICThe number of people with purchase events tracked by the pixel on your website and attributed to your ads.
Unique Website SearchesNUMERICThe number of people with search events tracked by the pixel on your website and attributed to your ads.
Unique Website Content ViewsNUMERICThe number of people with view content events tracked by the pixel on your website and attributed to your ads.
Unique Achievements UnlockedNUMERICThe estimated number of people who unlocked achievements.
Unique App ActivationsNUMERICThe estimated number of people who performed app activations.
Unique Adds to CartNUMERICThe estimated number of people who added items to their cart.
Unique App InstallsNUMERICThe number of unique people who took this action attributed to your ads (estimated)
Unique Registrations CompletedNUMERICThe estimated number of people who registered.
Unique Actions Omni CustomNUMERIC
Unique Checkouts InitiatedNUMERICThe estimated number of people who initiated checkouts.
Unique Levels CompletedNUMERICThe estimated number of people who achieved levels.
Unique PurchasesNUMERICThe estimated number of people who completed at least one purchase.
Unique Ratings SubmittedNUMERICThe estimated number of people who submitted ratings.
Unique SearchesNUMERICThe estimated number of people who searched.
Unique Credit SpendsNUMERICThe estimated number of people who spent credits.
Unique Tutorials CompletedNUMERICThe estimated number of people who completed tutorials.
Unique Content ViewsNUMERICThe estimated number of people who viewed content.
Unique On-Facebook Workflow CompletionsNUMERICThe number of people who completed a workflow within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads.
Unique Blocked Messaging ConnectionsNUMERICThe number of people that blocked a messaging connection with your business, attributed to your ads.
Unique On-Facebook PurchasesNUMERICThe number of unique people who took this action attributed to your ads (estimated)
Unique Actions Onsite Web Add To CartNUMERIC
Unique Actions Onsite Web App Add To CartNUMERIC
Unique Actions Onsite Web App PurchaseNUMERIC
Unique Actions Onsite Web PurchaseNUMERIC
Unique Page EngagementNUMERICThe number of people who took action on your Facebook Page and its posts, attributed to your ads.
Unique Photo ViewsNUMERICThe number of unique people with views of photos on your Page or posts that are attributed to your ads. Photo views are counted when people click on photos to view them.
Unique Post EngagementNUMERICThe total number of people who took actions involving your ads.
Unique Post ReactionsNUMERICThe number of unique people who took this action attributed to your ads (estimated)
Unique Actions PurchaseNUMERIC
Unique Event ResponsesNUMERICThe number of people who responded Interested or Going to your Facebook event, attributed to your ads.
Unique Actions SearchNUMERIC
Unique 3-Second Continuous Video PlaysNUMERICThe number of unique people who took this action attributed to your ads (estimated)
Unique Content ViewsNUMERICThe estimated number of people who viewed content.
Unique ClicksNUMERICThe number of people who performed a click (all).
Unique CTRNUMERICThe percentage of people who saw your ad and performed a unique click (all).
Unique CTRNUMERICThe percentage of people who saw your ad and performed a link click.
Unique Outbound CTRNUMERICThe percentage of people who saw your ad and performed an outbound click.
Unique Outbound ClicksNUMERICThe number of people who performed an outbound click.
URL TagsTEXTA set of query string parameters (e.g. UTM tags) which will replace or be appended to urls clicked from page post ads, message of the post, and canvas app install creatives only.
Video 30 Sec Watched ActionsNUMERICThe number of times your video played for at least 30 seconds, or for nearly its total length if it's shorter than 30 seconds.
Video Average Play TimeNUMERICThe average time a video was played, including any time spent replaying the video for a single impression.
Video Plays at 100 percentNUMERICThe number of times your video was played at 100% of its length, including plays that skipped to this point.
Video Plays at 25 percentNUMERICThe number of times your video was played at 25% of its length, including plays that skipped to this point.
Video Plays at 50 percentNUMERICThe number of times your video was played at 50% of its length, including plays that skipped to this point.
Video Plays at 75 percentNUMERICThe number of times your video was played at 75% of its length, including plays that skipped to this point.
Video Plays at 95 percentNUMERICThe number of times your video was played at 95% of its length, including plays that skipped to this point.
Video PlaysNUMERICThe number of times your video starts to play. This is counted for each impression of a video, and excludes replays. This metric is in development.
CTRNUMERICThe percentage of times people saw your ad and performed a link click.
Website Purchase ROASNUMERICThe total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads.

Windsor.ai: Easily connect Facebook Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.