Ad Spend Pacer
npx machina-cli add skill akhilkannur/marketing-agent-blueprints/ad-spend-pacer --openclawThe Ad Spend Pacer
Core Instructions
You are a highly specialized AI agent focusing on Paid Media. Your mission is: Overspending gets you fired. Underspending gets you yelled at. This agent takes your Month-to-Date spend and Total Budget, calculating exactly how much you need to spend daily for the rest of the month to hit the target perfectly.
Implementation Workflow
Phase 1: Initialization & Seeding
- Check: Does
campaign_spend.csvexist? - If Missing: Create
campaign_spend.csvusing thesampleDataprovided in this blueprint.
Phase 2: Calculation Loop
Create daily_budget_adjustments.csv.
For each Campaign in campaign_spend.csv:
- Remaining:
Budget - Spent_MTD. - Daily Target:
Remaining / Days_Left. - Action:
- If Daily Target > Current Avg Spend -> "Scale Up".
- If Daily Target < Current Avg Spend -> "Pull Back".
Phase 3: Orders Output
- Output: Save
daily_budget_adjustments.csv(Campaign, New_Daily_Cap). - Summary: "Retargeting needs $[X]/day. Prospecting is hot - cut budget to $[Y]/day to avoid overspend."
Blueprint ID: ad-spend-pacer Source: Real AI Examples
Source
git clone https://github.com/akhilkannur/marketing-agent-blueprints/blob/main/skills/ad-spend-pacer/SKILL.mdView on GitHub Overview
Ad Spend Pacer is a paid media agent that uses your Month-to-Date spend and Total Budget to compute the exact daily spend needed for the rest of the month. This helps prevent overspending and underspending by providing a clear action: scale up or pull back. It outputs daily_budget_adjustments.csv to guide campaign pacing.
How This Skill Works
Phase 1 checks for campaign_spend.csv and seeds it from the sampleData if missing. Phase 2 creates daily_budget_adjustments.csv and, for each campaign, computes Remaining, Daily Target, and Action by comparing the target to the Current Avg Spend. Phase 3 outputs the New_Daily_Cap per campaign and a brief summary about pacing for retargeting vs prospecting.
When to Use It
- When you want to precisely hit the monthly spend target by distributing remaining budget over upcoming days
- When a campaign is under-spending and needs a daily uplift to catch up
- When a campaign is overspending and you need to pull back to avoid overshoot
- When managing multiple audiences such as retargeting and prospecting and you need per campaign daily caps
- When the campaign_spend.csv is missing and you need to seed data from sampleData
Quick Start
- Step 1: Ensure campaign_spend.csv exists; if not, allow the agent to seed from sampleData
- Step 2: Run the Ad Spend Pacer to generate daily_budget_adjustments.csv
- Step 3: Review New_Daily_Cap values and the summary to confirm pacing targets
Best Practices
- Ensure campaign_spend.csv fields align with Spent_MTD, Budget and Current Avg Spend
- Allow the agent to seed from sampleData if the spend file is missing to enable quick starts
- Run daily to produce daily_budget_adjustments.csv with precise New_Daily_Cap values
- Audit that sum of New_Daily_Cap matches the remaining monthly budget
- Back up inputs before running and review the summary line for high level pacing
Example Use Cases
- Retargeting campaign with 60k budget and 40k spent MTD, 15 days left; Daily Target 1.33k; Current Avg Spend 1.1k -> Scale Up
- Prospecting campaign with 50k budget, 48k spent MTD, 5 days left; Daily Target 400; Current Avg Spend 600 -> Pull Back
- campaign_spend.csv missing; pacer seeds from sampleData and generates daily_budget_adjustments.csv
- Multiple campaigns with mixed statuses; pacer outputs per campaign New_Daily_Cap to optimize overall spend
- After running the pacer, the summary reports Retargeting needs X/day and Prospecting is hot - cut to Y/day
