[{"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((curr.people - prev.people) \/ NULLIF(prev.people, 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":"1.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":1,"last_value":"2.68","last_evaluated_at":"2026-04-14 18:20:02","last_triggered_at":"2026-04-14 17:41:01","created_at":"2026-04-13 15:42:59","updated_at":"2026-04-14 18:20:02"},{"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":1,"last_value":"0","last_evaluated_at":"2026-04-14 18:30:01","last_triggered_at":null,"created_at":"2026-04-13 15:42:59","updated_at":"2026-04-14 18:30: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 14 Apr |     11 nuevos\n 13 Apr |    123 nuevos\n 12 Apr |    321 nuevos\n 11 Apr |     82 nuevos\n 10 Apr |     90 nuevos\n 09 Apr |     83 nuevos\n 08 Apr |     87 nuevos\n```","last_evaluated_at":"2026-04-14 08:00:02","last_triggered_at":"2026-04-14 08:00:04","created_at":"2026-03-28 19:14:26","updated_at":"2026-04-14 08:00:04"}]