Stream marketing data from Facebook Ads to Snowflake
About Facebook Ads
About 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:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- 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.
2. In Select Destination select Snowflake as destination
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
| name | type | description |
|---|---|---|
| Account currency | TEXT | Currency that is used by your ad account. (duplicate) |
| Account ID | TEXT | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
| Account Name | TEXT | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
| Account ID (Duplicate) | TEXT | The 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 Value | NUMERIC | The total value of adds of payment info tracked with the conversions objective. |
| Adds to Cart Conversion Value | NUMERIC | The total value of adds to cart tracked with the conversions objective. |
| Adds to Wishlist Conversion Value | NUMERIC | The total value of adds to wishlist tracked with the conversions objective. |
| Action Values App Custom Event.Fb Mobile Add To Cart | NUMERIC | |
| Action Values App Custom Event.Fb Mobile Add To Wishlist | NUMERIC | |
| Action Values App Custom Event.Fb Mobile Content View | NUMERIC | |
| Action Values App Custom Event.Fb Mobile Initiated Checkout | NUMERIC | |
| Action Values App Custom Event.Fb Mobile Purchase | NUMERIC | |
| Action Values App Custom Event.Other | NUMERIC | |
| Call Confirmation Clicks Conversion Value | NUMERIC | The total value of call confirmation clicks conversions. |
| Registrations Completed Conversion Value | NUMERIC | The total value of registrations completed tracked with the conversions objective. |
| Checkouts Initiated Conversion Value | NUMERIC | The total value of checkouts initiated tracked with the conversions objective. |
| Leads Conversion Value | NUMERIC | The total value of leads tracked with the conversions objective. |
| Website Adds of Payment Info Conversion Value | NUMERIC | The total value of website adds of payment info conversions. |
| Website Adds to Cart Conversion Value | NUMERIC | The total value of website add to cart conversions. |
| Website Adds to Wishlist Conversion Value | NUMERIC | The total value of all website add to wishlist conversions. |
| Website Registrations Completed Conversion Value | NUMERIC | The value of complete registration events tracked by the pixel on your website and attributed to your ads. |
| Website Checkouts Initiated Conversion Value | NUMERIC | The total value of website checkout initiated conversions. |
| Website Leads Conversion Value | NUMERIC | The total value of website leads conversions. |
| Website Purchases Conversion Value | NUMERIC | The total value of website purchase conversions. |
| Website Searches Conversion Value | NUMERIC | The total value of website searches conversions. |
| Website Content Views Conversion Value | NUMERIC | The total value of website content views conversions. |
| Omni Adds to Cart Conversion Value | NUMERIC | The total value of omni adds to cart tracked with the conversions objective. |
| Omni Registrations Completed Conversion Value | NUMERIC | The total value of registrations completed tracked with the conversions objective. |
| Action Values Omni Custom | NUMERIC | |
| Omni Checkouts Initiated Conversion Value | NUMERIC | The total value of checkouts initiated tracked with the conversions objective. |
| Purchases Conversion Value | NUMERIC | The total value of purchases tracked with the conversions objective. |
| Omni Searches Conversion Value | NUMERIC | The total value of search conversions. |
| Credit Spends Conversion Value | NUMERIC | The total value of spend credits conversions. |
| Content Views Conversion Value | NUMERIC | The total value of content views tracked with the conversions objective. |
| On-Facebook Leads Conversion Value | NUMERIC | The total value of on-facebook leads conversions. |
| Action Values Onsite Conversion.Purchase | NUMERIC | |
| Action Values Onsite Web Add To Cart | NUMERIC | |
| Action Values Onsite Web App Add To Cart | NUMERIC | |
| Action Values Onsite Web App Purchase | NUMERIC | |
| Action Values Onsite Web Purchase | NUMERIC | |
| Action Values Purchase | NUMERIC | |
| Searches Conversion Value | NUMERIC | The total value of search conversions. |
| Adds of Payment Info | NUMERIC | 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. |
| Adds to Cart | NUMERIC | 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. |
| Adds to Wishlist | NUMERIC | 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. |
| Mobile App Activactions | NUMERIC | 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. |
| Actions App Custom Event.Fb Mobile Add Payment Info | NUMERIC | |
| Actions App Custom Event.Fb Mobile Add To Cart | NUMERIC | |
| Actions App Custom Event.Fb Mobile Add To Wishlist | NUMERIC | |
| Mobile App Registrations Completed | NUMERIC | The number of registrations in your mobile app that were recorded as app events and attributed to your ads. |
| Mobile Content Views | NUMERIC | The 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 Checkout | NUMERIC | |
| Mobile App Levels Completed | NUMERIC | The 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 Purchase | NUMERIC | |
| Actions App Custom Event.Fb Mobile Search | NUMERIC | |
| Actions App Custom Event.Fb Mobile Tutorial Completion | NUMERIC | |
| Mobile App - Other | NUMERIC | |
| Desktop App Installs | NUMERIC | The number of installs of your mobile app that were recorded as app events and attributed to your ads. |
| Check-Ins | NUMERIC | 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. |
| Call Confirmation Clicks | NUMERIC | The number of call confirmation clicks attributed to your ads. |
| Post Comments | NUMERIC | The number of comments on your ads. |
| Registrations Completed | NUMERIC | The number of complete registration events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| Checkouts Initiated | NUMERIC | The 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 Views | NUMERIC | 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. |
| Leads | NUMERIC | 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. |
| Page Likes | NUMERIC | The number of likes of your Facebook Page attributed to your ads. |
| Actions Link Clicks | NUMERIC | 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. |
| Mobile App Installs | NUMERIC | The number of installs of your mobile app that were recorded as app events and attributed to your ads. |
| Website Adds of Payment Info | NUMERIC | The number of add payment info events tracked by the pixel on your website and attributed to your ads. |
| Website Adds to Cart | NUMERIC | The number of add to cart events tracked by the pixel on your website and attributed to your ads. |
| Website Adds to Wishlist | NUMERIC | The number of add to wishlist events tracked by the pixel on your website and attributed to your ads. |
| Website Registrations Completed | NUMERIC | The number of complete registration events tracked by the pixel on your website and attributed to your ads. |
| Custom Events | NUMERIC | The number of custom events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| Website Checkouts Initiated | NUMERIC | The number of initiate checkout events tracked by the pixel on your website and attributed to your ads. |
| Website Leads | NUMERIC | The number of lead events tracked by the pixel on your website and attributed to your ads. |
| Website Purchases | NUMERIC | The number of purchase events tracked by the pixel on your website and attributed to your ads. |
| Website Searches | NUMERIC | The number of search events tracked by the pixel on your website and attributed to your ads. |
| Website Content Views | NUMERIC | The number of view content events tracked by the pixel on your website and attributed to your ads. |
| Achievements Unlocked | NUMERIC | The number of unlock achievement events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| App Activations | NUMERIC | 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 Adds to Cart | NUMERIC | The 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 Installs | NUMERIC | The number of app installs that were recorded as app events and attributed to your ads. |
| Omni Registrations Completed | NUMERIC | The 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 Custom | NUMERIC | |
| Omni checkouts Initiated | NUMERIC | The number of initiate checkout events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| Levels Achieved | NUMERIC | The number of achieve level events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| Purchases | NUMERIC | The number of purchase events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| Ratings Submitted | NUMERIC | 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 Searches | NUMERIC | The number of search events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| Credit Spends | NUMERIC | 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. |
| Tutorials Completed | NUMERIC | 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 Content Views | NUMERIC | The 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 Completions | NUMERIC | The 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 | NUMERIC | The number of leads submitted on Facebook-owned property (including forms and Messenger) and attributed to your ads. |
| Blocked Messaging Connections | NUMERIC | The number of times that people blocked a messaging connection with your business, attributed to your ads. |
| New Messaging Connections | NUMERIC | The number of people your business added as messaging connections, attributed to your ads. |
| Post Saves | NUMERIC | The total number of times your ad has been saved. |
| On-Facebook Purchases | NUMERIC | The number of purchases made within a Facebook-owned property (such as Pages or Messenger) and attributed to your ads. |
| Actions Onsite Web Add To Cart | NUMERIC | |
| Actions Onsite Web App Add To Cart | NUMERIC | |
| Actions Onsite Web App Purchase | NUMERIC | |
| Actions Onsite Web Purchase | NUMERIC | |
| Page Engagement | NUMERIC | The total number of actions that people took on your Facebook Page and its posts, attributed to your ads. |
| Photo Views | NUMERIC | 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. |
| Post Shares | NUMERIC | 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. |
| Post Engagement | NUMERIC | The total number of actions that people take involving your ads. |
| Post Reactions | NUMERIC | 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. |
| Event Responses | NUMERIC | The number of people who responded Interested or Going to your Facebook event, attributed to your ads. |
| Searches | NUMERIC | The 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 Plays | NUMERIC | 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. |
| Content Views | NUMERIC | The 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 ID | TEXT | Used for Instagram Ads. Provide Instagram account ID used for running these ads. |
| ID of ad format asset | TEXT | The ID of the ad format asset involved in impression, click, or action. |
| Ad ID | TEXT | Unique ID of the ad being viewed in reporting |
| Ad Name | TEXT | The name of the ad being viewed in reporting |
| Ad Content | TEXT | The 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) | TEXT | The 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) | TEXT | Unique ID of the ad being viewed in reporting (duplicate) |
| (Deprecated) Ad Network Conversions | NUMERIC | The Ad Network Reported Conversions. |
| Ad Network Revenue | NUMERIC | The Ad Network Reported Revenue |
| AdSet Bid Strategy | TEXT | Lowest cost is one of Facebook's bid strategy options, meaning it tells us how to bid in the ad auction. |
| AdSet Daily Budget | NUMERIC | The daily budget of the set defined in minimum denomination level of your account currency (such as cents for USD). |
| AdSet Destination Type | TEXT | Destination of ads in this Ad Set. Options include - Website, App, Messenger, INSTAGRAM_DIRECT. |
| Adset Effective Status | TEXT | The 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 Time | DATE | End time, in UTC UNIX timestamp |
| Ad Set ID | TEXT | The 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 Budget | NUMERIC | The lifetime budget of the set defined in minimum denomination level of your account currency (such as cents for USD). |
| Ad Set Name | TEXT | The 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 Time | DATE | Start time, in UTC UNIX timestamp |
| Adset Status | TEXT | The status of the adset. |
| Age Range | TEXT | The age range of the people you've reached. |
| Body of the ad | TEXT | The body of the ad. Not supported for video post creatives. |
| ID of body asset | TEXT | The ID of the body asset involved in impression, click or action. |
| Buying Type | TEXT | The 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 asset | TEXT | The ID of the call to action asset involved in impression, click, or action. |
| Campaign Name | TEXT | The campaign name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
| Campaign Bid Strategy | TEXT | Bid strategy for this campaign when you enable campaign budget optimization and when you use AUCTION as your buying type |
| Campaign Budget Remaining | NUMERIC | Remaining campaign budget defined in minimum denomination level of your account currency (such as cents for USD). |
| Campaign Buying t ype | TEXT | Buying type, possible values are - AUCTION default; - RESERVED for reach and frequency ads. |
| Campaign Created Time | DATE | Merging of start_times for the ad sets belonging to this campaign. |
| Campaign Daily Budget | NUMERIC | Daily 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 Status | TEXT | The effective status of the campaign.The status could be effective either because of its own status, or the status of its parent campaign. |
| Campaign ID | TEXT | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
| Campaign Lifetime Budget | NUMERIC | The lifetime budget of the campaign defined in minimum denomination level of your account currency (such as cents for USD). |
| Campaign Objective | TEXT | Campaign's objective. If it is specified the API will validate that any ads created under the campaign match that objective. |
| Campaign Special Ad Category | TEXT | The campaign's Special Ad Category. One of HOUSING, EMPLOYMENT, CREDIT, or NONE. |
| Campaign Spend Cap | TEXT | A spend cap for the campaign, such that it will not spend more than this cap. |
| Campaign Start Time | DATE | Merging of start_times for the ad sets belonging to this campaign. |
| Campaign Status | TEXT | The status of the campaign. |
| Campaign Stop Time | DATE | Merging of stop_times for the ad sets belonging to this campaign. |
| Campaign ID (duplicate) | TEXT | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. (duplicate) |
| Instant Experience View Percentage | PERCENT | The 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 Time | NUMERIC | The 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 Cart | NUMERIC | |
| Catalog Segment Actions App Custom Event.FB Mobile Add To Cart | NUMERIC | |
| Catalog Segment Actions App Custom Event.FB Mobile Content View | NUMERIC | |
| Catalog Segment Actions App Custom Event.FB Mobile Purchase | NUMERIC | |
| Catalog Segment Actions Offsite Conversion Fb Pixel Add To Cart | NUMERIC | |
| Catalog Segment Actions Offsite Conversion Fb Pixel View Content | NUMERIC | |
| Catalog Segment Actions Omni Add To Cart | NUMERIC | |
| Catalog Segment Actions Omni Purchase | NUMERIC | |
| Catalog Segment Actions Omni View Content | NUMERIC | |
| Catalog Segment Actions Purchase | NUMERIC | |
| Catalog Segment Actions View Content | NUMERIC | |
| Catalog Segment Value Add To Cart | NUMERIC | |
| Catalog Segment Value App Custom Event | NUMERIC | |
| Catalog Segment Value App Custom Event.FB Mobile Add To Cart | NUMERIC | |
| Catalog Segment Value App Custom Event.FB Mobile Content View | NUMERIC | |
| Catalog Segment Value App Custom Event.FB Mobile Purchase | NUMERIC | |
| Mobile purchase ROAS | NUMERIC | Value 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 Conversion | NUMERIC | |
| Catalog Segment Value Offsite Conversion Fb Pixel Add To Cart | NUMERIC | |
| Catalog Segment Value Offsite Conversion Fb Pixel View Content | NUMERIC | |
| Catalog Segment Value Omni Add To Cart | NUMERIC | |
| Catalog Segment Value Omni Purchase | NUMERIC | |
| Total purchase ROAS | NUMERIC | Total 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 Content | NUMERIC | |
| Catalog Segment Value Onsite App Add To Cart | NUMERIC | |
| Catalog Segment Value Onsite App Purchase | NUMERIC | |
| Catalog Segment Value Onsite App View Content | NUMERIC | |
| Catalog Segment Value Onsite Web Add To Cart | NUMERIC | |
| Catalog Segment Value Onsite Web App Add To Cart | NUMERIC | |
| Catalog Segment Value Onsite Web App Purchase | NUMERIC | |
| Catalog Segment Value Onsite Web App View Content | NUMERIC | |
| Catalog Segment Value Onsite Web View Content | NUMERIC | |
| Catalog Segment Value Purchase | NUMERIC | |
| Catalog Segment Value View Content | NUMERIC | |
| Website purchase ROAS | NUMERIC | Total 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. |
| Clicks | NUMERIC | The number of clicks on your ads. |
| Mobile app ad click conversions | NUMERIC | The number of Mobile app ad click |
| Mobile app ad impression conversions | NUMERIC | The number of Mobile app ad click |
| Mobile app cancel subscription conversions | NUMERIC | The number of mobile app canceled subscriptions |
| Offline cancel subscription conversions | NUMERIC | The number of offline canceled subscriptions |
| Cancel subscription conversions | NUMERIC | The total number of canceled subscriptions |
| Website cancel subscription conversions | NUMERIC | The number of website canceled subscriptions |
| Mobile app contact conversions | NUMERIC | The number of mobile app contacts |
| Offline contact conversions | NUMERIC | The number of offline contacts |
| Contact conversions | NUMERIC | The total number of contacts |
| Website contact conversions | NUMERIC | The number of website contacts |
| Mobile app customize product conversions | NUMERIC | The number of mobile app products customized |
| Offline customize product conversions | NUMERIC | The number of offline products customized |
| Customize product conversions | NUMERIC | The total number of products customized |
| Website customize product conversions | NUMERIC | The number of website products customized |
| Mobile app donate conversions | NUMERIC | The number of mobile app donations |
| Offline donate conversions | NUMERIC | The number of offline donations |
| Donate on facebook conversions | NUMERIC | The number of donations on facebook |
| Donate conversions | NUMERIC | The total number of donations |
| Website donate conversions | NUMERIC | The number of website donations |
| Mobile app find location conversions | NUMERIC | The number of mobile app location searches |
| Offline find location conversions | NUMERIC | The number of offline app location searches |
| Find location conversions | NUMERIC | The total number of location searches |
| Website find location conversions | NUMERIC | The number of website location searches |
| Appointments Scheduled | NUMERIC | Number of appointments scheduled |
| Mobile app recurring subscription payment conversions | NUMERIC | The number of mobile app recurring subscription payments |
| Offline recurring subscription payment conversions | NUMERIC | The number of offline recurring subscription payments |
| Recurring subscription payment conversions | NUMERIC | The total number of recurring subscription payments |
| Website recurring subscription payment conversions | NUMERIC | The number of website recurring subscription payments |
| Mobile app schedule conversions | NUMERIC | The number of mobile app appointments scheduled |
| Offline schedule conversions | NUMERIC | The number of offline app appointments scheduled |
| Schedule conversions | NUMERIC | The total number of appointments scheduled |
| Website schedule conversions | NUMERIC | The number of website appointments scheduled |
| Mobile app start trial conversions | NUMERIC | The number of mobile app trials started |
| Offline start trial conversions | NUMERIC | The number of offline trials started |
| Start trial conversions | NUMERIC | The total number of trials started |
| Website start trial conversions | NUMERIC | The number of website trials started |
| Mobile app submit application conversions | NUMERIC | The number of mobile app applications submitted |
| Offline submit application conversions | NUMERIC | The number of offline applications submitted |
| Submit application on facebook conversions | NUMERIC | The number of applications submitted on facebook |
| Submit application conversions | NUMERIC | The total number of applications submitted |
| Website submit application conversions | NUMERIC | The number of website applications submitted |
| Mobile app subscribe conversions | NUMERIC | The number of mobile app subscriptions |
| Offline subscribe conversions | NUMERIC | The number of offline subscriptions |
| Subscribe conversions | NUMERIC | The total number of subscriptions |
| Website subscribe conversions | NUMERIC | The number of website subscriptions |
| Converted Product Quantity App Custom Event | NUMERIC | |
| Converted Product Quantity App Custom Event.FB Mobile Add To Cart | NUMERIC | |
| Converted Product Quantity App Custom Event.FB Mobile Content View | NUMERIC | |
| Converted Product Quantity App Custom Event.FB Mobile Purchase | NUMERIC | |
| Converted Product Quantity Offsite Conversion | NUMERIC | |
| Converted Product Quantity Offsite Conversion Fb Pixel View Content | NUMERIC | |
| Converted Product Quantity Omni Add To Cart | NUMERIC | |
| Converted Product Quantity Omni Purchase | NUMERIC | |
| Converted Product Quantity Omni View Content | NUMERIC | |
| Converted Product Value App Custom Event | NUMERIC | |
| Converted Product Value App Custom Event.FB Mobile Add To Cart | NUMERIC | |
| Converted Product Value App Custom Event.FB Mobile Content View | NUMERIC | |
| Converted Product Value App Custom Event.FB Mobile Purchase | NUMERIC | |
| Converted Product Value Offsite Conversion | NUMERIC | |
| Converted Product Value Offsite Conversion Fb Pixel View Content | NUMERIC | |
| Converted Product Value Omni Add To Cart | NUMERIC | |
| Converted Product Value Omni Purchase | NUMERIC | |
| Converted Product Value Omni View Content | NUMERIC | |
| Cost per Adds of Payment Info | NUMERIC | Cost 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 Cart | NUMERIC | Cost 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 Wishlist | NUMERIC | Cost 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 Activactions | NUMERIC | Cost 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 Info | NUMERIC | |
| Cost per Actions App Custom Event.Fb Mobile Add To Cart | NUMERIC | |
| Cost per Actions App Custom Event.Fb Mobile Add To Wishlist | NUMERIC | |
| Cost per Mobile App Registrations Completed | NUMERIC | Cost per The number of registrations in your mobile app that were recorded as app events and attributed to your ads. |
| Cost per Mobile Content Views | NUMERIC | Cost 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 Checkout | NUMERIC | |
| Cost per Mobile App Levels Completed | NUMERIC | Cost 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 Purchase | NUMERIC | |
| Cost per Actions App Custom Event.Fb Mobile Search | NUMERIC | |
| Cost per Actions App Custom Event.Fb Mobile Tutorial Completion | NUMERIC | |
| Cost per Mobile App - Other | NUMERIC | |
| Cost per Check-Ins | NUMERIC | Cost 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 Clicks | NUMERIC | Cost per The number of call confirmation clicks attributed to your ads. |
| Cost per Post Comments | NUMERIC | Cost per The number of comments on your ads. |
| Cost per Registrations Completed | NUMERIC | Cost 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 Initiated | NUMERIC | Cost 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 Views | NUMERIC | Cost 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 Leads | NUMERIC | Cost 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 Likes | NUMERIC | Cost per The number of likes of your Facebook Page attributed to your ads. |
| Cost per Link Clicks | NUMERIC | Cost 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 Installs | NUMERIC | Cost 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 Info | NUMERIC | Cost 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 Cart | NUMERIC | Cost 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 Wishlist | NUMERIC | Cost per The number of add to wishlist events tracked by the pixel on your website and attributed to your ads. |
| Cost per Website Registrations Completed | NUMERIC | Cost per The number of complete registration events tracked by the pixel on your website and attributed to your ads. |
| Cost per Custom Events | NUMERIC | Cost 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 Initiated | NUMERIC | Cost per The number of initiate checkout events tracked by the pixel on your website and attributed to your ads. |
| Cost per Website Leads | NUMERIC | Cost per The number of lead events tracked by the pixel on your website and attributed to your ads. |
| Cost per Website Purchases | NUMERIC | Cost per The number of purchase events tracked by the pixel on your website and attributed to your ads. |
| Cost per Website Searches | NUMERIC | Cost per The number of search events tracked by the pixel on your website and attributed to your ads. |
| Cost per Website Content Views | NUMERIC | Cost per The number of view content events tracked by the pixel on your website and attributed to your ads. |
| Cost per Achievements Unlocked | NUMERIC | Cost 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 Activations | NUMERIC | Cost 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 Cart | NUMERIC | Cost 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 Installs | NUMERIC | Cost per The number of app installs that were recorded as app events and attributed to your ads. |
| Omni Cost per Registrations Completed | NUMERIC | Cost 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 Custom | NUMERIC | |
| Omni Cost per Checkouts Initiated | NUMERIC | Cost 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 Achieved | NUMERIC | Cost 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 Purchases | NUMERIC | Cost 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 Submitted | NUMERIC | Cost 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 Searches | NUMERIC | Cost 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 Spends | NUMERIC | Cost 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 Completed | NUMERIC | Cost 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 Views | NUMERIC | Cost 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 Completions | NUMERIC | Cost 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 | NUMERIC | Cost per The number of leads submitted on Facebook-owned property (including forms and Messenger) and attributed to your ads. |
| Cost per Blocked Messaging Connections | NUMERIC | Cost per The number of times that people blocked a messaging connection with your business, attributed to your ads. |
| Cost per New Messaging Connections | NUMERIC | Cost per The number of people your business added as messaging connections, attributed to your ads. |
| Cost per Post Saves | NUMERIC | Cost per The total number of times your ad has been saved. |
| Cost per On-Facebook Purchases | NUMERIC | Cost 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 Cart | NUMERIC | |
| Cost per Actions Onsite Web App Add To Cart | NUMERIC | |
| Cost per Actions Onsite Web App Purchase | NUMERIC | |
| Cost per Actions Onsite Web Purchase | NUMERIC | |
| Cost per Page Engagement | NUMERIC | Cost per The total number of actions that people took on your Facebook Page and its posts, attributed to your ads. |
| Cost per Photo Views | NUMERIC | Cost 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 Shares | NUMERIC | Cost 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 Engagement | NUMERIC | Cost per The total number of actions that people take involving your ads. |
| Cost per Post Reactions | NUMERIC | Cost 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 Responses | NUMERIC | Cost per The number of people who responded Interested or Going to your Facebook event, attributed to your ads. |
| Cost per Searches | NUMERIC | Cost 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 Plays | NUMERIC | Cost 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 Views | NUMERIC | Cost 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 conversion | NUMERIC | Cost per mobile app ad click conversion |
| Cost per mobile app ad impression conversion | NUMERIC | Cost per mobile app ad impression conversion |
| Cost per mobile app cancel subscription conversion | NUMERIC | Cost per mobile app cancel subscription conversion |
| Cost per offline cancel subscription conversion | NUMERIC | Cost per offline cancel subscription conversion |
| Cost per cancel subscription conversion | NUMERIC | Cost per cancel subscription conversion |
| Cost per website cancel subscription conversion | NUMERIC | Cost per website cancel subscription conversion |
| Cost per mobile app contact conversion | NUMERIC | Cost per mobile app contact conversion |
| Cost per offline contact conversion | NUMERIC | Cost per offline contact conversion |
| Cost per contact conversion | NUMERIC | Cost per contact conversion |
| Cost per website contact conversion | NUMERIC | Cost per website contact conversion |
| Cost per mobile app customize product conversion | NUMERIC | Cost per mobile app customize product conversion |
| Cost per offline customize product conversion | NUMERIC | Cost per offline customize product conversion |
| Cost per customize product conversion | NUMERIC | Cost per customize product conversion |
| Cost per website customize product conversion | NUMERIC | Cost per website customize product conversion |
| Cost per mobile app donate conversion | NUMERIC | Cost per mobile app donate conversion |
| Cost per offline donate conversion | NUMERIC | Cost per offline donate conversion |
| Cost per donate on facebook conversion | NUMERIC | Cost per donate on facebook conversion |
| Cost per donate conversion | NUMERIC | Cost per donate conversion |
| Cost per website donate conversion | NUMERIC | Cost per website donate conversion |
| Cost per mobile app find location conversion | NUMERIC | Cost per mobile app find location conversion |
| Cost per offline find location conversion | NUMERIC | Cost per offline find location conversion |
| Cost per find location conversion | NUMERIC | Cost per find location conversion |
| Cost per website find location conversion | NUMERIC | Cost per website find location conversion |
| Cost per mobile app recurring subscription payment conversion | NUMERIC | Cost per mobile app recurring subscription payment conversion |
| Cost per offline recurring subscription payment conversion | NUMERIC | Cost per offline recurring subscription payment conversion |
| Cost per recurring subscription payment conversion | NUMERIC | Cost per recurring subscription payment conversion |
| Cost per website recurring subscription payment conversion | NUMERIC | Cost per website recurring subscription payment conversion |
| Cost per mobile app schedule conversion | NUMERIC | Cost per mobile app schedule conversion |
| Cost per offline schedule conversion | NUMERIC | Cost per offline schedule conversion |
| Cost per schedule conversion | NUMERIC | Cost per schedule conversion |
| Cost per website schedule conversion | NUMERIC | Cost per website schedule conversion |
| Cost per mobile app start trial conversion | NUMERIC | Cost per mobile app start trial conversion |
| Cost per offline start trial conversion | NUMERIC | Cost per offline start trial conversion |
| Cost per start trial conversion | NUMERIC | Cost per start trial conversion |
| Cost per website start trial conversion | NUMERIC | Cost per website start trial conversion |
| Cost per mobile app submit application conversion | NUMERIC | Cost per mobile app submit application conversion |
| Cost per offline submit application conversion | NUMERIC | Cost per offline submit application conversion |
| Cost per submit application on facebook conversion | NUMERIC | Cost per submit application on facebook conversion |
| Cost per submit application conversion | NUMERIC | Cost per submit application conversion |
| Cost per website submit application conversion | NUMERIC | Cost per website submit application conversion |
| Cost per mobile app subscribe conversion | NUMERIC | Cost per mobile app subscribe conversion |
| Cost per offline subscribe conversion | NUMERIC | Cost per offline subscribe conversion |
| Cost per subscribe conversion | NUMERIC | Cost per subscribe conversion |
| Cost per website subscribe conversion | NUMERIC | Cost per website subscribe conversion |
| Cost per Estimated Ad Recall Lift | NUMERIC | Cost 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 Clicks | NUMERIC | Cost per The number of clicks on links that take people off Facebook-owned properties. |
| Cost per ThruPlays | NUMERIC | Cost per The number of times your video was played to completion, or for at least 15 seconds. |
| Cost per Unique Call Confirmation Clicks | NUMERIC | Cost per The number of call confirmation clicks attributed to your ads. |
| Cost per Unique Adds of Payment Info | NUMERIC | Cost per The estimated number of people who submitted payment info. |
| Cost per Unique Actions Add To Cart | NUMERIC | |
| Cost per Unique Adds to Wishlist | NUMERIC | Cost per The estimated number of people who added items to their wishlist. |
| Cost per Unique Actions App Custom Event | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Activate App | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Add Payment Info | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Add To Cart | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Add To Wishlist | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Complete Registration | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Content View | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Initiated Checkout | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Level Achieved | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Purchase | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Search | NUMERIC | |
| Cost per Unique Actions App Custom Event.Fb Mobile Tutorial Completion | NUMERIC | |
| Cost per Unique Actions App Custom Event.Other | NUMERIC | |
| Cost per Unique Check-Ins | NUMERIC | Cost 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 Comments | NUMERIC | Cost per The number of people with comments on your ads. |
| Cost per Unique Registrations Completed | NUMERIC | Cost per The estimated number of people who registered. |
| Cost per Unique Checkouts Initiated | NUMERIC | Cost per The estimated number of people who initiated checkouts. |
| Cost per Unique Landing Page Views | NUMERIC | Cost per The number of people who caused a landing page view. |
| Cost per Unique Leads | NUMERIC | Cost 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 Likes | NUMERIC | Cost per The number of people with likes of your Facebook Page attributed to your ads. |
| Cost per Unique Link Clicks | NUMERIC | Cost per The number of people who performed a link click. |
| Cost per Unique Mobile App Installs | NUMERIC | Cost 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 Conversions | NUMERIC | Cost per The number of unique people who with conversion events attributed to your ads (estimated) |
| Cost per Unique Website Adds of Payment Info | NUMERIC | Cost 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 Cart | NUMERIC | Cost 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 Wishlist | NUMERIC | Cost 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 Completed | NUMERIC | Cost 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 Initiated | NUMERIC | Cost 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 Leads | NUMERIC | Cost per The number of people with lead events tracked by the pixel on your website and attributed to your ads. |
| Cost per Unique Website Purchases | NUMERIC | Cost per The number of people with purchase events tracked by the pixel on your website and attributed to your ads. |
| Cost per Unique Website Searches | NUMERIC | Cost 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 Views | NUMERIC | Cost 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 Unlocked | NUMERIC | Cost per The estimated number of people who unlocked achievements. |
| Cost per Unique App Activations | NUMERIC | Cost per The estimated number of people who performed app activations. |
| Cost per Unique Adds to Cart | NUMERIC | Cost per The estimated number of people who added items to their cart. |
| Cost per Unique App Installs | NUMERIC | Cost per The number of unique people who took this action attributed to your ads (estimated) |
| Omni Cost per Unique Registrations Completed | NUMERIC | Cost per The estimated number of people who registered. |
| Cost per Unique Actions Omni Custom | NUMERIC | |
| Omni Cost per Unique Checkouts Initiated | NUMERIC | Cost per The estimated number of people who initiated checkouts. |
| Cost per Unique Levels Completed | NUMERIC | Cost per The estimated number of people who achieved levels. |
| Cost per Unique Purchases | NUMERIC | Cost per The estimated number of people who completed at least one purchase. |
| Cost per Unique Ratings Submitted | NUMERIC | Cost per The estimated number of people who submitted ratings. |
| Cost per Unique Searches | NUMERIC | Cost per The estimated number of people who searched. |
| Cost per Unique Credit Spends | NUMERIC | Cost per The estimated number of people who spent credits. |
| Cost per Unique Tutorials Completed | NUMERIC | Cost per The estimated number of people who completed tutorials. |
| Omni Cost per Unique Content Views | NUMERIC | Cost per The estimated number of people who viewed content. |
| Cost per Unique On-Facebook Workflow Completions | NUMERIC | Cost 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 Leads | NUMERIC | Cost per The number of leads submitted on Facebook-owned property (including forms and Messenger) and attributed to your ads. |
| Cost per Unique Blocked Messaging Connections | NUMERIC | Cost per The number of people that blocked a messaging connection with your business, attributed to your ads. |
| Cost per Unique On-Facebook Purchases | NUMERIC | Cost per The number of unique people who took this action attributed to your ads (estimated) |
| Cost per Unique Actions Onsite Web Add To Cart | NUMERIC | |
| Cost per Unique Actions Onsite Web App Add To Cart | NUMERIC | |
| Cost per Unique Actions Onsite Web App Purchase | NUMERIC | |
| Cost per Unique Actions Onsite Web Purchase | NUMERIC | |
| Cost per Unique Page Engagement | NUMERIC | Cost per The number of people who took action on your Facebook Page and its posts, attributed to your ads. |
| Cost per Unique Photo Views | NUMERIC | Cost 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 Engagement | NUMERIC | Cost per The total number of people who took actions involving your ads. |
| Cost per Unique Post Reactions | NUMERIC | Cost per The number of unique people who took this action attributed to your ads (estimated) |
| Cost per Unique Actions Purchase | NUMERIC | |
| Cost per Unique Event Responses | NUMERIC | Cost per The number of people who responded Interested or Going to your Facebook event, attributed to your ads. |
| Cost per Unique Actions Search | NUMERIC | |
| Cost per Unique 3-Second Continuous Video Plays | NUMERIC | Cost per The number of unique people who took this action attributed to your ads (estimated) |
| Cost per Unique Content Views | NUMERIC | Cost per The estimated number of people who viewed content. |
| Cost per Unique Clicks | NUMERIC | Cost per The number of people who performed a click (all). |
| Cost per Unique Outbound Clicks | NUMERIC | Cost per The number of people who performed an outbound click. |
| Country | COUNTRY | The 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. |
| CPC | NUMERIC | The average cost for each click (all). |
| CPM | NUMERIC | The average cost for 1,000 impressions. |
| Cost per 1,000 People Reached | NUMERIC | The average cost to reach 1,000 people. |
| CTR | PERCENT | The percentage of times people saw your ad and performed a click (all). |
| Currency | TEXT | Currency that is used by your ad account. |
| Custom conversion action count | NUMERIC | The number of custom conversion actions |
| Custom conversion action name | TEXT | The name of the custom conversion action |
| Date | DATE | The dimension that determines how date-based data in a chart is handled (the time dimension). |
| Reporting Starts | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
| Reporting Ends | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
| ID of description asset | TEXT | The ID of the description asset involved in impression, click or action. |
| Desktop Feed Standard Preview URL | TEXT | URL to a preview of the ad, as seen in the desktop feed standard placement |
| Device platform | TEXT | The type of device, mobile or desktop, used by people when they viewed or clicked on an ad, as shown in ads reporting. |
| Designated Market Area | TEXT | DMA (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 ID | TEXT | The ID of an Instagram post to use in an ad. |
| Instagram Story ID | TEXT | Used for Instagram Ads. The ID of an Instagram post to display as an Instagram ad. |
| Facebook Post ID | TEXT | The ID of a page post to use in an ad, regardless of whether it's an organic or unpublished page post |
| Effective Status | TEXT | The 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 Rate | PERCENT | The rate at which an estimated number of additional people, when asked, would remember seeing your ads within 2 days. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. |
| Estimated Ad Recall Lift | NUMERIC | 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. |
| Facebook Story Mobile Preview URL | TEXT | URL to a preview of the ad, as seen in the facebook story mobile placement |
| Frequency | NUMERIC | The average number of times each person saw your ad. |
| Number of frequency | TEXT | The number of times an ad in your Reach and Frequency campaign was served to each person. |
| Gender | TEXT | Gender 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. | TEXT | Hourly 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. | TEXT | Hourly 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 asset | TEXT | The ID of the image asset involved in impression, click or action. |
| Ad Image URL | IMAGE_URL | A 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 someone | TEXT | The device where your last ad was served to someone on Facebook. For example "iPhone" if someone viewed your ad on an iPhone. |
| Impressions | NUMERIC | The number of times your ads were on screen. |
| Instagram Page ID | TEXT | Used for Instagram Ads. Provide Instagram account ID used for running these ads. |
| Instagram Post URL | TEXT | URL for a post on Instagram you want to run as an ad. Also known as Instagram media. |
| Instagram Standard Preview URL | TEXT | URL to a preview of the ad, as seen in the instagram standard placement |
| Instagram Story Preview URL | TEXT | URL to a preview of the ad, as seen in the instagram story placement |
| Instant Article Standard Preview URL | TEXT | URL to a preview of the ad, as seen in the instant article standard placement |
| Instream Video Desktop Preview URL | TEXT | URL to a preview of the ad, as seen in the instream video desktop placement |
| Instream Video Mobile Preview URL | TEXT | URL to a preview of the ad, as seen in the instream video mobile placement |
| Keyword | TEXT | The name of the ad being viewed in reporting (duplicate) |
| Ad Link | TEXT | The link where the user is taken to upon clicking on the ad. |
| Link Clicks | NUMERIC | 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.(duplicate) |
| ID of the url asset | TEXT | The ID of the URL asset involved in impression, click or action. |
| Website URL of the url asset | TEXT | The website URL of the URL asset involved in impression, click or action. |
| Mobile App Purchase ROAS App Custom Event.Fb Mobile Purchase | NUMERIC | |
| Mobile Feed Basic Preview URL | TEXT | URL to a preview of the ad, as seen in the mobile feed basic placement |
| Mobile Feed Standard Preview URL | TEXT | URL to a preview of the ad, as seen in the mobile feed standard placement |
| Objective | TEXT | The 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 CTR | PERCENT | The percentage of times people saw your ad and performed an outbound click. |
| Outbound Clicks | NUMERIC | The number of clicks on links that take people off Facebook-owned properties. |
| The ID of the place page | TEXT | The ID of the place page involved in impression or click. |
| Where your ad was shown within a platform | TEXT | Where 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 product | TEXT | The ID and name of the product involved in impression, click, or action. |
| Platform your ad was shown | TEXT | Which platform your ad was shown, for example on Facebook, Instagram, or Audience Network. |
| Reach | NUMERIC | The number of people who saw your ads at least once. Reach is different from impressions, which may include multiple views of your ads by the same people. |
| Region | REGION | The 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 Spent | NUMERIC | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. |
| Status | TEXT | The status of the ad. |
| Thumbnail URL | IMAGE_URL | URL for a thumbnail image for this ad creative. |
| Link Ad Title | TEXT | Title for link ad, which does not belong to a page. |
| ID of the title asset | TEXT | The ID of the title asset involved in impression, click or action. |
| Total Cost | NUMERIC | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. (duplicate) |
| Unique Adds of Payment Info | NUMERIC | The estimated number of people who submitted payment info. |
| Unique Actions Add To Cart | NUMERIC | |
| Unique Adds to Wishlist | NUMERIC | The estimated number of people who added items to their wishlist. |
| Unique Actions App Custom Event | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Activate App | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Add Payment Info | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Add To Cart | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Add To Wishlist | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Complete Registration | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Content View | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Initiated Checkout | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Level Achieved | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Purchase | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Search | NUMERIC | |
| Unique Actions App Custom Event.Fb Mobile Tutorial Completion | NUMERIC | |
| Unique Actions App Custom Event.Other | NUMERIC | |
| Unique Check-Ins | NUMERIC | 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. |
| Unique Call Confirmation Clicks | NUMERIC | The number of call confirmation clicks attributed to your ads. |
| Unique Post Comments | NUMERIC | The number of people with comments on your ads. |
| Unique Registrations Completed | NUMERIC | The estimated number of people who registered. |
| Unique Checkouts Initiated | NUMERIC | The estimated number of people who initiated checkouts. |
| Unique Landing Page Views | NUMERIC | The number of people who caused a landing page view. |
| Unique Leads | NUMERIC | 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. |
| Unique Page Likes | NUMERIC | The number of people with likes of your Facebook Page attributed to your ads. |
| Unique Link Clicks | NUMERIC | The number of people who performed a link click. |
| Unique Mobile App Installs | NUMERIC | The number of people with installs of your mobile app that were recorded as app events and attributed to your ads. |
| (Deprecated) Unique Website Conversions | NUMERIC | The number of unique people who with conversion events attributed to your ads. |
| Unique Website Adds of Payment Info | NUMERIC | The number of people with add payment info events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Adds to Cart | NUMERIC | The number of people with add to cart events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Adds to Wishlist | NUMERIC | The number of people who performed add to wishlist events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Registrations Completed | NUMERIC | The number of people with complete registration events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Checkouts Initiated | NUMERIC | The number of people who initiated checkout events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Leads | NUMERIC | The number of people with lead events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Purchases | NUMERIC | The number of people with purchase events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Searches | NUMERIC | The number of people with search events tracked by the pixel on your website and attributed to your ads. |
| Unique Website Content Views | NUMERIC | The number of people with view content events tracked by the pixel on your website and attributed to your ads. |
| Unique Achievements Unlocked | NUMERIC | The estimated number of people who unlocked achievements. |
| Unique App Activations | NUMERIC | The estimated number of people who performed app activations. |
| Unique Adds to Cart | NUMERIC | The estimated number of people who added items to their cart. |
| Unique App Installs | NUMERIC | The number of unique people who took this action attributed to your ads (estimated) |
| Omni Unique Registrations Completed | NUMERIC | The estimated number of people who registered. |
| Unique Actions Omni Custom | NUMERIC | |
| Unique Omni Checkouts Initiated | NUMERIC | The estimated number of people who initiated checkouts. |
| Unique Levels Completed | NUMERIC | The estimated number of people who achieved levels. |
| Omni Unique Purchases | NUMERIC | The estimated number of people who completed at least one purchase. |
| Unique Ratings Submitted | NUMERIC | The estimated number of people who submitted ratings. |
| Unique Searches | NUMERIC | The estimated number of people who searched. |
| Unique Credit Spends | NUMERIC | The estimated number of people who spent credits. |
| Unique Tutorials Completed | NUMERIC | The estimated number of people who completed tutorials. |
| Unique Omni Content Views | NUMERIC | The estimated number of people who viewed content. |
| Unique On-Facebook Workflow Completions | NUMERIC | The 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 Leads | NUMERIC | The number of leads submitted on Facebook-owned property (including forms and Messenger) and attributed to your ads. |
| Unique Blocked Messaging Connections | NUMERIC | The number of people that blocked a messaging connection with your business, attributed to your ads. |
| Unique On-Facebook Purchases | NUMERIC | The number of unique people who took this action attributed to your ads (estimated) |
| Unique Actions Onsite Web Add To Cart | NUMERIC | |
| Unique Actions Onsite Web App Add To Cart | NUMERIC | |
| Unique Actions Onsite Web App Purchase | NUMERIC | |
| Unique Actions Onsite Web Purchase | NUMERIC | |
| Unique Page Engagement | NUMERIC | The number of people who took action on your Facebook Page and its posts, attributed to your ads. |
| Unique Photo Views | NUMERIC | 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. |
| Unique Post Engagement | NUMERIC | The total number of people who took actions involving your ads. |
| Unique Post Reactions | NUMERIC | The number of unique people who took this action attributed to your ads (estimated) |
| Unique Actions Purchase | NUMERIC | |
| Unique Event Responses | NUMERIC | The number of people who responded Interested or Going to your Facebook event, attributed to your ads. |
| Unique Actions Search | NUMERIC | |
| Unique 3-Second Continuous Video Plays | NUMERIC | The number of unique people who took this action attributed to your ads (estimated) |
| Unique Content Views | NUMERIC | The estimated number of people who viewed content. |
| Unique Clicks | NUMERIC | The number of people who performed a click (all). |
| Unique CTR | PERCENT | The percentage of people who saw your ad and performed a unique click (all). |
| Unique Link Clicks CTR | PERCENT | The percentage of people who saw your ad and performed a link click. |
| Unique Outbound CTR | PERCENT | The percentage of people who saw your ad and performed an outbound click. |
| Unique Outbound Clicks | NUMERIC | The number of people who performed an outbound click. |
| URL Tags | TEXT | A 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 Actions | NUMERIC | The 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 Time | NUMERIC | The average time a video was played, including any time spent replaying the video for a single impression. |
| Video Watched at 100 percent | NUMERIC | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
| Video Watched at 25 percent | NUMERIC | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
| Video Watched at 50 percent | NUMERIC | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
| Video Watched at 75 percent | NUMERIC | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
| Video Plays at 95 percent | NUMERIC | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
| Video Plays | NUMERIC | The 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 actions | NUMERIC | The number of times your video was played to completion, or for at least 15 seconds. |
| Website CTR link click | PERCENT | The percentage of times people saw your ad and performed a link click. |
| Website Purchase ROAS | NUMERIC | The 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. |
| Today | DATE | Today's date |
Easily connect Facebook Ads to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.