Facebook Ads data model: ads, creatives and insights at three levels
Facebook Ads ads, creatives and daily insights as tables, with each number traced to the table it adds up in: spend and clicks across ads and days, reach from the ad set and campaign tables.
- Open source. OWOX Data Marts is open source: you can read the code that loads and models your data, and run it yourself.
- You own the data. Facebook Ads tables load into your data warehouse, under your account. If you leave OWOX, they stay where they are.
- MCP-ready. Once the data is in, Claude or ChatGPT can work from your Data Marts through OWOX MCP.
Don't wire up Facebook Ads by hand. Have your AI assistant load it into your data warehouse.
Your assistant sets up the Facebook Ads connector with you and loads the tables you pick; OWOX keeps them in your data warehouse, ready to use.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /data-sources/facebook-ads.md. The task: set up the Facebook Ads connector in OWOX Data Marts, let me pick the tables I need, load them into my data warehouse and show me the first rows. Tag the links you give me with utm_campaign=ai-task and utm_term=data-source. Use what you know about my context and goals
Prefer to start on your own? Get started free
The Facebook Ads data model
Facebook Ads nests campaigns, ad sets and ads, and every ad runs a creative.
- The tables here cover the ads and what they run.
- Ads, Ad and Ad Creatives hold settings as of the last load, Ad Account holds the account itself, and Ad Insights holds one row per ad per day.
- Sibling tables cut the same ad-day by one thing each: age and gender, country, region, device platform, publisher platform and position, product ID, or link URL asset.
- Ad Insights by Ad Set and Ad Insights by Campaign are requested from Meta at their own level, so their reach counts each person once per day for the whole ad set or campaign.
- Campaign and ad set IDs travel as columns on the ads and on the insights rows, and the insights rows carry the names too, so you reach a campaign by grouping on those columns.
- An insights row finds its ad through
ad_id, and the ad finds its creative throughcreative_id. - People are what reach, frequency and the
unique_columns count, so a sum across ads, days or splits counts the same person twice.
How the tables join (18)
Ad joins to Adson
id1:1 (one to one)The same ad, read through Meta's ad reference; both tables list the ads of the account.
Ad Account User joins to Ad Accounton
id1:1 (one to one)As the connector requests it, this row is the account itself.
Ad Account User schemaAd Account schema
Fields of Ad Account User as the connector defines them (GitHub)
Ad Creatives joins to Ad Accounton
account_idN:1 (many to one)The account whose library holds the creative.
Ad Creatives schemaAd Account schema
Fields of Ad Creatives as the connector defines them (GitHub)
Ad Insights joins to Adson
ad_id = idN:1 (many to one)The ad the daily row reports on; one ad has many daily rows.
Fields of Ad Insights as the connector defines them (GitHub)
Ad Insights joins to Ad Insights by Ad Seton
adset_id,date_start,date_stopN:1 (many to one)The ad set's day that the ad's day rolls up into; counts of people do not add up across the two.
Ad Insights joins to Ad Accounton
account_idN:1 (many to one)The account the spend was charged to.
Ad Insights by Ad Set joins to Ad Insights by Campaignon
campaign_id,date_start,date_stopN:1 (many to one)The campaign's day that the ad set's day rolls up into; counts of people do not add up across the two.
Ad Insights by Ad Set schemaAd Insights by Campaign schema
Fields of Ad Insights by Ad Set as the connector defines them (GitHub)
Ad Insights by Ad Set joins to Ad Accounton
account_idN:1 (many to one)The account the ad set belongs to.
Ad Insights by Age and Gender joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Age and Gender schemaAd Insights schema
Fields of Ad Insights by Age and Gender as the connector defines them (GitHub)
Ad Insights by Campaign joins to Ad Accounton
account_idN:1 (many to one)The account the campaign belongs to.
Ad Insights by Campaign schemaAd Account schema
Fields of Ad Insights by Campaign as the connector defines them (GitHub)
Ad Insights by Country joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Country schemaAd Insights schema
Fields of Ad Insights by Country as the connector defines them (GitHub)
Ad Insights by Device Platform joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Device Platform schemaAd Insights schema
Fields of Ad Insights by Device Platform as the connector defines them (GitHub)
Ad Insights by Link URL Asset joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Link URL Asset schemaAd Insights schema
Fields of Ad Insights by Link URL Asset as the connector defines them (GitHub)
Ad Insights by Product ID joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Product ID schemaAd Insights schema
Fields of Ad Insights by Product ID as the connector defines them (GitHub)
Ad Insights by Publisher Platform and Position joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Publisher Platform and Position schemaAd Insights schema
Fields of Ad Insights by Publisher Platform and Position as the connector defines them (GitHub)
Ad Insights by Region joins to Ad Insightson
ad_id,date_start,date_stopN:1 (many to one)The ad's day that this row splits into parts; one ad-day has several rows here.
Ad Insights by Region schemaAd Insights schema
Fields of Ad Insights by Region as the connector defines them (GitHub)
Ads joins to Ad Creativeson
creative_id = idN:1 (many to one)The creative the ad runs as of the last load; one creative can serve several ads.
Ads joins to Ad Accounton
account_idN:1 (many to one)The account the ad belongs to.
The tables fit in your warehouse as they are, and import as Data Marts with the ad_id and creative_id joins already drawn.
OWOX for Facebook Ads data: reach counted at the level you report on
Add up the reach of every ad in a campaign and the same person is counted many times. OWOX asks Meta for ad set and campaign insights as tables of their own, so each level carries its own count of people for each day next to the ad-level rows. They load into Google BigQuery, Snowflake, AWS Redshift, AWS Athena or Databricks, whichever warehouse you run.
- A table for each level. Ad, ad set and campaign insights land side by side, so a campaign's reach on a given day is Meta's figure for the campaign, not a sum of its ads. No table holds people reached over several days.
- Splits as tables of their own. Age and gender, country, region, device, placement and product each get a table cut from the same ad and day. The link URL split is keyed by ad and day only, so check that it keeps one row per link before you rely on it.
- The creative an ad runs, one join away. Ads carry creative_id and Ad Creatives hold the copy, call to action and destination link, so you can ask which creative buys the cheapest conversions. Both tables are as of the last load: an ad's creative is the one it runs today.
- Account settings, matched on the bare number. Ad Account lists both an act_-prefixed id and a plain account_id, and every ads, creatives and insights table carries the plain number, so match on account_id.
Facebook Ads Endpoints
15 Facebook Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad
Individual ads with their creative, status, and links to their campaign and ad set.
32 fieldsAd Account
Your ad account settings, status, currency, and billing details.
61 fieldsAd Account User
Users with access to an ad account and their assigned roles.
2 fieldsAd Creatives
The images, videos, text, and other visual elements used in your ads.
65 fieldsAd Insights
Daily performance metrics for each ad — impressions, clicks, spend, and conversions.
100 fieldsTime seriesAd Insights by Ad Set
Daily ad set performance with reach deduplicated to match Meta Ads Manager.
92 fieldsTime seriesAd Insights by Age and Gender
Daily ad performance broken down by audience age range and gender.
102 fieldsTime seriesAd Insights by Campaign
Daily campaign performance with reach deduplicated to match Meta Ads Manager.
89 fieldsTime seriesAd Insights by Country
Daily ad performance broken down by the country where your audience is located.
101 fieldsTime seriesAd Insights by Device Platform
Daily ad performance broken down by the device type your audience used.
101 fieldsTime seriesAd Insights by Link URL Asset
Daily ad performance broken down by the link URL shown in your ads.
101 fieldsTime seriesAd Insights by Product ID
Daily ad performance broken down by individual product from your catalog.
101 fieldsTime seriesAd Insights by Publisher Platform and Position
Daily ad performance broken down by where your ads appeared — platform and placement position.
102 fieldsTime seriesAd Insights by Region
Daily ad performance broken down by the region where your audience is located.
101 fieldsTime seriesAds
Individual ads with their status, creative, and campaign hierarchy.
24 fields
Facebook Ads Ad schema
32 fieldsSchema on GitHubfacebook_ads_ad_group
Individual ads with their creative, status, and links to their campaign and ad set.
Questions this table answers
- Which ads were copied from another ad (
source_ad_idis set)? - Which ads have review feedback or delivery issues?
- Which ads have an end time scheduled?
| Field | Type | Description |
|---|---|---|
idPK | STRING | The ID of this ad. |
account_id | STRING | The ID of the ad account that this ad belongs to. |
ad_active_time | STRING | The time from when the ad was recently active |
ad_review_feedback | OBJECT | The review feedback for this ad after it is reviewed. |
ad_schedule_end_time | DATETIME | An optional parameter that defines the end time of an individual ad. If no end time is defined, the ad will run on the campaign’s schedule. |
ad_schedule_start_time | DATETIME | An optional parameter that defines the start time of an individual ad. If no start time is defined, the ad will run on the campaign’s schedule. |
adlabels | ARRAY | Ad labels associated with this ad |
adset | OBJECT | Ad set that contains this ad |
adset_id | STRING | ID of the ad set that contains the ad |
bid_amount | INTEGER | Bid amount for this ad which will be used in auction. This value would be the same as the bid_amount field on the ad set. |
campaign | OBJECT | Ad campaign that contains this ad |
campaign_id | STRING | ID of the ad campaign that contains this ad |
configured_status | STRING | The configured status of the ad. Use status instead of this field. |
conversion_domain | STRING | The domain where conversions happen. The field is no longer required for creation or update since June 2023. Note that this field should contain only the first and second level domains, and not the full URL. For example facebook.com. |
created_time | DATETIME | Time when the ad was created. |
creative_id | STRING | Unique ID for the ad creative |
creative_effective_object_story_id | STRING | The ID of a page post to use in an ad, regardless of whether its an organic or unpublished page post |
creative_name | STRING | Name of the ad creative as seen in the ad accounts library |
creative_object_story_spec | STRING | Object story spec containing page_id and other details |
creative_url_tags | STRING | A set of query string parameters which will replace or be appended to urls clicked from page post ads |
creative_asset_groups_spec | OBJECT | This field is used to create ads using the Flexible ad format. You can read more about that here |
effective_status | STRING | The effective status of the ad. The status could be effective either because of its own status, or the status of its parent units. WITH_ISSUES is available for version 3.2 or higher. IN_PROCESS is available for version 4.0 or higher |
issues_info | ARRAY | Issues for this ad that prevented it from delivering |
last_updated_by_app_id | STRING | Indicates the app used for the most recent update of the ad. |
name | STRING | Name of the ad. |
preview_shareable_link | STRING | A link that enables users to preview ads in different placements |
recommendations | ARRAY | If there are recommendations for this ad, this field includes them. Otherwise, it is not included in the response. Field not included in redownload mode. |
source_ad | OBJECT | The source ad that this ad is copied from |
source_ad_id | STRING | The source ad id that this ad is copied from |
status | STRING | The configured status of the ad. The field returns the same value as configured_status. Use this field, instead of configured_status. |
tracking_specs | ARRAY | With tracking specs, you log actions taken by people on your ad. This field takes arguments identical to action spec. See Tracking and Conversion Specs. |
updated_time | DATETIME | Time when this ad was updated. |
Facebook Ads Ad Account schema
61 fieldsSchema on GitHubfacebook_ads_ad_account
Your ad account settings, status, currency, and billing details.
Questions this table answers
- Which accounts are close to their spend cap?
- What currency and time zone does each account use?
- Which business does each account belong to, and what is its status?
| Field | Type | Description |
|---|---|---|
idPK | STRING | The string act\_{ad_account_id}. |
account_idPK | STRING | The ID of the Ad Account. |
account_status | INTEGER | Status of the account: |
age | NUMBER | Amount of time the ad account has been open, in days. |
agency_client_declaration | STRING | Details of the agency advertising on behalf of this client account, if applicable. Requires Business Manager Admin privileges. |
amount_spent | STRING | Current amount spent by the account with respect to spend_cap. Or total amount in the absence of spend_cap. |
attribution_spec | ARRAY | Deprecated due to iOS 14 changes. Please visit the changelog for more information. |
balance | STRING | Bill amount due for this Ad Account. |
brand_safety_content_filter_levels | ARRAY | Brand safety content filter levels set for in-content ads (Facebook in-stream videos and Ads on Facebook Reels) and Audience Network along with feed ads (Facebook Feed, Instagram feed, Facebook Reels feed and Instagram Reels feed) if applicable. |
business | STRING | The Business Manager, if this ad account is owned by one |
business_city | STRING | City for business address |
business_country_code | STRING | Country code for the business address |
business_name | STRING | The business name for the account |
business_state | STRING | State abbreviation for business address |
business_street | STRING | First line of the business street address for the account |
business_street2 | STRING | Second line of the business street address for the account |
business_zip | STRING | Zip code for business address |
can_create_brand_lift_study | BOOLEAN | If we can create a new automated brand lift study under the Ad Account. |
capabilities | ARRAY | List of capabilities an Ad Account can have. See capabilities |
created_time | DATETIME | The time the account was created in ISO 8601 format. |
currency | STRING | The currency used for the account, based on the corresponding value in the account settings. See supported currencies |
default_dsa_beneficiary | STRING | This is the default value for creating L2 object of dsa_beneficiary |
default_dsa_payor | STRING | This is the default value for creating L2 object of dsa_payor |
disable_reason | INTEGER | The reason why the account was disabled. Possible reasons are: |
end_advertiser | STRING | The entity the ads will target. Must be a Facebook Page Alias, Facebook Page ID or an Facebook App ID. |
end_advertiser_name | STRING | The name of the entity the ads will target. |
existing_customers | ARRAY | The custom audience ids that are used by advertisers to define their existing customers. This definition is primarily used by Automated Shopping Ads. |
expired_funding_source_details | STRING | ID = ID of the payment method |
extended_credit_invoice_group | STRING | The extended credit invoice group that the ad account belongs to |
failed_delivery_checks | ARRAY | Failed delivery checks |
fb_entity | INTEGER | fb_entity |
funding_source | STRING | ID of the payment method. If the account does not have a payment method it will still be possible to create ads but these ads will get no delivery. Not available if the account is disabled |
funding_source_details | STRING | ID = ID of the payment method |
has_migrated_permissions | BOOLEAN | Whether this account has migrated permissions |
io_number | STRING | The Insertion Order (IO) number. |
is_attribution_spec_system_default | BOOLEAN | If the attribution specification of ad account is generated from system default values |
is_direct_deals_enabled | BOOLEAN | Whether the account is enabled to run Direct Deals |
is_in_3ds_authorization_enabled_market | BOOLEAN | If the account is in a market requiring to go through payment process going through 3DS authorization |
is_notifications_enabled | BOOLEAN | Get the notifications status of the user for this ad account. This will return true or false depending if notifications are enabled or not |
is_personal | INTEGER | Indicates if this ad account is being used for private, non-business purposes. This affects how value-added tax (VAT) is assessed. Note: This is not related to whether an ad account is attached to a business. |
is_prepay_account | BOOLEAN | If this ad account is a prepay. Other option would be a postpay account. |
is_tax_id_required | BOOLEAN | If tax id for this ad account is required or not. |
line_numbers | ARRAY | The line numbers |
media_agency | STRING | The agency, this could be your own business. Must be a Facebook Page Alias, Facebook Page ID or an Facebook App ID. In absence of one, you can use NONE or UNFOUND. |
min_campaign_group_spend_cap | STRING | The minimum required spend cap of Ad Campaign. |
min_daily_budget | INTEGER | The minimum daily budget for this Ad Account |
name | STRING | Name of the account. If not set, the name of the first admin visible to the user will be returned. |
offsite_pixels_tos_accepted | BOOLEAN | Indicates whether the offsite pixel Terms Of Service contract was signed. This feature can be accessible before v2.9 |
owner | STRING | The ID of the account owner |
partner | STRING | This could be Facebook Marketing Partner, if there is one. Must be a Facebook Page Alias, Facebook Page ID or an Facebook App ID. In absence of one, you can use NONE or UNFOUND. |
rf_spec | OBJECT | Reach and Frequency limits configuration. See Reach and Frequency |
spend_cap | STRING | The maximum amount that can be spent by this Ad Account. When the amount is reached, all delivery stops. A value of 0 means no spending-cap. Setting a new spend cap only applies to spend AFTER the time at which you set it. Value specified in basic unit of the currency, for example 'cents' for USD. |
tax_id | STRING | Tax ID |
tax_id_status | INTEGER | VAT status code for the account. |
tax_id_type | STRING | Type of Tax ID |
timezone_id | INTEGER | The timezone ID of this ad account |
timezone_name | STRING | Name for the time zone |
timezone_offset_hours_utc | NUMBER | Time zone difference from UTC (Coordinated Universal Time). |
tos_accepted | OBJECT | Checks if this specific ad account has signed the Terms of Service contracts. Returns 1, if terms were accepted. |
user_tasks | ARRAY | user_tasks |
user_tos_accepted | OBJECT | Checks if a user has signed the Terms of Service contracts related to the Business that contains a specific ad account. Must include user's access token to get information. This verification is not valid for system users. |
Facebook Ads Ad Account User schema
2 fieldsSchema on GitHubfacebook_ads_ad_account_user
Users with access to an ad account and their assigned roles.
Questions this table answers
- Which accounts does the connector read, by id and name?
- How many accounts are loaded?
- Do the names here match the names in Ad Account?
| Field | Type | Description |
|---|---|---|
idPK | STRING | ID of the App Scoped User |
name | STRING | User public full name |
Facebook Ads Ad Creatives schema
65 fieldsSchema on GitHubfacebook_ads_ad_account_adcreatives
The images, videos, text, and other visual elements used in your ads.
Questions this table answers
- Which call to action types are used by the most creatives?
- Which creatives share the same Page post (
effective_object_story_id)? - Which creatives are not in an active status?
| Field | Type | Description |
|---|---|---|
idPK | STRING | Unique ID for an ad creative, numeric string. |
account_id | STRING | Ad account ID for the account this ad creative belongs to. |
actor_id | STRING | The actor ID (Page ID or User ID) of this creative |
ad_disclaimer_spec | STRING | Ad disclaimer data on creative for additional information on ads. |
adlabels | ARRAY | Ad Labels associated with this creative. Used to group it with related ad objects. |
applink_treatment | STRING | Used for Dynamic Ads. Specify what action should occur if a person clicks a link in the ad, but the business' app is not installed on their device. For example, open a webpage displaying the product, or open the app in an app store on the person's mobile device. |
asset_feed_spec | STRING | Used for Dynamic Creative to automatically experiment and deliver different variations of an ad's creative. Specifies an asset feed with multiple images, text and other assets used to generate variations of an ad. Formatted as a JSON string. |
authorization_category | STRING | Specifies whether ad was configured to be labeled as a political ad or not. See Facebook Advertising Policies. This field cannot be used for Dynamic Ads. |
body | STRING | The body of the ad. Not supported for video post creatives |
branded_content | STRING | branded_content |
branded_content_sponsor_page_id | STRING | ID for page representing business which runs Branded Content ads. See Creating Branded Content Ads. |
bundle_folder_id | STRING | The Dynamic Ad's bundle folder ID |
call_to_action_type | STRING | Type of call to action button in your ad. This determines the button text and header text for your ad. See Ads Guide for campaign objectives and permitted call to action types. |
categorization_criteria | STRING | The Dynamic Category Ad's categorization field, e.g. brand |
category_media_source | STRING | The Dynamic Ad's rendering mode for category ads |
collaborative_ads_lsb_image_bank_id | STRING | Used for CPAS local delivery image bank |
contextual_multi_ads | STRING | contextual_multi_ads |
creative_sourcing_spec | STRING | creative_sourcing_spec |
degrees_of_freedom_spec | STRING | Specifies the types of transformations that are enabled for the given creative |
destination_set_id | STRING | The ID of the Product Set for a Destination Catalog that will be used to link with Travel Catalogs |
dynamic_ad_voice | STRING | Used for Store Traffic Objective inside Dynamic Ads. Allows you to control the voice of your ad. If set to DYNAMIC, page name and profile picture in your ad post come from the nearest page location. If set to STORY_OWNER, page name and profile picture in your ad post come from the main page location. |
effective_authorization_category | STRING | Specifies whether ad is a political ad or not. See Facebook Advertising Policies. This field cannot be used for Dynamic Ads. |
effective_instagram_media_id | STRING | The ID of an Instagram post to use in an ad |
effective_object_story_id | STRING | The ID of a page post to use in an ad, regardless of whether it's an organic or unpublished page post |
enable_direct_install | BOOLEAN | Whether Direct Install should be enabled on supported devices |
enable_launch_instant_app | BOOLEAN | Whether Instant App should be enabled on supported devices |
facebook_branded_content | STRING | Stores fields for Facebook Branded Content |
image_crops | STRING | A JSON object defining crop dimensions for the image specified. See image crop reference for more details |
image_hash | STRING | Image hash for ad creative. If provided, do not add image_url. See image library for more details. |
image_url | STRING | A URL for the image for this creative. We save the image at this URL to the ad account's image library. If provided, do not include image_hash. |
instagram_permalink_url | STRING | URL for a post on Instagram you want to run as an ad. Also known as Instagram media. |
instagram_user_id | STRING | Instagram actor ID |
interactive_components_spec | STRING | Specification for all the interactive components that would show up on the ad |
link_destination_display_url | STRING | Overwrites the display URL for link ads when object_url is set to a click tag |
link_og_id | STRING | The Open Graph (OG) ID for the link in this creative if the landing page has OG tags |
link_url | STRING | Identify a specific landing tab on your Facebook page by the Page tab's URL. See connection objects for retrieving Page tab URLs. You can add app_data parameters to the URL to pass data to a Page's tab. |
link_url_parsed | STRING | link_url resolved to its landing page when it is a short link; otherwise the same value. Requires link_url and Process Short Links. |
messenger_sponsored_message | STRING | Used for Messenger sponsored message. JSON string with message for this ad creative. See Messenger Platform, Send API Reference. |
name | STRING | Name of this ad creative as seen in the ad account's library. This field has a limit of 100 characters. |
object_id | STRING | ID for Facebook object being promoted with ads or relevant to the ad or ad type. For example a page ID if you are running ads to generate Page Likes. See promoted_object. |
object_store_url | STRING | iTunes or Google Play of the destination of an app ad |
object_story_id | STRING | ID of a Facebook Page post to use in an ad. You can get this ID by querying the posts of the page. If this post includes an image, it should not exceed 8 MB. Facebook will upload the image from the post to your ad account's image library. If you create an unpublished page post via object_story_spec at the same time as creating the ad, this ID will be null. However, the effective_object_story_id will be the ID of the page post regardless of whether it's an organic or unpublished page post. |
object_story_spec | STRING | Use if you want to create a new unpublished page post and turn the post into an ad. The Page ID and the content to create a new unpublished page post. Specify link_data, photo_data, video_data, text_data or template_data with the content. |
object_type | STRING | The type of Facebook object you want to advertise. Allowed values are: |
object_url | STRING | URL that opens if someone clicks your link on a link ad. This URL is not connected to a Facebook page. |
object_url_parsed | STRING | object_url resolved to its landing page when it is a short link; otherwise the same value. Requires object_url and Process Short Links. |
page_welcome_message | STRING | Page welcome message for CTM ads |
photo_album_source_object_story_id | STRING | photo_album_source_object_story_id |
place_page_set_id | STRING | The ID of the page set for this creative. See theLocal Awareness guide |
platform_customizations | STRING | Use this field to specify the exact media to use on different Facebook placements. You can currently use this setting for images and videos. Facebook replaces the media originally defined in ad creative with this media when the ad displays in a specific placements. For example, if you define a media here for instagram, Facebook uses that media instead of the media defined in the ad creative when the ad appears on Instagram. |
playable_asset_id | STRING | The ID of the playable asset in this creative |
portrait_customizations | STRING | This field describes the rendering customizations selected for portrait mode ads like IG Stories, FB Stories, IGTV, etc |
product_data | ARRAY | product_data |
product_set_id | STRING | Used for Dynamic Ad. An ID for a product set, which groups related products or other items being advertised. |
recommender_settings | STRING | Used for Dynamic Ads. Settings to display Dynamic ads based on product recommendations. |
source_instagram_media_id | STRING | The ID of an Instagram post for creating ads |
status | STRING | The status of the creative. WITH_ISSUES and IN_PROCESS are available for 4.0 or higher |
template_url | STRING | Used for Dynamic Ads when you want to use third-party click tracking. See Dynamic Ads, Click Tracking and Templates. |
template_url_spec | STRING | Used for Dynamic Ads when you want to use third-party click tracking. See Dynamic Ads, Click Tracking and Templates. |
thumbnail_id | STRING | thumbnail_id |
thumbnail_url | STRING | URL for a thumbnail image for this ad creative. You can provide dimensions for this with thumbnail_width and thumbnail_height. See example. |
title | STRING | Title for link ad, which does not belong to a page. |
url_tags | STRING | A set of query string parameters which will replace or be appended to urls clicked from page post ads, message of the post, and canvas app install creatives only |
use_page_actor_override | BOOLEAN | Used for App Ads. If true, we display the Facebook page associated with the app ads. |
video_id | STRING | Facebook object ID for video in this ad creative. |
Facebook Ads Ad Insights schema
100 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights
Daily performance metrics for each ad — impressions, clicks, spend, and conversions.
Questions this table answers
- What did each ad spend and return per day over the last 30 days?
- Which campaigns have the highest cost per click, once their ads are rolled up through
campaign_id? - Which ads reach the fewest people while spending the most?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The percentage of results you received out of all the views of your ads. |
results | ARRAY | The number of results you received out of all the views of your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Facebook Ads Ad Insights by Ad Set schema
92 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_adset
Daily ad set performance with reach deduplicated to match Meta Ads Manager.
Questions this table answers
- How many people did each ad set reach on a given day, and how often did they see it?
- Which optimization goals have the lowest cost per click?
- Which ad sets spend the most within each campaign?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
adset_idPK | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | The number of people who saw your ads at least once, deduplicated at the ad set level. This metric is estimated. |
result_rate | ARRAY | The percentage of results you received out of all the views of your ads. |
results | ARRAY | The number of results you received out of all the views of your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
Ad Insights by Age and Gender schema
Facebook Ads Ad Insights by Age and Gender schema
102 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_age_and_gender
Daily ad performance broken down by audience age range and gender.
Questions this table answers
- Which age and gender groups give the cheapest clicks?
- How do impressions split by gender within each age range?
- Which age ranges convert best for a given ad (
actions,spend)?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
agePK | STRING | The age range of the people who saw your ad. This is based on the age people have listed in their Facebook profiles. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
genderPK | STRING | The gender of the people who saw your ad. This is based on the gender people have listed in their Facebook profiles. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Ad Insights by Campaign schema
Facebook Ads Ad Insights by Campaign schema
89 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_campaign
Daily campaign performance with reach deduplicated to match Meta Ads Manager.
Questions this table answers
- How many people did each campaign reach on a given day, and how often did they see it?
- Which campaigns have the highest spend for the lowest click-through rate?
- How does spend per day change within each objective?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
buying_type | STRING | 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. |
campaign_idPK | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | The number of people who saw your ads at least once, deduplicated at the campaign level. This metric is estimated. |
result_rate | ARRAY | The percentage of results you received out of all the views of your ads. |
results | ARRAY | The number of results you received out of all the views of your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
Facebook Ads Ad Insights by Country schema
101 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_country
Daily ad performance broken down by the country where your audience is located.
Questions this table answers
- Which countries get the most spend, and what do they return?
- Which ads spend in the most countries?
- How does the click-through rate differ between countries?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
countryPK | STRING | The country 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 Meta. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Ad Insights by Device Platform schema
Facebook Ads Ad Insights by Device Platform schema
101 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_device_platform
Daily ad performance broken down by the device type your audience used.
Questions this table answers
- Do mobile and desktop differ in click-through rate?
- How does spend split across device platforms for each campaign?
- Which ads depend most on one device platform?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
device_platformPK | STRING | device_platform |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Ad Insights by Link URL Asset schema
Facebook Ads Ad Insights by Link URL Asset schema
101 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_link_url_asset
Daily ad performance broken down by the link URL shown in your ads.
Questions this table answers
- Which link URLs get the most clicks?
- Which ads send traffic to more than one URL?
- Which link URLs cost the most per click?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
link_url_asset | OBJECT | The ID of the URL asset involved in impression, click or action. |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Ad Insights by Product ID schema
Facebook Ads Ad Insights by Product ID schema
101 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_product_id
Daily ad performance broken down by individual product from your catalog.
Questions this table answers
- Which products get the most spend?
- Which products have the most clicks per impression?
- Which products appear in the most ads?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
product_idPK | STRING | The ID of the product associated with the ad. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Ad Insights by Publisher Platform and Position schema
Facebook Ads Ad Insights by Publisher Platform and Position schema
102 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_publisher_platform_and_position
Daily ad performance broken down by where your ads appeared — platform and placement position.
Questions this table answers
- Which placements cost the least per click?
- How does spend split across platforms and positions for each campaign?
- Which positions get the most impressions without clicks?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
platform_positionPK | STRING | platform_position |
publisher_platformPK | STRING | Which platform your ad was shown, for example on Facebook, Instagram, or Audience Network. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Facebook Ads Ad Insights by Region schema
101 fieldsTime seriesSchema on GitHubfacebook_ads_ad_account_insights_by_region
Daily ad performance broken down by the region where your audience is located.
Questions this table answers
- Which regions bring the most clicks per unit of spend?
- Which regions get impressions but few clicks?
- How does spend split across regions for each campaign?
| Field | Type | Description |
|---|---|---|
account_currency | STRING | Currency that is used by your ad account. |
account_id | STRING | The ID number of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
account_name | STRING | The name of your ad account, which groups your advertising activity. Your ad account includes your campaigns, ads and billing. |
action_values | ARRAY | The total value of all conversions attributed to your ads. |
actions | ARRAY | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
ad_click_actions | ARRAY | ad_click_actions |
ad_idPK | STRING | The unique ID of the ad you're viewing in reporting. |
ad_impression_actions | ARRAY | ad_impression_actions |
ad_name | STRING | The name of the ad you're viewing in reporting. |
adset_id | STRING | 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. |
adset_name | STRING | The name 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. |
attribution_setting | STRING | The default attribution window to be used when attribution result is calculated. Each ad set has its own attribution setting value. The attribution setting for campaign or account is calculated based on existing ad sets. |
auction_bid | NUMBER | auction_bid |
auction_competitiveness | NUMBER | auction_competitiveness |
auction_max_competitor_bid | NUMBER | auction_max_competitor_bid |
buying_type | STRING | 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. |
campaign_id | STRING | The unique ID number of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
campaign_name | STRING | The name of the ad campaign you're viewing in reporting. Your campaign contains ad sets and ads. |
canvas_avg_view_percent | NUMBER | 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. |
canvas_avg_view_time | NUMBER | 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 | ARRAY | The number of actions performed attributed to your ads promoting your catalog segment, broken down by action type. |
catalog_segment_value | ARRAY | The total value of all conversions from your catalog segment attributed to your ads. |
catalog_segment_value_mobile_purchase_roas | ARRAY | The total return on ad spend (ROAS) from mobile app purchases for your catalog segment. |
catalog_segment_value_omni_purchase_roas | ARRAY | The total return on ad spend (ROAS) from all purchases for your catalog segment. |
catalog_segment_value_website_purchase_roas | ARRAY | The total return on ad spend (ROAS) from website purchases for your catalog segment. |
clicks | NUMBER | The number of clicks on your ads. |
conversion_values | ARRAY | The total value of the conversions attributed to your ads, counting conversion events only. Unlike action_values, it excludes engagement and clicks. |
conversions | ARRAY | The total number of conversions attributed to your ads. Counts conversion events only, unlike actions, which also counts engagement and clicks. |
converted_product_quantity | ARRAY | 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 | ARRAY | 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. |
cost_per_15_sec_video_view | ARRAY | cost_per_15_sec_video_view |
cost_per_2_sec_continuous_video_view | ARRAY | cost_per_2_sec_continuous_video_view |
cost_per_action_type | ARRAY | The average cost of a relevant action. |
cost_per_ad_click | ARRAY | cost_per_ad_click |
cost_per_conversion | ARRAY | cost_per_conversion |
cost_per_dda_countby_convs | NUMBER | cost_per_dda_countby_convs |
cost_per_inline_link_click | NUMBER | The average cost of each inline link click. |
cost_per_inline_post_engagement | NUMBER | The average cost of each inline post engagement. |
cost_per_one_thousand_ad_impression | ARRAY | cost_per_one_thousand_ad_impression |
cost_per_outbound_click | ARRAY | The average cost for each outbound click. |
cost_per_result | ARRAY | The average cost per result from your ads. |
cost_per_thruplay | ARRAY | The average cost for each ThruPlay. This metric is in development. |
cost_per_unique_action_type | ARRAY | The average cost of each unique action. This metric is estimated. |
cost_per_unique_click | NUMBER | The average cost for each unique click (all). This metric is estimated. |
cost_per_unique_conversion | ARRAY | cost_per_unique_conversion |
cost_per_unique_inline_link_click | NUMBER | The average cost of each unique inline link click. This metric is estimated. |
cost_per_unique_outbound_click | ARRAY | The average cost for each unique outbound click. This metric is estimated. |
cpc | NUMBER | The average cost for each click (all). |
cpm | NUMBER | The average cost for 1,000 impressions. |
cpp | NUMBER | The average cost to reach 1,000 people. This metric is estimated. |
created_time | STRING | created_time |
ctr | NUMBER | The percentage of times people saw your ad and performed a click (all). |
date_startPK | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stopPK | DATE | The end date for your data. This is controlled by the date range you've selected for your reporting view. |
dda_countby_convs | NUMBER | dda_countby_convs |
dda_results | ARRAY | dda_results |
frequency | NUMBER | The average number of times each person saw your ad. This metric is estimated. |
full_view_impressions | NUMBER | The number of Full Views on your Page's posts as a result of your ad. |
full_view_reach | NUMBER | The number of people who performed a Full View on your Page's post as a result of your ad. |
impressions | NUMBER | The number of times your ads were on screen. |
inline_link_click_ctr | NUMBER | The percentage of time people saw your ads and performed an inline link click. |
inline_link_clicks | NUMBER | The number of clicks on links to select destinations or experiences, on or off Facebook-owned properties. Inline link clicks use a fixed 1-day-click attribution window. |
inline_post_engagement | NUMBER | The total number of actions that people take involving your ads. Inline post engagements use a fixed 1-day-click attribution window. |
instagram_upcoming_event_reminders_set | NUMBER | instagram_upcoming_event_reminders_set |
instant_experience_clicks_to_open | NUMBER | instant_experience_clicks_to_open |
instant_experience_clicks_to_start | NUMBER | instant_experience_clicks_to_start |
instant_experience_outbound_clicks | ARRAY | instant_experience_outbound_clicks |
interactive_component_tap | ARRAY | interactive_component_tap |
marketing_messages_delivery_rate | NUMBER | The number of messages delivered divided by the number of messages sent. Some messages may not be delivered, such as when a customer's device is out of service. This metric doesn't include messages sent to Europe and Japan. |
mobile_app_purchase_roas | ARRAY | 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. |
objective | STRING | 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. |
optimization_goal | STRING | The optimization goal you selected for your ad or ad set. Your optimization goal reflects what you want to optimize for the ads. |
outbound_clicks | ARRAY | The number of clicks on links that take people off Facebook-owned properties. |
outbound_clicks_ctr | ARRAY | The percentage of times people saw your ad and performed an outbound click. |
purchase_roas | ARRAY | 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. |
qualifying_question_qualify_answer_rate | NUMBER | qualifying_question_qualify_answer_rate |
reach | NUMBER | 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. |
regionPK | STRING | The region where your ads were shown. |
result_rate | ARRAY | The result rate from your ads. |
results | ARRAY | The number of results from your ads. |
shops_assisted_purchases | STRING | shops_assisted_purchases |
social_spend | NUMBER | The total amount you've spent so far for your ads showed with social information. (ex: Jane Doe likes this). |
spend | NUMBER | The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule. This metric is estimated. |
updated_time | STRING | updated_time |
video_30_sec_watched_actions | ARRAY | 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. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
video_avg_time_watched_actions | ARRAY | The average time a video was played, including any time spent replaying the video for a single impression. |
video_continuous_2_sec_watched_actions | ARRAY | video_continuous_2_sec_watched_actions |
video_p100_watched_actions | ARRAY | The number of times your video was played at 100% of its length, including plays that skipped to this point. |
video_p25_watched_actions | ARRAY | The number of times your video was played at 25% of its length, including plays that skipped to this point. |
video_p50_watched_actions | ARRAY | The number of times your video was played at 50% of its length, including plays that skipped to this point. |
video_p75_watched_actions | ARRAY | The number of times your video was played at 75% of its length, including plays that skipped to this point. |
video_p95_watched_actions | ARRAY | The number of times your video was played at 95% of its length, including plays that skipped to this point. |
video_play_actions | ARRAY | 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_play_curve_actions | ARRAY | A video-play based curve graph that illustrates the percentage of video plays that reached a given second. Entries 0 to 14 represent seconds 0 thru 14. Entries 15 to 17 represent second ranges \[15 to 20), \[20 to 25), and \[25 to 30). Entries 18 to 20 represent second ranges \[30 to 40), \[40 to 50), and \[50 to 60). Entry 21 represents plays over 60 seconds. |
video_play_retention_0_to_15s_actions | ARRAY | video_play_retention_0_to_15s_actions |
video_play_retention_20_to_60s_actions | ARRAY | video_play_retention_20_to_60s_actions |
video_play_retention_graph_actions | ARRAY | video_play_retention_graph_actions |
video_time_watched_actions | ARRAY | video_time_watched_actions |
website_ctr | ARRAY | The percentage of times people saw your ad and performed a link click. |
website_purchase_roas | ARRAY | 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. |
wish_bid | NUMBER | wish_bid |
Facebook Ads Ads schema
24 fieldsSchema on GitHubfacebook_ads_ad_account_ads
Individual ads with their status, creative, and campaign hierarchy.
Questions this table answers
- How many ads are active, paused or with issues in each campaign?
- Which ads run the same creative?
- Which ads were updated in the last 30 days?
| Field | Type | Description |
|---|---|---|
idPK | STRING | The ID of this ad |
account_id | STRING | The ID of the ad account that this ad belongs to |
ad_active_time | STRING | The time from when the ad was recently active |
ad_schedule_end_time | DATETIME | An optional parameter that defines the end time of an individual ad. If no end time is defined, the ad will run on the campaign's schedule |
ad_schedule_start_time | DATETIME | An optional parameter that defines the start time of an individual ad. If no start time is defined, the ad will run on the campaign's schedule |
adlabels | ARRAY | Ad labels associated with this ad |
adset_id | STRING | ID of the ad set that contains the ad |
bid_amount | INTEGER | Bid amount for this ad which will be used in auction |
campaign_id | STRING | ID of the ad campaign that contains this ad |
configured_status | STRING | The configured status of the ad. Use status instead of this field |
conversion_domain | STRING | The domain where conversions happen |
created_time | DATETIME | Time when the ad was created |
creative_id | STRING | Unique ID for the ad creative |
creative_effective_object_story_id | STRING | The ID of a page post to use in an ad |
creative_name | STRING | Name of the ad creative |
creative_url_tags | STRING | Query string parameters appended to urls clicked from page post ads |
effective_status | STRING | The effective status of the ad |
issues_info | ARRAY | Issues for this ad that prevented it from delivering |
last_updated_by_app_id | STRING | Indicates the app used for the most recent update of the ad |
name | STRING | Name of the ad |
preview_shareable_link | STRING | A link that enables users to preview ads in different placements |
source_ad_id | STRING | The source ad id that this ad is copied from |
status | STRING | The configured status of the ad |
updated_time | DATETIME | Time when this ad was updated |
What Facebook Ads data answers
What Facebook Ads data answers
Across the tables
- Which campaigns spend the most for the fewest results, once spend is divided by results?
- Which creatives drive the cheapest conversions, once performance is joined to the creative each ad runs?
- How many people did each campaign reach on a given day, and how often did they see the ads?
Industry data models that use Facebook Ads
Industry data models that use Facebook Ads
- E-CommerceEcommerce12 data marts, 87 fields
- E-Commerce ExtendedEcommerce20 data marts, 125 fields
- E-commerce Subscription StoreEcommerce15 data marts, 189 fields
- FinanceFinance8 data marts, 66 fields
- HealthcareHealthcare8 data marts, 56 fields
- Healthcare Clinic AttributionHealthcare14 data marts, 132 fields
- Healthcare Clinic NetworkHealthcare10 data marts, 150 fields
- Marketing LeadgenAgency9 data marts, 81 fields
- MarketplaceEcommerce8 data marts, 66 fields
- MeasureCamp11 data marts, 61 fields
- Retail ChainRetail10 data marts, 128 fields
- SaaSSaaS10 data marts, 99 fields
- TradingFinance8 data marts, 168 fields
Where Facebook Ads data goes
Data warehouses
AI assistants
Spreadsheets
Dashboards
Messages
API
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.39.0Long Facebook Ads imports no longer fail on a corrupted response
- 0.37.0Short links resolve only on known short link services and domains you allow
- 0.36.0Resolve short links in every ads connector, with nested paths and a per-Data-Mart cache
- 0.35.0Select conversions and conversion values by default in Facebook Marketing insights
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.