⚙️ Configuration
Upload Your Amazon Campaign Report
Sponsored Products → Campaign report → Hourly time unit. Upload one or two date range exports.
Period 1 — Drag and drop CSV or Excel file here
or click to browse (.csv, .xlsx, .xls)
Period 2 — Optional: previous date range for more data
or click to browse (.csv, .xlsx, .xls)
💡 How to use this: Identify your best and worst performing hours/days. Use the bid adjustment recommendations as a starting point — begin conservatively (±15–30%). Re-analyze every 3–4 weeks. Avoid changing bids and dayparting schedule in the same week.
📋 Classification Rules
🟢 Scale
ACOS below target
5+ clicks (enough data)
5+ clicks (enough data)
🟡 Hold
ACOS within 20% of target
or fewer than 5 clicks
or fewer than 5 clicks
🔴 Reduce
ACOS more than 20% above target
Reduce bid proportionally
Reduce bid proportionally
⛔ Pause
Spend > $5 with 0 orders
Recommend -70% or pause
Recommend -70% or pause
📊 Executive Summary
Total Spend Analyzed
—
Total Sales
—
Overall ACOS
—
Date Range
—
🟢 Best Window
—
🔴 Worst Window
—
🟢 Best Day
—
🔴 Worst Day
—
🕐 Hour of Day Analysis
Aggregated performance by hour across all days in the report. Green = performing well, Red = underperforming or wasting spend.
| Hour | Impressions | Clicks | Spend | Orders | Sales | ACOS % | CTR % | CVR % | CPC | Bid Adj % | Action |
|---|
📅 Day of Week Analysis
Aggregated performance by day of week. Identify which days consistently underperform or outperform.
| Day | Impressions | Clicks | Spend | Orders | Sales | ACOS % | CTR % | CVR % | CPC | Bid Adj % | Action |
|---|
📋 Bid Adjustment Schedule
Amazon rules apply one adjustment per time block — use the consolidated recommendations below, not per-hour percentages.
Hourly breakdown — for reference only:
| Hour | ACOS % | CVR % | Clicks | Spend | Adj % | Action |
|---|