Facebook Ads Performance Export
This automation lets you create an easy Facebook Ads Performance report in Google Sheets.
If you are looking to create an easy reporting in Google Sheets that will refresh automatically, then this is an automation for you. This automation is as easy as it gets: Pull data from Facebook, choose the columns and output to a spreadsheet on schedule.
This recipe does not have a user view and can only be used in builder view.
JSON Recipe
Import the automation recipe(s) into your own account. Don’t know how? Learn here.
Click here to show JSON files to import
Facebook Ads Performance Export
{"name":"Facebook Ads Performance Export","description":"fb_insights_export_20220325","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":150,"y":238},"stop_1":{"type":"stop","logging_enabled":false,"x":161,"y":482,"inputs":{"stop":{"export_enabled":true}}},"fb_fetch_insights_v6_1":{"type":"fb_fetch_insights_v6","logging_enabled":false,"x":475,"y":273,"inputs":{"ad_account_ids":{"title":"ad_account_ids","description":"Select one or more Facebook Accounts to retrieve Insights from"},"action_report_time":{"export_enabled":true,"data":"conversion"},"breakdowns":{"export_enabled":true},"action_breakdowns":{"export_enabled":true},"fields":{"export_enabled":true,"data":["account_id","account_name","spend","impressions"]},"use_unified_attribution_setting":{"export_enabled":true,"data":true},"level":{"export_enabled":true,"data":"account"},"action_attribution_windows":{"export_enabled":true,"data":["default"]},"time_increment":{"export_enabled":true,"data":"all_days"},"date_range":{"export_enabled":true,"data":"yesterday"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":828,"y":434,"inputs":{"mapping":{"export_enabled":true,"data":{}},"add_header":{"export_enabled":true,"data":true},"schema":{"export_enabled":true,"data":"fb_insights"}}},"delay_to_1":{"type":"delay_to","logging_enabled":false,"x":159,"y":790,"inputs":{"weekdays":{"export_enabled":true},"time":{"export_enabled":true}}},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"x":1196,"y":407},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1540,"y":528},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":901,"y":116,"inputs":{"range":{"title":"range","description":"The range in A1 notation to fetch"},"spreadsheet_id":{"title":"spreadsheet_id","description":"The spreadsheet to fetch from"}}}},"edges":["fb_fetch_insights_v6_1.insights:map_any_to_table_rows_1.data","fb_fetch_insights_v6_1.fetched:map_any_to_table_rows_1.map","start_1.start:fb_fetch_insights_v6_1.fetch","delay_to_1.delayed:fb_fetch_insights_v6_1.fetch","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_append_table_rows_v3_1.range","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","google_sheets_clear_table_rows_v3_1.cleared:google_sheets_append_table_rows_v3_1.append","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","map_any_to_table_rows_1.mapped:google_sheets_clear_table_rows_v3_1.clear","google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id:google_sheets_append_table_rows_v3_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_clear_table_rows_v3_1.range","google_sheets_append_table_rows_v3_1.appended:delay_to_1.start"],"groups":{},"widgets":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[{"name":"Facebook Ads Performance Export","color":"#DE9597"}]}How To
Step 1
Create a new spreadsheet.
Step 2 - Fetch insights
- Select your Facebook Ad Account
- Select a date range for which you would like to fetch insights and a potential time breakdown.
- Choose the level: Account, Campaign, Adset or Ad.
- Choose fields that you would like to recieve. Any off-site and in-app conversion will be returned when choosing the “actions” field. Values will be returned with “action_values”. Any custom conversions can be found under “conversions”.
For detailed instructions follow this node deep-dive.
Step 3 - Mapping
Map any of the previously fetched data points. Follow this tutorial if you don’t know how that works.
Step 4 - Spreadsheet
- Select a spreadsheet and tab (e.g. Sheet1) or range in A1 notation (e.g. Sheet!A1:Z1)
- If you don’t want to overwrite data, remove the “Clear Spreadsheet Rows” node.
Did this answer your question?
😞
😐
🤩
Last updated on July 25, 2023