Facebook Ads Alert - CPM Change

CPM Increase | Adset Level

{"name":"CPM Increase 10+% | Adset Level | Yesterday vs. Last 7 Days","description":"fb_cpm_change_alert_adset_20230130","nodes":{"patch_json_list_v3_1":{"type":"patch_json_list_v3","logging_enabled":false,"error_rules":[],"x":925,"y":491,"group":"group_1","inputs":{"patches":{"export_enabled":true,"data":[{"op":"cast","path":"/cpm","value":"float"},{"op":"cast","path":"/previous/cpm","value":"float"},{"op":"add","path":"/cpm_change","value":"{{ subtract(1, divide(inputData(\"/cpm\"), inputData(\"/previous/cpm\"))) }}"},{"op":"add","path":"/cpm_change_pretty","value":"{{ round(multiply(inputData(\"/cpm_change\"),100),2) }} %"}]},"value":{"export_enabled":true}}},"slack_notifier_v2_1":{"type":"slack_notifier_v2","logging_enabled":false,"error_rules":[],"x":560,"y":449,"group":"group_2","inputs":{"blocks":{"title":"blocks","description":"Blocks to be transferred","export_enabled":true,"data":[{"type":"section","text":{"type":"mrkdwn","text":"These adsets have an unusual CPM change."}}]},"thread_ts":{"export_enabled":true}}},"if_v2_1":{"type":"if_v2","logging_enabled":false,"error_rules":[],"x":1284,"y":454,"group":"group_3","inputs":{"b":{"export_enabled":true,"data":[]},"condition":{"export_enabled":true,"data":"not_equal"}},"outputs":{"true":{"title":" true","description":"Triggers when the evaluation is true"}}},"start_1":{"type":"start","logging_enabled":false,"error_rules":[],"x":139,"y":100},"stop_1":{"type":"stop","logging_enabled":false,"error_rules":[],"x":3131,"y":853,"inputs":{"stop":{"export_enabled":true}}},"delay_to_1":{"type":"delay_to","logging_enabled":false,"error_rules":[],"x":1606,"y":735,"inputs":{"weekdays":{"export_enabled":true,"data":["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]},"time":{"export_enabled":true,"data":"08:00:00+01:00"}}},"fb_fetch_insights_v6_1":{"type":"fb_fetch_insights_v6","title":"Fetch Facebook Insights - Timeframe 2","description":"Fetches insights, i.e. peformance, engagement and conversion metrics, from the Facebook Ads API for multiple ad accounts. Specify the timeframe and time breakdown with 'date_range' and 'time_increment' and explicitly choose the fields for which you want to get values. Note that all events off Facebook and their values like 'Purchase' cannot be selected individually but will be returned with the 'actions' and 'action_values' fields, respectively.","logging_enabled":false,"error_rules":[],"x":350,"y":665,"inputs":{"action_report_time":{"export_enabled":true,"data":"conversion"},"breakdowns":{"export_enabled":true},"action_breakdowns":{"export_enabled":true},"use_unified_attribution_setting":{"export_enabled":true,"data":true},"level":{"export_enabled":true,"data":"adset"},"action_attribution_windows":{"export_enabled":true,"data":["7d_click"]},"time_increment":{"export_enabled":true,"data":"all_days"},"date_range":{"export_enabled":true,"data":{"start_date":"today-7d","end_date":"today-1d"}}}},"input_any_1":{"type":"input_any","title":"Input Fields","description":"Allows to input a any type","logging_enabled":false,"max_job_retries":6,"timeout":30,"error_rules":[],"x":41,"y":640,"inputs":{"any":{"export_enabled":true,"data":["account_id","account_name","spend","impressions","cpm","campaign_id","campaign_name","adset_id","adset_name"]}}},"fb_fetch_insights_v6_2":{"type":"fb_fetch_insights_v6","title":"Fetch Facebook Insights - Timeframe 1","description":"Fetches insights, i.e. peformance, engagement and conversion metrics, from the Facebook Ads API for multiple ad accounts. Specify the timeframe and time breakdown with 'date_range' and 'time_increment' and explicitly choose the fields for which you want to get values. Note that all events off Facebook and their values like 'Purchase' cannot be selected individually but will be returned with the 'actions' and 'action_values' fields, respectively.","logging_enabled":false,"error_rules":[],"x":350,"y":182,"inputs":{"action_report_time":{"export_enabled":true,"data":"conversion"},"breakdowns":{"export_enabled":true},"action_breakdowns":{"export_enabled":true},"use_unified_attribution_setting":{"export_enabled":true,"data":true},"level":{"export_enabled":true,"data":"adset"},"action_attribution_windows":{"export_enabled":true,"data":["7d_click"]},"time_increment":{"export_enabled":true,"data":"all_days"},"date_range":{"export_enabled":true,"data":"yesterday"}}},"for_each_v2_1":{"type":"for_each_v2","logging_enabled":false,"error_rules":[],"x":917,"y":694,"group":"group_2"},"slack_select_conversation_id_1":{"type":"slack_select_conversation_id","logging_enabled":false,"error_rules":[],"x":273,"y":133,"group":"group_2","inputs":{"conversation_id":{"title":"conversation_id","description":"Select a Slack Channel or Conversation"}}},"filter_v2_1":{"type":"filter_v2","title":"Filter","description":"filters a items of any by atributes of it's schema","logging_enabled":false,"max_job_retries":6,"timeout":600,"error_rules":[],"x":1015,"y":504,"group":"group_3"},"build_filter_v2_1":{"type":"build_filter_v2","title":"Build Filter (CPM Increase \u003e 20%)","description":"Builds a filter object to be used with a Filter node.","logging_enabled":false,"error_rules":[],"x":734,"y":281,"group":"group_3","inputs":{"filters":{"export_enabled":true,"data":[{"value":0.1,"pointer":"/cpm_change","operator":"\u003e="}]}}},"patch_json_v2_1":{"type":"patch_json_v2","logging_enabled":false,"error_rules":[],"x":1246,"y":438,"group":"group_2","inputs":{"patches":{"export_enabled":true,"data":[{"op":"replace","path":"/0/text/text","value":"Account: {{input.value/account_name}}\nAdset Name: {{input.value/adset_name}} ({{input.value/adset_id}})\nCPM changed {{input.value/cpm_change_pretty}} compared to the previous 7 days."},{"op":"replace","path":"/0/accessory/url","value":"https://business.facebook.com/adsmanager/manage/adsets?act={{input.value/account_id}}\u0026filter_set=SEARCH_BY_CAMPAIGN_ID-STRING%1EEQUAL%1E%22{{input.value/adset_id}}%22"}]},"data":{"export_enabled":true,"data":[{"type":"section","text":{"type":"mrkdwn","text":""},"accessory":{"type":"button","text":{"type":"plain_text","text":"Ads Manager"},"value":"click_me_123","url":"","action_id":"button-action"}}]}}},"slack_notifier_v2_2":{"type":"slack_notifier_v2","logging_enabled":false,"error_rules":[],"x":1639,"y":510,"group":"group_2"},"join_data_1":{"type":"join_data","logging_enabled":false,"error_rules":[],"x":651,"y":460,"group":"group_1","inputs":{"conditions":{"export_enabled":true,"data":[{"a":"/adset_id","b":"/adset_id"}]},"target":{"export_enabled":true,"data":"/previous"}},"outputs":{"joined":{"title":"joined","description":"Triggered when joined"}}},"fb_select_ad_account_ids_v2_1":{"type":"fb_select_ad_account_ids_v2","title":"Select Facebook Ad Account Ids","description":"Select any ids of your connected Ad Accounts.","logging_enabled":false,"error_rules":[],"x":48,"y":174,"inputs":{"ad_account_ids":{"title":"ad_account_ids","description":"Select one or more Facebook Accounts"}}}},"edges":[{"id":"fb_select_ad_account_ids_v2_1.ad_account_ids:fb_fetch_insights_v6_2.ad_account_ids","points":[]},{"id":"build_filter_v2_1.filters:filter_v2_1.filters","points":[]},{"id":"slack_select_conversation_id_1.conversation_id:slack_notifier_v2_2.conversation_id","points":[]},{"id":"patch_json_v2_1.data:slack_notifier_v2_2.blocks","points":[]},{"id":"patch_json_v2_1.patched:slack_notifier_v2_2.send","points":[]},{"id":"slack_notifier_v2_2.sent:for_each_v2_1.next","points":[]},{"id":"fb_select_ad_account_ids_v2_1.ad_account_ids:fb_fetch_insights_v6_1.ad_account_ids","points":[]},{"id":"input_any_1.any:fb_fetch_insights_v6_1.fields","points":[]},{"id":"input_any_1.any:fb_fetch_insights_v6_2.fields","points":[]},{"id":"fb_fetch_insights_v6_2.fetched:fb_fetch_insights_v6_1.fetch","points":[]},{"id":"delay_to_1.delayed:fb_fetch_insights_v6_2.fetch","points":[]},{"id":"for_each_v2_1.done:delay_to_1.start","points":[]},{"id":"fb_fetch_insights_v6_1.fetched:join_data_1.join","points":[]},{"id":"fb_fetch_insights_v6_2.insights:join_data_1.a","points":[]},{"id":"fb_fetch_insights_v6_1.insights:join_data_1.b","points":[]},{"id":"patch_json_list_v3_1.patched:filter_v2_1.filter","points":[]},{"id":"patch_json_list_v3_1.data_list:filter_v2_1.items","points":[]},{"id":"join_data_1.items:patch_json_list_v3_1.data_list","points":[]},{"id":"join_data_1.joined:patch_json_list_v3_1.patch","points":[]},{"id":"for_each_v2_1.item:patch_json_v2_1.value","points":[]},{"id":"for_each_v2_1.do:patch_json_v2_1.patch","points":[]},{"id":"filter_v2_1.items:if_v2_1.a","points":[]},{"id":"filter_v2_1.filtered:if_v2_1.evaluate","points":[]},{"id":"if_v2_1.true:slack_notifier_v2_1.send","points":[]},{"id":"if_v2_1.false:delay_to_1.start","points":[]},{"id":"slack_select_conversation_id_1.conversation_id:slack_notifier_v2_1.conversation_id","points":[]},{"id":"slack_notifier_v2_1.thread_ts:slack_notifier_v2_2.thread_ts","points":[]},{"id":"slack_notifier_v2_1.sent:for_each_v2_1.start","points":[]},{"id":"filter_v2_1.items:for_each_v2_1.items","points":[]},{"id":"start_1.start:fb_fetch_insights_v6_2.fetch","points":[]}],"groups":{"group_2":{"title":"Send Slack Messages","description":"","x":1284,"y":451,"inputs":["for_each_v2_1.items","slack_notifier_v2_1.send"],"outputs":["for_each_v2_1.done"]},"group_1":{"title":"Join data \u0026 calculate change","description":"","x":708,"y":494,"inputs":["join_data_1.b","join_data_1.a","join_data_1.join"],"outputs":["patch_json_list_v3_1.data_list","patch_json_list_v3_1.patched"]},"group_3":{"title":"Filter relevant items","description":"","x":978,"y":497,"inputs":["filter_v2_1.items","filter_v2_1.filter"],"outputs":["filter_v2_1.items","if_v2_1.false","if_v2_1.true"]}},"widgets":{"widget_1":{"title":"Ad Account","description":"Select one or more Facebook Ad Accounts.","position":0,"input":"fb_select_ad_account_ids_v2_1.ad_account_ids"},"widget_2":{"title":"Rule","description":"Select here how high the CPM Change should be set so that the alert is triggered (Please enter the value as decimals) and do not remove the first rule.","position":5,"icon":"las la-filter","input":"build_filter_v2_1.filters"},"widget_3":{"title":"Slack Channel","description":"Select a Slack Channel or Conversation.","position":2,"input":"slack_select_conversation_id_1.conversation_id"},"widget_4":{"title":"Timeframe 1","description":"Select a base timeframe.","position":3,"icon":"las la-calendar-week","input":"fb_fetch_insights_v6_2.date_range"},"widget_5":{"title":"Timeframe 2","description":"Select a comparison timeframe.","position":4,"icon":"las la-calendar","input":"fb_fetch_insights_v6_1.date_range"},"widget_6":{"title":"Weekdays","description":"Select one or more weekdays.","position":98,"icon":"las la-calendar","input":"delay_to_1.weekdays"},"widget_7":{"title":"Time","description":"Select a time and timezone.","position":99,"icon":"las la-clock","input":"delay_to_1.time"}},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}

CPM Increase | Campaign Level

{ "name": "CPM Increase 10+% | Campaign Level | Yesterday vs. Last 7 Days", "description": "fb_cpm_change_alert_campaign_20230130", "nodes": { "patch_json_list_v3_1": { "type": "patch_json_list_v3", "logging_enabled": false, "x": 925, "y": 491, "group": "group_1", "inputs": { "patches": { "export_enabled": true, "data": [{ "op": "cast", "path": "/cpm", "value": "float" }, { "op": "cast", "path": "/previous/cpm", "value": "float" }, { "op": "add", "path": "/cpm_change", "value": "{{ subtract(1, divide(inputData(\"/cpm\"), inputData(\"/previous/cpm\"))) }}" }, { "op": "add", "path": "/cpm_change_pretty", "value": "{{ round(multiply(inputData(\"/cpm_change\"),100),2) }} %" }] }, "value": { "export_enabled": true } } }, "slack_notifier_v2_1": { "type": "slack_notifier_v2", "logging_enabled": false, "x": 560, "y": 449, "group": "group_2", "inputs": { "blocks": { "title": "blocks", "description": "Blocks to be transferred", "export_enabled": true, "data": [{ "type": "section", "text": { "type": "mrkdwn", "text": "These campaigns have an unusual CPM change." } }] }, "thread_ts": { "export_enabled": true } } }, "start_1": { "type": "start", "logging_enabled": false, "x": 139, "y": 100 }, "stop_1": { "type": "stop", "logging_enabled": false, "x": 3131, "y": 853, "inputs": { "stop": { "export_enabled": true } } }, "delay_to_1": { "type": "delay_to", "logging_enabled": false, "x": 1606, "y": 735, "inputs": { "weekdays": { "export_enabled": true, "data": ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"] }, "time": { "export_enabled": true, "data": "08:00:00+01:00" } } }, "fb_fetch_insights_v6_1": { "type": "fb_fetch_insights_v6", "title": "Fetch Facebook Insights - Timeframe 2", "description": "Fetches insights, i.e. peformance, engagement and conversion metrics, from the Facebook Ads API for multiple ad accounts. Specify the timeframe and time breakdown with 'date_range' and 'time_increment' and explicitly choose the fields for which you want to get values. Note that all events off Facebook and their values like 'Purchase' cannot be selected individually but will be returned with the 'actions' and 'action_values' fields, respectively.", "logging_enabled": false, "x": 350, "y": 665, "inputs": { "level": { "export_enabled": true, "data": "campaign" }, "action_report_time": { "export_enabled": true, "data": "conversion" }, "breakdowns": { "export_enabled": true }, "action_breakdowns": { "export_enabled": true }, "use_unified_attribution_setting": { "export_enabled": true, "data": true }, "action_attribution_windows": { "export_enabled": true, "data": ["7d_click"] }, "time_increment": { "export_enabled": true, "data": "all_days" }, "date_range": { "export_enabled": true, "data": { "start_date": "today-7d", "end_date": "today-1d" } } } }, "input_any_1": { "type": "input_any", "title": "Input Fields", "description": "Allows to input a any type", "logging_enabled": false, "max_job_retries": 6, "timeout": 30, "x": 41, "y": 640, "inputs": { "any": { "export_enabled": true, "data": ["account_id", "account_name", "spend", "impressions", "cpm", "campaign_id", "campaign_name"] } } }, "fb_fetch_insights_v6_2": { "type": "fb_fetch_insights_v6", "title": "Fetch Facebook Insights - Timeframe 1", "description": "Fetches insights, i.e. peformance, engagement and conversion metrics, from the Facebook Ads API for multiple ad accounts. Specify the timeframe and time breakdown with 'date_range' and 'time_increment' and explicitly choose the fields for which you want to get values. Note that all events off Facebook and their values like 'Purchase' cannot be selected individually but will be returned with the 'actions' and 'action_values' fields, respectively.", "logging_enabled": false, "x": 350, "y": 182, "inputs": { "level": { "export_enabled": true, "data": "campaign" }, "action_report_time": { "export_enabled": true, "data": "conversion" }, "breakdowns": { "export_enabled": true }, "action_breakdowns": { "export_enabled": true }, "use_unified_attribution_setting": { "export_enabled": true, "data": true }, "action_attribution_windows": { "export_enabled": true, "data": ["7d_click"] }, "time_increment": { "export_enabled": true, "data": "all_days" }, "date_range": { "export_enabled": true, "data": "yesterday" } } }, "for_each_v2_1": { "type": "for_each_v2", "logging_enabled": false, "x": 917, "y": 694, "group": "group_2" }, "slack_select_conversation_id_1": { "type": "slack_select_conversation_id", "logging_enabled": false, "x": 273, "y": 133, "group": "group_2", "inputs": { "conversation_id": { "title": "conversation_id", "description": "Select a Slack Channel or Conversation" } } }, "filter_v2_1": { "type": "filter_v2", "title": "Filter", "description": "filters a items of any by atributes of it's schema", "logging_enabled": false, "max_job_retries": 6, "timeout": 600, "x": 945, "y": 490, "group": "group_3" }, "patch_json_v2_1": { "type": "patch_json_v2", "logging_enabled": false, "x": 1246, "y": 438, "group": "group_2", "inputs": { "patches": { "export_enabled": true, "data": [{ "op": "replace", "path": "/0/text/text", "value": "Account: {{input.value/account_name}}\nCampaign Name: {{input.value/campaign_name}} ({{input.value/campaign_id}})\nCPM changed {{input.value/cpm_change_pretty}} compared to the previous 7 days." }, { "op": "replace", "path": "/0/accessory/url", "value": "https://business.facebook.com/adsmanager/manage/campaigns?act={{input.value/account_id}}\u0026filter_set=SEARCH_BY_CAMPAIGN_GROUP_ID-STRING%1EEQUAL%1E%22{{input.value/campaign_id}}%22" }] }, "data": { "export_enabled": true, "data": [{ "type": "section", "text": { "type": "mrkdwn", "text": "" }, "accessory": { "type": "button", "text": { "type": "plain_text", "text": "Ads Manager" }, "value": "click_me_123", "url": "", "action_id": "button-action" } }] } } }, "slack_notifier_v2_2": { "type": "slack_notifier_v2", "logging_enabled": false, "x": 1639, "y": 510, "group": "group_2" }, "join_data_1": { "type": "join_data", "logging_enabled": false, "x": 651, "y": 460, "group": "group_1", "inputs": { "conditions": { "export_enabled": true, "data": [{ "a": "/campaign_id", "b": "/campaign_id" }] }, "target": { "export_enabled": true, "data": "/previous" } }, "outputs": { "joined": { "title": "joined", "description": "Triggered when joined" } } }, "fb_select_ad_account_ids_v2_1": { "type": "fb_select_ad_account_ids_v2", "title": "Select Facebook Ad Account Ids", "description": "Select any ids of your connected Ad Accounts.", "logging_enabled": false, "x": 48, "y": 174, "inputs": { "ad_account_ids": { "title": "ad_account_ids", "description": "Select one or more Facebook Accounts" } } }, "if_v2_1": { "type": "if_v2", "logging_enabled": false, "x": 1287, "y": 455, "group": "group_3", "inputs": { "b": { "export_enabled": true, "data": [] }, "condition": { "export_enabled": true, "data": "not_equal" } }, "outputs": { "true": { "title": " true", "description": "Triggers when the evaluation is true" } } }, "build_filter_v2_1": { "type": "build_filter_v2", "title": "Build Filter", "description": "Builds a filter object to be used with a Filter node.", "logging_enabled": false, "max_job_retries": 6, "timeout": 30, "x": 605, "y": 321, "group": "group_3", "inputs": { "filters": { "export_enabled": true, "data": [{ "value": 0.1, "pointer": "/cpm_change", "operator": "\u003e=" }] }, "schema": { "export_enabled": true, "data": "fb_insight" } } } }, "edges": ["fb_select_ad_account_ids_v2_1.ad_account_ids:fb_fetch_insights_v6_2.ad_account_ids", "build_filter_v2_1.filters:filter_v2_1.filters", "slack_select_conversation_id_1.conversation_id:slack_notifier_v2_2.conversation_id", "patch_json_v2_1.data:slack_notifier_v2_2.blocks", "patch_json_v2_1.patched:slack_notifier_v2_2.send", "slack_notifier_v2_2.sent:for_each_v2_1.next", "fb_select_ad_account_ids_v2_1.ad_account_ids:fb_fetch_insights_v6_1.ad_account_ids", "input_any_1.any:fb_fetch_insights_v6_1.fields", "input_any_1.any:fb_fetch_insights_v6_2.fields", "fb_fetch_insights_v6_2.fetched:fb_fetch_insights_v6_1.fetch", "delay_to_1.delayed:fb_fetch_insights_v6_2.fetch", "for_each_v2_1.done:delay_to_1.start", "fb_fetch_insights_v6_1.fetched:join_data_1.join", "fb_fetch_insights_v6_2.insights:join_data_1.a", "fb_fetch_insights_v6_1.insights:join_data_1.b", "patch_json_list_v3_1.patched:filter_v2_1.filter", "patch_json_list_v3_1.data_list:filter_v2_1.items", "join_data_1.items:patch_json_list_v3_1.data_list", "join_data_1.joined:patch_json_list_v3_1.patch", "for_each_v2_1.item:patch_json_v2_1.value", "for_each_v2_1.do:patch_json_v2_1.patch", "filter_v2_1.items:if_v2_1.a", "filter_v2_1.filtered:if_v2_1.evaluate", "if_v2_1.true:slack_notifier_v2_1.send", "if_v2_1.false:delay_to_1.start", "slack_select_conversation_id_1.conversation_id:slack_notifier_v2_1.conversation_id", "slack_notifier_v2_1.thread_ts:slack_notifier_v2_2.thread_ts", "slack_notifier_v2_1.sent:for_each_v2_1.start", "filter_v2_1.items:for_each_v2_1.items", "start_1.start:fb_fetch_insights_v6_2.fetch"], "groups": { "group_2": { "title": "Send Slack Messages", "description": "", "x": 1284, "y": 451, "inputs": ["for_each_v2_1.items", "slack_notifier_v2_1.send"], "outputs": ["for_each_v2_1.done"] }, "group_1": { "title": "Join data \u0026 calculate change", "description": "", "x": 708, "y": 494, "inputs": ["join_data_1.b", "join_data_1.a", "join_data_1.join"], "outputs": ["patch_json_list_v3_1.data_list", "patch_json_list_v3_1.patched"] }, "group_3": { "title": "Filter relevant items", "description": "", "x": 978, "y": 497, "inputs": ["filter_v2_1.items", "filter_v2_1.filter"], "outputs": ["filter_v2_1.items", "if_v2_1.false", "if_v2_1.true"] } }, "widgets": { "widget_1": { "title": "Weekdays", "description": "Select one or more weekdays.", "position": 98, "icon": "las la-calendar", "input": "delay_to_1.weekdays" }, "widget_2": { "title": "Ad Account", "description": "Select one or more Facebook Ad Accounts.", "position": 0, "input": "fb_select_ad_account_ids_v2_1.ad_account_ids" }, "widget_3": { "title": "Rule", "description": "Select here how high the CPM Change should be set so that the alert is triggered (Please enter the value as decimals) and do not remove the first rule.", "position": 5, "icon": "las la-filter", "input": "build_filter_v2_1.filters" }, "widget_4": { "title": "Slack Channel", "description": "Select a Slack Channel or Conversation.", "position": 2, "input": "slack_select_conversation_id_1.conversation_id" }, "widget_5": { "title": "Timeframe 1", "description": "Select a base timeframe.", "position": 3, "icon": "las la-calendar-week", "input": "fb_fetch_insights_v6_2.date_range" }, "widget_6": { "title": "Timeframe 2", "description": "Select a comparison timeframe.", "position": 4, "icon": "las la-calendar", "input": "fb_fetch_insights_v6_1.date_range" }, "widget_7": { "title": "Time", "description": "Select a time and timezone.", "position": 99, "icon": "las la-clock", "input": "delay_to_1.time" } }, "config": { "capture_inputs_enabled": false, "caching_enabled": false }, "tags": [{ "name": "Alerts", "color": "#DE9597" }, { "name": "Quality Control", "color": "#E6BD5C" }] }