Data Sources

Meta Ads

Metrics & Dimensions List

Introduction

You have different tables depending on your connection settings:

  • meta_ads__{level}_insights_{breakdowns}_daily
  • meta_ads__{level}_insights_{breakdowns}_weekly
  • meta_ads__{level}_insights_{breakdowns}_monthly
  • meta_ads__{level}_insights_{breakdowns}_lifetime
  • meta_ads__ad_creative

The different levels available are: ads, adsets, campaigns
The breakdowns: age, gender, age, gender, country

Important

When to use _weekly, _monthly or _lifetime tables instead of _daily?

These granularities are crucial when working with non-aggregatable metrics, which are typically identified by the _unique suffix in the metric name. While daily tables allow for simple aggregation of metrics like impressions (where you can sum daily values to obtain monthly totals), this approach fails for metrics that represent distinct or unique interactions.

For example, reach is a classic non-aggregatable metric. You cannot calculate monthly reach by simply summing daily reach values. Instead, you must use the appropriate granularity table—such as the _weekly or _monthly table—to accurately capture unique interactions across a given time period.

Key considerations:

  • Use _daily tables for metrics that can be summed (e.g., impressions)
  • Use _weekly, _monthly, or _lifetime tables for metrics representing unique interactions (e.g., reach)
  • Metrics with _unique in their name typically require special aggregation methods

Insights Table

account_id
Text

Account ID : the ID of the advertising account.

account_name
Text

Account Name : The name of the advertising account.

account_currency
Text

Account Currency : The currency used for billing in the advertising account. Example: USD, EUR, GBP.

ad_id
Text

Ad ID : the ID of the ad.

ad_name
Text

Ad Name : The name of the ad.

ad_created_time
Timestamp

Ad Created Time : The date and time the ad was created.

ad_updated_time
Timestamp

Ad Updated Time : The date and time the ad was last updated.

ad_effective_status
Text

Ad Effective Status : The effective status of the ad. The status could be effective either because of its own status, or the status of its parent units. (e.g., ACTIVE, PAUSED, DELETED).

ad_bid_type
Text

Ad Bid Type : The type of bidding used for the ad.

ad_bid_amount
Number

Ad Bid Amount : The amount bid for the ad.

source_ad_id
Text

Source Ad ID : The ID of the original ad if this ad is a copy.

last_updated_by_app_id
Text

Last Updated By App ID : Indicates the app used for the most recent update of the ad.

preview_shareable_link
Text

Preview Shareable Link : A link that enables users to preview ads in different placements.

adset_id
Text

Ad Set ID : the ID of the ad set.

adset_name
Text

Ad Set Name : The name of the ad set.

adset_daily_budget
Number

Ad Set Daily Budget : The daily budget for the ad set.

adset_lifetime_budget
Number

Ad Set Lifetime Budget : The lifetime budget for the ad set.

adset_created_time
Timestamp

Ad Set Created Time : The date and time the ad set was created.

adset_updated_time
Timestamp

Ad Set Updated Time : The date and time the ad set was last updated.

adset_start_time
Timestamp

Ad Set Start Time : The date and time the ad set is scheduled to start.

adset_end_time
Timestamp

Ad Set End Time : The date and time the ad set is scheduled to end.

adset_effective_status
Text

Ad Set Effective Status : The effective status of the ad set (e.g., ACTIVE, PAUSED, DELETED).

adset_optimization_goal
Text

Ad Set Optimization Goal : The optimization goal for the ad set (e.g., REACH, CLICKS, IMPRESSIONS).

adset_bid_amount
Number

Ad Set Bid Amount : The bid amount for the ad set (if applicable).

adset_billing_event
Text

Ad Set Billing Event : The billing event for the ad set (e.g., IMPRESSIONS, CLICKS, CONVERSIONS).

source_adset_id
Text

Source Ad Set ID : The ID of the original ad set if this ad set is a copy.

campaign_id
Text

Campaign ID : the ID of the campaign.

campaign_name
Text

Campaign Name : The name of the campaign.

campaign_daily_budget
Number

Campaign Daily Budget : The daily budget for the campaign.

campaign_lifetime_budget
Number

Campaign Lifetime Budget : The lifetime budget for the campaign.

campaign_created_time
Timestamp

Campaign Created Time : The date and time the campaign was created.

campaign_updated_time
Timestamp

Campaign Updated Time : The date and time the campaign was last updated.

campaign_start_time
Timestamp

Campaign Start Time : The date and time the campaign is scheduled to start.

campaign_end_time
Timestamp

Campaign End Time : The date and time the campaign is scheduled to end.

campaign_effective_status
Text

Campaign Effective Status : The effective status of the campaign (e.g., ACTIVE, PAUSED, DELETED).

campaign_objective
Text

Campaign Objective : The objective of the campaign.

campaign_buying_type
Text

Campaign Buying Type : The buying type of the campaign (e.g., AUCTION, RESERVED).

source_campaign_id
Text

Source Campaign ID : The ID of the original campaign if this campaign is a copy.

date
Date

Date : The date for which the metrics are reported.

conversion_rate_ranking
Text

Conversion Rate Ranking : A ranking of your ad's expected conversion rate. Your ad is ranked against ads with your optimization goal that competed for the same audience. Possible values include BELOW_AVERAGE_10, BELOW_AVERAGE_20, BELOW_AVERAGE_35, AVERAGE, ABOVE_AVERAGE, or UNKNOWN if there's not enough information about the ad. This metric is an ad relevance diagnostic and does not apply to campaigns or ad sets, only ads.

engagement_rate_ranking
Text

Engagement Rate Ranking : A ranking of your ad's expected engagement rate. Engagement includes all clicks, likes, comments and shares. Your ad is ranked against ads that competed for the same audience. Possible values include BELOW_AVERAGE_10, BELOW_AVERAGE_20, BELOW_AVERAGE_35, AVERAGE, ABOVE_AVERAGE, or UNKNOWN if there's not enough information about the ad. This metric is an ad relevance diagnostic and does not apply to campaigns or ad sets, only ads.

quality_ranking
Text

Quality Ranking : A ranking of your ad’s perceived quality. Quality is measured using feedback on your ads and the post-click experience. Your ad is ranked against ads that competed for the same audience. Possible values include BELOW_AVERAGE_10, BELOW_AVERAGE_20, BELOW_AVERAGE_35, AVERAGE, ABOVE_AVERAGE, or UNKNOWN if there’s not enough information about the ad. This metric is an ad relevance diagnostic (https://www.facebook.com/help/403110480493160) and does not apply to campaigns or ad sets, only ads.

spend
Number

Spend : The amount spent on the ad.

social_spend
Number

Social Spend : The amount spent on social components of the ad (e.g., boosted posts).

clicks
Number

Clicks : The total number of clicks on the ad.

inline_link_clicks
Number

Inline Link Clicks : The number of clicks on links within the ad.

outbound_clicks
Number

Outbound Clicks : The number of clicks that take the user outside of the Facebook platform. This is often clicks to a website.

impressions
Number

Impressions : The number of times your ads were on screen.

full_view_impressions
Number

Full View Impressions : The number of Full Views on your Page's posts as a result of your ad.

inline_post_engagement
Number

Inline Post Engagement : The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window.

reach
Number

Reach : 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. This metric is estimated.

full_view_reach
Number

Full View Reach : The number of people who performed a Full View on your Page's post as a result of your ad.

unique_clicks
Number

Unique Clicks : The number of people who performed a click (all). This metric is estimated.

unique_inline_link_clicks
Number

Unique Inline Link Clicks : The number of people who performed an inline link click. This metric is estimated.

unique_outbound_clicks
Number

Unique Outbound Clicks : The number of people who performed an outbound click. This metric is estimated.

mobile_app_purchase_roas
Number

Mobile App Purchase ROAS : The total return on ad spend (ROAS) from mobile app purchases. This is based on the value that you assigned when you set up the app event.

purchase_roas
Number

Purchase ROAS : The total return on ad spend (ROAS) from purchases. This is based on information received from one or more of your connected Facebook Business Tools and attributed to your ads.

website_purchase_roas
Number

Website Purchase ROAS : 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.

instant_experience_clicks_to_open
Number

Instant Experience Clicks to Open : The number of clicks on your ad that open an Instant Experience. This metric is in development.

instant_experience_clicks_to_start
Number

Instant Experience Clicks to Start : The number of times an interactive component in an Instant Experience starts. This metric is in development.

instant_experience_outbound_clicks
Number

Instant Experience Outbound Clicks : The number of clicks on links in an Instant Experience that take people off Facebook-owned properties. This metric is in development.

conversion_values
Number

Conversion Values : The total value of all conversions across all channels (i.e. website, mobile app, offline, and on-facebook) attributed to your ads. Visit the Ads Action Stats reference for a list of conversion values.

conversions
Number

Conversions : The total number of conversions across all channels (i.e. website, mobile app, offline, and on-facebook) attributed to your ads. Visit the Ads Action Stats reference for a list of conversions.

converted_product_quantity
Number

Converted Product Quantity : The number of products purchased which are recorded by your merchant partner’s pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.

converted_product_value
Number

Converted Product Value : The value of purchases recorded by your merchant partner’s pixel or app SDK for a given product ID and driven by your ads. Has to be used together with converted product ID breakdown.

estimated_ad_recallers
Number

Estimated Ad Recallers : 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. This metric is estimated and in development.

video_play_actions
Number

Video Play Actions : 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.

video_3_sec_watched_actions
Number

Video 3 Sec Watched Actions : The number of times a video was watched for at least 3 seconds.

video_continuous_2_sec_watched_actions
Number

Video Continuous 2 Sec Watched Actions : video_continuous_2_sec_watched_actions

video_15_sec_watched_actions
Number

Video 15 Sec Watched Actions : The number of times a video was watched for at least 15 seconds.

video_30_sec_watched_actions
Number

Video 30 Sec Watched Actions : The number of times a video was watched for at least 30 seconds.

video_p25_watched_actions
Number

Video P25 Watched Actions : The number of times your video was played at 25% of its length, including plays that skipped to this point.

video_p50_watched_actions
Number

Video P50 Watched Actions : The number of times your video was played at 50% of its length, including plays that skipped to this point.

video_p75_watched_actions
Number

Video P75 Watched Actions : The number of times your video was played at 75% of its length, including plays that skipped to this point.

video_p95_watched_actions
Number

Video P95 Watched Actions : The number of times your video was played at 95% of its length, including plays that skipped to this point.

video_p100_watched_actions
Number

Video P100 Watched Actions : The number of times your video was played at 100% of its length, including plays that skipped to this point.

video_avg_time_watched_actions
Number

Video Avg Time Watched Actions : The average time a video was played, including any time spent replaying the video for a single impression.

unique_video_3_sec_watched_actions
Number

Unique Video 3 Sec Watched Actions : The number of people who watched a video for at least 3 seconds.

unique_video_continuous_2_sec_watched_actions
Number

Unique Video Continuous 2 Sec Watched Actions : The number of people who watched a video for at least 2 continuous seconds.

unique_video_15_sec_watched_actions
Number

Unique Video 15 Sec Watched Actions : The number of people who watched a video for at least 15 seconds.

actions__app_custom_event__fb_mobile_achievement_unlocked
Number

App Custom Event: Achievement Unlocked - The number of times mobile app achievements were unlocked.

actions__app_custom_event__fb_mobile_activate_app
Number

App Custom Event: Activate App - The number of times the mobile app was started.

actions__app_custom_event__fb_mobile_add_payment_info
Number

App Custom Event: Add Payment Info - The number of times payment details were added in the mobile app.

actions__app_custom_event__fb_mobile_add_to_cart
Number

App Custom Event: Add to Cart - The number of times items were added to a cart in the mobile app.

actions__app_custom_event__fb_mobile_add_to_wishlist
Number

App Custom Event: Add to Wishlist - The number of times items were added to a wishlist in the mobile app.

actions__app_custom_event__fb_mobile_complete_registration
Number

App Custom Event: Complete Registration - The number of times registrations were completed in the mobile app.

actions__app_custom_event__fb_mobile_content_view
Number

App Custom Event: Content View - The number of times content was viewed in the mobile app.

actions__app_custom_event__fb_mobile_initiated_checkout
Number

App Custom Event: Initiated Checkout - The number of times checkouts were initiated in the mobile app.

actions__app_custom_event__fb_mobile_level_achieved
Number

App Custom Event: Level Achieved - The number of times levels were achieved in the mobile app.

actions__app_custom_event__fb_mobile_purchase
Number

App Custom Event: Purchase - The number of purchases made in the mobile app.

actions__app_custom_event__fb_mobile_rate
Number

App Custom Event: Rate - The number of times the mobile app was rated.

actions__app_custom_event__fb_mobile_search
Number

App Custom Event: Search - The number of searches performed in the mobile app.

actions__app_custom_event__fb_mobile_spent_credits
Number

App Custom Event: Spent Credits - The number of times credits were spent in the mobile app.

actions__app_custom_event__fb_mobile_tutorial_completion
Number

App Custom Event: Tutorial Completion - The number of times tutorials were completed in the mobile app.

actions__app_custom_event__other
Number

App Custom Event: Other - The number of other actions performed in the mobile app.

actions__app_install
Number

App Installs - The number of app installs.

actions__app_use
Number

App Uses - The number of times the app was used.

actions__checkin
Number

Checkins - The number of check-ins.

actions__comment
Number

Comments - The number of post comments.

actions__credit_spent
Number

Credit Spends - The number of credit spends.

actions__games__plays
Number

Game Plays - The number of game plays.

actions__landing_page_view
Number

Landing Page Views - The number of landing page views.

actions__like
Number

Likes - The number of page likes.

actions__link_click
Number

Link Clicks - The number of link clicks.

actions__mobile_app_install
Number

Mobile App Installs - The number of mobile app installs.

actions__offsite_conversion__fb_pixel_add_payment_info
Number

Offsite Conversion: Add Payment Info - The number of times payment information was added via the Facebook pixel.

actions__offsite_conversion__fb_pixel_add_to_cart
Number

Offsite Conversion: Add to Cart - The number of times products were added to cart via the Facebook pixel.

actions__offsite_conversion__fb_pixel_add_to_wishlist
Number

Offsite Conversion: Add to Wishlist - The number of times products were added to wishlist via the Facebook pixel.

actions__offsite_conversion__fb_pixel_complete_registration
Number

Offsite Conversion: Complete Registration - The number of completed registrations via the Facebook pixel.

actions__offsite_conversion__fb_pixel_custom
Number

Offsite Conversion: Custom - The number of custom conversions defined by the advertiser via the Facebook pixel.

actions__offsite_conversion__fb_pixel_initiate_checkout
Number

Offsite Conversion: Initiate Checkout - The number of initiated checkouts via the Facebook pixel.

actions__offsite_conversion__fb_pixel_lead
Number

Offsite Conversion: Lead - The number of leads generated via the Facebook pixel.

actions__offsite_conversion__fb_pixel_purchase
Number

Offsite Conversion: Purchase - The number of purchases made via the Facebook pixel.

actions__offsite_conversion__fb_pixel_search
Number

Offsite Conversion: Search - The number of searches made via the Facebook pixel.

actions__offsite_conversion__fb_pixel_view_content
Number

Offsite Conversion: View Content - The number of content views via the Facebook pixel.

actions__onsite_conversion__flow_complete
Number

Onsite Conversion: Flow Complete - The number of completed on-Facebook workflows.

actions__onsite_conversion__messaging_block
Number

Onsite Conversion: Messaging Block - The number of blocked messaging conversations on Facebook.

actions__onsite_conversion__messaging_conversation_started_7d
Number

Onsite Conversion: Messaging Conversation Started (7d) - The number of messaging conversations started on Facebook in the last 7 days.

actions__onsite_conversion__messaging_first_reply
Number

Onsite Conversion: Messaging First Reply - The number of new messaging conversations started on Facebook.

actions__onsite_conversion__messaging_user_subscribed
Number

Onsite Conversion: Messaging User Subscribed - The number of messaging subscriptions on Facebook.

actions__onsite_conversion__post_save
Number

Onsite Conversion: Post Save - The number of times posts were saved on Facebook.

actions__onsite_conversion__purchase
Number

Onsite Conversion: Purchase - The number of purchases made on Facebook.

actions__outbound_click
Number

Outbound Clicks - The number of outbound clicks.

actions__photo_view
Number

Photo Views - The number of page photo views.

actions__post
Number

Post Shares - The number of post shares.

actions__post_reaction
Number

Post Reactions - The number of post reactions.

actions__rsvp
Number

Event Responses - Number of RSVPs to events.

actions__contact_total
Number

Contacts (Total) - Total number of contacts across all platforms.

actions__contact_website
Number

Contacts (Website) - Number of contacts made through the website.

actions__contact_mobile_app
Number

Contacts (Mobile App) - Number of contacts made through the mobile app.

actions__contact_offline
Number

Contacts (Offline) - Number of offline contacts.

actions__customize_product_total
Number

Customize Product (Total) - Total number of product customizations.

actions__customize_product_website
Number

Customize Product (Website) - Number of product customizations on the website.

actions__customize_product_mobile_app
Number

Customize Product (Mobile App) - Number of product customizations on the mobile app.

actions__customize_product_offline
Number

Customize Product (Offline) - Number of offline product customizations.

actions__donate_total
Number

Donations (Total) - Total number of donations.

actions__donate_website
Number

Donations (Website) - Number of donations through the website.

actions__donate_on_facebook
Number

Donations (On Facebook) - Number of donations made on Facebook.

actions__donate_mobile_app
Number

Donations (Mobile App) - Number of donations through the mobile app.

actions__donate_offline
Number

Donations (Offline) - Number of offline donations.

actions__find_location_total
Number

Find Location (Total) - Total number of location searches.

actions__find_location_website
Number

Find Location (Website) - Number of location searches on the website.

actions__find_location_mobile_app
Number

Find Location (Mobile App) - Number of location searches on the mobile app.

actions__find_location_offline
Number

Find Location (Offline) - Number of offline location searches.

actions__schedule_total
Number

Appointments Scheduled (Total) - Total number of appointments scheduled.

actions__schedule_website
Number

Appointments Scheduled (Website) - Number of appointments scheduled through the website.

actions__schedule_mobile_app
Number

Appointments Scheduled (Mobile App) - Number of appointments scheduled through the mobile app.

actions__schedule_offline
Number

Appointments Scheduled (Offline) - Number of offline appointments scheduled.

actions__start_trial_total
Number

Trials Started (Total) - Total number of trials started.

actions__start_trial_website
Number

Trials Started (Website) - Number of trials started on the website.

actions__start_trial_mobile_app
Number

Trials Started (Mobile App) - Number of trials started on the mobile app.

actions__start_trial_offline
Number

Trials Started (Offline) - Number of offline trials started.

actions__submit_application_total
Number

Applications Submitted (Total) - Total number of applications submitted.

actions__submit_application_website
Number

Applications Submitted (Website) - Number of applications submitted through the website.

actions__submit_application_mobile_app
Number

Applications Submitted (Mobile App) - Number of applications submitted through the mobile app.

actions__submit_application_offline
Number

Applications Submitted (Offline) - Number of offline applications submitted.

actions__submit_application_on_facebook
Number

Applications Submitted (On Facebook) - Number of applications submitted through Facebook.

actions__subscribe_total
Number

Subscriptions (Total) - Total number of subscriptions.

actions__subscribe_website
Number

Subscriptions (Website) - Number of subscriptions through the website.

actions__subscribe_mobile_app
Number

Subscriptions (Mobile App) - Number of subscriptions through the mobile app.

actions__subscribe_offline
Number

Subscriptions (Offline) - Number of offline subscriptions.

actions__recurring_subscription_payment_total
Number

Recurring Subscription Payments (Total) - Total number of recurring subscription payments.

actions__recurring_subscription_payment_website
Number

Recurring Subscription Payments (Website) - Number of recurring subscription payments through the website.

actions__recurring_subscription_payment_mobile_app
Number

Recurring Subscription Payments (Mobile App) - Number of recurring subscription payments through the mobile app.

actions__recurring_subscription_payment_offline
Number

Recurring Subscription Payments (Offline) - Number of offline recurring subscription payments.

actions__cancel_subscription_total
Number

Canceled Subscriptions (Total) - Total number of canceled subscriptions.

actions__cancel_subscription_website
Number

Canceled Subscriptions (Website) - Number of canceled subscriptions through the website.

actions__cancel_subscription_mobile_app
Number

Canceled Subscriptions (Mobile App) - Number of canceled subscriptions through the mobile app.

actions__cancel_subscription_offline
Number

Canceled Subscriptions (Offline) - Number of offline canceled subscriptions.

actions__ad_click_mobile_app
Number

Ad Click (Mobile App) - The number of clicks on ads within a mobile app.

actions__ad_impression_mobile_app
Number

Ad Impression (Mobile App) - The number of times ads were displayed within a mobile app.

actions__click_to_call_call_confirm
Number

Click-to-Call: Call Confirm - Estimated number of call confirmation clicks. This signifies someone clicking to confirm initiating a call.

actions__click_to_call_native_call_placed
Number

Click-to-Call: Calls Placed - Number of calls placed via click-to-call.

actions__click_to_call_native_20s_call_connect
Number

Click-to-Call: 20s Calls Placed - Number of calls placed via click-to-call that lasted for at least 20 seconds.

actions__click_to_call_native_60s_call_connect
Number

Click-to-Call: 60s Calls Placed - Number of calls placed via click-to-call that lasted for at least 60 seconds.

actions__page_engagement
Number

Page Engagement - Number of actions people take involving your Page or content on it.

actions__post_engagement
Number

Post Engagement - Number of actions people take involving your posts or content on them.

actions__onsite_conversion__lead_grouped
Number

On-Facebook Leads - The total number of leads generated on Facebook, including those from Messenger and Instant Forms.

actions__lead
Number

Leads (All) - The total number of leads from both on-Facebook and off-Facebook sources.

actions__leadgen_grouped
Number

On-Facebook Leads (Messenger & Instant Forms) - The number of on-Facebook leads specifically coming from Messenger and Instant Forms.

actions__omni_app_install
Number

Omni-App Installs - Total app installs across all platforms.

actions__omni_purchase
Number

Omni-Purchases - Total purchases across platforms (on and off Facebook).

actions__omni_add_to_cart
Number

Omni-Add to Cart - Total "add to cart" events across platforms.

actions__omni_complete_registration
Number

Omni-Complete Registration - Total completed registrations across platforms.

actions__omni_view_content
Number

Omni-View Content - Total content views across platforms.

actions__omni_search
Number

Omni-Search - Total searches across platforms.

actions__omni_initiated_checkout
Number

Omni-Initiated Checkout - Total initiated checkouts across platforms.

actions__omni_achievement_unlocked
Number

Omni-Achievement Unlocked - Total achievements unlocked across platforms.

actions__omni_activate_app
Number

Omni-Activate App - Total app activations across platforms.

actions__omni_level_achieved
Number

Omni-Level Achieved - Total levels achieved across platforms.

actions__omni_rate
Number

Omni-Rate - Total ratings submitted across platforms.

actions__omni_spend_credits
Number

Omni-Spend Credits - Total credits spent across platforms.

actions__omni_tutorial_completion
Number

Omni-Tutorial Completion - Total tutorials completed across platforms.

actions__omni_custom
Number

Omni-Custom - Total custom events across platforms.

action_values__offsite_conversion__fb_pixel_add_payment_info
Number

Value of Offsite Conversion: Add Payment Info - Total value associated with adding payment info via Facebook pixel.

action_values__offsite_conversion__fb_pixel_add_to_cart
Number

Value of Offsite Conversion: Add to Cart - Total value associated with adding items to cart via Facebook pixel.

action_values__offsite_conversion__fb_pixel_add_to_wishlist
Number

Value of Offsite Conversion: Add to Wishlist - Total value associated with adding to wishlist via Facebook pixel.

action_values__offsite_conversion__fb_pixel_complete_registration
Number

Value of Offsite Conversion: Complete Registration - Total value associated with completing registration via Facebook pixel.

action_values__offsite_conversion__fb_pixel_custom
Number

Value of Offsite Conversion: Custom - Total value associated with custom conversions via Facebook pixel.

action_values__offsite_conversion__fb_pixel_initiate_checkout
Number

Value of Offsite Conversion: Initiate Checkout - Total value associated with initiating checkout via Facebook pixel.

action_values__offsite_conversion__fb_pixel_lead
Number

Value of Offsite Conversion: Lead - Total value associated with leads generated via Facebook pixel.

action_values__offsite_conversion__fb_pixel_purchase
Number

Value of Offsite Conversion: Purchase - Total value associated with purchases via Facebook pixel.

action_values__offsite_conversion__fb_pixel_search
Number

Value of Offsite Conversion: Search - Total value associated with searches via Facebook pixel.

action_values__offsite_conversion__fb_pixel_view_content
Number

Value of Offsite Conversion: View Content - Total value associated with content views via Facebook pixel.

action_values__games__plays
Number

Value of Game Plays - Total value attributed to game plays.

action_values__app_custom_event__fb_mobile_achievement_unlocked
Number

Value of App Custom Event: Achievement Unlocked - Total value attributed to mobile app achievements unlocked.

action_values__app_custom_event__fb_mobile_activate_app
Number

Value of App Custom Event: Activate App - Total value attributed to mobile app activations.

action_values__app_custom_event__fb_mobile_add_payment_info
Number

Value of App Custom Event: Add Payment Info - Total value attributed to adding payment info in mobile app.

action_values__app_custom_event__fb_mobile_add_to_cart
Number

Value of App Custom Event: Add to Cart - Total value attributed to adding to cart in mobile app.

action_values__app_custom_event__fb_mobile_add_to_wishlist
Number

Value of App Custom Event: Add to Wishlist - Total value attributed to adding to wishlist in mobile app.

action_values__app_custom_event__fb_mobile_complete_registration
Number

Value of App Custom Event: Complete Registration - Total value attributed to completing registration in mobile app.

action_values__app_custom_event__fb_mobile_content_view
Number

Value of App Custom Event: Content View - Total value attributed to content views in mobile app.

action_values__app_custom_event__fb_mobile_initiated_checkout
Number

Value of App Custom Event: Initiated Checkout - Total value attributed to initiating checkout in mobile app.

action_values__app_custom_event__fb_mobile_level_achieved
Number

Value of App Custom Event: Level Achieved - Total value attributed to achieving levels in mobile app.

action_values__app_custom_event__fb_mobile_purchase
Number

Value of App Custom Event: Purchase - Total value attributed to purchases in mobile app.

action_values__app_custom_event__fb_mobile_rate
Number

Value of App Custom Event: Rate - Total value attributed to rating the mobile app.

action_values__app_custom_event__fb_mobile_search
Number

Value of App Custom Event: Search - Total value attributed to searches in mobile app.

action_values__app_custom_event__fb_mobile_spent_credits
Number

Value of App Custom Event: Spent Credits - Total value attributed to spending credits in mobile app.

action_values__app_custom_event__fb_mobile_tutorial_completion
Number

Value of App Custom Event: Tutorial Completion - Total value attributed to completing tutorials in mobile app.

action_values__app_custom_event__other
Number

Value of App Custom Event: Other - Total value attributed to other actions in mobile app.

action_values__app_install
Number

Value of App Installs - Total value attributed to app installs.

action_values__app_use
Number

Value of App Uses - Total value attributed to app usage.

action_values__mobile_app_install
Number

Value of Mobile App Installs - Total value attributed to mobile app installs.

action_values__contact_total
Number

Value of Contacts (Total) - Total value attributed to all contact methods.

action_values__contact_website
Number

Value of Contacts (Website) - Value attributed to contacts made through the website.

action_values__contact_mobile_app
Number

Value of Contacts (Mobile App) - Value attributed to contacts made through the mobile app.

action_values__contact_offline
Number

Value of Contacts (Offline) - Value attributed to offline contacts.

action_values__customize_product_total
Number

Value of Product Customizations (Total) - Total value attributed to product customizations across all methods.

action_values__customize_product_website
Number

Value of Product Customizations (Website) - Value attributed to product customizations on the website.

action_values__customize_product_mobile_app
Number

Value of Product Customizations (Mobile App) - Value attributed to product customizations on the mobile app.

action_values__customize_product_offline
Number

Value of Product Customizations (Offline) - Value attributed to offline product customizations.

action_values__donate_total
Number

Value of Donations (Total) - Total value of donations across all methods.

action_values__donate_website
Number

Value of Donations (Website) - Value of donations made through the website.

action_values__donate_on_facebook
Number

Value of Donations (On Facebook) - Value of donations made on Facebook.

action_values__donate_mobile_app
Number

Value of Donations (Mobile App) - Value of donations made through the mobile app.

action_values__donate_offline
Number

Value of Donations (Offline) - Value of offline donations.

action_values__find_location_total
Number

Value of Find Location (Total) - Total value attributed to finding a location across all methods.

action_values__find_location_website
Number

Value of Find Location (Website) - Value attributed to location searches on the website.

action_values__find_location_mobile_app
Number

Value of Find Location (Mobile App) - Value attributed to location searches on the mobile app.

action_values__find_location_offline
Number

Value of Find Location (Offline) - Value attributed to offline location searches.

action_values__schedule_total
Number

Value of Schedule (Total) - Total value attributed to scheduled appointments across all methods.

action_values__schedule_website
Number

Value of Schedule (Website) - Value attributed to scheduling appointments on the website.

action_values__schedule_mobile_app
Number

Value of Schedule (Mobile App) - Value attributed to scheduling appointments on the mobile app.

action_values__schedule_offline
Number

Value of Schedule (Offline) - Value attributed to scheduling appointments offline.

action_values__start_trial_total
Number

Value of Start Trial (Total) - Total value attributed to starting trials across all methods.

action_values__start_trial_website
Number

Value of Start Trial (Website) - Value attributed to starting trials on the website.

action_values__start_trial_mobile_app
Number

Value of Start Trial (Mobile App) - Value attributed to starting trials on the mobile app.

action_values__start_trial_offline
Number

Value of Start Trial (Offline) - Value attributed to starting trials offline.

action_values__submit_application_total
Number

Value of Submit Application (Total) - Total value attributed to submitting applications across all methods.

action_values__submit_application_website
Number

Value of Submit Application (Website) - Value attributed to submitting applications on the website.

action_values__submit_application_mobile_app
Number

Value of Submit Application (Mobile App) - Value attributed to submitting applications on the mobile app.

action_values__submit_application_offline
Number

Value of Submit Application (Offline) - Value attributed to submitting applications offline.

action_values__submit_application_on_facebook
Number

Value of Submit Application (On Facebook) - Value attributed to submitting applications on Facebook.

action_values__subscribe_total
Number

Value of Subscribe (Total) - Total value attributed to subscriptions across all methods.

action_values__subscribe_website
Number

Value of Subscribe (Website) - Value attributed to subscribing on the website.

action_values__subscribe_mobile_app
Number

Value of Subscribe (Mobile App) - Value attributed to subscribing on the mobile app.

action_values__subscribe_offline
Number

Value of Subscribe (Offline) - Value attributed to offline subscriptions.

action_values__recurring_subscription_payment_total
Number

Value of Recurring Subscription Payment (Total) - Total value attributed to recurring subscription payments across all methods.

action_values__recurring_subscription_payment_website
Number

Value of Recurring Subscription Payment (Website) - Value attributed to recurring subscription payments on the website.

action_values__recurring_subscription_payment_mobile_app
Number

Value of Recurring Subscription Payment (Mobile App) - Value attributed to recurring subscription payments on the mobile app.

action_values__recurring_subscription_payment_offline
Number

Value of Recurring Subscription Payment (Offline) - Value attributed to offline recurring subscription payments.

action_values__cancel_subscription_total
Number

Value of Canceled Subscription (Total) - Total value attributed to canceled subscriptions across all methods.

action_values__cancel_subscription_website
Number

Value of Canceled Subscription (Website) - Value attributed to canceling subscriptions on the website.

action_values__cancel_subscription_mobile_app
Number

Value of Canceled Subscription (Mobile App) - Value attributed to canceling subscriptions on the mobile app.

action_values__cancel_subscription_offline
Number

Value of Canceled Subscription (Offline) - Value attributed to canceling subscriptions offline.

action_values__ad_click_mobile_app
Number

Value of Ad Click (Mobile App) - Total value attributed to clicks on in-app ads.

action_values__ad_impression_mobile_app
Number

Value of Ad Impression (Mobile App) - Total value attributed to impressions of in-app ads.

action_values__omni_app_install
Number

Value of Omni-App Installs - Total value associated with app installs across all platforms.

action_values__omni_purchase
Number

Value of Omni-Purchases - Total value associated with purchases across all platforms.

action_values__omni_add_to_cart
Number

Value of Omni-Add to Cart - Total value associated with adding to cart across all platforms.

action_values__omni_complete_registration
Number

Value of Omni-Complete Registration - Total value associated with completing registrations across all platforms.

action_values__omni_view_content
Number

Value of Omni-View Content - Total value associated with content views across all platforms.

action_values__omni_search
Number

Value of Omni-Search - Total value associated with searches across all platforms.

action_values__omni_initiated_checkout
Number

Value of Omni-Initiated Checkout - Total value associated with initiated checkouts across all platforms.

action_values__omni_achievement_unlocked
Number

Value of Omni-Achievement Unlocked - Total value associated with achievements unlocked across all platforms.

action_values__omni_activate_app
Number

Value of Omni-Activate App - Total value associated with activating the app across all platforms.

action_values__omni_level_achieved
Number

Value of Omni-Level Achieved - Total value associated with levels achieved across all platforms.

action_values__omni_rate
Number

Value of Omni-Rate - Total value associated with ratings submitted across all platforms.

action_values__omni_spend_credits
Number

Value of Omni-Spend Credits - Total value associated with credits spent across all platforms.

action_values__omni_tutorial_completion
Number

Value of Omni-Tutorial Completion - Total value associated with tutorials completed across all platforms.

action_values__omni_custom
Number

Value of Omni-Custom - Total value associated with custom events across all platforms.

unique_actions__app_custom_event__fb_mobile_achievement_unlocked
Number

Unique App Custom Event: Achievement Unlocked - Number of people who unlocked achievements in the mobile app.

unique_actions__app_custom_event__fb_mobile_activate_app
Number

Unique App Custom Event: Activate App - Number of people who activated/opened the mobile app.

unique_actions__app_custom_event__fb_mobile_add_payment_info
Number

Unique App Custom Event: Add Payment Info - Number of people who added payment info in the mobile app.

unique_actions__app_custom_event__fb_mobile_add_to_cart
Number

Unique App Custom Event: Add to Cart - Number of people who added items to their cart in the mobile app.

unique_actions__app_custom_event__fb_mobile_add_to_wishlist
Number

Unique App Custom Event: Add to Wishlist - Number of people who added items to a wishlist in the mobile app.

unique_actions__app_custom_event__fb_mobile_complete_registration
Number

Unique App Custom Event: Complete Registration - Number of people who completed registration in the mobile app.

unique_actions__app_custom_event__fb_mobile_content_view
Number

Unique App Custom Event: Content View - Number of people who viewed content in the mobile app.

unique_actions__app_custom_event__fb_mobile_initiated_checkout
Number

Unique App Custom Event: Initiated Checkout - Number of people who initiated checkout in the mobile app.

unique_actions__app_custom_event__fb_mobile_level_achieved
Number

Unique App Custom Event: Level Achieved - Number of people who achieved a level in the mobile app.

unique_actions__app_custom_event__fb_mobile_purchase
Number

Unique App Custom Event: Purchase - Number of people who made a purchase in the mobile app.

unique_actions__app_custom_event__fb_mobile_rate
Number

Unique App Custom Event: Rate - Number of people who rated the mobile app.

unique_actions__app_custom_event__fb_mobile_search
Number

Unique App Custom Event: Search - Number of people who performed a search in the mobile app.

unique_actions__app_custom_event__fb_mobile_spent_credits
Number

Unique App Custom Event: Spent Credits - Number of people who spent credits in the mobile app.

unique_actions__app_custom_event__fb_mobile_tutorial_completion
Number

Unique App Custom Event: Tutorial Completion - Number of people who completed a tutorial in the mobile app.

unique_actions__app_custom_event__other
Number

Unique App Custom Event: Other - Number of people who triggered other custom events in the mobile app.

unique_actions__app_install
Number

Unique App Installs - Number of people who installed the app.

unique_actions__app_use
Number

Unique App Uses - Number of people who used the app.

unique_actions__checkin
Number

Unique Checkins - Number of people who checked in.

unique_actions__comment
Number

Unique Comments - Number of people who commented.

unique_actions__credit_spent
Number

Unique Credit Spends - Number of people who spent credits.

unique_actions__games__plays
Number

Unique Game Plays - Number of people who played the game.

unique_actions__landing_page_view
Number

Unique Landing Page Views - Number of people who viewed the landing page.

unique_actions__like
Number

Unique Likes - Number of people who liked the page or post.

unique_actions__link_click
Number

Unique Link Clicks - Number of people who clicked on a link.

unique_actions__mobile_app_install
Number

Unique Mobile App Installs - Number of people who installed the mobile app.

unique_actions__offsite_conversion__fb_pixel_add_payment_info
Number

Unique Offsite Conversion: Add Payment Info - Number of people who added payment information on the website.

unique_actions__offsite_conversion__fb_pixel_add_to_cart
Number

Unique Offsite Conversion: Add to Cart - Number of people who added items to their cart on the website.

unique_actions__offsite_conversion__fb_pixel_add_to_wishlist
Number

Unique Offsite Conversion: Add to Wishlist - Number of people who added items to a wishlist on the website.

unique_actions__offsite_conversion__fb_pixel_complete_registration
Number

Unique Offsite Conversion: Complete Registration - Number of people who completed registration on the website.

unique_actions__offsite_conversion__fb_pixel_custom
Number

Unique Offsite Conversion: Custom - Number of people who triggered a custom conversion event on the website.

unique_actions__offsite_conversion__fb_pixel_initiate_checkout
Number

Unique Offsite Conversion: Initiate Checkout - Number of people who initiated checkout on the website.

unique_actions__offsite_conversion__fb_pixel_lead
Number

Unique Offsite Conversion: Lead - Number of people who submitted a lead form on the website.

unique_actions__offsite_conversion__fb_pixel_purchase
Number

Unique Offsite Conversion: Purchase - Number of people who made a purchase on the website.

unique_actions__offsite_conversion__fb_pixel_search
Number

Unique Offsite Conversion: Search - Number of people who performed a search on the website.

unique_actions__offsite_conversion__fb_pixel_view_content
Number

Unique Offsite Conversion: View Content - Number of people who viewed content on the website.

unique_actions__onsite_conversion__flow_complete
Number

Unique Onsite Conversion: Flow Complete - Number of people who completed a lead form flow on Facebook.

unique_actions__onsite_conversion__messaging_block
Number

Unique Onsite Conversion: Messaging Block - Number of people who blocked messaging conversations.

unique_actions__onsite_conversion__messaging_conversation_started_7d
Number

Unique Onsite Conversion: Messaging Conversation Started (7d) - Number of people who started a messaging conversation in the last 7 days.

unique_actions__onsite_conversion__messaging_first_reply
Number

Unique Onsite Conversion: Messaging First Reply - Number of people who sent their first reply in a messaging conversation.

unique_actions__onsite_conversion__messaging_user_subscribed
Number

Unique Onsite Conversion: Messaging User Subscribed - Number of people who subscribed to messaging updates.

unique_actions__onsite_conversion__post_save
Number

Unique Onsite Conversion: Post Save - Number of people who saved a post.

unique_actions__onsite_conversion__purchase
Number

Unique Onsite Conversion: Purchase - Number of people who made a purchase on Facebook.

unique_actions__outbound_click
Number

Unique Outbound Clicks - Number of people who clicked on a link leading outside of Facebook.

unique_actions__photo_view
Number

Unique Photo Views - Number of people who viewed a photo.

unique_actions__post
Number

Unique Post Shares - Number of people who shared a post.

unique_actions__post_reaction
Number

Unique Post Reactions - Number of people who reacted to a post.

unique_actions__rsvp
Number

Unique Event Responses - Number of people who responded to an event.

unique_actions__video_view
Number

Unique 3-Second Video Views - Number of people who viewed a video for at least 3 seconds.

Creative Table

account_id
Text

Account ID - The ID of the ad account.

account_name
Text

Account Name - The name of the ad account.

ad_id
Text

Ad ID - The ID of the ad.

creative_id
Text

Creative ID - Unique ID for an ad creative.

actor_id
Text

Actor ID - The ID of the Page or User who owns the ad creative.

applink_treatment
Text

App Link Treatment - Defines the action taken when a user clicks an ad but doesn't have the app installed.

asset_feed_spec
Text

Asset Feed Spec - Specifies an asset feed for Dynamic Creative.

authorization_category
Text

Authorization Category - Specifies whether the ad is labeled as political.

body
Text

Body - The main text content of the ad.

branded_content
Text

Branded Content - Data related to branded content ads.

bundle_folder_id
Text

Bundle Folder ID - The ID of the Dynamic Ad's bundle folder.

call_to_action_type
Text

Call To Action Type - The type of call-to-action button.

categorization_criteria
Text

Categorization Criteria - The categorization field for Dynamic Category Ads.

category_media_source
Text

Category Media Source - The rendering mode for Dynamic Category Ads.

collaborative_ads_lsb_image_bank_id
Text

Collaborative Ads LSB Image Bank ID - Image bank ID for CPAS local delivery.

degrees_of_freedom_spec
Text

Degrees of Freedom Spec - Specifies the allowed transformations for the creative.

destination_set_id
Text

Destination Set ID - The ID of the Product Set for a Destination Catalog.

dynamic_ad_voice
Text

Dynamic Ad Voice - Controls the voice of the ad for Store Traffic Objective in Dynamic Ads.

effective_authorization_category
Text

Effective Authorization Category - System-determined political ad status.

effective_instagram_media_id
Text

Effective Instagram Media ID - The ID of the Instagram post used in the ad.

effective_instagram_story_id
Text

Effective Instagram Story ID - The ID of the Instagram Story used in the ad.

effective_object_story_id
Text

Effective Object Story ID - The ID of the Page post used in the ad.

enable_direct_install
Text

Enable Direct Install - Whether Direct Install is enabled.

enable_launch_instant_app
Text

Enable Launch Instant App - Whether Instant App is enabled.

facebook_branded_content__sponsor_id
Text

Facebook Branded Content Sponsor ID - The ID of the sponsor page for Facebook Branded Content.

image_crops
Text

Image Crops - Crop dimensions for the ad image.

image_hash
Text

Image Hash - Image hash for the ad creative.

image_url
Text

Image URL - URL of the image for the creative.

instagram_actor_id
Text

Instagram Actor ID - The Instagram account ID used for running ads.

instagram_branded_content__sponsor_id
Text

Instagram Branded Content Sponsor ID - ID of the sponsor for Instagram Branded Content.

instagram_permalink_url
Text

Instagram Permalink URL - URL of the Instagram post to use as an ad.

instagram_story_id
Text

Instagram Story ID - The ID of the Instagram Story to use as an ad (deprecated).

instagram_user_id
Text

Instagram User ID - The ID of the Instagram user.

link_destination_display_url
Text

Link Destination Display URL - Overrides the display URL for link ads.

link_og_id
Text

Link OG ID - The Open Graph ID for the link.

link_url
Text

Link URL - URL of the landing page for the ad.

name
Text

Name - Name of the ad creative.

object_id
Text

Object ID - ID of the Facebook object being promoted.

object_store_url
Text

Object Store URL - iTunes or Google Play URL for app ads.

object_story_id
Text

Object Story ID - ID of a Facebook Page post used in the ad.

object_type
Text

Object Type - Type of Facebook object being advertised.

object_url
Text

Object URL - URL that opens when the ad is clicked.

page_welcome_message
Text

Page Welcome Message - Welcome message for Click-to-Messenger ads.

photo_album_source_object_story_id
Text

Photo Album Source Object Story ID - ID of the source story for photo album ads.

place_page_set_id
Text

Place Page Set ID - ID of the page set for the creative.

playable_asset_id
Text

Playable Asset ID - The ID of the playable asset.

portrait_customizations
Text

Portrait Customizations - Rendering customizations for portrait mode ads.

product_set_id
Text

Product Set ID - ID of the product set for Dynamic Ads.

recommender_settings
Text

Recommender Settings - Settings for product recommendations in Dynamic Ads.

referral_id
Text

Referral ID - ID of the Referral Ad Configuration.

source_instagram_media_id
Text

Source Instagram Media ID - ID of the Instagram post for creating ads.

status
Text

Status - The status of the creative.

template_url
Text

Template URL - URL of the template for Dynamic Ads with third-party click tracking.

thumbnail_id
Text

Thumbnail ID - ID of the thumbnail image.

thumbnail_url
Text

Thumbnail URL - URL of the thumbnail image.

title
Text

Title - Title of the ad.

url_tags
Text

URL Tags - Query Text parameters appended to URLs clicked from certain ad types.

use_page_actor_override
Text

Use Page Actor Override - Whether to display the Facebook Page associated with app ads.

video_id
Text

Video ID - Facebook object ID for the video in the ad creative.