Data Source - Facebook Ad Insights

Prev Next

summary

This is a help page for ETL Configuration for acquiring Facebook Ads results and Data Setting.

Obtaining data from Instagram ads

Instagram ad results can also be obtained from the Data Source Facebook Ad Insights.
If you have any questions about specific acquisition procedures, please contact Customer Success.

constraints

  • Transfers may fail due to access token expiration or other causes.
  • Please use the Facebook Ad Insights Connection Configuration information to re-certify.
  • Access tokens must be re-authenticated every 60 days. You can set up notifications for errors in ETL Configuration and Workflow to notify you when they are due.
  • In the breakdown section, there are items that cannot be specified at the same time.
    The official documentation lists the combinations that can be specified simultaneously.

Setting items

STEP1 Basic settings

item name indispensable default value Contents
Facebook Ad Insights Connection Configuration Yes - Select the previously registered Facebook Ad Insights Connection Configuration that has the necessary permissions for this ETL Configuration.
Ad Account ID Yes - Specify the ad account ID from which you want to retrieve the report.
The ad account ID can be found on the Meta Ads Manager screen.
data-source-facebook-ad-insights-2024-08-29-14-7-0{height="" width=""}
For more information on how to verify your ad account ID, please refer to the official Facebook documentation - Find your Facebook ad account ID number.
Report Type Yes - Select the report you wish to retrieve from the following
  • account
  • campaign
  • adset
  • ad
    		•
    field No - Select the fields to be included in the report to be retrieved.
    You can also load key fields from a template by clicking on Report Template Import.
    For details on each item, please refer to the following official Facebook documents, respectively.
  • ACCOUNT: Official Facebook Documentation - Ad Account, Insights
  • Campaign: Official Facebook Documentation - Campaign Insights
  • adset: Official Facebook Documentation - Ad Set Insights
  • ad: Official Facebook Documentation - Ad Insights
    		•
    breakdown No - Reports can be retrieved by device type and gender.
    List of items that can be obtained
  • ad_format_asset
  • age
  • body_asset
  • call_to_action_asset
  • country
  • description_asset
  • device_platform
  • dma
  • frequency_value
  • gender
  • hourly_stats_aggregated_by_advertiser_time_zone
  • hourly_stats_aggregated_by_audience_time_zone
  • image_asset
  • impression_device
  • link_url_asset
  • place_page_id
  • platform_position
  • product_id
  • publisher_platform
  • region
  • title_asset
  • video_asset
    • For example, if gender is specified, multiple lines of results will be obtained for each breakdown such as male, female, etc.
    For more information on each item, please refer to the official Facebook documentation - Insights API Breakdowns.
    Data acquisition period Yes - Enter the start and end date and time of the data you wish to transfer.
    Please enter in YYYYY-MM-DD format.

    STEP1 Detailed settings

    Click on Advanced Settings to display the configuration items.

    item name indispensable default value Contents
    Attribution Window No no designation
    List of items that can be obtained
  • 1d_view
  • 7d_view
  • 28d_view
  • 1d_click
  • 7d_click
  • 28d_click
    • For more information on each item, please refer to the official Facebook documentation - Ads Action Stats.
    Action Breakdown No no designation
    List of items that can be retrieved
  • action_device</li>
  • action_canvas_component_name
  • action_carousel_card_id
  • action_carousel_card_name
  • action_destination
  • action_reaction
  • action_target_id
  • action_type
  • action_video_sound
  • action_video_type
    • For more information on each item, please refer to the official Facebook documentation - Ads Action Stats.
    Enable integrated attribution settings No validity Check the box to enable integrated attribution.

    Loading Report Templates

    Key fields can be loaded from a template by clicking on Report Template Import.

    If a field has already been set, all of its entries will be overwritten. Please note

    Field to be inserted

    item name remarks
    account_id
    account_name
    campaign_id Inserted when campaign, adset, or ad is selected for the report type.
    campaign_name Inserted when campaign, adset, or ad is selected for the report type.
    adset_id Inserted when adset, ad is selected for report type.
    adset_name Inserted when adset, ad is selected for report type.
    ad_id It is inserted when ad is selected for the report type.
    ad_name It is inserted when ad is selected for the report type.
    actions
    clicks
    conversions
    cpc
    ctr
    date_start
    date_stop
    gender_targeting
    impressions
    inline_link_clicks
    reach
    spend