Weekly churn watch

trigger:
  kind: schedule
  cron: "0 8 * * 1"
  timezone: America/New_York
steps:
  - key: usage
    name: Query usage drop
    kind: tool
    tool: warehouse.query
    args:
      sql: |
        select account_name, mrr, wau_this_week, wau_last_week
        from weekly_account_usage
        where wau_last_week > 0 and wau_this_week < wau_last_week * 0.7
  - key: rank
    name: Score and rank
    kind: javascript
    inputs: { rows: "{{ steps.usage.output.rows }}" }
    outputs: { top: array }
    code: |
      function main({ rows }) {
        const scored = rows.map(r => ({ ...r, drop: 1 - r.wau_this_week / r.wau_last_week }))
          .sort((a, b) => b.mrr * b.drop - a.mrr * a.drop)
        return { top: scored.slice(0, 5) }
      }
  - key: drafts
    name: Draft check-ins
    kind: llm
    model: smart
    prompt: "For each account, write a two-sentence friendly check-in from their CSM. Format as a Slack list. {{ steps.rank.output.top }}"
  - key: post
    name: "Post to #customer-success"
    kind: tool
    tool: slack.post_message
    args: { channel: C06SUCCESS, text: "*Accounts going quiet this week*\n{{ steps.drafts.output.text }}" }