# Dermatology exposure review

To: Jordan Ellis, regional sales director  
From: Maya Chen, fictional revenue operations analyst  
Status: draft; source/account validation pending

The supplied Dermatology pipeline needs a stage and close-date review before it supports planning. Its 53 open opportunities total $4,579,800 in assumed annual software contract value, or 11.40% of the $40,178,200 all-specialty open total. All 53 are overdue as of the invented 2026-08-31 scenario date, with close dates 25–291 days behind that date. No selected open close dates are missing or invalid. The source includes 55 Dermatology rows overall; closed outcomes are excluded from open exposure.

For Dermatology HCPCS 99213, the 2022-to-2023 comparison shows average payment decreasing from $108.05 to $104.91: -$3.14, or -2.91%. Services increase from 3,626 to 3,777: +151, or +4.16%. I recalculated service-weighted payment from the raw rows using specialty, procedure and services >=11 filters. Both years have 57 qualifying rows, and their rounded weighted payments and service totals reconcile to the mart. Percentage changes use displayed payment values and prior-year denominators.

This is a synthetic scenario: 2023 is a synthetic base and 2022 a generated comparison, not historical CMS observations. Practice reimbursement and vendor software ACV are different measures. Sales totals include all 500 supplied rows without period filtering; source capture time is unknown, and overdue rows remain open as supplied. ACV is neither recognized revenue nor a forecast. The project pressure score is unvalidated and cannot establish account need or justify outreach. Source and account validation remain pending.

The unresolved question is whether these 53 opportunities remain open and whether owners can substantiate revised dates and account-specific needs. The next reviewer should be the sales operations manager, working with opportunity owners. Have them check the 53 stages and close dates in the source system and return a reconciled exposure total to Jordan before planning use. Account discovery is a separate prerequisite for any later account action. No CRM change or account recommendation is requested.

Pinned references (supplied with the case; checked through local extracts):

- https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/sample_2022_puf_10k.csv
- https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/sample_2023_puf_10k.csv
- https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/sample_sfdc_pipeline.csv
- https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/data/releases/databricks-527988765998273/mart.csv
- https://github.com/kristenmartino/specialtypulse_pipeline/blob/d628a13592a5d0f5cc0ca93f6cce5f0c265258ca/docs/METRIC_CERTIFICATION_LOG.md