Planet9 sales agent still sends reporting webhook for archived media buy

[BaiyuScope3]

Hi team,

We observed that the Planet9 sales agent is still sending daily reporting webhooks for an archived media buy:

• Media buy: mb_36c8fb4d88d9
• Status on buyer agent side (scope3): archived
• Behavior: daily report still sent
• Period: this behavior has been lasting for a month after the media buy being archived
• Payload behavior: 0 impressions, missing package rate

Webhook payload

{
  "notification_type": "scheduled",
  "partial_data": false,
  "unavailable_count": 0,
  "sequence_number": 45,
  "next_expected_at": "2026-04-16T00:00:00Z",
  "reporting_period": {
    "start": "2026-04-14T00:00:00Z",
    "end": "2026-04-15T00:00:00Z"
  },
  "currency": "USD",
  "aggregated_totals": {
    "impressions": 0,
    "spend": 0,
    "media_buy_count": 1
  },
  "media_buy_deliveries": [
    {
      "media_buy_id": "mb_36c8fb4d88d9",
      "buyer_ref": "mb_yi2zwWPwUg",
      "status": "active",
      "is_adjusted": false,
      "pricing_model": "cpm",
      "pricing_options": [
        {
          "pricing_option_id": "cpm_eur_auction",
          "pricing_model": "cpm"
        }
      ],
      "totals": {
        "impressions": 0,
        "spend": 0,
        "clicks": 0
      },
      "by_package": [
        {
          "package_id": "pkg_prod_f195cdc6_b0c77539_1",
          "buyer_ref": "mb_yi2zwWPwUg_pkg_prod_f195cdc6",
          "impressions": 0,
          "spend": 0,
          "pacing_index": 1,
          "pricing_model": "cpm",
          "currency": "EUR"
        }
      ],
      "ext": {}
    }
  ]
}

Questions

• Is there any potential status discrepency that causing the sales agent still sending the media buy in the db

Impact
No functional impact for now, but it adds noise to reporting and alerts.

Thank you team

[jrosendahl-opt]

This is caused by the same gap tracked in #1261 — the salesagent silently ignores canceled: true on update_media_buy, so the local DB status never transitions away from active. The delivery webhook scheduler queries for status IN ('active', 'approved'), so it keeps picking up the media buy and sending reports indefinitely.

Fix is being tracked in #1261.

[jrosendahl-opt]

This is caused by the same gap tracked in #1261 — the salesagent silently ignores canceled: true on update_media_buy, so the local DB status never transitions away from active. The delivery webhook scheduler queries for status IN ('active', 'approved'), so it keeps picking up the media buy and sending reports indefinitely.

Fix is being tracked in #1261.

[jrosendahl-opt]

When 1261 is fixed verify this is solved as well

[numarasSigmaSoftware]

All work on this issue will be done on #1606