Harpy Guide

Dayparting — Timing Your Amazon Spend

13 min read · Harpy Media

Stop paying the same price for every hour's clicks: the complete dayparting method — hourly data, conversion zones, bid modifiers, and the mistakes that ruin it.

Part 1

What dayparting actually is

Your campaigns run 24 hours a day. Your customers don't shop the same way across those 24 hours. At 10 AM a shopper sees your product, clicks, buys — done. At 10 PM a different shopper clicks, browses three competitors, watches a video, and forgets about it. Same keyword, same bid, completely different outcome.

Dayparting is how you stop paying the same price for both of those clicks: adjust bids by time of day and day of week — higher when shoppers are buying, lower when they're merely browsing. Spend, conversion, and revenue per click all follow natural daily patterns, sometimes dramatic ones. Dayparting aligns your CPC with those patterns instead of running one flat bid around the clock.

Two dimensions matter. Hourly dayparting — bid up from 8 AM to noon, down from 10 PM to 6 AM. Weekparting — bid up Tuesday to Thursday, down on weekends. They stack, and the stacking compounds (Part 5 covers that math — it surprises people).

🔑 Key insight. As a broad pattern, daytime hours convert meaningfully better — often 20–30% — than evening hours. More mobile shopping by day (higher conversion) versus more desktop comparison-shopping at night. B2B and office products see the same effect amplified.
💡 Tip. Where dayparting fits: it is an advanced optimization — the top of the pyramid, not the foundation. If bidding fundamentals, targeting, and structure aren't solid yet, fix those first. On a sound foundation, dayparting genuinely shifts performance.

Part 2

Choosing the right tool

Three ways to implement dayparting; the right one depends on campaign count and how seriously you optimize.

Amazon's native scheduled rules

The ad console now lets you set percentage bid adjustments for specific hours or days, per campaign. Free, built-in, and clean — modifiers apply at auction time, so your change history stays readable and the bid in the console remains your true base bid. The limits: one campaign at a time (no bulk application — a real bottleneck past a few dozen campaigns), no visual schedule builder, no heatmap, and no built-in calculator, so the percentages are still your spreadsheet's job.

Dedicated PPC platforms

Management platforms layer dayparting into a full workflow: a visual week grid where every cell is a percentage modifier, one schedule applied across hundreds of campaigns at once, and the modifier math handled for you. The value isn't glamour — it's that the optimization actually gets deployed everywhere it should. Cutting late-night bids on 10 of 200 campaigns because rule setup got tedious leaves the savings on the table.

Manual bid changes — don't

Adjusting bids by hand at different hours isn't a strategy; you'd need to be awake and logged in around the clock, and every change clutters your bid history.

🔑 Key insight. Whatever tool you use, the principle is the same: percentage modifiers on top of a clean base bid — never tools that rewrite your actual bid values through the API, which floods the changelog and makes real issues harder to debug. And don't confuse dynamic bidding (Amazon adjusting your bid per auction by conversion likelihood) with dayparting (you adjusting by time pattern). They're different systems — and they stack.

Part 3

Pulling your hourly data

Before touching a bid, get the data. The Sponsored Products campaign report includes hourly breakdowns — that's the starting point.

1. Download the report.Reports → Sponsored Products → Campaign report. At least 30 days; 60–90 is better. Make sure the time unit is hourly. You get rows by date and hour with impressions, clicks, spend, orders, sales.
2. Add a weekday column.The report has date and hour but no day-of-week. Add a column with =WEEKDAY() (Sunday = 1, Saturday = 7).
3. Build two pivots.Hourly pivot: rows = hour, values = impressions, clicks, spend, orders, sales. Weekly pivot: rows = weekday number, same values.
4. Calculate ratios manually.Copy-paste the pivot output as values, then compute CPC, CVR, ACOS, RPC from the totals — never inside the pivot.
⚠️ Watch out. The pivot trap: dragging ACOS or CVR into a pivot's value field gives you a SUM or AVERAGE of per-row percentages — mathematically wrong. Percentages can't be averaged that way. Always derive ratios from aggregated totals: total spend ÷ total sales, total orders ÷ total clicks.

If you kept campaign names in the raw data, drop them into the pivot's filter area — different product categories often have different shopping rhythms, and drilling into one campaign group beats staring at the account-wide blur.

💡 Tip. Time zone: Amazon's hourly reporting runs on Pacific Time as far as anyone has established — plan your rules against PT, and double-check against when your own orders actually land.

Part 4

Finding the conversion trends

This is where most attempts fail at step one: they look at the wrong metric.

The mistake — chasing order volume

“We get most of our orders between 6 and 10 PM, so let's bid up in the evening.” Backwards. There are more orders in the evening because there's more traffic in the evening. More traffic at a lower conversion rate means you're paying more per sale, not less. You're not chasing total orders — you're chasing conversion efficiency.

🔑 Key insight. The metrics that matter are conversion rate and revenue per click. They tell you when each click is most likely to become money — not when the most clicks happen. The two move together; use whichever you prefer.

Build the heat map

Apply conditional formatting to the hourly data: green for high CVR/RPC, red for low, and the inverse scale for ACOS (high ACOS = red). CPC gets a neutral scale — expensive clicks aren't inherently bad, only expensive relative to conversion. An illustrative shape of what typically falls out:

Hour blockCVRRPCACOSSpend shareSignal
12–4 AM5.8%$1.2068%4%Low volume, low CVR
5–7 AM14.2%$5.1028%6%Hidden gem — high CVR on quiet volume
8 AM–12 PM16.8%$6.4024%22%🔥 Peak zone — bid up
1–4 PM12.1%$4.3033%20%Solid — keep baseline
5–8 PM9.4%$3.1044%28%High volume, lower CVR
9–11 PM7.2%$2.0052%20%Browsing traffic — bid down

Those numbers are illustrative — your account's pattern is the whole point, and it will differ. Don't aim for hour-by-hour precision either. You're looking for zones: a morning peak block, an afternoon baseline, an evening cool-down. That's the granularity that pays.

The difference-from-average column

Deviation = (Hourly RPC ÷ Total-average RPC) − 1Total RPC $4.00; 9 AM at $5.40 = +35%. 9 PM at $2.40 = −40%

That one calculation makes dayparting actionable: each hour's deviation from the account average becomes the basis for its bid adjustment.

Part 5

Calculating bid adjustments

The simple approach — start here

Amazon's native scheduled rules only allow bid increases. That constraint actually produces a clean starting strategy: set your base bids 10–15% below your normal optimum, then add a scheduled increase during peak conversion hours — say +25% from 8 AM to 2 PM. Peak hours get full aggression; the rest of the day runs at your lowered base, which is effectively the decrease.

💡 Tip. Quick start: if your peak hours convert 25%+ better than average, deploy a +25% rule on those hours with a 10–15% base-bid reduction, and monitor two weeks before expanding.

The compounding math — the part that catches everyone

Stacked rules multiply, they don't add — and placement modifiers stack on top:

$1.00 base × 1.25 (day rule) × 1.25 (hour rule) × 2.00 (top of search) = $3.12Multiple scheduled rules active at once compound multiplicatively

A “modest” day rule plus an hour rule plus your top-of-search modifier can triple a base bid before you notice. Run the compounding math before deploying anything — if your base bids are already aggressive, even a 25% dayparting layer can blow out CPCs. This is the single best argument for starting conservative.

Day-of-week adjustments

Run the same analysis on the weekly pivot. Common shapes: B2B brands convert strongly Monday–Friday and fall off a cliff on weekends (with Monday and Wednesday often standing out); consumer brands run flatter but frequently spike Sunday evening into Monday morning; impulse and low-ticket products often convert best on weekends when people are relaxed and browsing.

💡 Tip. Power move: filter the hourly pivot to a single block — say 8 AM to noon — and read it across days of the week. Sometimes the real goldmine isn't “Wednesday” or “mornings” but Wednesday mornings specifically.

Part 6

Three ways to ruin dayparting

Done right, dayparting meaningfully improves performance. Done wrong, it destroys it — and all three of these mistakes are actively taught or automated somewhere.

1. Following hourly sales volume

The most prevalent version, and it's simply the wrong signal. Evening has more orders because it has more traffic; if daytime converts at 15% and evenings at 8%, bidding up in the evening means paying more per click during the exact hours each click is least likely to convert. ACOS is CPC × conversion — raise CPC while conversion falls and ACOS spikes. That's arithmetic, not opinion. Chase conversion rate, with volume as the secondary filter (a great window needs enough traffic to matter).

2. Daypausing

Pausing campaigns entirely during “bad” hours and reactivating for “good” ones. It's the same error as negating a keyword with high ACOS instead of lowering its bid — you throw away every sale from that window instead of capturing it at a lower price. People still buy at midnight; the conversion rate is lower, not zero. Pause, and those sales belong to your competitors. Lower the bid, and you still win the economical ones.

⚠️ Watch out. The midnight-to-4 AM pause is a meaningless gesture: those hours typically carry around 1% of daily spend. You've added operational complexity to save pocket change while handing your competitors cheap sales.

3. Day budgeting

The newest bad idea — tools that wiggle the daily budget through the day instead of adjusting bids. It can't work mechanically: a campaign is either in-budget or out, on or off. Raise the budget while in-budget → nothing changes. Lower it while out → nothing changes. You've built an unpredictable pause/unpause roulette whose outcome depends on real-time auction dynamics you can't see. Budgets can't modulate CPC — and CPC is the entire lever. If a tool dayparts by budget, it's solving the wrong problem.

🔑 Key insight. Dayparting is bid control, period. Percentage modifiers on top of a clean base bid — that's the only mechanism that moves CPC by hour without wrecking your account's manageability.

Part 7

Implementing, iterating, and knowing when to skip it

Deploying in the console

Inside any Sponsored Products campaign, under the bidding strategy section, you'll find scheduled rules: an increase percentage plus a time block (hours or days). Multiple rules can coexist and compound when simultaneously active. The catch: rules are added campaign by campaign — no bulk operation yet — so for larger accounts, budget an hour or two and start with your top-spending campaigns where the impact concentrates.

What to expect

Deploying dayparting changes the CPC curve, which changes spend distribution, which changes where clicks land — so give it at least two weeks before judging. The typical shape: total spend roughly flat (you're redistributing, not adding), ACOS stabilizing as the peak/trough swings smooth out, total sales rising because more of your clicks land in windows where they convert, peak-hour CPCs up by design and off-peak CPCs down from the lowered base.

When dayparting isn't worth it

Skip it when...Why
Low daily spendHourly data too thin for reliable patterns — fix bidding and targeting fundamentals first
Flat intraday curveIf CVR barely moves between 8 AM and 10 PM, there's nothing to optimize around — check before assuming
Bigger fires burning80% ACOS and tangled structure? Dayparting is rearranging deck chairs. Fix the foundation
💡 Tip. The litmus test: pull hourly data and read the RPC or CVR deviation from average. Swings of 20%+ between best and worst hours mean dayparting can move real money. Under 10% — spend the effort elsewhere.

Volume follows bids

The most important lesson after deployment: the hourly sales curve isn't fixed. Bid up in daytime hours and you win more of those auctions — more impressions, more clicks, more sales in that window. Accounts whose order curves were evening-dominated have watched the curve invert after a few months of daytime bidding: not because shoppers changed, but because the account started winning the mornings. You don't just respond to the volume curve — you reshape it.

That's the full method: pull the data, find the zones, calculate the deviations, deploy conservative modifiers, iterate monthly. If you'd rather have us run the analysis on your hours and hand you the schedule, the first diagnosis is free.

Want this run on your account instead? The first diagnosis is free.

Book Free Consultation

New guides, straight to your inbox.

Practical D2C playbooks as we publish them. No fluff, no spam — unsubscribe anytime.