Pacing Report

Pull spend data and current targets, then report variance by campaign.

Inputs

• Period — weekly, monthly, or custom date range; default is current month to date
• Campaigns — comma-separated campaign names or IDs; empty means all active campaigns
• Target type — absolute budget, monthly run rate, or CPL (cost per lead); default is budget
• Alert threshold — pace variance percentage to flag (e.g., 15%); default 10%

Steps

1. Gather current spend by campaign for the specified period from your analytics platform.
2. Retrieve budget targets and historical run-rate baseline for each campaign.
3. Calculate projected pace: daily average spend times remaining days in period versus target.
4. Identify outliers: campaigns running over, under, or sideways beyond the alert threshold.
5. Annotate trends: flag campaigns accelerating spend or showing declining cost efficiency.
6. Format results as a summary table with columns: Campaign, Spend, Target, Pace %, Status.
7. Post or send the report to stakeholders via Slack, email, or internal dashboard.

Constraints

• Exclude campaigns marked paused or archived.
• Use only data from approved analytics sources; do not extrapolate from partial daily snapshots.
• If data is older than 24 hours, note staleness in the report header.

Done when: A dated pacing report is delivered showing each campaign's variance from target with actionable status flags.