CURRENT DEMO CONTRACT V1 · REVIEWED JULY 22, 2026
MSP QBR data dictionary: 10 fields for a source-labeled brief.
A field-by-field contract for comparing exactly two reporting periods without sending ticket text, credentials, or client names. The rules below are enforced by the current browser demo.
Two synthetic rows · about 60 seconds · no signup · no PSA/RMM credentials
DIRECT ANSWER
Give the meeting comparable evidence. Leave judgment with the MSP.
The current demo requires one header and two rows for the same redacted client. It validates quarter or month labels, rejects blanks and extra columns, orders the periods, computes deterministic changes, and labels findings and decision prompts with their source rows.
It does not establish causation, contractual compliance, security assurance, financial impact, or the right threshold for a client.
10 EXACT COLUMNS
The current evidence surface.
Unknown is not zero. Additional headers are rejected so accidental notes, identifiers, or free text do not slip through the narrow template.
| Field + example | Definition | Current use | Enforced guardrail |
|---|---|---|---|
01period2026-Q2 | Comparable reporting window | Orders the two rows | Exactly YYYY-Q1…Q4 or YYYY-MM; both periods must be distinct. |
02client_aliasClient-042 | Stable pseudonym for one client | Labels the brief | 1–64 letters, numbers, spaces, hyphens, or underscores; use the same alias twice. |
03tickets_opened134 | Tickets created under one inclusion rule | Demand-change context | Non-negative integer. It cannot explain severity, cause, or backlog. |
04tickets_closed128 | Tickets closed under one scope | Throughput context | Non-negative integer. Opened and closed counts can represent different cohorts. |
05sla_breaches3 | Breaches under one unchanged PSA rule | Service-level finding | Non-negative integer. The export does not contain contractual targets or exclusions. |
06patch_compliance_pct94 | In-scope assets meeting one patch rule | Coverage finding + exception prompt | Bare number from 0–100; keep asset scope and policy fixed. |
07backup_success_pct98.4 | Successful jobs within one backup scope | Backup exception prompt | Bare number from 0–100. Job success is not restore-test evidence. |
08critical_alerts2 | Alerts under one severity and deduplication rule | Alert finding + review prompt | Non-negative integer. Confirm disposition and business relevance in the source system. |
09recurring_incidents11 | Incidents under one recurrence key | Repeat-incident finding | Non-negative integer. Aggregate counts cannot identify root cause. |
10licenses_unused12 | Seats meeting one inactivity rule | Reclaim/reassign prompt | Non-negative integer. Verify ownership and contract terms before removal. |
BEFORE THE EXPORT LEAVES THE PSA/RMM
Aggregate first. Redact twice.
Build the comparison inside an approved reporting environment. Then inspect the final CSV as plain text before it enters any new tool.
- Replace the client's legal name and account ID with a new stable alias.
- Remove ticket subjects, bodies, comments, notes, attachments, and hidden columns.
- Remove names, emails, phone numbers, usernames, and user IDs.
- Remove hostnames, domains, IP/MAC addresses, serial numbers, and asset tags.
- Never include credentials, API keys, tokens, secrets, authenticated URLs, or recovery codes.
- Use an alphanumeric alias; spreadsheet formula prefixes such as =, +, -, and @ are rejected.
A pseudonym is not anonymity. Aggregate metrics can remain confidential or become identifiable when combined with other information.
period,client_alias,tickets_opened,tickets_closed, sla_breaches,patch_compliance_pct,backup_success_pct, critical_alerts,recurring_incidents,licenses_unused 2026-Q1,Client-042,112,106,8,86,99.2,4,19,14 2026-Q2,Client-042,134,128,3,94,98.4,2,11,12
INTERPRETATION CONTRACT
Four claims this CSV cannot make.
“The backlog is X.”
Opened minus closed is not backlog without carried opening and closing balances.
“Backups are recoverable.”
Job-success percentage is not evidence of a completed restore test or recovery objective.
“The client is compliant.”
Operational percentages do not prove contractual, regulatory, or framework compliance.
“This caused business loss.”
The export has no financial, root-cause, user-impact, or business-priority context.
60-SECOND PREFLIGHT
Check comparability before generating prose.
- 01
Exact contract. Ten unique headers, two data rows, and no additional columns.
- 02
One alias. Both rows use the same non-identifying client alias.
- 03
Distinct windows, same cadence. Use either two YYYY-Qn labels or two YYYY-MM labels with equal scope; never mix quarters and months.
- 04
Valid values. No blanks; counts are non-negative integers; percentages are 0–100.
- 05
Stable definitions. Populations, exclusions, SLA rules, and severity rules did not drift.
- 06
Human owner. Name who will inspect source detail and approve each client-facing line.
FROM FIELD CONTRACT TO DECISION BRIEF
See what these ten fields can—and cannot—support.
The application reads CSV values in your browser. Cookie-free, session-scoped telemetry records the action—not the CSV values.