Log Bid Change

Document Bid Adjustments for AI Accuracy Tracking

1
USER
User Input
Direction: PUSH or PULL
Magnitude: e.g., 20%
Reason (optional): context note
|
2
READ
Read Current State
From SDLY sheet:
Current hour, Today spend, vs SDLY %
|
3
LOG
Write to AI Accuracy Log
Appends row to AI Accuracy sheet:
Date, Hour, Direction, Magnitude, Context
User Input
Read Data
Write Log

Input Form (Dashboard)

Direction
PUSH / PULL
Magnitude
20%
Reason
Over budget early

Log Entry Written

Date
12/24/2024
Hour
14
Direction
PUSH
Magnitude
-20%
Spend
$45,230
vs SDLY
+8.5%

Data Flow Details

PUSH vs PULL

  • PUSH: Reduce ROAS = spend more = negative sign
  • PULL: Increase ROAS = spend less = positive sign
  • Sign auto-calculated from direction
  • Displayed as -20% (PUSH) or +20% (PULL)

Context Captured

  • Current hour of day
  • Today's cumulative spend
  • % change vs SDLY (same day last year)
  • Optional: Recommendation ID (if from Detector)

AI Accuracy Sheet

  • Historical log of all bid changes
  • Used for ML model training
  • Tracks AI recommendation accuracy
  • Links to Detector recommendations

Use Cases

  • After approving Detector recommendation
  • Manual adjustment without Detector
  • Override with different magnitude
  • End-of-day position recording