Facebook Ads Connector to Microsoft Excel
Own your Facebook Ads data in Microsoft Excel with OWOX Data Marts. Collect granular, analytics-ready Facebook Ads data, control schema and refresh logic, and reuse it across Microsoft Excel and AI Insights.
Facebook Ads endpoints
15 Facebook Ads endpoints you can import. Each lands in its own table in your warehouse.
Ad
Individual ads with their creative, status, and links to their campaign and ad set.
32 fieldsfacebook_ads_ad_groupAd Account
Your ad account settings, status, currency, and billing details.
61 fieldsfacebook_ads_ad_accountAd Account User
Users with access to an ad account and their assigned roles.
2 fieldsfacebook_ads_ad_account_userAd Creatives
The images, videos, text, and other visual elements used in your ads.
63 fieldsfacebook_ads_ad_account_adcreativesAd Insights
Daily performance metrics for each ad — impressions, clicks, spend, and conversions.
100 fieldsTime seriesfacebook_ads_ad_account_insightsAd Insights by Ad Set
Daily ad set performance with reach deduplicated to match Meta Ads Manager.
92 fieldsTime seriesfacebook_ads_ad_account_insights_by_adsetAd Insights by Age and Gender
Daily ad performance broken down by audience age range and gender.
102 fieldsTime seriesfacebook_ads_ad_account_insights_by_age_and_genderAd Insights by Campaign
Daily campaign performance with reach deduplicated to match Meta Ads Manager.
89 fieldsTime seriesfacebook_ads_ad_account_insights_by_campaignAd Insights by Country
Daily ad performance broken down by the country where your audience is located.
101 fieldsTime seriesfacebook_ads_ad_account_insights_by_countryAd Insights by Device Platform
Daily ad performance broken down by the device type your audience used.
101 fieldsTime seriesfacebook_ads_ad_account_insights_by_device_platformAd Insights by Link URL Asset
Daily ad performance broken down by the link URL shown in your ads.
101 fieldsTime seriesfacebook_ads_ad_account_insights_by_link_url_assetAd Insights by Product ID
Daily ad performance broken down by individual product from your catalog.
101 fieldsTime seriesfacebook_ads_ad_account_insights_by_product_idAd Insights by Publisher Platform and Position
Daily ad performance broken down by where your ads appeared — platform and placement position.
102 fieldsTime seriesfacebook_ads_ad_account_insights_by_publisher_platform_and_positionAd Insights by Region
Daily ad performance broken down by the region where your audience is located.
101 fieldsTime seriesfacebook_ads_ad_account_insights_by_regionAds
Individual ads with their status, creative, and campaign hierarchy.
24 fieldsfacebook_ads_ad_account_ads
Facebook Ads data schema
Ad 32 fields · facebook_ads_ad_group
| Field | Type | Description |
|---|---|---|
id | 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. |
Ad Account 61 fields · facebook_ads_ad_account
| Field | Type | Description |
|---|---|---|
id | STRING | The string act\_{ad_account_id}. |
account_id | 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. |
Ad Account User 2 fields · facebook_ads_ad_account_user
| Field | Type | Description |
|---|---|---|
id | STRING | ID of the App Scoped User |
name | STRING | User public full name |
Ad Creatives 63 fields · facebook_ads_ad_account_adcreatives
| Field | Type | Description |
|---|---|---|
id | 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. |
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. |
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 |
Ad Insights 100 fields · facebook_ads_ad_account_insights
| 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_id | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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 |
Ad Insights by Ad Set 92 fields · facebook_ads_ad_account_insights_by_adset
| 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_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. |
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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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 102 fields · facebook_ads_ad_account_insights_by_age_and_gender
| 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_id | 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. |
age | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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. |
gender | 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 89 fields · facebook_ads_ad_account_insights_by_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. |
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_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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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. |
Ad Insights by Country 101 fields · facebook_ads_ad_account_insights_by_country
| 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_id | 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. |
country | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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 101 fields · facebook_ads_ad_account_insights_by_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_id | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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_platform | 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 101 fields · facebook_ads_ad_account_insights_by_link_url_asset
| 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_id | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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 101 fields · facebook_ads_ad_account_insights_by_product_id
| 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_id | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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_id | 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 102 fields · facebook_ads_ad_account_insights_by_publisher_platform_and_position
| 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_id | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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_position | STRING | platform_position |
publisher_platform | 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 |
Ad Insights by Region 101 fields · facebook_ads_ad_account_insights_by_region
| 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_id | 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 | conversion_values |
conversions | ARRAY | conversions |
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_start | DATE | The start date for your data. This is controlled by the date range you've selected for your reporting view. |
date_stop | 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. |
region | 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 |
Ads 24 fields · facebook_ads_ad_account_ads
| Field | Type | Description |
|---|---|---|
id | 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 |
Data Partner You Can Trust
users
175K
Executives and data analysts across 20+ industries
G2 rating
4.9★
“A trusted data analytics partner” — verified review
Customers
ArtPix 3D — transparent KPI calculationsasset pending
Avrora — a partner we could trustasset pending
Avrora — clarity and confidence to decide fastasset pending
Avrora — reliable analytics systemasset pending
Avrora — transformed approach to BIasset pending
Better&Stronger — always there to helpasset pending
Better&Stronger — rich educational resourcesasset pending
Domas R. (G2) — data we can actually trustasset pending
Domas R. (G2) — solution to most data challengesasset pending
Hiveon — key metrics built our wayasset pending
Khrystyna G. (G2) — simple tool, amazing supportasset pending
MatahariMall — less time on reportingasset pending
MotionVFX — data quality to predict budgetasset pending
MotionVFX — exceeded our expectationsasset pending
MotionVFX — no decisions without analysisasset pending
MotionVFX — transparency behind every KPIasset pending
ON Clinic — cost per acquisition by serviceasset pending
ON Clinic — data for regional KPIsasset pending
ON Clinic — know AOV by segmentasset pending
IT
QVC — reports in line with business needsasset pending
QVC — totally satisfied with resultasset pending
Retail
IT
Wojciech W. (G2) — accurate data, more revenueasset pending
Wojciech W. (G2) — reliable business partnerasset pending
Wojciech W. (G2) — transparent, honest cooperation termsasset pending
Business & Consumer Services
ZOOD — foundation for years to comeasset pending
Every claim has a receipt.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
Nodari RizunFounder & CEO, Pürblack®“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”