PPC bid sheet

Weekly Sponsored Products bid comparison

A small studio calculator for an Amazon Sponsored Products campaign. Enter three to five target keywords with the daily bid, the suggested low / high band the network serves, and a rank-delta placeholder column. The sheet totals the 7-day weekly spend at your bids and shows a worst / best range.

Math runs client-side. Move any input and the weekly totals update live. No fetch, no DB — a single formula module under src/lib/business.

Assumptions in use

Week length
One calendar week
7 days
Worst band
Bid × 0.75 × 7
−25%
Best band
Bid × 1.25 × 7
+25%
Keyword rows
Comparison-ready
3 – 5

Comparison sheet

3 keywords

Bid the matrix.

One row per target keyword. Daily bid is yours; the low / high band comes from the ad network. The rank-delta column is a placeholder for a manual note.

Keyword	Daily bid	Suggested low	Suggested high	Rank delta (Δ)
Keyword 1	Daily bid row 1 $	Suggested low row 1 $	Suggested high row 1 $	Rank delta row 1
Keyword 2	Daily bid row 2 $	Suggested low row 2 $	Suggested high row 2 $	Rank delta row 2
Keyword 3	Daily bid row 3 $	Suggested low row 3 $	Suggested high row 3 $	Rank delta row 3

3–5 keywords. The sheet totals 7-day weekly spend at the worst / best band (≤ ±25%).

Weekly totals

Worst ↔ Best

What the bid totals

Live at the daily bids above. Worst / best band pads ±25% across a 7-day week.

7-day weekly spend

At your daily bids

$14.70 – $24.50

$2.80/day across 3 keywords

Worst = bid × 0.75; best = bid × 1.25. Floor and ceiling only — the bid network may overshoot.

Per-keyword weekly

3 rows

$8.40 · $6.30 · $4.90

At the daily bid × 7

Tallies stay above zero once the bid crosses zero. Negative low deltas flag keywords below the network low (raise the bid or skip).

Continue the math

Back out — round-trip the rest of the studio

Cross-check this bid against the headline numbers the rest of the studio lands on.

Back to /scorecard Back to /tools/cpm-pad