Dashboard
|
Architecture
|
Flows:
Morning Flow
Morning Setup
Hourly Update
Detector
BSP
Log Change
Weekly Pulse
|
Data Flow
sheetflo.app Dashboard
Google Ads Budget Tracker - Control Center
Checking...
cd app && npm run dev
Check Status
--
Hour
(PT)
:
--
--
Daily Workflow
1
Morning Flow
Capture yesterday
2
Morning Setup
Initialize today
3
Hourly Update
Refresh as needed
4
Log Changes
Document bids
① Morning Setup
AM
Morning Flow
6-9 AM window
Captures yesterday's forecast accuracy to
Yesterday
sheet:
• SDLY Forecast vs Real Spend (hourly)
• L1HR/L3HR/L6HR forecasts from L52W tracker
Run Morning Flow
GO
Morning Setup
Once per day
Initialize today's tracking:
• SDLY data refresh
• L52W historical data by day of week
• MTD balance status check
Run Morning Setup
② Pacing & Adjustment
UPD
Hourly Update
Anytime
Refresh today's spend data + auto-run Adjustment Detector.
Run Hourly Update
DET
Adjustment Detector
Auto-runs with Hourly Update
Pacing analysis results. Compares EOD forecasts vs MTD-adjusted budget.
Run Detector
BSP
BSP Calculator
After L30D refresh
Bid Strategy Portfolio calculator. Refresh L30D data before applying adjustments.
Refresh L30D Data
③ Logging & Reporting
LOG
Log Bid Change
After adjustments
Document bid adjustments with context.
PUSH
PULL
-
Log Change
WP
Weekly Pulse
Weekly (Mondays)
Full report: GA4 L30, YoY, Google Ads CPM/CPC, and Performance Master sync.
Run Weekly Pulse