Rule Template: Change TikTok Ad Status

Rule: Facebook | Ad | Change Status

{"name":"Rule Template: Change TikTok Ad Status","description":"A blank recipe","nodes":{"tik_tok_select_ad_account_ids_1":{"type":"tik_tok_select_ad_account_ids","logging_enabled":false,"error_rules":[],"x":27,"y":127,"group":"group_1"},"tik_tok_fetch_reports_v2_1":{"type":"tik_tok_fetch_reports_v2","logging_enabled":false,"error_rules":[],"x":982,"y":437,"group":"group_1","inputs":{"date_range":{"export_enabled":true,"data":"last_3d"},"dimensions":{"export_enabled":true,"data":["ad_id"]},"metrics":{"export_enabled":true,"data":["spend","impressions","anchor_clicks","clicks","cpc","ctr","ad_name","advertiser_id","adgroup_id","campaign_id","cpm","complete_payment_roas","value_per_complete_payment","complete_payment"]},"data_level":{"export_enabled":true,"data":"AUCTION_AD"},"service_type":{"export_enabled":true,"data":"AUCTION"},"report_type":{"export_enabled":true,"data":"BASIC"}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":11,"y":595},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":27,"y":664},"delay_to_1":{"type":"delay_to","logging_enabled":false,"error_rules":[],"x":158,"y":516,"inputs":{"weekdays":{"export_enabled":true,"data":["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]},"time":{"export_enabled":true,"data":"07:00:00+00:00"}}},"filter_v2_1":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":721,"y":253,"group":"group_2","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"\u003e","pointer":"/spend","value":100}]}}},"patch_json_v3_1":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1690,"y":337,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/0/text/text","value":"Ad ID: {{inputValue(\"/ad_id\")}}\nSpend: {{inputValue(\"/spend\")}}\n\nAd Account ID: {{inputValue(\"/advertiser_id\")}}\nCampaign ID: {{inputValue(\"/campaign_id\")}}\nAdgroup ID: {{inputValue(\"/adgroup_id\")}}"}]},"data":{"export_enabled":true,"data":[{"type":"section","text":{"type":"mrkdwn","text":""}}]}}},"slack_notifier_v2_1":{"type":"slack_notifier_v2","logging_enabled":false,"error_rules":[],"x":1057,"y":280,"group":"group_3","inputs":{"thread_ts":{"export_enabled":true},"send":{"title":"send","description":"Sends the message"}}},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":1373,"y":307,"group":"group_3"},"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":406,"y":233,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/rule_name","value":"{{inputValue('/name')}}"},{"op":"add","path":"/timestamp_utc","value":"{{formatTime(timeNow(\"UTC\"), \"%Y-%m-%d %H:%M:%S\")}}"}]}}},"patch_json_v3_2":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":798,"y":281,"group":"group_3","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/0/text/text","value":"Rule applied: {{inputValue('/name')}}"}]},"value":{"title":"rule_name","description":"A value that can be used in patches"},"data":{"export_enabled":true,"data":[{"type":"section","text":{"type":"mrkdwn","text":""}}]}}},"trigger_relay_1":{"type":"trigger_relay","logging_enabled":false,"error_rules":[],"x":1633,"y":687,"group":"group_3"},"slack_select_conversation_id_1":{"type":"slack_select_conversation_id","logging_enabled":false,"error_rules":[],"x":655,"y":79,"group":"group_3","inputs":{"conversation_id":{"export_enabled":true}}},"slack_notifier_v2_2":{"type":"slack_notifier_v2","logging_enabled":false,"error_rules":[],"x":2010,"y":385,"group":"group_3","inputs":{"send":{"title":"send","description":"Sends the message"}}},"map_any_to_table_rows_1":{"type":"map_any_to_table_rows","logging_enabled":false,"error_rules":[],"x":1545,"y":238,"group":"group_4","inputs":{"mapping":{"export_enabled":true,"data":{"A":"/timestamp_utc","B":"/rule_name","C":"/advertiser_id","D":"/campaign_id","E":"/adgroup_id","F":"/ad_id","G":"/action","H":"/spend"}},"add_header":{"export_enabled":true,"data":true},"schema":{"export_enabled":true,"data":"any_list"}}},"data_relay_1":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":228,"y":414,"group":"group_2","inputs":{"data":{"title":"items","description":"Data to relay"}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":254,"y":293,"group":"group_3","inputs":{"b":{"export_enabled":true,"data":[]},"condition":{"export_enabled":true,"data":"not_equal"}}},"patch_json_v3_3":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":976,"y":233,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/timestamp","value":"{{formatTime(timeNow(\"UTC\"), \"%Y-%m-%d %H:%M:%S\")}}"},{"op":"add","path":"/rule_name","value":"{{inputValue('/name')}}"},{"op":"add","path":"/action","value":"Ran rule."}]},"data":{"export_enabled":true,"data":{}}}},"patch_json_v3_4":{"type":"patch_json_v3","logging_enabled":false,"error_rules":[],"x":1250,"y":237,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/-","value":"{{inputValue(\"\")}}"}]}}},"google_sheets_append_table_rows_v3_1":{"type":"google_sheets_append_table_rows_v3","logging_enabled":false,"error_rules":[],"x":1823,"y":239,"group":"group_4","inputs":{"spreadsheet_id":{"export_enabled":true},"range":{"export_enabled":true,"data":"log"}}},"data_relay_2":{"type":"data_relay","logging_enabled":false,"error_rules":[],"x":13,"y":344,"group":"group_3","inputs":{"data":{"title":"items","description":"Data to relay"}}},"fetch_automation_details_1":{"type":"fetch_automation_details","logging_enabled":false,"error_rules":[],"x":535,"y":339,"group":"group_3"},"join_data_1":{"type":"join_data","logging_enabled":false,"error_rules":[],"x":1277,"y":306,"group":"group_1","inputs":{"conditions":{"export_enabled":true,"data":[{"b":"/dimensions/ad_id","a":"/ad_id"}]},"target":{"export_enabled":true,"data":""}}},"filter_v2_2":{"type":"filter_v2","logging_enabled":false,"error_rules":[],"x":1533,"y":305,"group":"group_1","inputs":{"filters":{"export_enabled":true,"data":[{"operator":"!=","pointer":"/metrics/spend","value":0}]}}},"for_each_v2_2":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":218,"y":138,"group":"group_5"},"extract_1":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":710,"y":109,"group":"group_6","inputs":{"pointer":{"export_enabled":true,"data":"/advertiser_id"}}},"parse_string_to_id_1":{"type":"parse_string_to_id","logging_enabled":false,"error_rules":[],"x":660,"y":106,"group":"group_7","inputs":{"schema":{"export_enabled":true,"data":"tik_tok_ad_id"}}},"append_1":{"type":"append","logging_enabled":false,"error_rules":[],"x":969,"y":60,"group":"group_1","inputs":{"flatten":{"export_enabled":true,"data":true},"schema":{"export_enabled":true,"data":"any"}}},"tik_tok_fetch_ads_v2_1":{"type":"tik_tok_fetch_ads_v2","logging_enabled":false,"error_rules":[],"x":727,"y":59,"group":"group_1","inputs":{"operational_status":{"export_enabled":true,"data":"RUNNING"}}},"for_each_v2_3":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":451,"y":58,"group":"group_1"},"patch_json_list_v3_2":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":1782,"y":305,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"move","from":"/metrics/spend","path":"/spend"},{"op":"move","from":"/metrics/impressions","path":"/impressions"},{"op":"move","from":"/metrics/cpc","path":"/cpc"},{"op":"move","from":"/metrics/ctr","path":"/ctr"},{"op":"move","from":"/metrics/cpm","path":"/cpm"},{"op":"move","from":"/metrics/clicks","path":"/clicks"},{"op":"move","from":"/metrics/value_per_complete_payment","path":"/value_per_complete_payment"},{"op":"move","from":"/metrics/complete_payment_roas","path":"/complete_payment_roas"},{"op":"move","from":"/metrics/complete_payment","path":"/complete_payment"}]},"value":{"export_enabled":true}}},"tik_tok_update_ad_status_1":{"type":"tik_tok_update_ad_status","logging_enabled":false,"error_rules":[],"x":992,"y":137,"group":"group_5"},"parse_string_to_id_2":{"type":"parse_string_to_id","logging_enabled":false,"error_rules":[],"x":990,"y":113,"group":"group_6","inputs":{"schema":{"export_enabled":true,"data":"tik_tok_ad_account_id"}}},"extract_2":{"type":"extract_v2","logging_enabled":false,"error_rules":[],"x":409,"y":107,"group":"group_7","inputs":{"pointer":{"export_enabled":true,"data":"/ad_id"}}},"input_string_1":{"type":"input_string","logging_enabled":false,"error_rules":[],"x":638,"y":569,"group":"group_5","inputs":{"string":{"export_enabled":true,"data":"DISBALE"}},"outputs":{"string":{"title":"status","description":"A string to input"}}},"patch_json_list_v3_3":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":709,"y":235,"group":"group_4","inputs":{"patches":{"export_enabled":true,"data":[{"op":"add","path":"/action","value":"Set status to '{{inputValue('')}}'"}]},"value":{"title":"status","description":"A value that can be used in patches"}}},"fetch_automation_details_2":{"type":"fetch_automation_details","logging_enabled":false,"error_rules":[],"x":111,"y":232,"group":"group_4"}},"edges":[{"id":"start_1.start:delay_to_1.start","points":[]},{"id":"slack_notifier_v2_1.sent:for_each_v2_1.start","points":[]},{"id":"slack_notifier_v2_1.thread_ts:slack_notifier_v2_2.thread_ts","points":[]},{"id":"slack_notifier_v2_2.sent:for_each_v2_1.next","points":[]},{"id":"for_each_v2_1.do:patch_json_v3_1.patch","points":[]},{"id":"for_each_v2_1.item:patch_json_v3_1.value","points":[]},{"id":"patch_json_v3_1.patched:slack_notifier_v2_2.send","points":[]},{"id":"if_v2_1.false:trigger_relay_1.relay","points":[]},{"id":"for_each_v2_1.done:trigger_relay_1.relay","points":[]},{"id":"patch_json_v3_1.data:slack_notifier_v2_2.blocks","points":[]},{"id":"map_any_to_table_rows_1.rows:google_sheets_append_table_rows_v3_1.rows","points":[]},{"id":"map_any_to_table_rows_1.mapped:google_sheets_append_table_rows_v3_1.append","points":[]},{"id":"patch_json_list_v3_1.data_list:patch_json_list_v3_3.data_list","points":[]},{"id":"patch_json_list_v3_1.patched:patch_json_list_v3_3.patch","points":[]},{"id":"patch_json_list_v3_3.patched:patch_json_v3_3.patch","points":[]},{"id":"patch_json_list_v3_3.data_list:patch_json_v3_4.data","points":[]},{"id":"patch_json_v3_3.data:patch_json_v3_4.value","points":[]},{"id":"patch_json_v3_3.patched:patch_json_v3_4.patch","points":[]},{"id":"patch_json_v3_4.data:map_any_to_table_rows_1.data","points":[]},{"id":"patch_json_v3_4.patched:map_any_to_table_rows_1.map","points":[]},{"id":"google_sheets_append_table_rows_v3_1.appended:delay_to_1.start","points":[]},{"id":"data_relay_2.data:if_v2_1.a","points":[]},{"id":"slack_select_conversation_id_1.conversation_id:slack_notifier_v2_2.conversation_id","points":[]},{"id":"patch_json_v3_2.data:slack_notifier_v2_1.blocks","points":[]},{"id":"data_relay_2.data:for_each_v2_1.items","points":[]},{"id":"slack_select_conversation_id_1.conversation_id:slack_notifier_v2_1.conversation_id","points":[]},{"id":"patch_json_v3_2.patched:slack_notifier_v2_1.send","points":[]},{"id":"data_relay_1.data:filter_v2_1.items","points":[]},{"id":"filter_v2_1.items:data_relay_2.data","points":[]},{"id":"filter_v2_1.items:patch_json_list_v3_1.data_list","points":[]},{"id":"if_v2_1.true:fetch_automation_details_1.fetch","points":[]},{"id":"fetch_automation_details_1.details:patch_json_v3_2.value","points":[]},{"id":"fetch_automation_details_1.fetched:patch_json_v3_2.patch","points":[]},{"id":"fetch_automation_details_2.details:patch_json_list_v3_1.value","points":[]},{"id":"fetch_automation_details_2.details:patch_json_v3_3.value","points":[]},{"id":"fetch_automation_details_2.fetched:patch_json_list_v3_1.patch","points":[]},{"id":"trigger_relay_1.relayed:fetch_automation_details_2.fetch","points":[]},{"id":"tik_tok_select_ad_account_ids_1.ad_account_ids:tik_tok_fetch_reports_v2_1.ad_account_ids","points":[]},{"id":"tik_tok_select_ad_account_ids_1.ad_account_ids:for_each_v2_3.items","points":[]},{"id":"for_each_v2_3.item:tik_tok_fetch_ads_v2_1.ad_account_id","points":[]},{"id":"tik_tok_fetch_ads_v2_1.fetched:append_1.append","points":[]},{"id":"tik_tok_fetch_ads_v2_1.ads:append_1.item","points":[]},{"id":"append_1.resetted:for_each_v2_3.start","points":[]},{"id":"append_1.appended:for_each_v2_3.next","points":[]},{"id":"append_1.list:join_data_1.a","points":[]},{"id":"tik_tok_fetch_reports_v2_1.reports:join_data_1.b","points":[]},{"id":"for_each_v2_3.done:tik_tok_fetch_reports_v2_1.fetch","points":[]},{"id":"tik_tok_fetch_reports_v2_1.fetched:join_data_1.join","points":[]},{"id":"join_data_1.items:filter_v2_2.items","points":[]},{"id":"join_data_1.joined:filter_v2_2.filter","points":[]},{"id":"filter_v2_2.items:patch_json_list_v3_2.data_list","points":[]},{"id":"filter_v2_2.filtered:patch_json_list_v3_2.patch","points":[]},{"id":"patch_json_list_v3_2.patched:filter_v2_1.filter","points":[]},{"id":"patch_json_list_v3_2.data_list:data_relay_1.data","points":[]},{"id":"filter_v2_1.items:for_each_v2_2.items","points":[]},{"id":"for_each_v2_2.item:extract_2.data","points":[]},{"id":"for_each_v2_2.do:extract_2.extract","points":[]},{"id":"extract_2.data:parse_string_to_id_1.value","points":[]},{"id":"extract_2.extracted:parse_string_to_id_1.parse","points":[]},{"id":"parse_string_to_id_1.parsed:extract_1.extract","points":[]},{"id":"for_each_v2_2.item:extract_1.data","points":[]},{"id":"extract_1.data:parse_string_to_id_2.value","points":[]},{"id":"extract_1.extracted:parse_string_to_id_2.parse","points":[]},{"id":"parse_string_to_id_2.result:tik_tok_update_ad_status_1.ad_account_id","points":[]},{"id":"parse_string_to_id_1.result:tik_tok_update_ad_status_1.ad_id","points":[]},{"id":"input_string_1.string:tik_tok_update_ad_status_1.operation_status","points":[]},{"id":"input_string_1.string:patch_json_list_v3_3.value","points":[]},{"id":"parse_string_to_id_2.parsed:tik_tok_update_ad_status_1.update","points":[]},{"id":"tik_tok_update_ad_status_1.updated:for_each_v2_2.next","points":[]},{"id":"filter_v2_1.filtered:for_each_v2_2.start","points":[]},{"id":"for_each_v2_2.done:if_v2_1.evaluate","points":[]},{"id":"delay_to_1.delayed:append_1.reset","points":[]},{"id":"for_each_v2_3.do:tik_tok_fetch_ads_v2_1.fetch","points":[]}],"groups":{"group_3":{"title":"Send Slack Alert","description":"","x":1234,"y":298,"inputs":["if_v2_1.evaluate","slack_select_conversation_id_1.conversation_id","data_relay_2.data"],"outputs":["trigger_relay_1.relayed"]},"group_4":{"title":"Add to log","description":"","x":1516,"y":298,"inputs":["patch_json_list_v3_3.value","patch_json_list_v3_1.data_list","fetch_automation_details_2.fetch"],"outputs":["google_sheets_append_table_rows_v3_1.appended"]},"group_2":{"title":"Filter ad objects","description":"","x":680,"y":296,"inputs":["filter_v2_1.filter","data_relay_1.data"],"outputs":["filter_v2_1.items","filter_v2_1.filtered"]},"group_1":{"title":"Get data","description":"","x":408,"y":295,"inputs":["append_1.reset"],"outputs":["patch_json_list_v3_2.data_list","patch_json_list_v3_2.patched"]},"group_5":{"title":"Apply changes","description":"","x":961,"y":298,"inputs":["for_each_v2_2.items","for_each_v2_2.start"],"outputs":["input_string_1.string","for_each_v2_2.done"]},"group_6":{"title":"Fetch Account ID","description":"","x":735,"y":139,"group":"group_5","inputs":["extract_1.data","extract_1.extract"],"outputs":["parse_string_to_id_2.parsed","parse_string_to_id_2.result"]},"group_7":{"title":"Fetch Ad ID","description":"","x":477,"y":138,"group":"group_5","inputs":["extract_2.data","extract_2.extract"],"outputs":["parse_string_to_id_1.result","parse_string_to_id_1.parsed"]}},"widgets":{"widget_1":{"title":"Time (Schedule)","description":"Time to run this automation. This should be at least 5 minutes after the Tableau automation.","position":100,"icon":"las la-clock","input":"delay_to_1.time"},"widget_2":{"title":"Slack Channel","description":"Select a Slack Channel or Conversation","position":9,"input":"slack_select_conversation_id_1.conversation_id"},"widget_3":{"title":"Tab","description":"Input the range to search for the table to append to","position":51,"icon":"las la-table","input":"google_sheets_append_table_rows_v3_1.range"},"widget_4":{"title":"Log Sheet","description":"Select a Google Spreadsheet file to append data to","position":50,"input":"google_sheets_append_table_rows_v3_1.spreadsheet_id"},"widget_5":{"title":"Weekdays (Schedule)","description":"The weekdays to delay the trigger","position":99,"icon":"las la-calendar-day","input":"delay_to_1.weekdays"},"widget_6":{"title":"Date Range","description":"Set the timeframe for which the reports should be fetched","position":3,"icon":"las la-calendar","input":"tik_tok_fetch_reports_v2_1.date_range"},"widget_7":{"title":"Ad Accounts","description":"Select the ad account ids","position":-10,"input":"tik_tok_select_ad_account_ids_1.ad_account_ids"},"widget_8":{"title":"Set Status To","description":"Choose the status.","position":5,"icon":"las la-battery-half","options":[{"data":"ENABLE","title":"Enable"},{"data":"DISBALE","title":"Disable"},{"data":"DELETE","title":"Delete"}],"input":"input_string_1.string"},"widget_9":{"title":"Ad Status","description":"Set a filter for the operational status of the ads to fetch","position":0,"icon":"las la-battery-half","input":"tik_tok_fetch_ads_v2_1.operational_status"},"widget_10":{"title":"Conditions 1","description":"If any ad object matches this set of conditions, the rule will be applied.\n\nUse these metrics with `Greater than` and `Less than`.\n`/spend`\n`/impressions`\n`/cpm`\n`/clicks`\n`/cpc`\n`/ctr` \n`/complete_payment`\n`/value_per_complete_payment`\n`/complete_payment_roas`\n\nUse these fields with `Equals`, `Not equals` or `Matches Regex`:\n`/campaign_id` (string)\n`/adgroup_id` (string)\n`/ad_id` (string)\n`/campaign_name` (string)\n`/adgroup_name` (string)\n`/ad_name` (string)","position":3,"icon":"las la-filter","input":"filter_v2_1.filters"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}