Products Solutions Templates Pricing Resources

Real-time dashboards versus scheduled reports: choosing the right refresh rate

Home / Everything About / Everything About Analytics / Real-time dashboards versus scheduled reports: choosing the right refresh rate

Two approaches to dashboards: real-time and scheduled.

Real-time dashboard updates every minute or hour. Operational dashboard for ops team watching uptime. Ops sees error rate spike in real-time. Ops responds immediately. Cost: expensive infrastructure to compute metrics constantly.

Scheduled dashboard updates once daily at 6am. Executive dashboard. CEO sees revenue at 6am. Sufficient for decisions made daily. Cost: cheap, simple infrastructure.

Choose based on decision frequency and cost tolerance.

When real-time is needed

Operations dashboards

System can go down. Ops needs to know immediately. Delay of one hour is too late. Build real-time.

Incident response dashboards

Problem happens. On-call engineer needs to see current status. Stale data is dangerous. Build real-time.

Trading dashboards

Seconds matter. Data that is five minutes old is useless. Build real-time.

Customer-facing dashboards

Customers want to see current system status. Showing status from six hours ago is misleading. Build real-time.

When scheduled is fine

Executive dashboards

CEO checks once daily. Data from 6am is fine. Decision is made once daily. Cheaper to compute once daily.

Marketing dashboards

Campaign data refreshes daily. One day delay is not critical. Team makes decisions once daily.

Financial dashboards

Month-end data is final. Daily updates are not needed. Weekly or monthly is fine.

Sales dashboards

Sales manager checks quota daily. Data from yesterday is fine. Decision is made based on recent data, not real-time.

Cost comparison

Real-time dashboard: infrastructure cost one hundred thousand dollars per year. Maintenance cost fifty thousand per year. Total: one hundred fifty thousand annually.

Scheduled dashboard: infrastructure cost five thousand dollars per year. Maintenance cost five thousand per year. Total: ten thousand annually.

Difference: one hundred forty thousand dollars per year. Huge. Only use real-time if you truly need it.

Real example: three dashboards at different refresh rates

Executive dashboard (scheduled daily at 6am)

Revenue, churn, acquisition cost, expansion revenue. Updated once daily. Cost: low.

Sales dashboard (scheduled hourly)

Pipeline, quota, forecast. Updated hourly at top of each hour. Ops team checks at start and end of day. Cost: moderate.

Operational dashboard (real-time)

Uptime, error rate, response time. Updated every minute. Ops team watches continuously. On-call engineer uses for incident response. Cost: high.

Strategy

Three dashboards with three different refresh rates. Each is optimized for use case. Do not make all dashboards real-time (too expensive). Do not make all scheduled (miss real-time problems).

Hybrid approach: real-time alerts plus scheduled dashboards

Dashboard updates once daily (cheap). Alert fires if metric crosses threshold (expensive but precise). Example: revenue dashboard updates daily. But alert fires if daily revenue drops fifty percent (real-time threshold check). Alert is rare but real-time when needed. Saves cost while maintaining responsiveness.