Seasonality and Day-of-Week Effects in Raw Feeds
Recurring calendar patterns baked into alternative data, weekday reporting cycles, month-end spikes, holiday gaps, that can masquerade as a real signal unless they're identified and controlled for first.
A raw alternative data feed, web traffic, credit-card transactions, satellite counts, app downloads, is rarely a clean stream of underlying business activity. It's usually contaminated with mechanical calendar patterns that have nothing to do with the thing being measured: retail foot traffic naturally spikes on weekends, credit-card processors batch and report transactions with a lag that varies by day of week, and many providers show artificial dips or gaps around public holidays simply because fewer people are generating data, not because underlying demand changed.
If these patterns aren't identified and removed, they can easily be mistaken for genuine predictive signal, a strategy that appears to "predict" retail sales might just be re-discovering that Saturdays are busier than Tuesdays, a fact any calendar already tells you for free, contributing zero real alpha despite looking statistically significant in a naive backtest. The standard fix is seasonal adjustment: estimating and subtracting out the recurring day-of-week, day-of-month, and holiday components before looking for anything else in the series, often using a rolling average of the same weekday across recent weeks as a baseline.
This matters most for data with irregular collection cadence, where a provider's own operational quirks, a batch job that runs only on business days, a scraper that misses holidays, get baked directly into the feed and are easy to confuse with the underlying economic reality the data is supposed to represent.
Raw alternative data feeds routinely carry mechanical calendar effects, weekday cycles, month-end spikes, holiday gaps, from collection and reporting processes rather than genuine business activity, and failing to seasonally adjust for them is a common way naive backtests mistake a calendar artifact for real predictive signal.
Discussion
💡 Discussion rules
- Ask and answer about this concept. Off-topic gets removed.
- No homework dumps. Show what you tried first.
- Corrections are welcome. Cite a source when you claim an error.
Loading discussion…
Related concepts
- A Scorecard for Ranking Candidate Datasets
- PII and Anonymisation Checks Before Onboarding
- Aggregating Raw Records Into a Company Panel
- Getting a Useful Trial Sample
- How Much History Do You Actually Need?
- Keeping a Data Inventory Researchers Will Use
- Mapping a Vendor Dataset to Your Universe
- Normalising Counts Across Entities of Different Size
Further reading
- Kolanovic & Krishnamachari, Big Data and AI Strategies, JPMorgan