# Campaign Budget Tracker Template

## Document Control

| Field | Value |
|-------|-------|
| **Template Version** | 1.0.0 |
| **Last Updated** | 2025-01-28 |
| **Owner** | Campaign Manager / Finance |
| **Status** | DRAFT |
| **Budget ID** | BDG-{project}-{number} |

---

## Metadata

- **ID**: `BDG-{project}-{number}` (e.g., BDG-Q1LAUNCH-001)
- **Type**: Campaign Budget Tracker
- **Status**: Draft | Approved | Active | Complete | Reconciled | Archived
- **Owner**: [Campaign Manager - name]
- **Contributors**: [Finance, media buyers, agency, vendors]
- **Reviewers**: [VP Marketing, Finance Director]
- **Team**: Marketing Operations / Finance
- **Stakeholders**: [CMO, CFO, campaign stakeholders]
- **Created**: YYYY-MM-DD
- **Last Updated**: YYYY-MM-DD
- **Budget Period**: [YYYY-MM-DD to YYYY-MM-DD]
- **Related**:
  - Campaign: `CAM-{id}`
  - Vendor Briefs: `VND-{id1}`, `VND-{id2}`
  - Agency Brief: `AGY-{id}`
  - Assets: `AST-{id1}`, `AST-{id2}` (paid production)
  - Content: `CNT-{id1}`, `CNT-{id2}` (paid content)
  - Reports: `RPT-{id}` (performance analysis)

## Budget-Specific Metadata

- **Total Budget**: $[total approved budget]
- **Budget Status**: [X]% allocated / [Y]% committed / [Z]% spent
- **Remaining Budget**: $[amount available]
- **Variance**: [+/- %] vs. plan
- **Approval Level**: [Department | VP | Executive | Board]
- **Fiscal Year**: [FY 2025]
- **Quarter**: [Q1, Q2, Q3, Q4]
- **Budget Authority**: [Name of approver]
- **Last Reconciliation**: [YYYY-MM-DD]

---

## 1. Budget Overview

### 1.1 Campaign Information

**Campaign Name**: [Official campaign name]

**Campaign ID**: CAM-{id}

**Campaign Type**: [Brand awareness, lead generation, product launch, seasonal, etc.]

**Campaign Timeline**: [Start date] to [End date]

**Campaign Owner**: [Name, title]

**Budget Owner**: [Name, title - may differ from campaign owner]

### 1.2 Budget Summary

**Total Approved Budget**: $[amount]

**Budget Allocation Date**: [YYYY-MM-DD]

**Budget Approval Authority**: [Name, title - who approved this budget]

**Budget Source**: [Operating budget, project budget, special allocation, etc.]

**Budget Currency**: [USD, EUR, GBP, etc.]

**Exchange Rate** (if applicable): [Rate and lock date]

### 1.3 Budget Snapshot

| Category | Allocated | Committed | Spent | Remaining | % Utilized |
|----------|-----------|-----------|-------|-----------|------------|
| **Total** | **$[amount]** | **$[amount]** | **$[amount]** | **$[amount]** | **[%]** |

**Budget Health**:

- [ ] On track (within +/- 5%)
- [ ] Slightly over (5-10% over)
- [ ] Over budget (>10% over)
- [ ] Under budget (>10% under - may indicate execution issues)

**As of**: [YYYY-MM-DD]

---

## 2. Detailed Budget Breakdown

### 2.1 Budget by Category

| Category | Allocated | Committed | Spent | Remaining | % of Total | % Utilized | Variance | Status |
|----------|-----------|-----------|-------|-----------|------------|------------|----------|--------|
| **Paid Media** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Paid Social | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Paid Search | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Display | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Video/YouTube | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Programmatic | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Sponsored Content | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Content Production** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Copywriting | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Video Production | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Photography | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Audio/Podcast | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Creative/Design** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Graphic Design | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Motion Graphics | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Art Direction | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Agency/Vendor Fees** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Creative Agency | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Media Agency | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Freelance/Contractors | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Technology/Tools** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Marketing Automation | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Analytics/Attribution | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Design/Creative Tools | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Ad Tech Platforms | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Events/Experiences** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Venue/Catering | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Event Marketing | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Sponsorships | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Other** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| Stock Assets | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Music Licensing | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Talent/Models | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| Shipping/Logistics | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | |
| **Contingency** | $[amount] | $[amount] | $[amount] | $[amount] | [%] | [%] | [+/- %] | [🟢/🟡/🔴] |
| **TOTAL** | **$[amount]** | **$[amount]** | **$[amount]** | **$[amount]** | **100%** | **[%]** | **[+/- %]** | |

**Status Legend**:

- 🟢 Green: On budget (within +/- 5%)
- 🟡 Yellow: Attention needed (5-10% variance)
- 🔴 Red: Over budget (>10% variance) or underspent risk

### 2.2 Budget by Channel

| Channel | Allocated | Spent | Remaining | % Utilized | CPM/CPC/CPA | Impressions/Clicks | Status |
|---------|-----------|-------|-----------|------------|-------------|-------------------|--------|
| Paid Social | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| Paid Search | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| Display | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| Video/YouTube | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| Email | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| Content/Organic | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| Events | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| PR/Earned Media | $[amount] | $[amount] | $[amount] | [%] | [metric] | [volume] | [🟢/🟡/🔴] |
| **TOTAL** | **$[amount]** | **$[amount]** | **$[amount]** | **[%]** | | | |

### 2.3 Budget by Month

| Month | Allocated | Spent | Remaining | % of Total | Cumulative Spent | Cumulative % | Status |
|-------|-----------|-------|-----------|------------|------------------|--------------|--------|
| [Month 1] | $[amount] | $[amount] | $[amount] | [%] | $[amount] | [%] | [🟢/🟡/🔴] |
| [Month 2] | $[amount] | $[amount] | $[amount] | [%] | $[amount] | [%] | [🟢/🟡/🔴] |
| [Month 3] | $[amount] | $[amount] | $[amount] | [%] | $[amount] | [%] | [🟢/🟡/🔴] |
| [Month 4] | $[amount] | $[amount] | $[amount] | [%] | $[amount] | [%] | [🟢/🟡/🔴] |
| **TOTAL** | **$[amount]** | **$[amount]** | **$[amount]** | **100%** | **$[amount]** | **[%]** | |

**Pacing Analysis**: [On pace | Ahead of pace | Behind pace]

**Budget Runway**: [X] months remaining at current spend rate

---

## 3. Line Item Detail

### 3.1 Paid Media Expenses

| Line Item | Vendor/Platform | Allocated | Committed | Spent | Invoice Date | PO Number | Payment Status | Notes |
|-----------|-----------------|-----------|-----------|-------|--------------|-----------|----------------|-------|
| Facebook Ads | Meta | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending / Overdue | [notes] |
| LinkedIn Ads | LinkedIn | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending / Overdue | [notes] |
| Google Ads | Google | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending / Overdue | [notes] |
| Display Network | [Vendor] | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending / Overdue | [notes] |
| Sponsored Content | [Publication] | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending / Overdue | [notes] |

**Total Paid Media**: $[amount] allocated / $[amount] spent

### 3.2 Agency and Vendor Expenses

| Vendor | Service | Contract Type | Allocated | Committed | Spent | Invoice Date | PO Number | Payment Status | Notes |
|--------|---------|---------------|-----------|-----------|-------|--------------|-----------|----------------|-------|
| [Agency] | Creative services | Retainer / Project | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending | [notes] |
| [Vendor] | Video production | Project | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending | [notes] |
| [Freelancer] | Copywriting | Hourly | $[amount] | $[amount] | $[amount] | [date] | [PO-#] | Paid / Pending | [notes] |

**Total Agency/Vendor**: $[amount] allocated / $[amount] spent

### 3.3 Production Expenses

| Expense | Description | Vendor | Allocated | Actual | Invoice Date | Receipt/Invoice | Payment Status | Notes |
|---------|-------------|--------|-----------|--------|--------------|-----------------|----------------|-------|
| Video shoot | 2-day production | [Studio] | $[amount] | $[amount] | [date] | [file] | Paid / Pending | [notes] |
| Photography | Product photos | [Photographer] | $[amount] | $[amount] | [date] | [file] | Paid / Pending | [notes] |
| Stock footage | Video clips | [Platform] | $[amount] | $[amount] | [date] | [file] | Paid / Pending | [notes] |
| Music licensing | Background track | [Platform] | $[amount] | $[amount] | [date] | [file] | Paid / Pending | [notes] |
| Talent fees | Models/actors | [Agency] | $[amount] | $[amount] | [date] | [file] | Paid / Pending | [notes] |

**Total Production**: $[amount] allocated / $[amount] spent

### 3.4 Technology and Tools

| Tool/Platform | Purpose | Subscription Type | Monthly Cost | Campaign Period Cost | Allocated | Actual | Status |
|---------------|---------|-------------------|--------------|---------------------|-----------|--------|--------|
| [Tool 1] | Marketing automation | Annual | $[/mo] | $[total] | $[amount] | $[amount] | Active |
| [Tool 2] | Analytics | Monthly | $[/mo] | $[total] | $[amount] | $[amount] | Active |
| [Tool 3] | Design software | Monthly | $[/mo] | $[total] | $[amount] | $[amount] | Active |

**Total Technology**: $[amount] allocated / $[amount] spent

---

## 4. Budget Tracking and Reconciliation

### 4.1 Budget Commitment Tracking

**Committed but Not Yet Spent**: $[amount]

| Item | Vendor | Committed Amount | Expected Invoice Date | PO Number | Notes |
|------|--------|------------------|----------------------|-----------|-------|
| [Item 1] | [Vendor] | $[amount] | [date] | [PO-#] | [notes] |
| [Item 2] | [Vendor] | $[amount] | [date] | [PO-#] | [notes] |
| [Item 3] | [Vendor] | $[amount] | [date] | [PO-#] | [notes] |

**Total Committed**: $[amount]

**Available to Commit**: $[total budget] - $[spent] - $[committed] = $[available]

### 4.2 Invoice and Payment Tracking

**Invoices Pending Payment**: $[amount]

| Invoice Number | Vendor | Amount | Invoice Date | Due Date | PO Number | Status | Notes |
|----------------|--------|--------|--------------|----------|-----------|--------|-------|
| [INV-###] | [Vendor] | $[amount] | [date] | [date] | [PO-#] | Pending / Approved / Paid | [notes] |
| [INV-###] | [Vendor] | $[amount] | [date] | [date] | [PO-#] | Pending / Approved / Paid | [notes] |

**Overdue Invoices**: $[amount]

**Payment Schedule**: [Net 30 | Net 60 | Other]

### 4.3 Budget Variance Analysis

| Category | Allocated | Actual Spent | Variance ($) | Variance (%) | Reason | Action |
|----------|-----------|--------------|--------------|--------------|--------|--------|
| [Category 1] | $[amount] | $[amount] | [+/- $] | [+/- %] | [Explanation] | [Action plan] |
| [Category 2] | $[amount] | $[amount] | [+/- $] | [+/- %] | [Explanation] | [Action plan] |
| [Category 3] | $[amount] | $[amount] | [+/- $] | [+/- %] | [Explanation] | [Action plan] |

**Overall Variance**: [+/- $] ([+/- %])

**Variance Threshold**: [+/- X%] - variances exceeding threshold require explanation and approval

### 4.4 Budget Forecast

**Projected Total Spend**: $[amount]

**Projected Variance**: [+/- $] ([+/- %])

**Projected Budget Status**: [On budget | Over budget | Under budget]

**Forecast Assumptions**:

- [Assumption 1 - e.g., "Media pacing continues at current rate"]
- [Assumption 2 - e.g., "No additional creative revisions required"]
- [Assumption 3 - e.g., "All committed spend invoiced by [date]"]

**Risk to Forecast**:

- [Risk 1 - e.g., "Media may overdeliver by 10% ($X)"]
- [Risk 2 - e.g., "Additional creative rounds may add $X"]

---

## 5. Budget Performance Metrics

### 5.1 Cost Efficiency

| Metric | Target | Actual | Variance | Status |
|--------|--------|--------|----------|--------|
| Cost per Lead (CPL) | $[amount] | $[amount] | [+/- $] | [🟢/🟡/🔴] |
| Cost per Acquisition (CPA) | $[amount] | $[amount] | [+/- $] | [🟢/🟡/🔴] |
| Cost per Click (CPC) | $[amount] | $[amount] | [+/- $] | [🟢/🟡/🔴] |
| Cost per Thousand Impressions (CPM) | $[amount] | $[amount] | [+/- $] | [🟢/🟡/🔴] |
| Cost per View (CPV) | $[amount] | $[amount] | [+/- $] | [🟢/🟡/🔴] |
| Cost per Engagement | $[amount] | $[amount] | [+/- $] | [🟢/🟡/🔴] |

### 5.2 Return on Investment (ROI)

**Total Campaign Spend**: $[amount]

**Revenue/Pipeline Generated**: $[amount]

**ROI**: [X.X]x or [XX]%

**ROMI (Return on Marketing Investment)**: ([Revenue - Marketing Spend] / Marketing Spend) x 100 = [%]

**Payback Period**: [X] months

**Customer Lifetime Value (LTV) to CAC Ratio**: [X:1]

### 5.3 Budget Efficiency by Channel

| Channel | Budget | Spend | Results | Cost per Result | ROI | Efficiency Rank |
|---------|--------|-------|---------|----------------|-----|-----------------|
| Paid Social | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| Paid Search | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| Display | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| Video | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| Email | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| Content | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| Events | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |
| PR | $[amount] | $[amount] | [# leads] | $[CPL] | [X]x | [1-8] |

**Top Performing Channel**: [Channel] - [ROI]

**Lowest Performing Channel**: [Channel] - [ROI]

**Optimization Opportunities**: [Recommendations based on performance data]

---

## 6. Budget Governance

### 6.1 Approval Thresholds

| Expense Type | Amount | Approval Required |
|--------------|--------|-------------------|
| Under $[amount] | < $[threshold] | Campaign Manager approval |
| $[threshold] - $[threshold] | $[range] | VP Marketing approval |
| Over $[threshold] | > $[threshold] | CMO or CFO approval |
| Budget reallocation | > [%] of category | VP Marketing approval |
| Over budget | Any amount | VP Marketing + Finance approval |

### 6.2 Budget Change Management

**Budget Increase Request**:

| Requested By | Amount | Reason | Approval Status | Approver | Date |
|--------------|--------|--------|-----------------|----------|------|
| [Name] | $[amount] | [Justification] | Pending / Approved / Rejected | [Name] | [date] |

**Budget Reallocation**:

| From Category | To Category | Amount | Reason | Approval Status | Approver | Date |
|---------------|-------------|--------|--------|-----------------|----------|------|
| [Category] | [Category] | $[amount] | [Justification] | Pending / Approved / Rejected | [Name] | [date] |

**Change Request Process**:

1. Campaign Manager submits request with justification
2. Finance reviews budget availability
3. Appropriate approver reviews and approves/rejects
4. Budget tracker updated
5. Stakeholders notified

### 6.3 Reconciliation Schedule

**Weekly Reconciliation**: [Day of week]

- Review spend vs. budget
- Update committed amounts
- Flag variances > [X]%

**Monthly Reconciliation**: [Day of month]

- Full invoice reconciliation
- Payment status review
- Forecast update
- Variance analysis
- Stakeholder report

**Final Reconciliation**: [Within X days of campaign end]

- All invoices received and paid
- Final spend vs. budget analysis
- Lessons learned documentation
- Budget close-out

**Last Reconciliation Date**: [YYYY-MM-DD]

**Next Reconciliation Date**: [YYYY-MM-DD]

---

## 7. Risk and Issues

### 7.1 Budget Risks

| Risk | Probability | Impact | Amount at Risk | Mitigation | Owner |
|------|-------------|--------|----------------|------------|-------|
| [Risk 1 - e.g., "Media overdelivery"] | High/Med/Low | High/Med/Low | $[amount] | [Strategy] | [Name] |
| [Risk 2 - e.g., "Scope creep"] | High/Med/Low | High/Med/Low | $[amount] | [Strategy] | [Name] |
| [Risk 3 - e.g., "Exchange rate fluctuation"] | High/Med/Low | High/Med/Low | $[amount] | [Strategy] | [Name] |

**Total Budget at Risk**: $[amount]

### 7.2 Current Issues

| Issue | Impact | Action Required | Owner | Due Date | Status |
|-------|--------|-----------------|-------|----------|--------|
| [Issue 1] | $[amount] or [description] | [Action] | [Name] | [date] | Open / In Progress / Resolved |
| [Issue 2] | $[amount] or [description] | [Action] | [Name] | [date] | Open / In Progress / Resolved |

---

## 8. Reporting and Documentation

### 8.1 Budget Reports

**Report Frequency**: [Weekly | Bi-weekly | Monthly]

**Report Distribution**:

- [Stakeholder 1] - [Role]
- [Stakeholder 2] - [Role]
- [Stakeholder 3] - [Role]

**Report Format**: [Dashboard, slide deck, spreadsheet, etc.]

**Report Location**: [Link to reports folder or dashboard]

### 8.2 Supporting Documentation

**Invoices**: [Link to invoice folder]

**Purchase Orders**: [Link to PO tracking system]

**Contracts/SOWs**: [Link to contract repository]

**Receipts**: [Link to expense management system]

**Approval Emails**: [Link to email archive or approval system]

---

## Agent Notes

### For Campaign Manager

- Update budget tracker weekly minimum
- Flag variances > 10% immediately
- Obtain approvals before committing spend
- Maintain documentation for all expenses
- Reconcile with Finance monthly
- Plan for contingency (typically 10-20% of budget)

### For Finance

- Review budget tracker monthly
- Validate invoices against POs and contracts
- Process payments per terms (Net 30/60)
- Alert campaign manager of budget risks
- Support budget variance analysis
- Ensure compliance with company financial policies

### For Media Buyer

- Track daily media spend vs. pacing
- Alert campaign manager of overdelivery risk
- Optimize budget allocation across platforms
- Provide weekly spend reports
- Forecast final spend based on current performance

### For Agency/Vendor

- Submit invoices promptly with PO reference
- Provide detailed line-item breakdown
- Alert client of potential budget overruns early
- Track scope changes and budget impact
- Maintain receipts for reimbursable expenses

---

## Related Templates

- `/templates/operations/campaign-card.md` - Parent campaign tracking
- `/templates/operations/vendor-brief-template.md` - Vendor engagement and cost
- `/templates/operations/agency-brief-template.md` - Agency engagement and cost
- `/templates/analytics/campaign-performance-report-template.md` - ROI analysis

---

## Template Version History

| Version | Date | Author | Changes |
|---------|------|--------|---------|
| 1.0.0 | 2025-01-28 | MMK Framework Team | Initial template creation |

---

**END OF TEMPLATE**