The calendar moves your numbers before patients do
Every specialty brand reads its numbers by week, month and quarter. Those periods are not the same size. A week with a holiday has fewer days when prescriber offices send referrals, hubs run benefits checks, payers decide prior authorizations and specialty pharmacies ship. A month can hold four weekly data loads or five. A quarter can have several more working days than the one before it. None of this changes how many patients need therapy, yet all of it changes the count on the dashboard.
The pattern is easiest to see at the end of the year. Thanksgiving week shows fewer new patient starts, and the following week shows a rebound. The last two weeks of December dip again, and early January looks strong as delayed work clears, just as plan year changes start to stall refills. Each move gets an explanation in a meeting, and some get an action plan. Many of them were the calendar.
The fix is not a sophisticated model. It is a shared calendar table, a few written rules for comparing periods of different sizes, and the discipline to show both the raw and the adjusted view. This article covers where calendar effects come from in specialty pharma data, how they reach the QBR and what good reporting looks like.
Where calendar effects come from
Holiday weeks
Offices close or run short, hubs and payers work fewer days, and pharmacies ship less. Referrals, approvals and first fills slide into the next week rather than disappearing.
- A dip, then a rebound of similar size
- Thanksgiving, Christmas and New Year weeks most visible
Uneven months
Months differ in working days, and in how many weekly pharmacy files they contain. A month with five Friday loads can look like a strong month for that reason alone.
- Working days differ month to month
- Four or five weekly loads per month
28-day fills
A product dispensed every 28 days produces 13 fills a year, so one calendar month each year holds two fills for the same patient. Monthly TRx rises with no new patient.
- A spike that repeats on a fixed cycle
- Units rising faster than patients
Unequal quarters
Quarters differ in working days and in where the holidays fall. Quarter on quarter growth can be partly a difference in days, which matters when goals and incentive pay are set on it.
- Growth that is partly the calendar
- Goals set on one quarter, paid on another
How it reaches the QBR
What good looks like
One shared calendar table
Every date with its week, month and quarter, a working day flag, the US holidays your offices and pharmacies observe, and the number of weekly data loads in each month. Every report joins to it, so nobody counts days by hand.
Per working day views beside raw counts
Show new patient starts, referrals and first fills per working day next to the raw total. Leaders see the real volume and the rate, and can tell which one moved.
Holiday weeks compared with holiday weeks
Compare Thanksgiving week with last year's Thanksgiving week, not with the week before. Mark holiday weeks on every trend chart so the dip arrives with its label.
Patients and days of therapy for refill-driven measures
Where fills follow a 28-day or other fixed cycle, report patients on therapy or days of therapy alongside TRx, so a double-fill month does not read as growth.
Working day rules written into goals
Agree in writing how quarters with different working days are compared for goals and incentive compensation, before the quarter starts rather than in the dispute after it.
Clocks that state what they count
Report time to therapy in calendar days and in working days, and say which one a target uses. Patients wait in calendar days. Teams work in working days. Both are useful when labelled.
Questions leaders ask about selling day adjustment
What is selling day adjustment in pharma reporting?
Why do new patient starts dip in Thanksgiving week and rebound the week after?
How do 28-day fills distort monthly TRx?
Should time to therapy be measured in calendar days or working days?
What is the simplest first step?
Compare notes on your holiday season reporting
Tell us how your weekly and monthly numbers handle holidays and uneven periods today. We will show where calendar effects are being read as demand and what a shared calendar table would change. More on our work at specialty pharma analytics and automation.
Part of our Pharma Commercial and Patient Analytics hub. Start with our specialty pharmacy analytics.