Is a revenue metric moving, or is the calendar moving it?

Research question

A week-over-week or month-over-month change may reflect demand, selling capacity, reporting cutoffs, weekdays, holidays, quarter-end behavior, or a recurring campaign calendar. A raw comparison cannot identify which explanation is responsible. The Office for National Statistics describes time series as combinations of systematic calendar effects, irregular fluctuations, and trend behavior. This review asks how a GTM team can inspect those components without declaring every recurring pattern seasonal or treating an adjusted series as observed fact.

Preserve an observation calendar

Build a calendar that records period start and end, working days, regional holidays, fiscal cutoffs, major releases, pricing changes, campaigns, outages, and data backfills. Keep the raw timestamp and the reporting-period assignment. Monthly totals with different numbers of selling days are not directly comparable when daily opportunity creation is material. A stable calendar also exposes silent definition changes, such as moving an outcome from booking date to invoice date or changing the timezone used at the cutoff.

Plot the raw series first

NIST recommends time-order plots because averages alone hide shifts, cycles, outliers, and changes in variation. Show counts, values, and rates rather than one normalized metric. Annotate known interventions without deleting inconvenient observations. Compare the same period across prior cycles and inspect whether amplitude changes with the level. If the business is young or has changed its motion repeatedly, there may be too little stable history to estimate a recurring seasonal pattern. That limitation belongs in the result.

Distinguish seasonal and calendar effects

Seasonal effects recur around a time of year, while calendar effects depend on the composition or timing of the calendar, such as weekdays or movable holidays. Fiscal quarter pressure may be an organizational cycle rather than an external season. Model these drivers separately where possible and document which calendars apply to each market. Pooling regions with different holidays can blur patterns. Adjusting for a pattern should follow evidence that it is sufficiently stable and relevant to the decision horizon.

Investigate dependence across time

An autocorrelation plot measures association between observations separated by different lags. Peaks near a seasonal frequency can support investigation, but ONS cautions that seasonal-frequency autocorrelation is not proof of seasonality. Trend, changing variance, reporting artifacts, or an omitted event can create similar signals. Spectral plots can reveal dominant frequencies, while run-sequence plots help identify shifts and outliers. Use several diagnostics and inspect residuals after any adjustment rather than relying on one statistical flag.

Handle interventions and revisions

A product launch, acquisition, routing change, price increase, or outage may create a level shift that should not be absorbed into the seasonal component. Record interventions before fitting and test reasonable alternatives. Data revisions also matter because late outcomes can make recent periods look artificially weak. Maintain vintage snapshots showing what was known at each reporting date. Backtesting on the final corrected series can overstate the quality of a process that must operate with incomplete real-time data.

Publish raw and adjusted views

An adjusted series is a model-derived aid for comparison, not a replacement for the observed record. Publish the raw series, adjusted series, method version, included effects, revision policy, and enough uncertainty to discourage false precision. Explain whether the model is additive or multiplicative and how it treats changing amplitude. Do not use adjusted results to rewrite accountable financial totals. Their role is to help interpret movement, form forecasts, and identify unusual departures that deserve operational review.

Set a decision rule before the next period

Define which question the series supports: staffing, campaign pacing, pipeline coverage, or anomaly review. Choose a baseline and tolerance that reflect historical forecast error and business cost. A large deviation may trigger investigation rather than an automatic strategy change. Re-estimate on a declared cadence and compare revised factors with prior versions. If the process cannot distinguish calendar composition from recurring demand, use simpler same-week or same-month comparisons and state the limitation instead of presenting a fragile seasonal adjustment as settled evidence.

Sources

1. Seasonal adjustment, Office for National Statistics. Separates systematic calendar effects, irregular fluctuations, and trend so consecutive periods can be interpreted more carefully.
2. Assessing residual seasonality, Office for National Statistics. Explains why seasonal-frequency autocorrelation is evidence to investigate rather than proof of one specific cause.
3. Time series plot, National Institute of Standards and Technology. Uses observations in time order to reveal shifts, trends, cycles, outliers, and changes in variability.
4. Autocorrelation plot, National Institute of Standards and Technology. Shows how correlation across time lags can diagnose randomness, dependence, and recurring structure in a series.
5. Spectral plot, National Institute of Standards and Technology. Describes frequency-domain analysis for identifying dominant cyclical components in sequential observations.
6. Run sequence plot, National Institute of Standards and Technology. Supports visual checks for location, scale, outliers, and temporal structure before applying summary statistics.
7. Exploratory data analysis, National Institute of Standards and Technology. Prioritizes graphical examination, assumption checking, robust summaries, and pattern discovery before formal modeling.
8. Engineering Statistics Handbook, National Institute of Standards and Technology. Provides official methods for exploratory analysis, process monitoring, uncertainty, forecasting, and model checking.
9. Government Data Quality Framework, United Kingdom Government Data Quality Hub. Makes timeliness, consistency, accuracy, completeness, validity, and uniqueness explicit dimensions of usable data.
10. Quality in official statistics, Office for National Statistics. Provides guidance on comparability, coherence, uncertainty, revisions, and communicating the limits of statistical outputs.

Related GTM research

• Right-censored sales cycle analysis
• Probabilistic sales forecast calibration