Google Ads Performance Report

Google Ads Reporting with Date Preset

{"name":"Google Ads Reporting - Date Preset","description":"A blank recipe","nodes":{"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1180,"y":313,"inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/segments/date","B":"/campaign/name","C":"/adGroup/name","D":"/metrics/cost","E":"/metrics/conversionsValue","F":"/metrics/clicks","G":"/metrics/impressions","H":"/metrics/conversions","I":"/source"}},"schema":{"export_enabled":true,"data":"any_list"}}},"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"x":942,"y":313,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/source","value":"Google"},{"op":"cast","path":"/metrics/costMicros","value":"integer"},{"op":"add","path":"/metrics/cost","value":"{{divide(inputData(\"/metrics/costMicros\"),1000000)}}"}]},"value":{"export_enabled":true}}},"input_any_1":{"type":"input_any","title":"Input Any - SELECT","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":512,"y":132,"group":"group_1","inputs":{"any":{"title":"metrics","description":"The any to input","export_enabled":true,"data":"campaign.name, ad_group.name, segments.date, customer.id, metrics.impressions, metrics.conversions, metrics.clicks, metrics.cost_micros, metrics.conversions_value"}}},"replace_string_1":{"type":"replace_string","title":"Replace String","description":"Replaces string or regex with an other string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1018,"y":118,"group":"group_1","inputs":{"regex":{"export_enabled":true,"data":"my_metrics"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"},"data":{"export_enabled":true,"data":"SELECT my_metrics FROM table WHERE dates AND metrics.cost_micros \u003e 0"}}},"replace_string_2":{"type":"replace_string","title":"Replace String","description":"Replaces string or regex with an other string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1076,"y":292,"group":"group_2","inputs":{"regex":{"export_enabled":true,"data":"table"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}}},"stop_1":{"type":"stop","logging_enabled":false,"x":2273,"y":674,"inputs":{"stop":{"export_enabled":true}}},"start_1":{"type":"start","logging_enabled":false,"x":11,"y":123},"delay_to_1":{"type":"delay_to","logging_enabled":false,"x":155,"y":52,"inputs":{"weekdays":{"export_enabled":true,"data":["Monday","Friday","Sunday","Thursday","Tuesday","Saturday","Wednesday"]},"time":{"export_enabled":true,"data":"08:00:00+02:00"}}},"google_ads_search_1":{"type":"google_ads_search","title":"Search GoogleAds - Main Query","description":"Run search querys on multiple ad accounts","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":694,"y":317,"outputs":{"searched":{"title":"searched","description":"Searched stream"}}},"google_ads_select_ad_account_ids_1":{"type":"google_ads_select_ad_account_ids","logging_enabled":false,"x":498,"y":87,"inputs":{"ad_account_ids":{"export_enabled":true}}},"replace_string_3":{"type":"replace_string","title":"Replace String - Full Query","description":"Replaces string or regex with an other string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1191,"y":316,"group":"group_3","inputs":{"regex":{"export_enabled":true,"data":"dates"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}}},"replace_string_4":{"type":"replace_string","logging_enabled":false,"x":666,"y":494,"group":"group_4","inputs":{"regex":{"export_enabled":true,"data":"date_preset"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"},"data":{"export_enabled":true,"data":"segments.date DURING date_preset"}}},"input_any_2":{"type":"input_any","title":"Input Any - WHERE","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":968,"y":537,"group":"group_4"},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":964,"y":77,"group":"group_5","inputs":{"range":{"export_enabled":true,"data":"data"},"spreadsheet_id":{"export_enabled":true}}},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"x":1351,"y":331,"group":"group_5"},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1747,"y":223,"group":"group_5","inputs":{"range":{"export_enabled":true,"data":"data"}}},"input_string_1":{"type":"input_string","title":"Input String - Date Preset","description":"Allows to input a string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":315,"y":544,"group":"group_4","inputs":{"string":{"title":"date_preset","description":"A string to input","export_enabled":true,"data":"YESTERDAY"}}},"input_string_2":{"type":"input_string","title":"Input String: From","description":"Allows to input a string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":709,"y":391,"group":"group_2","inputs":{"string":{"title":"from","description":"A string to input","export_enabled":true,"data":"ad_group"}}}},"edges":["patch_json_list_v3_1.patched:map_any_to_table_rows_1.map","map_any_to_table_rows_1.mapped:google_sheets_clear_table_rows_v3_1.clear","google_ads_search_1.searched:patch_json_list_v3_1.patch","google_ads_search_1.result:patch_json_list_v3_1.data_list","patch_json_list_v3_1.data_list:map_any_to_table_rows_1.data","replace_string_4.replaced:replace_string_1.replace","replace_string_1.replaced:replace_string_2.replace","replace_string_1.data:replace_string_2.data","replace_string_4.data:input_any_2.any","replace_string_3.replaced:google_ads_search_1.search","input_any_1.any:replace_string_1.value","replace_string_2.replaced:replace_string_3.replace","replace_string_2.data:replace_string_3.data","input_any_2.any:replace_string_3.value","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","start_1.start:delay_to_1.start","google_sheets_append_table_rows_v3_1.appended:delay_to_1.start","google_ads_select_ad_account_ids_1.ad_account_ids:google_ads_search_1.ad_account_ids","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.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_clear_table_rows_v3_1.range","google_sheets_clear_table_rows_v3_1.cleared:google_sheets_append_table_rows_v3_1.append","delay_to_1.delayed:replace_string_4.replace","input_string_2.string:replace_string_2.value","input_string_1.string:replace_string_4.value","replace_string_3.data:google_ads_search_1.query"],"groups":{"group_3":{"title":"Query Builder","description":"","x":385,"y":341,"inputs":["replace_string_4.replace"],"outputs":["replace_string_3.replaced","replace_string_3.data"]},"group_5":{"title":"Update Spreadsheet","description":"","x":1430,"y":419,"inputs":["google_sheets_clear_table_rows_v3_1.clear","google_sheets_append_table_rows_v3_1.rows"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_2":{"title":"Select data table","description":"","x":844,"y":280,"group":"group_3","inputs":["replace_string_2.data","replace_string_2.replace","input_string_2.string"],"outputs":["replace_string_2.data","replace_string_2.replaced"]},"group_1":{"title":"Select Metrics","description":"","x":553,"y":280,"group":"group_3","inputs":["replace_string_1.replace","input_any_1.any"],"outputs":["replace_string_1.data","replace_string_1.replaced"]},"group_4":{"title":"Create conditions","description":"","x":259,"y":280,"group":"group_3","inputs":["replace_string_4.replace","input_string_1.string"],"outputs":["replace_string_4.replaced","input_any_2.any"]}},"widgets":{"widget_1":{"title":"Metrics","description":"Enter the metrics (separated by a comma) you want to request.","position":5,"icon":"las la-chart-bar","input":"input_any_1.any"},"widget_2":{"title":"Mapping","description":"Choose what value should be output into what column.","position":10,"icon":"las la-table","input":"map_any_to_table_rows_1.mapping"},"widget_3":{"title":"Ad Accounts","description":"Select one or more GoogleAds Accounts","position":2,"input":"google_ads_select_ad_account_ids_1.ad_account_ids"},"widget_4":{"title":"Spreadsheet","description":"Select a spreadsheet.","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_5":{"title":"Lookback","description":"Choose a lookback window.","position":3,"icon":"las la-calendar","options":[{"data":"YESTERDAY","title":"Yesterday"},{"data":"LAST_7_DAYS","title":"Last 7 Days"},{"data":"LAST_30_DAYS","title":"Last 30 Days"}],"input":"input_string_1.string"},"widget_6":{"title":"Level","description":"Choose the level of your report. Make sure to adapt the metrics accordingly.","position":4,"icon":"las la-level-up-alt","options":[{"data":"ad_group","title":"AdGroup"},{"data":"campaign","title":"Campaign"}],"input":"input_string_2.string"},"widget_7":{"title":"Tab","description":"Select a tab or enter the range in A1 notation, e.g. Sheet!A2:Z.","position":1,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"}},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

Google Ads Reporting with Date Range

{"name":"Google Ads Reporting - Date Range","description":"A blank recipe","nodes":{"input_any_1":{"type":"input_any","title":"Input Any - Start Date","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":325,"y":80,"group":"group_1","inputs":{"any":{"export_enabled":true,"data":"2022-12-15"}}},"input_any_2":{"type":"input_any","title":"Input Any - End Date","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":327,"y":422,"group":"group_1","inputs":{"any":{"export_enabled":true,"data":"2022-12-18"}}},"replace_string_1":{"type":"replace_string","logging_enabled":false,"x":613,"y":160,"group":"group_1","inputs":{"regex":{"export_enabled":true,"data":"start_date"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"any"},"data":{"export_enabled":true,"data":"segments.date \u003e= 'start_date' AND segments.date \u003c= 'end_date' AND metrics.cost_micros \u003e 0"}}},"replace_string_2":{"type":"replace_string","logging_enabled":false,"x":970,"y":160,"group":"group_1","inputs":{"regex":{"export_enabled":true,"data":"end_date"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"x":1180,"y":313,"inputs":{"add_header":{"export_enabled":true,"data":true},"mapping":{"export_enabled":true,"data":{"A":"/segments/date","B":"/campaign/name","C":"/adGroup/name","D":"/metrics/cost","E":"/metrics/conversionsValue","F":"/metrics/clicks","G":"/metrics/impressions","H":"/metrics/conversions","I":"/source"}},"schema":{"export_enabled":true,"data":"any_list"}}},"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"x":942,"y":313,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/source","value":"Google"},{"op":"cast","path":"/metrics/costMicros","value":"integer"},{"op":"add","path":"/metrics/cost","value":"{{divide(inputData(\"/metrics/costMicros\"),1000000)}}"}]},"value":{"export_enabled":true}}},"input_any_3":{"type":"input_any","title":"Input Any - SELECT","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":512,"y":132,"group":"group_2","inputs":{"any":{"title":"metrics","description":"The any to input","export_enabled":true,"data":"campaign.name, ad_group.name, segments.date, customer.id, metrics.impressions, metrics.conversions, metrics.clicks, metrics.cost_micros, metrics.conversions_value"}}},"replace_string_3":{"type":"replace_string","title":"Replace String","description":"Replaces string or regex with an other string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1018,"y":118,"group":"group_2","inputs":{"regex":{"export_enabled":true,"data":"my_metrics"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"},"data":{"export_enabled":true,"data":"SELECT my_metrics FROM table WHERE dates AND metrics.cost_micros \u003e 0"}}},"replace_string_4":{"type":"replace_string","title":"Replace String","description":"Replaces string or regex with an other string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1076,"y":292,"group":"group_3","inputs":{"regex":{"export_enabled":true,"data":"table"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}}},"stop_1":{"type":"stop","logging_enabled":false,"x":2273,"y":674,"inputs":{"stop":{"export_enabled":true}}},"start_1":{"type":"start","logging_enabled":false,"x":11,"y":123},"delay_to_1":{"type":"delay_to","logging_enabled":false,"x":155,"y":52,"inputs":{"weekdays":{"export_enabled":true,"data":["Monday","Friday","Sunday","Thursday","Tuesday","Saturday","Wednesday"]},"time":{"export_enabled":true,"data":"08:00:00+02:00"}}},"google_ads_search_1":{"type":"google_ads_search","title":"Search GoogleAds - Main Query","description":"Run search querys on multiple ad accounts","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":694,"y":317,"outputs":{"searched":{"title":"searched","description":"Searched stream"}}},"google_ads_select_ad_account_ids_1":{"type":"google_ads_select_ad_account_ids","logging_enabled":false,"x":498,"y":87,"inputs":{"ad_account_ids":{"export_enabled":true}}},"google_sheets_select_spreadsheet_id_v2_1":{"type":"google_sheets_select_spreadsheet_id_v2","logging_enabled":false,"x":964,"y":77,"group":"group_4","inputs":{"range":{"export_enabled":true,"data":"data"},"spreadsheet_id":{"export_enabled":true}}},"google_sheets_clear_table_rows_v3_1":{"type":"google_sheets_clear_table_rows_v3","logging_enabled":false,"x":1351,"y":331,"group":"group_4"},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"x":1747,"y":223,"group":"group_4","inputs":{"range":{"export_enabled":true,"data":"data"}}},"input_string_1":{"type":"input_string","title":"Input String: From","description":"Allows to input a string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":709,"y":391,"group":"group_3","inputs":{"string":{"title":"from","description":"A string to input","export_enabled":true,"data":"ad_group"}}},"replace_string_5":{"type":"replace_string","title":"Replace String - Full Query","description":"Replaces string or regex with an other string","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":1223,"y":314,"group":"group_5","inputs":{"regex":{"export_enabled":true,"data":"dates"},"pointer":{"export_enabled":true,"data":""},"schema":{"export_enabled":true,"data":"string"}}},"input_any_4":{"type":"input_any","title":"Input Any - WHERE","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"x":576,"y":289,"group":"group_6"}},"edges":["input_any_1.any:replace_string_1.value","replace_string_1.data:replace_string_2.data","input_any_2.any:replace_string_2.value","patch_json_list_v3_1.patched:map_any_to_table_rows_1.map","map_any_to_table_rows_1.mapped:google_sheets_clear_table_rows_v3_1.clear","google_ads_search_1.searched:patch_json_list_v3_1.patch","google_ads_search_1.result:patch_json_list_v3_1.data_list","patch_json_list_v3_1.data_list:map_any_to_table_rows_1.data","replace_string_3.replaced:replace_string_4.replace","replace_string_3.data:replace_string_4.data","replace_string_5.replaced:google_ads_search_1.search","input_any_3.any:replace_string_3.value","replace_string_4.replaced:replace_string_5.replace","replace_string_4.data:replace_string_5.data","input_any_4.any:replace_string_5.value","map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","start_1.start:delay_to_1.start","google_sheets_append_table_rows_v3_1.appended:delay_to_1.start","google_ads_select_ad_account_ids_1.ad_account_ids:google_ads_search_1.ad_account_ids","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.spreadsheet_id:google_sheets_clear_table_rows_v3_1.spreadsheet_id","google_sheets_select_spreadsheet_id_v2_1.range:google_sheets_clear_table_rows_v3_1.range","google_sheets_clear_table_rows_v3_1.cleared:google_sheets_append_table_rows_v3_1.append","input_string_1.string:replace_string_4.value","replace_string_5.data:google_ads_search_1.query","replace_string_2.data:input_any_4.any","replace_string_1.replaced:replace_string_2.replace","replace_string_2.replaced:replace_string_3.replace","delay_to_1.delayed:replace_string_1.replace"],"groups":{"group_1":{"title":"Create date range","description":"","x":278,"y":297,"group":"group_6","inputs":["replace_string_1.replace"],"outputs":["replace_string_2.data","replace_string_2.replaced"]},"group_4":{"title":"Update Spreadsheet","description":"","x":1430,"y":419,"inputs":["google_sheets_clear_table_rows_v3_1.clear","google_sheets_append_table_rows_v3_1.rows"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_3":{"title":"Select data table","description":"","x":933,"y":319,"group":"group_5","inputs":["replace_string_4.data","replace_string_4.replace","input_string_1.string"],"outputs":["replace_string_4.data","replace_string_4.replaced"]},"group_2":{"title":"Select Metrics","description":"","x":642,"y":319,"group":"group_5","inputs":["replace_string_3.replace","input_any_3.any"],"outputs":["replace_string_3.data","replace_string_3.replaced"]},"group_5":{"title":"Build the query","description":"","x":427,"y":323,"inputs":["replace_string_1.replace"],"outputs":["replace_string_5.replaced","replace_string_5.data"]},"group_6":{"title":"Select Conditions","description":"","x":353,"y":319,"group":"group_5","inputs":["replace_string_1.replace"],"outputs":["input_any_4.any","replace_string_2.replaced"]}},"widgets":{"widget_1":{"title":"Start Date","description":"Enter a valid date.\nThe format should be YYYY-MM-DD","position":3,"icon":"las la-calendar","input":"input_any_1.any"},"widget_2":{"title":"End Date","description":"Enter a valid date.\nThe format should be YYYY-MM-DD","position":4,"icon":"las la-calendar","input":"input_any_2.any"},"widget_3":{"title":"Metrics","description":"Enter the metrics (separated by a comma) you want to request.","position":5,"icon":"las la-chart-bar","input":"input_any_3.any"},"widget_4":{"title":"Mapping","description":"Choose what value should be output into what column.","position":10,"icon":"las la-table","input":"map_any_to_table_rows_1.mapping"},"widget_5":{"title":"Ad Accounts","description":"Select one or more GoogleAds Accounts","position":2,"input":"google_ads_select_ad_account_ids_1.ad_account_ids"},"widget_6":{"title":"Spreadsheet","description":"Select a spreadsheet.","position":0,"input":"google_sheets_select_spreadsheet_id_v2_1.spreadsheet_id"},"widget_7":{"title":"Level","description":"Choose the level of your report. Make sure to adapt the metrics accordingly.","position":4,"icon":"las la-level-up-alt","options":[{"data":"ad_group","title":"AdGroup"},{"data":"campaign","title":"Campaign"}],"input":"input_string_1.string"},"widget_8":{"title":"Tab","description":"Select a tab or enter the range in A1 notation, e.g. Sheet!A2:Z.","position":1,"icon":"las la-table","input":"google_sheets_select_spreadsheet_id_v2_1.range"}},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}