Marketing Plan - Weekly Budget - Simple

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

< Week 3 0 < / td > < Week 4 Content Creation < / td >

Week	Channel	Budget Allocation ($)	Spent ($)
Week 2 < / td >	Email Marketing < / td >	0 < / td >	0 < / < t d> 0 < / t d> < t d>Pending< / t d> < / tr >
0 < / < t d> 0 < / t d> < t d>Pending< / t d> < / tr >
0 < / td >	0 < / < t d> 0 < / t d> < t d>Pending< / t d>

Simple Weekly Budget Marketing Plan Excel Template

This Simple Weekly Budget Marketing Plan Excel template is designed for small to mid-sized marketing teams, startups, or freelance marketers who need a clear, intuitive, and efficient way to track weekly advertising spend and performance metrics without overwhelming complexity. As a Simple-style template, it avoids unnecessary tabs or over-engineered formulas while still delivering actionable insights. The core purpose is to ensure every dollar spent on marketing is accounted for, analyzed, and optimized week-over-week — making it ideal for agile campaigns that require rapid adjustments.

Sheet Names

The template contains three well-organized sheets:

Weekly Budget Tracker – The main data input sheet where users log daily marketing expenses and campaign details.
Dashboards – A visual summary sheet featuring charts and KPI summaries derived from the Tracker.
Reference Data – A hidden (but editable) sheet containing static values like average cost-per-click (CPC), industry benchmarks, and campaign category codes for dropdown validation.

Table Structure & Columns

The Weekly Budget Tracker contains a single table with the following structured columns:

Name of campaign, e.g., “Facebook Summer Sale” or “Google Search – Q3”.

Grouping: Social Media, Paid Search, Email, Influencer, Print.

Platform used: Facebook Ads, Google Ads, Instagram Stories, Mailchimp.

Brief note on spend purpose (e.g., “Boosted post targeting mothers aged 30-45”).

Actual cost incurred for the activity.

User-input estimate based on historical performance or platform prediction.

Campaign result recorded from analytics dashboard.

Total form submissions, sign-ups, or inquiries generated.

=Amount Spent / Actual Clicks (auto-calculated).

=Amount Spent / Leads Generated (auto-calculated).

Marks if this row represents the weekly summary. Only one per week.

Column Name	Data Type	Description
Date	Date (DD/MM/YYYY)	Day the expense occurred.
Campaign Name	Text (Dropdown)
Campaign Category	Text (Dropdown)
Channel	Text (Dropdown)
Description	Text
Amount Spent ($)	Currency (Number)
Expected Clicks	Number
Actual Clicks	Number
Leads Generated	Number
CPC ($)	Currency (Formula)
Cost Per Lead ($)	Currency (Formula)
Weekly Total?	Yes/No

Required Formulas

The template uses essential formulas to automate key metrics:

=SUMIF([Weekly Total?], "Yes", [Amount Spent ($)]) – Calculates weekly spending total.
=AVERAGEIFS([CPC ($)], [Weekly Total?], "No") – Averages CPC across all daily entries (excludes summary row).
=SUM([Leads Generated]) / SUMIF([Weekly Total?], "Yes", [Amount Spent ($)]) – Calculates overall cost per lead for the week.
=IFERROR([Amount Spent ($)] / [Actual Clicks], "") – Safely calculates CPC to avoid #DIV/0 errors.
=SUM([Amount Spent ($)]) - SUMIF([Weekly Total?], "Yes", [Amount Spent ($)]) – Shows remaining budget for the week.

Conditional Formatting

To enhance usability, conditional formatting rules are applied:

CPC ($): Red if above industry benchmark (set in Reference Data), green if below.
Cost Per Lead ($): Yellow if above target, green if within 20% of goal.
Amount Spent ($): Highlighted in light orange for entries >75% of daily budget cap (set manually per channel).
Weekly Total? column: Rows marked “Yes” are bolded and shaded in light blue.

User Instructions

How to Use This Template:

Set Weekly Budget Cap: In the Dashboard sheet, enter your total weekly marketing budget in cell B2. This auto-updates the “Remaining Budget” gauge.
Log Daily Expenses: Each day, fill out a row with campaign details. Use dropdowns to maintain consistency.
Mark Weekly Summary: On the last day of your week (e.g., Sunday), mark the row as “Yes” in the Weekly Total? column. This triggers summary calculations.
Update Results: After running campaigns, fill in Actual Clicks and Leads Generated from Google Analytics or ad platform dashboards.
Review Dashboard: Check charts weekly to identify top-performing channels and adjust next week’s budget accordingly.

Note: Do not delete or reorder columns. Always use the dropdowns for Campaign Category and Channel to ensure data integrity.

Example Rows

Date	Campaign Name	Campaign Category	Channel	Description	Amount Spent ($)
02/10/2024	FB Summer Sale 1	Social Media	Facebook Ads	Banner ad targeting NYC females 25-35	$85.00
02/10/2024	G Search - Q3 Retargeting	Paid Search	Google Ads	Retarget users who visited pricing page	$120.00
06/10/2024 (Summary)	WEEKLY SUMMARY – Week 41	All Categories	Total	Weekly Total Spend & Performance	$567.50 (bold, blue)

In the same row as the summary, Actual Clicks = 234, Leads Generated = 18 → CPC = $2.43 | Cost Per Lead = $31.53

Recommended Charts & Dashboards

The Dashboards sheet includes four visual elements:

Pie Chart: Shows % allocation of weekly spend by Campaign Category (e.g., 40% Social, 30% Paid Search).
Bar Chart: Compares Cost Per Lead across all channels for the week.
Line Graph: Plots daily spend over the 7-day period with a budget line to highlight overspending trends.
KPI Summary Cards: Display total spent, total leads, average CPC, and budget remaining (with color-coded status: green/yellow/red).

This Simple Weekly Budget Marketing Plan template is intentionally lean but powerful. It removes complexity without removing insight. By focusing on weekly cycles and clear metrics, teams can make faster decisions, reduce wasted spend, and continuously improve campaign ROI — all in a single, easy-to-use Excel file.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT