Skip to content
CommissionSight Docs

Reading deltas

Per-field deltas for a job

Terminal window
curl "https://api.commissionsight.com/v1/jobs/$JOB_ID/deltas?changeType=modified" \
  -H "Authorization: Bearer $TOKEN"

Each delta row: memberRefId, field, prevValue, currValue, changeType.

Member timeline

Terminal window
curl https://api.commissionsight.com/v1/members/$MEMBER_REF_ID/timeline \
  -H "Authorization: Bearer $TOKEN"

A month-over-month ledger of status + flags — this is how reappearance is detected (a member whose most recent prior status was red and who returns is flagged REAPPEARED).

Compare any two periods

Terminal window
curl "https://api.commissionsight.com/v1/comparisons?from=2025-01&to=2025-03&carrierId=$CARRIER_ID" \
  -H "Authorization: Bearer $TOKEN"

carrierId is optional (omit for all carriers). granularity may be month|quarter|year. The comparison reuses the same status engine that powers MoM.

{
  "from": "2025-01", "to": "2025-03", "carrierId": null,
  "summary": { "green": 8120, "yellow": 940, "red": 612, "new": 210, "reappeared": 34, "total": 9672 },
  "data": [
    {
      "memberRefId": "…", "status": "yellow", "flags": ["COMMISSION_CHANGED"],
      "commissionAmount": 142.0, "prevCommissionAmount": 120.0,
      "comparedAgainstPeriod": "2025-01",
      "memberName": "Jane Doe", "memberExternalId": "M-1001", "policyNumber": "P-77"
    }
  ],
  "deltas": [ /* every field that moved between the two periods */ ]
}

Each row carries the member’s name, external id, and policy number (when present) alongside the status/flags and commission then-vs-now — readable and searchable without a second lookup.

Reports

  • GET /v1/reports/rollup?period=YYYY-MM&carrierId= — green/yellow/red counts (fast precomputed rollup). period defaults to the latest period with data; carrierId optional.
  • GET /v1/reports/attrition?period=YYYY-MM&carrierId=&granularity= — attrition ≈ red ÷ members present in the prior period, overall + per carrier. (These projection-backed reports approximate the prior-period denominator as present + dropped; for exact MoM movement use /comparisons.)
  • GET /v1/reports/attrition-series?months=12&carrierId= — month-over-month attrition for the last N periods (oldest→newest), for trend charts.
  • GET /v1/reports/data-quality?period=YYYY-MM — per-carrier statement-quality check (ok|watch|alert) that flags abnormal month-over-month movement — an unusually large simultaneous drop + add, or very high fallout alone — which usually means an incomplete or wrong-period file.