Marketing Plan - Weekly Budget - Basic

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

Week	Channel	Budget Assigned ($)	Budget Spent ($)	Difference ($)	Status
Week 1	Social Media	0	0	0	Pending
Week 1	Email Marketing	0	0	0	Pending
Week 1	Search Ads	0	0	0	Pending
Week 2	Social Media	0	0	0	Pending
Week 2	Email Marketing	0	0	0	Pending
Week 2	Search Ads	0	0	0	Pending
Total:		0.00	0.00	0.00

Basic Weekly Budget Marketing Plan Excel Template

This comprehensive Excel template is designed specifically for small to medium-sized marketing teams or solo marketers who need a simple, structured, and actionable way to track their weekly marketing expenditures against planned budgets. As a Basic-style template, it prioritizes ease of use, clarity, and functionality without overwhelming users with complex features. The template is centered around the core objective of the Marketing Plan: optimizing campaign ROI by controlling costs and measuring spending efficiency on a weekly basis. This Weekly Budget tracker enables users to monitor cash flow in real time, identify overspending early, and align daily tactics with broader quarterly or annual marketing goals.

Sheet Names

Weekly Budget Tracker
Marketing Plan Overview
Chart Dashboard
Instructions & Tips

Column	Data Type	Description
A: Week Starting Date	Date (MM/DD/YYYY)	The start date of the marketing week (e.g., Monday).
B: Channel Name	Text	Marketing channel used (e.g., Google Ads, Facebook, Email Newsletter).
C: Campaign Name	Text
D: Planned Spend ($)	Currency (USD)
E: Actual Spend ($)	Currency (USD)
F: Variance ($)	Currency (USD)
G: Variance %	Percentage
H: Campaign Status	Text (Dropdown)
I: Notes	Text

Week Start	Channel	Campaign	Planned ($)	Actual ($)	Variance ($)
04/01/2024	Google Ads	Spring Sale - Search	$500.00	$585.23	$85.23	17.0%

Table Structures & Columns Data Types

The primary working sheet, "Weekly Budget Tracker", contains a tabular structure with the following columns:

Name of the specific marketing campaign within the channel.
The allocated budget for this campaign during the week.
Real expenditure recorded for the campaign in that week.
Difference between planned and actual spend (E - D).
Variance as a percentage of planned spend ((F/D)*100).
Status options: "On Track", "Over Budget", "Under Budget". Auto-updated based on variance.
Space for user to record insights, issues, or adjustments made during the week.

Column Data Type Description

A: Week Starting Date Date (MM/DD/YYYY) The start date of the marketing week (e.g., Monday).

B: Channel Name Text Marketing channel used (e.g., Google Ads, Facebook, Email Newsletter).

C: Campaign Name Text

D: Planned Spend ($) Currency (USD)

E: Actual Spend ($) Currency (USD)

F: Variance ($) Currency (USD)

G: Variance % Percentage

H: Campaign Status Text (Dropdown)

I: Notes Text

The "Marketing Plan Overview" sheet consolidates monthly and quarterly summaries. It includes:

Total Planned Budget (sum of weekly planned spends)

Total Actual Spend (sum of weekly actual spends)

Overall Variance

Channel-wise spending percentage pie chart reference

The "Chart Dashboard" sheet dynamically displays visual summaries using data from the main tracker. The "Instructions & Tips" sheet provides step-by-step guidance for first-time users.

Formulas Required

Variance ($): =E2-D2

Variance %: =IF(D2<>0,F2/D2,"N/A") — prevents division-by-zero errors.

Campaign Status:
=IF(G2>10%,"Over Budget",IF(G2<-5%,"Under Budget","On Track"))
(Adjust thresholds as needed; +10% over = over budget, -5% under = under budget)

Total Planned Spend (Overview sheet): =SUM('Weekly Budget Tracker'!D:D)

Total Actual Spend: =SUM('Weekly Budget Tracker'!E:E)

Conditional Formatting Rules

Variance ($): Red fill if >$0 (over budget), Green if <$0 (under budget).

Variance %: Text in red if >10%, green if <-5%, neutral gray otherwise.

Campaign Status column: Background color matches status text — red for "Over Budget", green for "Under Budget", yellow for "On Track".

Week Starting Date: Highlight current week in bold with light blue background.

Instructions for the User

Start each new week: Enter the start date in column A. Copy down as needed.

Input campaign data: In columns B and C, list your marketing campaigns (e.g., “Facebook - Spring Sale”).

Enter planned budget: Type your weekly budget allocation in column D. Use prior weeks’ data as a baseline.

Record actual spend: Update column E daily or at the end of each week from your ad platform reports (Google Ads, Meta Ads Manager, etc.).

Monitor alerts: Red cells indicate overspending. Investigate immediately and adjust future allocations.

Add notes: Document why spending deviated — e.g., “Increased spend due to Black Friday preview campaign.”

Review Dashboard: Each Monday, glance at the Chart Dashboard for a snapshot of channel performance and total variance.

Example Rows

Week Start Channel Campaign Planned ($) Actual ($) Variance ($)

04/01/2024 Google Ads Spring Sale - Search $500.00 $585.23 $85.23 17.0%

Recommended Charts & Dashboards

Stacked Bar Chart: Compares planned vs. actual spend by channel — useful for quick visual comparison.

Pie Chart: Shows percentage of total weekly spend per channel (from Overview sheet).

Line Graph: Tracks cumulative variance over the past 6–8 weeks to identify trends.

KPI Summary Box on Dashboard Sheet: Displays key metrics: “Total Spent”, “Budget Remaining”, “Variance %”, and “Top Overspending Channel” using formulas.

This Basic Weekly Budget Marketing Plan template strikes the ideal balance between simplicity and utility. It empowers users to take control of their marketing spend without requiring advanced Excel knowledge. By enforcing weekly accountability, it prevents budget drift, improves forecasting accuracy, and ensures every dollar spent contributes meaningfully to business growth.
⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:
GoGPT