Weekly Marketing Plan Income Statement Excel Template

This comprehensive Excel template is designed specifically for marketing professionals and business owners who need to track, analyze, and optimize their marketing campaigns on a weekly basis. Combining the strategic framework of a Marketing Plan with the financial rigor of an Income Statement, this Weekly template enables users to measure return on investment (ROI), allocate budgets effectively, and adjust strategies dynamically based on real-time financial performance.

SHEET NAMES

The template includes three primary sheets:

• Weekly_Income_Statement: The core financial dashboard tracking all marketing-related revenues and expenses on a weekly basis.
• Campaign_Tracker: A detailed log of all active marketing campaigns, including channels, costs, targets, and outcomes.
• Dashboard: A visual summary using charts and KPI cards to provide instant insights into campaign performance and profitability.

TABLE STRUCTURES & COLUMNS

Weekly_Income_Statement Sheet

This sheet contains a structured table with the following columns:

Campaign_Tracker Sheet

This sheet serves as the source database for all campaigns. Columns include:

• Campaign ID (Text, unique alphanumeric code)
• Campaign Name (Text)
• Channel (Dropdown: Facebook, Google Ads, Email, Instagram, LinkedIn, Influencers, SEO)
• Budget Assigned ($) (Currency)
• Budget Spent ($) (Currency - auto-updated from Weekly_Income_Statement via SUMIFS formula)
• Start Date (Date)
• End Date (Date)
• Status (Dropdown: Planned, Active, Paused, Completed)
• TARGET Leads/Week (Number)
• TARGET Conversion Rate (%) (Percentage)
• AVERAGE Sale Value ($) (Currency)

FORMULAS REQUIRED

The template leverages powerful Excel formulas for automated analysis:

• =SUMIF(Campaign_Tracker!$A:$A, Weekly_Income_Statement!B2, Campaign_Tracker!$J:$J) — Pulls target sales value for each campaign.
• =IFERROR([@[Sales Revenue]] / [@[Cost (USD)]] - 1, 0) — Calculates ROI as a percentage.
• =SUM([@[Cost (USD)]]) — Totals weekly marketing spend.
• =SUM([@[Converted Sales]]) * AVERAGE_SALE_VALUE — Computes total revenue based on conversions and average sale value (linked to Campaign_Tracker).
• =[@[Sales Revenue]] - [@[Cost (USD)]] — Calculates gross profit per campaign.
• =SUMIFS(Weekly_Income_Statement!E:E, Weekly_Income_Statement!C:C, Campaign_Tracker!C2) — Aggregates total spent on each campaign across weeks.
• =IF([@[ROI (%)]] > 0.5, "High ROI", IF([@[ROI (%)]] > 0.2, "Moderate ROI", "Low ROI")) — Categorizes campaign efficiency.

CONDITIONAL FORMATTING

To enhance readability and decision-making:

• Cost (USD): Red fill if above budget allocation (linked to Campaign_Tracker).
• Gross Profit: Green fill if positive; red if negative.
• ROI (%): Color scales from red (< 20%) to green (> 100%).
• Status (Campaign_Tracker): Yellow for "Paused", Gray for "Planned", Green for "Active/Completed".
• Leads Generated: Highlight in blue if exceeding target by 20% or more.

INSTRUCTIONS FOR THE USER

Week 1 Setup:

1. Open the Campaign_Tracker sheet and enter all planned marketing campaigns for the quarter.
2. Fill in budget, expected leads, average sale value, and target conversion rate.
3. Each week (e.g., every Monday), update the Weekly_Income_Statement with actual costs and results from completed campaigns.
4. Do not edit formulas — only input data in highlighted cells (yellow background).
5. Use the dropdowns for Channel and Status to maintain data integrity.
6. Check the Dashboard sheet daily for visual trends. Adjust underperforming campaigns by Friday evening.

EXAMPLE ROWS

RECOMMENDED CHARTS & DASHBOARD

The Dashboard sheet features:

• Weekly Net Profit Trend Line: Shows profit movement over 12 weeks.
• Pie Chart: Channel Cost Distribution: Highlights where budget is spent.
• Bar Chart: ROI by Campaign: Compares performance across channels and campaigns.
• KPI Cards: Display real-time metrics: Total Weekly Spend, Net Profit, Avg. ROI, Lead Conversion Rate.
• Heat Map: Channel Efficiency: Uses color intensity to show which channels generate highest profit per dollar spent.

This template transforms raw marketing data into actionable insights. By aligning campaign execution with financial outcomes on a weekly cadence, businesses can eliminate waste, scale what works, and sustainably grow revenue — making this Weekly Marketing Plan Income Statement an indispensable tool for modern digital marketers.