[{"id":7,"name":"Realtime 13go · Récord semanal (salto fuerte)","description":"","metric_key":"realtime_peak_delta_7d_jump_13go","sql_query":"SELECT GREATEST(CAST(last_point.people AS SIGNED) - CAST(COALESCE(prev_window.prev_max, 0) AS SIGNED), 0) AS value\nFROM (\n  SELECT captured_at, people\n  FROM chartbeat_realtime\n  WHERE client_id = 3\n  ORDER BY captured_at DESC\n  LIMIT 1\n) AS last_point\nLEFT JOIN (\n  SELECT MAX(people) AS prev_max\n  FROM chartbeat_realtime\n  WHERE client_id = 3\n    AND captured_at >= (NOW() - INTERVAL 7 DAY)\n    AND captured_at < (NOW() - INTERVAL 10 MINUTE)\n) AS prev_window ON 1 = 1","value_field":"value","schedule_type":"interval","schedule_cron":"","schedule_timezone":"America\/Santiago","operator":"gte","threshold":"300.0000","cooldown_minutes":30,"slack_channel":"","notify_slack":1,"notify_pushover":0,"pushover_user_key":"","pushover_device":"","pushover_priority":null,"message_template":null,"message_template_pushover":null,"is_active":1,"last_value":"0","last_evaluated_at":"2026-06-05 23:48:01","last_triggered_at":null,"created_at":"2026-05-10 20:49:02","updated_at":"2026-06-05 23:48:01"},{"id":6,"name":"Realtime 13go · Nuevo récord semanal","description":"","metric_key":"realtime_peak_delta_7d_13go","sql_query":"SELECT GREATEST(CAST(last_point.people AS SIGNED) - CAST(COALESCE(prev_window.prev_max, 0) AS SIGNED), 0) AS value\nFROM (\n  SELECT captured_at, people\n  FROM chartbeat_realtime\n  WHERE client_id = 3\n  ORDER BY captured_at DESC\n  LIMIT 1\n) AS last_point\nLEFT JOIN (\n  SELECT MAX(people) AS prev_max\n  FROM chartbeat_realtime\n  WHERE client_id = 3\n    AND captured_at >= (NOW() - INTERVAL 7 DAY)\n    AND captured_at < (NOW() - INTERVAL 10 MINUTE)\n) AS prev_window ON 1 = 1","value_field":"value","schedule_type":"interval","schedule_cron":"","schedule_timezone":"America\/Santiago","operator":"gte","threshold":"10.0000","cooldown_minutes":360,"slack_channel":"","notify_slack":1,"notify_pushover":0,"pushover_user_key":"","pushover_device":"","pushover_priority":null,"message_template":null,"message_template_pushover":null,"is_active":1,"last_value":"0","last_evaluated_at":"2026-06-05 23:48:01","last_triggered_at":"2026-06-01 21:21:02","created_at":"2026-05-10 20:46:07","updated_at":"2026-06-05 23:48:01"},{"id":3,"name":"Diario a las 8am · Suscripciones últimos días","description":"Informa cada 60 minutos el total de suscripciones vendidas hoy.","metric_key":"subs_today_hourly_report","sql_query":"SELECT CONCAT(\n  'Últimos 7 días (Chile):\n```\n',\n  GROUP_CONCAT(\n    CONCAT(LPAD(DATE_FORMAT(fecha,'%d %b'), 7, ' '), ' | ',\n           LPAD(total_subs, 6, ' '), ' nuevos')\n    ORDER BY fecha DESC\n    SEPARATOR '\n'\n  ),\n  '\n```'\n) AS value\nFROM (\n  SELECT DATE(window_start) AS fecha, SUM(COALESCE(nuevos_suscriptores,0)) AS total_subs\n  FROM flow_suscriptores_por_hora \n  WHERE window_start >= DATE_SUB(CURDATE(), INTERVAL 6 DAY) \n    AND window_start < DATE_ADD(CURDATE(), INTERVAL 1 DAY)\n  GROUP BY DATE(window_start)\n) AS daily","value_field":"value","schedule_type":"cron","schedule_cron":"0 8 * * *","schedule_timezone":"America\/Santiago","operator":"gte","threshold":"0.0000","cooldown_minutes":60,"slack_channel":"#suscripciones","notify_slack":1,"notify_pushover":1,"pushover_user_key":"","pushover_device":"","pushover_priority":null,"message_template":":bar_chart: Reporte de Suscripciones (7 días)\n{{metric_value}}","message_template_pushover":"","is_active":1,"last_value":"Últimos 7 días (Chile):\n```\n 05 Jun |     11 nuevos\n 04 Jun |    178 nuevos\n 03 Jun |    183 nuevos\n 02 Jun |    183 nuevos\n 01 Jun |    225 nuevos\n 31 May |    372 nuevos\n 30 May |    183 nuevos\n```","last_evaluated_at":"2026-06-05 08:00:01","last_triggered_at":"2026-06-05 08:00:03","created_at":"2026-03-28 19:14:26","updated_at":"2026-06-05 08:00:03"},{"id":5,"name":"Realtime 13go · Cambio abrupto >= 1%","description":"Dispara cuando el cambio entre las dos últimas mediciones de people es >= 25%.","metric_key":"realtime_abrupt_change_pct_13go","sql_query":"SELECT ROUND(ABS((CAST(curr.people AS SIGNED) - CAST(prev.people AS SIGNED)) \/ NULLIF(CAST(prev.people AS SIGNED), 0)) * 100, 2) AS value\r\nFROM (\r\n  SELECT captured_at, people\r\n  FROM chartbeat_realtime\r\n  WHERE client_id = 3\r\n  ORDER BY captured_at DESC\r\n  LIMIT 1\r\n) AS curr\r\nJOIN (\r\n  SELECT captured_at, people\r\n  FROM chartbeat_realtime\r\n  WHERE client_id = 3\r\n  ORDER BY captured_at DESC\r\n  LIMIT 1 OFFSET 1\r\n) AS prev ON 1 = 1","value_field":"value","schedule_type":"interval","schedule_cron":"","schedule_timezone":"America\/Santiago","operator":"gte","threshold":"10.0000","cooldown_minutes":30,"slack_channel":"","notify_slack":0,"notify_pushover":1,"pushover_user_key":"","pushover_device":"","pushover_priority":0,"message_template":"Realtime 13go · Cambio abrupto >= 25%\nValor actual: {{metric_value}}","message_template_pushover":"Cambio brusco realtime 13go\nVariación entre últimas mediciones: {{metric_value}}%","is_active":0,"last_value":"10.47","last_evaluated_at":"2026-04-17 13:29:01","last_triggered_at":"2026-04-17 13:21:01","created_at":"2026-04-13 15:42:59","updated_at":"2026-04-17 13:29:17"},{"id":4,"name":"Realtime 13go · Nuevo récord 24h","description":"Dispara cuando el último people supera el máximo previo de 24h por al menos 25 concurrentes.","metric_key":"realtime_peak_delta_24h_13go","sql_query":"SELECT GREATEST(CAST(last_point.people AS SIGNED) - CAST(COALESCE(prev_window.prev_max, 0) AS SIGNED), 0) AS value\r\nFROM (\r\n  SELECT captured_at, people\r\n  FROM chartbeat_realtime\r\n  WHERE client_id = 3\r\n  ORDER BY captured_at DESC\r\n  LIMIT 1\r\n) AS last_point\r\nLEFT JOIN (\r\n  SELECT MAX(people) AS prev_max\r\n  FROM chartbeat_realtime\r\n  WHERE client_id = 3\r\n    AND captured_at >= (NOW() - INTERVAL 24 HOUR)\r\n    AND captured_at < (NOW() - INTERVAL 10 MINUTE)\r\n) AS prev_window ON 1 = 1","value_field":"value","schedule_type":"interval","schedule_cron":"","schedule_timezone":"America\/Santiago","operator":"gte","threshold":"25.0000","cooldown_minutes":10,"slack_channel":"","notify_slack":0,"notify_pushover":1,"pushover_user_key":"","pushover_device":"","pushover_priority":0,"message_template":"Realtime 13go · Nuevo pico 24h (anti-spam)\nValor actual: {{metric_value}}","message_template_pushover":"Pico realtime 13go (24h)\nIncremento sobre máximo previo: {{metric_value}} concurrentes","is_active":0,"last_value":"31","last_evaluated_at":"2026-05-10 20:54:01","last_triggered_at":"2026-05-10 20:51:01","created_at":"2026-04-13 15:42:59","updated_at":"2026-05-10 20:54:15"}]