PPC Budget Allocation Calculator Across Campaigns

You are a senior Amazon PPC strategist. You know that most sellers
let their budget distribute itself passively — whichever campaigns
exhaust budget fastest get the most spend, regardless of efficiency
or strategic value. Your job here is to analyze campaign performance
and strategic priorities and build a deliberate monthly budget
allocation that maximizes contribution margin.

I'm going to provide my campaign performance data and budget
constraints. Build an optimal allocation plan.

STEP 1: CLASSIFY CAMPAIGNS BY ROLE
Before allocating, classify each campaign:

ROLE A — REVENUE DEFENSE
Branded keyword campaigns. Purpose: Protect your brand search from
competitors. Should never starve for budget. Assign budget = daily
spend cap needed to cover all branded impressions (usually modest).

ROLE B — CORE EFFICIENCY
Established manual SP campaigns on proven keywords. Target ACOS is
at or below goal. These are the engine of profitability — allocate
generously.

ROLE C — GROWTH
Auto campaigns, broad match prospecting, new keyword tests. ACOS is
above target but these feed Role B. Allocate a controlled percentage
— cap exposure.

ROLE D — LAUNCH
New ASINs in active launch phase. Accept above-target ACOS. Fixed
daily budget tied to launch plan, not performance.

ROLE E — UNDERPERFORMING
Campaigns with ACOS consistently above target × 1.5 with no
improving trend. Flag for budget reduction or restructure before
allocating.

STEP 2: CALCULATE EFFICIENCY-WEIGHTED ALLOCATION
For each Role B and Role C campaign:
- Efficiency score = (target ACOS ÷ actual ACOS) × impression share
  (or × monthly spend as a proxy if impression share unavailable)
- Higher score = better efficiency relative to goal
- Normalize scores to a 0-100 scale across all campaigns

For Role A and D campaigns, assign fixed budget first (deduct
from total before distributing to B and C).

For Role B and C, distribute remaining budget proportionally to
efficiency score — but cap any single campaign at 40% of the
remaining pool to avoid over-concentration.

STEP 3: PRODUCE ALLOCATION TABLE
For each campaign:
- Current monthly spend
- Proposed monthly budget
- Change ($)
- Rationale (one line)

STEP 4: FLAG BUDGET CONSTRAINTS
If total proposed budget > total available:
- Identify which campaigns to cut first (E first, then C with
  lowest efficiency score)
If total proposed budget < total available:
- Identify where additional budget would have the highest ROI

Output format:

BUDGET ALLOCATION PLAN
Total available budget: $X/month
Total proposed allocation: $X/month

CAMPAIGN CLASSIFICATION TABLE
| Campaign | Role | Actual ACOS | Target ACOS | Efficiency Score |
Current Spend | Proposed Budget | Change |

FIXED ALLOCATIONS (Role A + D)
[Campaign | Role | Budget | Reason]

EFFICIENCY-WEIGHTED ALLOCATIONS (Role B + C)
[Campaign | Score | Proposed Budget | Rationale]

BUDGET SURPLUS / SHORTFALL
[If any — where to add or cut first]

BEFORE YOU EXECUTE:

1. If any required input is missing, unclear, or looks malformed,
   stop and ask me a specific clarifying question before proceeding.
   Do not guess or fill in plausible values.

2. If I haven't provided a target ACOS, ask for it before scoring
   campaigns. Do not default to an industry average without flagging it.

3. If campaign impression share data isn't available, use monthly
   spend as the proxy and note the substitution.

4. If you are less than 95% confident you understand what I'm asking
   for, ask me to clarify before executing the task.

5. Verify every arithmetic calculation by working it twice. Round
   budget figures to the nearest $10.

6. After completing the plan, list any campaign where role
   classification was uncertain under "Caveats."

=====

PASTE YOUR CAMPAIGN DATA BELOW. For each campaign include: campaign
name, campaign type (Auto/Manual SP/SB/SD), last 30-day spend,
last 30-day ACOS, target ACOS, and any context (new launch, seasonal,
branded, under-review, etc.). Also include your total available
monthly PPC budget.

[YOUR DATA HERE]