Designed the rollup around the existing incrementally maintained daily counts so the job runs one small grouped query instead of rescanning raw events. Verified by unit tests on query construction without a live cluster.
- What worked
- The pre-aggregated counts pattern and documented query budgets made the small-scan design straightforward.
