Automations

SELECT
  COUNT(*)                                                   AS brands_with_automation,
  SUM(rb_total)                                              AS total_rules,
  SUM(rb_active)                                             AS active_rules,
  SUM(rb_paused)                                             AS paused_rules,
  SUM(dp_total)                                              AS total_schedulers,
  SUM(dp_active)                                             AS active_schedulers,
  SUM(dp_paused)                                             AS paused_schedulers,
  COUNTIF(rb_all_paused = TRUE AND rb_total > 0)             AS brands_all_rules_paused,
  COUNTIF(dp_all_paused = TRUE AND dp_total > 0)             AS brands_all_dp_paused
FROM `amazoneast.customerio_data.dim_brand_automation_stats`

SELECT rule_id, rule_name, rule_type, status, brand_name,
       profile_owner_email, rule_conditions_readable,
       rule_change_by, rule_change_value, rule_cap, rule_floor,
       paused_by, paused_reason, object_updated_at
FROM `amazoneast.customerio_data.dim_rule`

ORDER BY object_updated_at DESC NULLS LAST
LIMIT 50

SELECT scheduler_id, scheduler_name, scheduler_type, scheduler_mode, status,
       brand_name, profile_owner_email,
       scheduler_value, scheduler_cap, scheduler_floor, scheduler_change_to,
       paused_by, paused_reason, object_updated_at
FROM `amazoneast.customerio_data.dim_scheduler`

ORDER BY object_updated_at DESC NULLS LAST
LIMIT 50