Adjustment Detector

AI-Powered Pacing Analysis & Recommendations

1
SDLY
SDLY Sheet
Current spend vs SDLY
C4 Today total
F4 Cumulative %
L52W
L52W Sheet
Forecast models
B35-B38 L1HR, L3HR, L6HR, Cum
CFG
Config (D)
B4 Daily budget
B11 Adjusted budget
B10 MTD balance
|
2
fx
Calculate EOD Forecasts
4 models predict end-of-day spend:
L1HR, L3HR, L6HR, Cumulative
|
3
vs
Compare vs Adjusted Budget
Delta % = (EOD Forecast - Adj Budget) / Adj Budget
Per model
|
4
?
Determine Consensus
All/most models agree?
OVER_BUDGET | UNDER_BUDGET | ON_PACE
|
5
!
Calculate Severity
Based on average delta %
EXTREME to ON_PACE
|
6
REC
Generate Recommendation
Direction: PUSH | PULL | HOLD
Strength: 5-30%
Confidence: LOW to HIGH
Data Source
Calculation
Decision Point
Severity Assessment
Output

Severity Scale

EXTREME
>25%
VERY HIGH
20-25%
HIGH
15-20%
MEDIUM
10-15%
LOW
5-10%
VERY LOW
2-5%
ON PACE
<2%
Urgent action needed No action

Recommendation Logic

Consensus?
OVER_BUDGET
PUSH (reduce ROAS)
ON_PACE
HOLD (no change)
UNDER_BUDGET
PULL (increase ROAS)

Data Flow Details

Forecast Models

  • L1HR - Last 1 hour run rate
  • L3HR - Last 3 hours run rate
  • L6HR - Last 6 hours run rate
  • Cumulative - All hours weighted

Strength Mapping

  • EXTREME: 25-30%
  • VERY_HIGH: 20-25%
  • HIGH: 15-20%
  • MEDIUM: 10-15%
  • LOW: 5-10%
  • VERY_LOW: 5%

Confidence Factors

  • Model agreement (all vs mixed)
  • Hours remaining in day
  • MTD balance context
  • Historical accuracy

User Actions

  • Approve - Accept recommendation
  • Override - Change strength/direction
  • Let It Run - Monitor, don't act
  • Apply to BSP - Open BSP Calculator