Facebook Ads data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: AD

AccountID_fromFA
Display name Account ID
Description The ID number of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
Accountname_fromFA
Display name Account name
Description The name of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
action_app_custom_event.fb_mobile_achievement_unlocked
Display name Mobile app achievements unlocked
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_activate_app
Display name Mobile app sessions
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_add_payment_info
Display name Mobile app adds of payment info
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_add_to_cart
Display name Mobile app adds to cart
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_add_to_wishlist
Display name Mobile app adds to wishlist
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_complete_registration
Display name Mobile app registrations completed
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_content_view
Display name Mobile app content views
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_initiated_checkout
Display name Mobile app checkouts initiated
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_level_achieved
Display name Mobile app levels completed
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_purchase
Display name Mobile app purchases
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_search
Display name Mobile app searches
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_spent_credits
Display name Mobile app credits spent
Field type metric
Data type int.number.value
action_app_custom_event.fb_mobile_tutorial_completion
Display name Mobile app tutorials completed
Field type metric
Data type int.number.value
action_app_custom_event.other
Display name Other mobile app actions
Field type metric
Data type int.number.value
action_app_engagement
Display name Desktop app engagements
Field type metric
Data type int.number.value
action_app_install
Display name Desktop app installs
Field type metric
Data type int.number.value
action_app_story
Display name Desktop app story engagements
Field type metric
Data type int.number.value
action_app_use
Display name Desktop app uses
Field type metric
Data type int.number.value
action_checkin
Display name Check-ins
Field type metric
Data type int.number.value
action_comment
Display name Post comments
Field type metric
Data type int.number.value
action_credit_spent
Display name Credit spends
Field type metric
Data type int.number.value
action_follow
Display name Question follows
Description Please note that this field will be removed on 2017-04-18
Field type metric
Data type int.number.value
action_games.plays
Display name Game plays
Field type metric
Data type int.number.value
action_gift_sale
Display name Gift sales
Description Please note that this field will be removed on 2017-04-18
Field type metric
Data type int.number.value
action_leadgen.other
Display name Leads (form)
Description Please note that this field will be removed on 2020-03-25
Field type metric
Data type int.number.value
action_like
Display name Page likes
Field type metric
Data type int.number.value
action_link_click
Display name Link clicks
Field type metric
Data type int.number.value
action_mobile_app_install
Display name Mobile app installs
Field type metric
Data type int.number.value
action_page_engagement
Display name Page engagements
Field type metric
Data type int.number.value
action_photo_view
Display name Photo views
Field type metric
Data type int.number.value
action_post
Display name Post shares
Field type metric
Data type int.number.value
action_post_engagement
Display name Post engagements
Field type metric
Data type int.number.value
action_post_like
Display name Post reactions
Field type metric
Data type int.number.value
action_receive_offer
Display name Offer claims
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
action_rsvp
Display name Event responses
Field type metric
Data type int.number.value
action_value_app_custom_event.fb_mobile_purchase
Display name Mobile app purchases conversion value
Field type metric
Data type float.currency.value
action_value_app_custom_event.fb_mobile_spent_credits
Display name Mobile app credits spent conversion value
Field type metric
Data type float.currency.value
action_video_play
Display name Clicks to play video
Field type metric
Data type int.number.value
action_video_view
Display name Three-second video views
Field type metric
Data type int.number.value
Actions
Display name Actions
Field type metric
Data type int.number.value
actionvalue
Display name Total action value
Field type metric
Data type float.currency.value
ad_id
Display name Ad ID
Description The unique ID of the ad that you're viewing in reporting
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad that you're viewing in the report
Field type dimension
Data type string.text.value
adbid_info
Display name Ad bid info
Field type dimension
Data type string.text.value
adcampaign_id
Display name Campaign ID
Description The unique ID number of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adcampaign_name
Display name Campaign name
Description The name of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adconfigured_status
Display name Ad configured status
Field type dimension
Data type string.text.value
adset_id
Display name Ad set ID
Description The unique ID of the ad set you're viewing in reports
Field type dimension
Data type string.text.value
adset_name
Display name Ad set name
Description The name of the ad set that you're viewing in reporting
Field type dimension
Data type string.text.value
adsetbudget_remaining
Display name Ad set budget remaining
Field type dimension
Data type float.currency.value
adsetconfigured_status
Display name Ad set configured status
Field type dimension
Data type string.text.value
adsetdaily_budget
Display name Ad set daily budget
Field type dimension
Data type float.currency.value
adsetend_time
Display name Ad set end time
Field type dimension
Data type string.time.date
adsetlifetime_budget
Display name Ad set lifetime budget
Field type dimension
Data type float.currency.value
adsetstart_time
Display name Ad set start time
Field type dimension
Data type string.time.date
adsetstatus
Display name Ad set status
Field type dimension
Data type string.text.value
adstatus
Display name Ad status
Field type dimension
Data type string.text.value
bidamount
Display name Bid amount
Field type dimension
Data type float.currency.value
bidinfo
Display name Bid info
Field type dimension
Data type string.text.value
bidtype
Display name Bid type
Field type dimension
Data type string.text.value
campaign_end_date
Display name Campaign end date
Field type dimension
Data type string.time.date
campaign_start_date
Display name Campaign start date
Field type dimension
Data type string.time.date
campaignbuyingtype
Display name Campaign buying type
Description 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
Field type dimension
Data type string.text.value
campaignconfigured_status
Display name Campaign configured status
Field type dimension
Data type string.text.value
campaignobjective
Display name Campaign objective
Description The objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising
Field type dimension
Data type string.text.value
campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
Clicks
Display name Clicks (all)
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
cost_eur
Display name Cost (EUR)
Description Advertising cost converted to euros
Field type metric
Data type float.currency.value
cost_gbp
Display name Cost (GBP)
Description Advertising cost in your account currency
Field type metric
Data type float.currency.value
cost_usd
Display name Cost (USD)
Description Advertising cost converted to US dollars
Field type metric
Data type float.currency.value
creative_body
Display name Ad body
Field type dimension
Data type string.text.value
creative_call_to_action_type
Display name Ad call_to_action type
Field type dimension
Data type string.text.value
creative_image_url
Display name Ad creative image URL
Field type dimension
Data type string.text.url
creative_link_url
Display name Internal destination URL
Field type dimension
Data type string.text.url
creative_name
Display name Creative name
Field type dimension
Data type string.text.value
creative_object_type
Display name Ad creative object type
Field type dimension
Data type string.text.value
creative_object_url
Display name External destination URL
Field type dimension
Data type string.text.url
creative_template_url
Display name Tracking template URL
Field type dimension
Data type string.text.url
creative_thumbnail_url
Display name Ad creative thumbnail URL
Field type dimension
Data type string.text.url
creative_title
Display name Creative title
Field type dimension
Data type string.text.value
creative_url_tags
Display name Ad url tags
Field type dimension
Data type string.text.value
currency
Display name Currency
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
destinationURL
Display name Destination URL
Field type dimension
Data type string.text.url
estimated_ad_recallers
Display name Estimated ad recall lift (people)
Description An estimate of the number of additional people who may remember seeing your ads, if asked, within 2 days. This metric is only available for assets in the Brand Awareness Objective
Field type metric
Data type int.number.value
estimated_ad_recallers_lower_bound
Display name Estimated ad recall lift (lower bound)
Description Please note that this field will be removed on 2024-03-25
Field type metric
Data type int.number.value
estimated_ad_recallers_upper_bound
Display name Estimated ad recall lift (upper bound)
Description Please note that this field will be removed on 2024-03-25
Field type metric
Data type int.number.value
impression_device
Display name Impression device
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of times your ads were on screen
Field type metric
Data type int.number.value
landing_page_views
Display name Landing page views
Field type metric
Data type int.number.value
offline_conversions_leads
Display name Offline leads
Field type metric
Data type int.number.value
offline_other_conversion
Display name Offline other conversions
Field type metric
Data type int.number.value
offsite_conversion_value
Display name Website conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_add_payment_info
Display name Website adds of payment info conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_add_to_cart
Display name Website adds to cart conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_add_to_wishlist
Display name Website adds to wishlist conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_complete_registration
Display name Website registrations completed conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_custom
Display name Website custom conversions value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_initiate_checkout
Display name Website checkouts initiated conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_lead
Display name Website leads conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_purchase
Display name Website purchases conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_search
Display name Website searches conversion value
Field type metric
Data type float.currency.value
offsite_conversion_value_fb_pixel_view_content
Display name Website content views conversion value
Field type metric
Data type float.currency.value
offsite_conversions
Display name Website conversions
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_add_payment_info
Display name Website adds of payment info
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_add_to_cart
Display name Website adds to cart
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_add_to_wishlist
Display name Website adds to wishlist
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_complete_registration
Display name Website registrations completed
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_custom
Display name Website custom conversions
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_initiate_checkout
Display name Website checkouts initiated
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_lead
Display name Website leads
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_purchase
Display name Website purchases
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_search
Display name Website searches
Field type metric
Data type int.number.value
offsite_conversions_fb_pixel_view_content
Display name Website content views
Field type metric
Data type int.number.value
onsite_conversion.lead_grouped
Display name On-Facebook leads
Field type metric
Data type int.number.value
outbound_clicks
Display name Outbound clicks
Description The number of clicks on links that take people off Facebook-owned properties
Field type metric
Data type int.number.value
platform_position
Display name Platform position
Field type dimension
Data type string.text.value
post_save
Display name Post Saves
Field type metric
Data type int.number.value
promoted_post_caption
Display name Promoted post caption
Field type dimension
Data type string.text.value
promoted_post_created_time
Display name Promoted post created date
Field type dimension
Data type string.time.date
promoted_post_description
Display name Promoted post description
Field type dimension
Data type string.text.value
promoted_post_destination_url
Display name Promoted post destination URL
Field type dimension
Data type string.text.url
promoted_post_full_picture
Display name Promoted post image URL
Field type dimension
Data type string.text.url
promoted_post_icon
Display name Promoted post icon
Field type dimension
Data type string.text.value
promoted_post_id
Display name Promoted post ID
Field type dimension
Data type string.text.value
promoted_post_id_ig
Display name Promoted post Instagram ID
Field type dimension
Data type string.text.value
promoted_post_message
Display name Promoted post message
Field type dimension
Data type string.text.value
promoted_post_name
Display name Promoted post name
Field type dimension
Data type string.text.value
promoted_post_permalink_url
Display name Link to promoted post
Field type dimension
Data type string.text.url
promoted_post_permalink_url_ig
Display name Link to promoted Instagram post
Field type dimension
Data type string.text.url
promoted_post_picture
Display name Promoted post thumbnail URL
Field type dimension
Data type string.text.url
promoted_post_privacy
Display name Promoted post privacy
Field type dimension
Data type string.text.value
promoted_post_privacy_description
Display name Promoted post privacy description
Field type dimension
Data type string.text.value
promoted_post_source
Display name Promoted post source
Field type dimension
Data type string.text.value
promoted_post_story
Display name Promoted post story
Field type dimension
Data type string.text.value
promoted_post_type
Display name Promoted post type
Field type dimension
Data type string.text.value
publisher_platform
Display name Publisher platform
Description Distinguishes between platforms like Facebook and Instagram
Field type dimension
Data type string.text.value
reach
Display name Reach
Description 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
Field type metric
Data type int.number.value
reach28d
Display name Reach (28d)
Description The number of people who saw your ads at least once in the last 28 days. Reach is different from impressions, which may include multiple views of your ads by the same people
Field type metric
Data type int.number.value
reach7d
Display name Reach (7 days)
Description The number of people who saw your ads at least once in the last 7 days. Reach is different from impressions, which may include multiple views of your ads by the same people
Field type metric
Data type int.number.value
spend_cap
Display name Account spend cap
Field type dimension
Data type float.currency.value
timezone_id
Display name Account timezone ID
Field type dimension
Data type string.text.value
unique_action_comment
Display name Unique post comments
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_follow
Display name Unique question follows
Description Please note that this field will be removed on 2017-04-18
Field type metric
Data type int.number.value
unique_action_like
Display name Unique page likes
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_link_click
Display name Unique link clicks
Field type metric
Data type int.number.value
unique_action_page_engagement
Display name Unique page engagements
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_photo_view
Display name Unique photo views
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_post
Display name Unique post shares
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_post_engagement
Display name Unique post engagements
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_post_reaction
Display name Unique post reactions
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_video_play
Display name Unique clicks to play video
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_action_video_view
Display name Unique three-second video views
Description Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
unique_inline_link_clicks
Display name Unique inline link clicks
Description The number of people who performed an inline link click
Field type metric
Data type int.number.value
unique_outbound_clicks
Display name Unique outbound clicks
Description The number of people who performed an outbound click
Field type metric
Data type int.number.value
UniqueActions
Display name People taking action
Description The number of people who took an action that was attributed to your ads. Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value
UniqueClicks
Display name Unique clicks (all)
Field type metric
Data type int.number.value
utm_campaign
Display name Campaign (utm)
Description Value of the utm_campaign parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_content
Display name Content (utm)
Description Value of the utm_content parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_medium
Display name Medium (utm)
Description Value of the utm_medium parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_source
Display name Source (utm)
Description Value of the utm_source parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_term
Display name Term (utm)
Description Value of the utm_term parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value

Table: VIDEO

AccountID_fromFA
Display name Account ID
Description The ID number of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
Accountname_fromFA
Display name Account name
Description The name of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
action_video_view
Display name Three-second video views
Field type metric
Data type int.number.value
ad_id
Display name Ad ID
Description The unique ID of the ad that you're viewing in reporting
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad that you're viewing in the report
Field type dimension
Data type string.text.value
adcampaign_id
Display name Campaign ID
Description The unique ID number of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adcampaign_name
Display name Campaign name
Description The name of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adset_id
Display name Ad set ID
Description The unique ID of the ad set you're viewing in reports
Field type dimension
Data type string.text.value
adset_name
Display name Ad set name
Description The name of the ad set that you're viewing in reporting
Field type dimension
Data type string.text.value
adstatus
Display name Ad status
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
platform_position
Display name Platform position
Field type dimension
Data type string.text.value
publisher_platform
Display name Publisher platform
Description Distinguishes between platforms like Facebook and Instagram
Field type dimension
Data type string.text.value
video_10_sec_watched_actions
Display name Ten-second video views
Description The number of times your video was watched for an aggregate of at least 10 seconds, or for nearly its total length, whichever happened first. Please note that this field will be removed on 2020-01-20
Field type metric
Data type int.number.value
video_15_sec_watched_actions
Display name 15-second video views (Deprecated)
Description Please note that this field will be removed on 2018-07-30
Field type metric
Data type int.number.value
video_30_sec_watched_actions
Display name 30-second video views
Description The number of times your video was watched for an aggregate of at least 30 seconds, or for nearly its total length, whichever happened first
Field type metric
Data type int.number.value
video_average_watch_time
Display name Video average watch time
Description The average time a video was played in seconds, including any time spent replaying the video for a single impression. As this contains replays, the watch time may be longer than the actual video length
Field type metric
Data type float.number.value
video_p100_watched_actions
Display name Video watches at 100%
Description The number of times your video was watched at 100% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
video_p25_watched_actions
Display name Video watches at 25%
Description The number of times your video was watched at 25% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
video_p50_watched_actions
Display name Video watches at 50%
Description The number of times your video was watched at 50% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
video_p75_watched_actions
Display name Video watches at 75%
Description The number of times your video was watched at 75% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
video_p95_watched_actions
Display name Video watches at 95%
Description The number of times your video was watched at 95% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
video_thruplay_watched_actions
Display name ThruPlay actions
Description The number of times your video was played to completion, or for at least 15 seconds
Field type metric
Data type int.number.value

Table: CAMPAIGN

account_status
Display name Account status
Field type dimension
Data type string.text.value
AccountID_fromFA
Display name Account ID
Description The ID number of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
Accountname_fromFA
Display name Account name
Description The name of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
adcampaign_id
Display name Campaign ID
Description The unique ID number of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adcampaign_name
Display name Campaign name
Description The name of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
campaign_budget_remaining
Display name Campaign budget remaining
Field type dimension
Data type float.currency.value
campaign_daily_budget
Display name Campaign daily budget
Field type dimension
Data type float.currency.value
campaign_end_date
Display name Campaign end date
Field type dimension
Data type string.time.date
campaign_lifetime_budget
Display name Campaign lifetime budget
Field type dimension
Data type float.currency.value
campaign_start_date
Display name Campaign start date
Field type dimension
Data type string.time.date
campaignbuyingtype
Display name Campaign buying type
Description 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
Field type dimension
Data type string.text.value
campaignconfigured_status
Display name Campaign configured status
Field type dimension
Data type string.text.value
campaignobjective
Display name Campaign objective
Description The objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising
Field type dimension
Data type string.text.value
campaignspend_cap
Display name Campaign spending limit
Field type dimension
Data type float.currency.value
campaignstatus
Display name Campaign status
Field type dimension
Data type string.text.value
cost
Display name Cost
Field type metric
Data type float.currency.value
cost_eur
Display name Cost (EUR)
Description Advertising cost converted to euros
Field type metric
Data type float.currency.value
cost_gbp
Display name Cost (GBP)
Description Advertising cost in your account currency
Field type metric
Data type float.currency.value
cost_usd
Display name Cost (USD)
Description Advertising cost converted to US dollars
Field type metric
Data type float.currency.value
currency
Display name Currency
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
platform_position
Display name Platform position
Field type dimension
Data type string.text.value
publisher_platform
Display name Publisher platform
Description Distinguishes between platforms like Facebook and Instagram
Field type dimension
Data type string.text.value
reach
Display name Reach
Description 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
Field type metric
Data type int.number.value
spend_cap
Display name Account spend cap
Field type dimension
Data type float.currency.value
store_visits_point_estimate
Display name Store visits point estimate
Description This field is still being developed by Facebook and as such it might not return any data. Please note that this field will be removed on 2021-05-01
Field type metric
Data type int.number.value

Table: CONVERSION

AccountID_fromFA
Display name Account ID
Description The ID number of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
Accountname_fromFA
Display name Account name
Description The name of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
ActionDevice
Display name Action device
Field type dimension
Data type string.text.value
Actions
Display name Actions
Field type metric
Data type int.number.value
ActionTypeWithCustomLabels
Display name Action type
Description The kind of actions taken on your ad, Page, app or event after your ad was served to someone, even if they didn't click on it. Action types include Page likes, app installs, conversions, event responses and more. Custom conversion types will be listed by their label
Field type dimension
Data type string.text.value
actionvalue
Display name Total action value
Field type metric
Data type float.currency.value
ad_id
Display name Ad ID
Description The unique ID of the ad that you're viewing in reporting
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad that you're viewing in the report
Field type dimension
Data type string.text.value
adcampaign_id
Display name Campaign ID
Description The unique ID number of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adcampaign_name
Display name Campaign name
Description The name of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adset_id
Display name Ad set ID
Description The unique ID of the ad set you're viewing in reports
Field type dimension
Data type string.text.value
adset_name
Display name Ad set name
Description The name of the ad set that you're viewing in reporting
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
destinationURL
Display name Destination URL
Field type dimension
Data type string.text.url
publisher_platform
Display name Publisher platform
Description Distinguishes between platforms like Facebook and Instagram
Field type dimension
Data type string.text.value
UniqueActions
Display name People taking action
Description The number of people who took an action that was attributed to your ads. Please note that this field will be removed on 2024-10-30
Field type metric
Data type int.number.value

Table: GEO

AccountID_fromFA
Display name Account ID
Description The ID number of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
Accountname_fromFA
Display name Account name
Description The name of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
action_leadgen.other
Display name Leads (form)
Description Please note that this field will be removed on 2020-03-25
Field type metric
Data type int.number.value
action_link_click
Display name Link clicks
Field type metric
Data type int.number.value
action_video_view
Display name Three-second video views
Field type metric
Data type int.number.value
ad_id
Display name Ad ID
Description The unique ID of the ad that you're viewing in reporting
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad that you're viewing in the report
Field type dimension
Data type string.text.value
adcampaign_id
Display name Campaign ID
Description The unique ID number of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adcampaign_name
Display name Campaign name
Description The name of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adset_id
Display name Ad set ID
Description The unique ID of the ad set you're viewing in reports
Field type dimension
Data type string.text.value
adset_name
Display name Ad set name
Description The name of the ad set that you're viewing in reporting
Field type dimension
Data type string.text.value
adsetstatus
Display name Ad set status
Field type dimension
Data type string.text.value
campaignobjective
Display name Campaign objective
Description The objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising
Field type dimension
Data type string.text.value
Clicks
Display name Clicks (all)
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
cost_eur
Display name Cost (EUR)
Description Advertising cost converted to euros
Field type metric
Data type float.currency.value
cost_gbp
Display name Cost (GBP)
Description Advertising cost in your account currency
Field type metric
Data type float.currency.value
cost_usd
Display name Cost (USD)
Description Advertising cost converted to US dollars
Field type metric
Data type float.currency.value
Country
Display name Country code
Field type dimension
Data type string.geo.country.twolettercode
Countryname
Display name Country
Field type dimension
Data type string.geo.country
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description The number of times your ads were on screen
Field type metric
Data type int.number.value
onsite_conversion.lead_grouped
Display name On-Facebook leads
Field type metric
Data type int.number.value
reach
Display name Reach
Description 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
Field type metric
Data type int.number.value
Region
Display name Region
Field type dimension
Data type string.geo.region

Table: AGE_GENDER

AccountID_fromFA
Display name Account ID
Description The ID number of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
Accountname_fromFA
Display name Account name
Description The name of your ad account, which groups your advertising activity
Field type dimension
Data type string.text.value
action_leadgen.other
Display name Leads (form)
Description Please note that this field will be removed on 2020-03-25
Field type metric
Data type int.number.value
action_video_view
Display name Three-second video views
Field type metric
Data type int.number.value
ad_id
Display name Ad ID
Description The unique ID of the ad that you're viewing in reporting
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad that you're viewing in the report
Field type dimension
Data type string.text.value
adcampaign_id
Display name Campaign ID
Description The unique ID number of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adcampaign_name
Display name Campaign name
Description The name of the advertising campaign that you're viewing in reporting
Field type dimension
Data type string.text.value
adset_id
Display name Ad set ID
Description The unique ID of the ad set you're viewing in reports
Field type dimension
Data type string.text.value
adset_name
Display name Ad set name
Description The name of the ad set that you're viewing in reporting
Field type dimension
Data type string.text.value
adsetstatus
Display name Ad set status
Field type dimension
Data type string.text.value
Age
Display name Age
Field type dimension
Data type string.person.age
campaignobjective
Display name Campaign objective
Description The objective you selected for your campaign. Your objective reflects the goal you want to achieve with your advertising
Field type dimension
Data type string.text.value
Clicks
Display name Clicks (all)
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
cost_eur
Display name Cost (EUR)
Description Advertising cost converted to euros
Field type metric
Data type float.currency.value
cost_gbp
Display name Cost (GBP)
Description Advertising cost in your account currency
Field type metric
Data type float.currency.value
cost_usd
Display name Cost (USD)
Description Advertising cost converted to US dollars
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Gender
Display name Gender
Field type dimension
Data type string.person.gender
impressions
Display name Impressions
Description The number of times your ads were on screen
Field type metric
Data type int.number.value
onsite_conversion.lead_grouped
Display name On-Facebook leads
Field type metric
Data type int.number.value
reach
Display name Reach
Description 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
Field type metric
Data type int.number.value