Run everything you never had time to implement. Define your process once, and keep it

running with Qore.
Qore > Skills > Monthly Spend Pacerr
Retail Readiness

Monthly Spend Pacer

Projects month-end spend from the month so far and the last seven days, acts only when the projection misses the target by more than 10%, and moves budget toward campaigns at or under their ACoS target.
Standard
·
7 steps
Amazon
READS
Your ad data
Change history
LOOKS FOR
Portfolios on course to miss the monthly target by more than 10%
PRODUCES
Pacing status by portfolio, and budget changes ranked by size
YOU
Approve the budget changes, and they go live
Overview

What it reads, what it checks, what comes back, what you approve.

What it reads
Where the month stands
  • Month-to-date spend by campaign, through yesterday
  • The monthly target by portfolio, and any planned pacing curve
  • Target ACoS and objective per campaign
  • The change log and promo calendar, to explain known spikes
What it checks
Whether the month is off course
  • Expected pace against actual month-to-date spend
  • A month-end projection from the last seven days' run rate
  • Only projections more than 10% off target count as off course
  • Budget added only where ACoS is at or under target
What comes back
A status, a projection, and the fix
  • Pacing status for every portfolio
  • Projected month-end spend against target
  • Daily budget changes, split by share of spend and ranked by size
What you approve
Every change, inside hard limits
  • No campaign moves more than 20% in a day
  • The total account budget moves no more than 15% in a day
  • Any change over $500 a day, and any branded or hero campaign, needs approval
  • Every previous budget logged, so each change reverses

Where the month is heading, and what moves it back

Month-to-date spend + targets · components

ComponentsStep 1Step 2Step 3Step 4Step 5Step 6Step 7Load Month-to-Date SpendCompute Expected PaceProject Month-EndCheck the VarianceScreen by PerformanceTag Room to AddtaggingTag Cut FirsttaggingSize the AdjustmentLoad Change Log312121

The skill's components as built in Qore, with Screen by Performance open.

Run Settings
The five things this skill asks you to set.
Monthly target
The spend target for the month, by portfolio.
Pacing curve
How the month is weighted. Flat by default, or front- or back-loaded for event months.
Variance band
How far the projection can drift from target before the skill acts. Inside the band, it reports and stops.
Daily change limits
The most any campaign, and the account in total, can move in one day.
Protected campaigns
Branded defense, launch campaigns and anything the brand has flagged. These are never touched.

Frequently Asked Questions

How do I keep Amazon ad spend on track for the monthly budget?

This skill runs every morning. It projects month-end spend from month-to-date spend plus the last seven days' run rate, and stages daily budget changes when the projection lands more than 10% off target.

Will it overspend to hit the target?

No. Budget is added only to campaigns at or under their ACoS target, and cuts come first from campaigns above it. The goal is landing within 5% of target without breaking ACoS or TACoS.

What about months with a big event?

You set a planned pacing curve for front- or back-loaded months, and expected pace follows that curve rather than a straight line.

Does it change budgets automatically?

Does it change budgets automatically?

What happens late in the month?

With fewer than five days left, it flags the variance and makes no changes.

What if one day's spend was unusual?

A one-time spike already explained in the change log is set aside, so a day that will not repeat does not throw off the projection.

Start
Provisioned on your account at signup.
Try Qore

Every one of these runs on your own account.

Sign up, connect an account, and install a skill. The first run produces a real result you can look at before you schedule anything.
Try QoreBrowse The Skill Library