Flow Forecast & Actuals Hub

Import raw Flow Forecasts or Historical Actuals, stage interval-level curves, auto-sync parameters, and evolve database schemas dynamically.

AI Forecasting Go to Planner
Upload Flow Forecast File
Download Template (.xlsx) .xlsx Supported
Select the target Org node for this flow forecast.
Click to browse or drag & drop Flow Forecast Excel

Supports standard Flow Forecast format (.xlsx)

Pipeline Execution Summary
Idle

Upload a Flow Forecast file to see ingestion stats, dates processed, and live calculated intervals.

Dates Processed
0
Intervals Synced
0
Automated Provisioning
  • Staged raw data into dbo.Stg_FlowForecastData
  • Synced intervals into dbo.VolumeForecast
  • Auto-mapped parameters and volume-weighted SUMPRODUCTs
View Fresh Data in Planner
Automated SFTP Feed
Active

Automated hourly ingestion drop directory:

Cron Schedule: Hourly (0 * * * *)
Upload Historical Actual Data
Download Template (.xlsx) .xlsx Supported
Select the target Org node for historical actuals (powers AI Forecast & Variance).
Click to browse or drag & drop Actual Data Excel

Supports interval actuals format (.xlsx)

Actuals Ingestion Summary
Idle

Upload an Actual Data file to see upsert stats, dates processed, and interval counts.

Dates
0
Inserted
0
Updated
0
Data Pipeline Benefits
  • Idempotent UPSERT into dbo.ActualData
  • Supports dynamic column expansion and schema evolution
  • Immediately available in AI Forecasting Model Tournament
Open AI Forecasting Hub
Target Parameters for AI Forecasting Engine
Source: ActualData

Select which parameters from the ActualData table are eligible for AI time-series forecasting. Active parameters will appear in the AI Forecast Engine dropdown. (Note: Service Level and Service Time are derived Erlang KPIs and are permanently excluded from direct forecasting).

Active Parameter Column Name Display Label Target Table Mapping
Volume Volume (Calls / Interactions) ActualData.ActualVolume
AHT AHT (Average Handle Time) ActualData.AHT
OutOfOfficeShrinkage Out of Office Shrinkage (%) ActualData.OutOfOfficeShrinkage
InOfficeShrinkage In Office Shrinkage (%) ActualData.InOfficeShrinkage
Parameter Rules
  • Volume: Toggles Volume Forecasting in the AI Forecast dropdown. Default is unchecked.
  • AHT: Forecasts average handle time in seconds based on historical distribution.
  • Shrinkage: Predicts shrinkage % (Out of Office / In Office) for capacity planning.
  • Service Level & Service Time: Computed dynamically via Erlang algorithms, never directly forecasted.