Connect Facebook Ads to Snowflake

Facebook SnowFlake integration

Stream marketing data from Facebook Ads to Snowflake

Connect Facebook Ads to Snowflake in 2023

It is very simple to connect Facebook Ads to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1.You need to select Facebook Ads as a Data Source and Grant Access to Windsor.ai.

facebook ads onboarding

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.

Facebook Ads metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account currencyTEXTCurrency that is used by your ad account. (duplicate)
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
Call Confirmation Clicks Conversion ValueNUMERICThe total value of call confirmation clicks conversions.
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.
Omni Adds to Cart Conversion ValueNUMERICThe total value of omni adds to cart tracked with the conversions objective.
Omni Registrations Completed Conversion ValueNUMERICThe total value of registrations completed tracked with the conversions objective.
Action Values Omni CustomNUMERIC
Omni 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.
Omni 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.
On-Facebook Leads Conversion ValueNUMERICThe total value of on-facebook leads conversions.
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
NUMERIC
Actions App Custom Event.Fb Mobile Tutorial CompletionNUMERIC
Mobile App - OtherNUMERIC
Desktop App InstallsNUMERICThe number of installs of your mobile app that were recorded as app events and attributed to your ads.
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.
Call Confirmation ClicksNUMERICThe number of call confirmation clicks attributed to your ads.
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.
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.
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.
Omni Adds to CartNUMERICThe number of add to cart omni 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.
Omni 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
Omni 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.
Omni 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.
Omni 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 LeadsNUMERICThe 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 assetTEXTThe 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 ContentTEXTThe 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 ID (duplicate)TEXTThe 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 ID (duplicate)TEXTUnique ID of the ad being viewed in reporting (duplicate)
(Deprecated) 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 BudgetNUMERICThe daily budget of the set defined in minimum denomination level of your account currency (such as cents for USD).
AdSet Destination TypeTEXTDestination of ads in this Ad Set. Options include - Website, App, Messenger, INSTAGRAM_DIRECT.
Adset Effective StatusTEXTThe effective status of the adset.The status could be effective either because of its own status, or the status of its parent campaign.
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 BudgetNUMERICThe lifetime budget of the set defined in minimum denomination level of your account currency (such as cents for USD).
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
Adset StatusTEXTThe status of the adset.
Age RangeTEXTThe age range of the people you've reached.
TEXTThe body of the ad. Not supported for video post creatives.
ID of body assetTEXTThe 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 assetTEXTThe 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 RemainingNUMERICRemaining campaign budget defined in minimum denomination level of your account currency (such as cents for USD).
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 BudgetNUMERICDaily budget of this campaign defined in minimum denomination level of your account currency (such as cents for USD). All adsets under this campaign will share this budget.
Campaign Effective StatusTEXTThe effective status of the campaign.The status could be effective either because of its own status, or the status of its parent campaign.
Campaign IDTEXTThe unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads.
Campaign Lifetime BudgetNUMERICThe lifetime budget of the campaign defined in minimum denomination level of your account currency (such as cents for USD).
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 Spend CapTEXTA 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 StatusTEXTThe status of the 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 PercentagePERCENTThe 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.
Catalog Segment Actions Add To CartNUMERIC
Catalog Segment Actions App Custom Event.FB Mobile Add To CartNUMERIC
Catalog Segment Actions App Custom Event.FB Mobile Content ViewNUMERIC
Catalog Segment Actions App Custom Event.FB Mobile PurchaseNUMERIC
Catalog Segment Actions Offsite Conversion Fb Pixel Add To CartNUMERIC
Catalog Segment Actions Offsite Conversion Fb Pixel View ContentNUMERIC
Catalog Segment Actions Omni Add To CartNUMERIC
Catalog Segment Actions Omni PurchaseNUMERIC
Catalog Segment Actions Omni View ContentNUMERIC
Catalog Segment Actions PurchaseNUMERIC
Catalog Segment Actions View ContentNUMERIC
Catalog Segment Value Add To CartNUMERIC
Catalog Segment Value App Custom EventNUMERIC
Catalog Segment Value App Custom Event.FB Mobile Add To CartNUMERIC
Catalog Segment Value App Custom Event.FB Mobile Content ViewNUMERIC
Catalog Segment Value App Custom Event.FB Mobile PurchaseNUMERIC
Mobile purchase ROASNUMERICValue from conversion events, including a breakdown of purchases, add-to-carts and view products for the catalog segment at each ad object level.
Catalog Segment Value Offsite ConversionNUMERIC
Catalog Segment Value Offsite Conversion Fb Pixel Add To CartNUMERIC
Catalog Segment Value Offsite Conversion Fb Pixel View ContentNUMERIC
Catalog Segment Value Omni Add To CartNUMERIC
Catalog Segment Value Omni PurchaseNUMERIC
Total purchase ROASNUMERICTotal return on ad spend (ROAS) from purchases of items shared between Brand and Retailer. This number is based on information received from one or more Retailer' connected Facebook Business Tools. The amount is attributed to your ads.
Catalog Segment Value Omni View ContentNUMERIC
Catalog Segment Value Onsite App Add To CartNUMERIC
Catalog Segment Value Onsite App PurchaseNUMERIC
Catalog Segment Value Onsite App View ContentNUMERIC
Catalog Segment Value Onsite Web Add To CartNUMERIC
Catalog Segment Value Onsite Web App Add To CartNUMERIC
Catalog Segment Value Onsite Web App PurchaseNUMERIC
Catalog Segment Value Onsite Web App View ContentNUMERIC
Catalog Segment Value Onsite Web View ContentNUMERIC
Catalog Segment Value PurchaseNUMERIC
Catalog Segment Value View ContentNUMERIC
Website purchase ROASNUMERICTotal return on ad spend (ROAS) from website purchases of items shared between Brand and Retailer. This number is based on information received from one or more Retailers' connected Facebook Business Tools. The amount is attributed to your ads.
ClicksNUMERICThe number of clicks on your ads.
Mobile app ad click conversionsNUMERICThe number of Mobile app ad click
Mobile app ad impression conversionsNUMERICThe number of Mobile app ad click
Mobile app cancel subscription conversionsNUMERICThe number of mobile app canceled subscriptions
Offline cancel subscription conversionsNUMERICThe number of offline canceled subscriptions
Cancel subscription conversionsNUMERICThe total number of canceled subscriptions
Website cancel subscription conversionsNUMERICThe number of website canceled subscriptions
Mobile app contact conversionsNUMERICThe number of mobile app contacts
Offline contact conversionsNUMERICThe number of offline contacts
Contact conversionsNUMERICThe total number of contacts
Website contact conversionsNUMERICThe number of website contacts
Mobile app customize product conversionsNUMERICThe number of mobile app products customized
Offline customize product conversionsNUMERICThe number of offline products customized
Customize product conversionsNUMERICThe total number of products customized
Website customize product conversionsNUMERICThe number of website products customized
NUMERICThe number of mobile app donations
NUMERICThe number of offline donations
NUMERICThe number of donations on facebook
NUMERICThe total number of donations
NUMERICThe number of website donations
Mobile app find location conversionsNUMERICThe number of mobile app location searches
Offline find location conversionsNUMERICThe number of offline app location searches
Find location conversionsNUMERICThe total number of location searches
Website find location conversionsNUMERICThe number of website location searches
Appointments ScheduledNUMERICNumber of appointments scheduled
Mobile app recurring subscription payment conversionsNUMERICThe number of mobile app recurring subscription payments
Offline recurring subscription payment conversionsNUMERICThe number of offline recurring subscription payments
Recurring subscription payment conversionsNUMERICThe total number of recurring subscription payments
Website recurring subscription payment conversionsNUMERICThe number of website recurring subscription payments
Mobile app schedule conversionsNUMERICThe number of mobile app appointments scheduled
Offline schedule conversionsNUMERICThe number of offline app appointments scheduled
Schedule conversionsNUMERICThe total number of appointments scheduled
Website schedule conversionsNUMERICThe number of website appointments scheduled
Mobile app start trial conversionsNUMERICThe number of mobile app trials started
Offline start trial conversionsNUMERICThe number of offline trials started
Start trial conversionsNUMERICThe total number of trials started
Website start trial conversionsNUMERICThe number of website trials started
Mobile app submit application conversionsNUMERICThe number of mobile app applications submitted
Offline submit application conversionsNUMERICThe number of offline applications submitted
Submit application on facebook conversionsNUMERICThe number of applications submitted on facebook
Submit application conversionsNUMERICThe total number of applications submitted
Website submit application conversionsNUMERICThe number of website applications submitted
Mobile app subscribe conversionsNUMERICThe number of mobile app subscriptions
Offline subscribe conversionsNUMERICThe number of offline subscriptions
Subscribe conversionsNUMERICThe total number of subscriptions
Website subscribe conversionsNUMERICThe number of website subscriptions
Converted Product Quantity App Custom EventNUMERIC
Converted Product Quantity App Custom Event.FB Mobile Add To CartNUMERIC
Converted Product Quantity App Custom Event.FB Mobile Content ViewNUMERIC
Converted Product Quantity App Custom Event.FB Mobile PurchaseNUMERIC
Converted Product Quantity Offsite ConversionNUMERIC
Converted Product Quantity Offsite Conversion Fb Pixel View ContentNUMERIC
Converted Product Quantity Omni Add To CartNUMERIC
Converted Product Quantity Omni PurchaseNUMERIC
Converted Product Quantity Omni View ContentNUMERIC
Converted Product Value App Custom EventNUMERIC
Converted Product Value App Custom Event.FB Mobile Add To CartNUMERIC
Converted Product Value App Custom Event.FB Mobile Content ViewNUMERIC
Converted Product Value App Custom Event.FB Mobile PurchaseNUMERIC
Converted Product Value Offsite ConversionNUMERIC
Converted Product Value Offsite Conversion Fb Pixel View ContentNUMERIC
Converted Product Value Omni Add To CartNUMERIC
Converted Product Value Omni PurchaseNUMERIC
Converted Product Value Omni View ContentNUMERIC
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
NUMERIC
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 Call Confirmation ClicksNUMERICCost per The number of call confirmation clicks attributed to your ads.
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.
NUMERICCost 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.
Omni 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.
Omni 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
Omni 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.
Omni 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.
Omni 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 LeadsNUMERICCost 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 mobile app ad click conversionNUMERICCost per mobile app ad click conversion
Cost per mobile app ad impression conversionNUMERICCost per mobile app ad impression conversion
Cost per mobile app cancel subscription conversionNUMERICCost per mobile app cancel subscription conversion
Cost per offline cancel subscription conversionNUMERICCost per offline cancel subscription conversion
Cost per cancel subscription conversionNUMERICCost per cancel subscription conversion
Cost per website cancel subscription conversionNUMERICCost per website cancel subscription conversion
Cost per mobile app contact conversionNUMERICCost per mobile app contact conversion
Cost per offline contact conversionNUMERICCost per offline contact conversion
Cost per contact conversionNUMERICCost per contact conversion
Cost per website contact conversionNUMERICCost per website contact conversion
Cost per mobile app customize product conversionNUMERICCost per mobile app customize product conversion
Cost per offline customize product conversionNUMERICCost per offline customize product conversion
Cost per customize product conversionNUMERICCost per customize product conversion
Cost per website customize product conversionNUMERICCost per website customize product conversion
NUMERICCost per mobile app donate conversion
NUMERICCost per offline donate conversion
NUMERICCost per donate on facebook conversion
NUMERICCost per donate conversion
NUMERICCost per website donate conversion
Cost per mobile app find location conversionNUMERICCost per mobile app find location conversion
Cost per offline find location conversionNUMERICCost per offline find location conversion
Cost per find location conversionNUMERICCost per find location conversion
Cost per website find location conversionNUMERICCost per website find location conversion
Cost per mobile app recurring subscription payment conversionNUMERICCost per mobile app recurring subscription payment conversion
Cost per offline recurring subscription payment conversionNUMERICCost per offline recurring subscription payment conversion
Cost per recurring subscription payment conversionNUMERICCost per recurring subscription payment conversion
Cost per website recurring subscription payment conversionNUMERICCost per website recurring subscription payment conversion
Cost per mobile app schedule conversionNUMERICCost per mobile app schedule conversion
Cost per offline schedule conversionNUMERICCost per offline schedule conversion
Cost per schedule conversionNUMERICCost per schedule conversion
Cost per website schedule conversionNUMERICCost per website schedule conversion
Cost per mobile app start trial conversionNUMERICCost per mobile app start trial conversion
Cost per offline start trial conversionNUMERICCost per offline start trial conversion
Cost per start trial conversionNUMERICCost per start trial conversion
Cost per website start trial conversionNUMERICCost per website start trial conversion
Cost per mobile app submit application conversionNUMERICCost per mobile app submit application conversion
Cost per offline submit application conversionNUMERICCost per offline submit application conversion
Cost per submit application on facebook conversionNUMERICCost per submit application on facebook conversion
Cost per submit application conversionNUMERICCost per submit application conversion
Cost per website submit application conversionNUMERICCost per website submit application conversion
Cost per mobile app subscribe conversionNUMERICCost per mobile app subscribe conversion
Cost per offline subscribe conversionNUMERICCost per offline subscribe conversion
Cost per subscribe conversionNUMERICCost per subscribe conversion
Cost per website subscribe conversionNUMERICCost per website subscribe conversion
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 Call Confirmation ClicksNUMERICCost per The number of call confirmation clicks attributed to your ads.
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
NUMERIC
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.
NUMERICCost 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.
(Deprecated) 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)
Omni Cost per Unique Registrations CompletedNUMERICCost per The estimated number of people who registered.
Cost per Unique Actions Omni CustomNUMERIC
Omni 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.
Omni 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 On-Facebook LeadsNUMERICCost per The number of leads submitted on Facebook-owned property (including forms and 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.
NUMERIC
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.
CountryCOUNTRYThe 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.
CTRPERCENTThe percentage of times people saw your ad and performed a click (all).
CurrencyTEXTCurrency that is used by your ad account.
Custom conversion action countNUMERICThe number of custom conversion actions
Custom conversion action nameTEXTThe name of the custom conversion action
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 assetTEXTThe ID of the description asset involved in impression, click or action.
Desktop Feed Standard Preview URLTEXTURL to a preview of the ad, as seen in the desktop feed standard placement
Device platformTEXTThe 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
Effective StatusTEXTThe effective status of the ad.The status could be effective either because of its own status, or the status of its parent campaign.
Estimated Ad Recall Lift RatePERCENTThe 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.
Facebook Story Mobile Preview URLTEXTURL to a preview of the ad, as seen in the facebook story mobile placement
FrequencyNUMERICThe average number of times each person saw your ad.
Number of frequencyTEXTThe 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 assetTEXTThe ID of the image asset involved in impression, click or action.
Ad Image URLIMAGE_URLA 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.
Instagram Standard Preview URLTEXTURL to a preview of the ad, as seen in the instagram standard placement
Instagram Story Preview URLTEXTURL to a preview of the ad, as seen in the instagram story placement
Instant Article Standard Preview URLTEXTURL to a preview of the ad, as seen in the instant article standard placement
Instream Video Desktop Preview URLTEXTURL to a preview of the ad, as seen in the instream video desktop placement
Instream Video Mobile Preview URLTEXTURL to a preview of the ad, as seen in the instream video mobile placement
KeywordTEXTThe name of the ad being viewed in reporting (duplicate)
TEXTThe link where the user is taken to upon clicking on the ad.
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 assetTEXTThe ID of the URL asset involved in impression, click or action.
Website URL of the url assetTEXTThe website URL of the URL asset involved in impression, click or action.
Mobile App Purchase ROAS App Custom Event.Fb Mobile PurchaseNUMERIC
Mobile Feed Basic Preview URLTEXTURL to a preview of the ad, as seen in the mobile feed basic placement
Mobile Feed Standard Preview URLTEXTURL to a preview of the ad, as seen in the mobile feed standard placement
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 CTRPERCENTThe 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 pageTEXTThe 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.
The ID and name of the productTEXTThe ID and name of the product involved in impression, click, or action.
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.
RegionREGIONThe 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.
StatusTEXTThe status of the ad.
Thumbnail URLIMAGE_URLURL for a thumbnail image for this ad creative.
TEXTTitle for link ad, which does not belong to a page.
ID of the title assetTEXTThe ID of the title asset involved in impression, click or action.
Total CostNUMERICThe 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
NUMERIC
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 Call Confirmation ClicksNUMERICThe number of call confirmation clicks attributed to your ads.
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.
NUMERICThe 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.
(Deprecated) Unique Website ConversionsNUMERICThe number of unique people who with conversion events attributed to your ads.
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)
Omni Unique Registrations CompletedNUMERICThe estimated number of people who registered.
Unique Actions Omni CustomNUMERIC
Unique Omni Checkouts InitiatedNUMERICThe estimated number of people who initiated checkouts.
Unique Levels CompletedNUMERICThe estimated number of people who achieved levels.
Omni 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 Omni 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 On-Facebook LeadsNUMERICThe number of leads submitted on Facebook-owned property (including forms and 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.
NUMERIC
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 CTRPERCENTThe percentage of people who saw your ad and performed a unique click (all).
PERCENTThe percentage of people who saw your ad and performed a link click.
Unique Outbound CTRPERCENTThe 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 Watched at 100 percentNUMERICThe number of times your video was played at 100% of its length, including plays that skipped to this point.
Video Watched at 25 percentNUMERICThe number of times your video was played at 25% of its length, including plays that skipped to this point.
Video Watched at 50 percentNUMERICThe number of times your video was played at 50% of its length, including plays that skipped to this point.
Video Watched 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.
ThruPlay actionsNUMERICThe number of times your video was played to completion, or for at least 15 seconds.
PERCENTThe 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.
TodayDATEToday's date

Easily connect Facebook Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

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

insights

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

Build your Facebook Ads and Snowflake Integrations