Data Source - Facebook Ad Insights

summary

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

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. {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.

Loading Report Templates

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

Field to be inserted