Detailed Weekly Budget Marketing Plan Excel Template

This Detailed Weekly Budget Marketing Plan Excel template is specifically designed for marketing teams and campaign managers who require granular control over their weekly advertising and promotional expenditures. Unlike generic budget trackers, this template integrates strategic marketing planning with real-time financial tracking on a weekly cadence, enabling agile decision-making and ROI optimization. Whether you're running digital ads, social media campaigns, email sequences, or influencer partnerships — this template ensures every dollar is accounted for and aligned with campaign objectives.

Sheet Names

• Weekly Budget Tracker – Main worksheet for logging daily and weekly spending.
• Marketing Channels – Reference table defining all marketing channels, their cost structures, and KPI targets.
• Campaign Calendar – Timeline view of planned campaigns with start/end dates, owners, and goals.
• Budget vs Actuals – Summary dashboard with charts comparing planned vs spent budgets.
• ROI Analysis – Calculates return on ad spend (ROAS), cost per acquisition (CPA), and customer lifetime value (LTV).

Table Structures & Columns

The Weekly Budget Tracker is the core of the template. It features a comprehensive table with the following columns:

The Marketing Channels sheet contains fixed channel definitions with columns for:

• Channel Name: Text (e.g., Google Ads)
• Cost Model: Dropdown: CPC, CPM, CPA, Flat Fee
• Target ROAS: Number (e.g., 4.0 = $4 revenue per $1 spent)
• Average CPA Target: Currency ($)
• Max Weekly Budget Cap: Currency ($)

The Campaign Calendar uses a Gantt-style table with start date, end date, campaign name, owner (person responsible), objective (e.g., brand awareness, lead gen), and budget allocation.

Required Formulas

• =SUMIF(Weekly Budget Tracker!B:B,A2,Weekly Budget Tracker!F:F) – Sum of actual spend per channel on the Marketing Channels sheet.
• =IF(F2 > E2*1.1, "Over Budget", IF(F2 < E2*0.9, "Under Budget", "On Track")) – Status column logic in Weekly Budget Tracker.
• =(F2-E2)/E2 – Variance percentage (column G).
• =SUM(Weekly Budget Tracker!F:F) – Total actual spend (Dashboard sheet).
• =IF(ISBLANK(G2), "", IF(G2 > 0.15, "⚠️ High Variance", IF(G2 < -0.1, "💰 Under Spend", ""))) – Warning flag for extreme variance.
• ROAS Formula: =SUM(ROI Analysis!Revenue) / SUM(ROI Analysis!Spent)

Conditional Formatting

• Red fill (Spent > 110% of Budget): Highlights overspending in the “Spent” column.
• Yellow fill (Variance between +5% and -5%): Indicates minor deviation.
• Green fill (Spent ≤ 90% of Budget): Signals underutilization requiring optimization.
• Status column: Red = Over Budget, Green = On Track, Orange = Under Budget

User Instructions

1. Update the Campaign Calendar with your planned campaigns for the upcoming weeks.
2. In the Marketing Channels sheet, set targets and caps based on historical performance.
3. Daily or weekly, enter actual spend in the “Spent” column of the Weekly Budget Tracker. Use data from Google Ads, Meta Ads Manager, etc.
4. Do not edit formulas – they are protected. Only input values into shaded cells (indicated by light yellow background).
5. Review the Dashboard sheet daily: Check if any campaign exceeds 10% variance and pause or adjust spend accordingly.
6. Use the ROI Analysis sheet to calculate total revenue generated against spend — update revenue figures manually from your CRM or sales system.

Example Rows (Weekly Budget Tracker)

Recommended Charts & Dashboards

The Budget vs Actuals sheet must include:

• Stacked Column Chart: Weekly planned vs actual spend per channel.
• Pie Chart: Proportion of total spend by marketing channel (for allocation insights).
• Line Graph with Dual Axis: Actual Spend (bars) vs ROAS/Cost Per Acquisition (line) – to visualize efficiency trends.
• KPI Summary Box: Real-time display of Total Spent, Variance %, ROAS, and CPA against targets.

This Detailed Weekly Budget Marketing Plan template transforms marketing from a cost center into a measurable growth engine. By enforcing weekly accountability and visualizing performance trends in real time, teams can eliminate waste and double down on high-return channels. The “Detailed” nature ensures that no expense goes unnoticed — from micro-influencer fees to automated ad bids — making this the definitive tool for data-driven marketers seeking precision, agility, and clarity.