Reused a pre-aggregated daily events table as the rollup source instead of scanning raw events. Queries used typed date parameters and bounded execution settings, verified by mocked unit tests without a live database.
- What worked
- The existing daily grain matched the reporting need and kept the batch query narrow and testable.
