Marketing Plan - Weekly Budget - Compact

Download and customize a free Marketing Plan Weekly Budget Compact Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.

<1 <1 Email Marketing <1 <1 Pending <

Week	Channel	Budget ($)	Spent ($)	Variance ($)	Status
0	0	0	Pending
Total		0	0	0

Compact Weekly Budget Marketing Plan Excel Template

This Compact Weekly Budget Marketing Plan Excel template is designed for small to medium marketing teams or solo marketers who need a streamlined, high-efficiency tool to track, manage, and optimize weekly advertising and promotional spending. Unlike bloated monthly or quarterly templates, this version focuses exclusively on weekly cycles to enable rapid decision-making, agile budget reallocation, and precise ROI measurement—all within a single-sheet Compact design that minimizes clutter while maximizing utility.

Sheet Names

Main Budget Tracker – The primary interface where all weekly spend data is entered and calculated.
Dashboards – A visual summary sheet featuring charts, KPIs, and trend analysis.
Channel Reference – A lookup table defining marketing channels, cost norms, and expected ROAS (Return on Ad Spend).

Table Structures & Column Definitions

The Main Budget Tracker consists of one unified data table with the following columns:

Column Name	Data Type	Description
Week Starting (Date)	Date (DD/MM/YYYY)	The start date of the weekly cycle. Automatically populates via dropdown or formula based on input.
Marketing Channel	Text (Dropdown)	Select from predefined channels: Google Ads, Meta Ads, TikTok, Email Marketing, Influencers, Events, SEO.
Budget Allocated ($)	Currency	The planned weekly spend for the selected channel. User inputs this value.
Actual Spend ($)	Currency Amount actually spent during the week. Updated manually or via integration with ad platforms.
Revenue Generated ($)	Currency Total sales or conversions attributed to this channel during the week. Optional but recommended for ROI tracking.
ROAS (Return on Ad Spend)	Number (Formula) Calculated as: Revenue Generated / Actual Spend. If spend is zero, returns 0.
Budget Variance ($)	Currency (Formula) Difference between Allocated and Actual Spend: =Actual Spend - Budget Allocated
Budget Utilization (%)	Percentage (Formula) =Actual Spend / Budget Allocated * 100. Caps at 200% to avoid misleading spikes.
Status	Text (Formula) Dynamically shows: “Under Budget”, “On Target”, or “Over Budget” based on Utilization thresholds.

Key Formulas

ROAS: =IF([@Actual Spend]>0, [@[Revenue Generated]]/[@[Actual Spend]], 0)
Budget Variance: =[@[Actual Spend]]-[@[Budget Allocated]]
Budget Utilization: =MIN([@[Actual Spend]]/[@[Budget Allocated]], 2) formatted as percentage.

Status:

=IF([@[Budget Utilization]]<0.85, "Under Budget", IF([@[Budget Utilization]]<=1.15, "On Target", "Over Budget"))

Total Weekly Spend: =SUMIF([Marketing Channel], "*") applied to Actual Spend column.
Total Revenue & ROAS: Sum of all revenue and total spend used to calculate company-wide ROAS on Dashboard.

Conditional Formatting

Budget Utilization (%):
- <85% → Light Green (Under Budget)
- 85%-115% → Yellow (On Target)
- >115% → Red (Over Budget)
Budget Variance ($):
- Negative values → Green (savings)
  Positive values → Red (overspend)
Status Column: Color-coded cells using text color rules: Green for “Under Budget”, Blue for “On Target”, Red for “Over Budget”.
ROAS Values: Values above 4.0 (excellent) → Gold background; below 1.0 → Light gray to highlight underperformers.

User Instructions

How to Use This Template:

Start each week by entering the "Week Starting" date (e.g., 01/04/2024).
Select a marketing channel from the dropdown. If new, add it to the Channel Reference sheet first.
Input your planned budget and actual spend as soon as data becomes available (preferably daily).
Record revenue generated using UTM parameters or attribution tools (e.g., Google Analytics).
Review the Status and Utilization columns weekly. If a channel is consistently over budget with low ROAS, reallocate funds to better performers.
Use the Dashboard sheet to visualize trends — compare performance week-over-week.
Reset only the "Actual Spend" and "Revenue Generated" columns each week; keep historical data for trend analysis.

Example Rows

Week Starting: 01/04/2024
Marketing Channel: Google Ads
Budget Allocated: $1,500.00
Actual Spend: $1,685.00
Revenue Generated: $8,425.00
ROAS: 5.0 (Gold)
Budget Variance: +$185.0 (Red)
Budget Utilization: 112% (Yellow → On Target)
Status: On Target

Recommended Charts & Dashboards

The Dashboards sheet contains:

Weekly Spend Bar Chart: Compares allocated vs. actual spend per channel.
ROAS Trend Line Chart: Shows ROAS over the last 8 weeks to identify performance decay or improvement.
Pie Chart: Budget Allocation by Channel – Visualizes where money is being spent this week.
KPI Summary Box: Displays Total Spend, Total Revenue, Overall ROAS, and % of budget utilized.

This template exemplifies the perfect balance of Marketing Plan discipline with the speed and clarity of a Weekly Budget. Its Compact, single-sheet design ensures that users are not overwhelmed by complexity — yet it delivers deep insights. Ideal for startups, agency freelancers, and growth marketers operating under tight timelines, this template turns data into action — one week at a time.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT