Marketing Plan Weekly Planner – Dashboard View Excel Template

The Marketing Plan Weekly Planner – Dashboard View is a comprehensive, professionally designed Microsoft Excel template engineered to streamline the execution and monitoring of your weekly marketing initiatives. This template combines the strategic rigor of a full Marketing Plan with the tactical discipline of a Weely Planner, all presented through an intuitive, data-driven Dashboard View. Designed for marketing managers, digital marketers, brand coordinators, and small business owners, this template transforms chaotic campaign data into actionable insights—empowering users to track performance in real-time and adjust strategies dynamically.

Sheet Names

• Dashboard: Central hub displaying key performance indicators (KPIs), charts, and summary metrics.
• Weekly Activities: Detailed log of all marketing tasks scheduled for the week.
• Channel Performance: Tracks ROI, engagement, and cost per acquisition across marketing channels.
• Budget Tracker: Monitors spending against allocated budgets by campaign and channel.
• Goals & Targets: Defines monthly/quarterly KPIs to align weekly actions with long-term strategy.
• Data Sources: Hidden sheet storing raw inputs, lookup tables, and validation lists (not to be edited).

Table Structures & Columns

Weekly Activities Sheet:

The Channel Performance Sheet includes:

The Budget Tracker Sheet includes:

Formulas Required

• In Channel Performance, CPC = Spend / Clicks; CPA = Spend / Conversions; ROAS = Revenue (assumed from conversions × avg. value) / Spend.
• In Budget Tracker, % Spent = Spent to Date / Budgeted Amount.
• Dashboard uses SUMIFS and COUNTIFS to pull data dynamically from child sheets by week and channel.
• Status columns use nested IF formulas: e.g., IF(%Spent > 1.05, "Over Budget", IF(%Spent < 0.9, "Under Budget", "On Track"))
• Dynamic date ranges in Dashboard use TODAY() and WEEKNUM() functions to auto-update the current week's view.

Conditional Formatting

• In Weekly Activities: Status = “Completed” → Green fill; “In Progress” → Yellow; “Not Started” → Red.
• In Budget Tracker: % Spent > 100% → Red background; 90–100% → Amber; <90% → Light green.
• In Channel Performance: ROAS > 5.0 → Green border; CPA under $25 → Blue highlight.

Instructions for the User

1. Begin by entering your quarterly goals in the Goals & Targets sheet.
2. Each Monday, populate Weekly Activities with planned tasks. Use dropdowns to ensure consistency.
3. Update Channel Performance daily or weekly with actual spend and metrics from your analytics tools (Google Ads, Meta Ads Manager, etc.).
4. The Dashboard auto-updates every time you save. Review KPI cards, trend charts, and budget alerts before Friday’s strategy meeting.
5. If spending exceeds 90% of budget in any channel, the Dashboard will flash a warning alert.
6. Use the “Prioritized?” column to flag high-impact tasks; these appear on the main Dashboard for urgent attention.

Example Rows

Weekly Activities:
Date: 04/15/2024 | Channel: Social Media | Action Item: Launch Instagram Reel for Spring Sale | Owner: Maria T. | Status: Completed

Channel Performance:
Date Ending: 04/14/2024 | Channel: PPC | Campaign Name: Google Search - Spring Sale | Spend ($): $850 | Clicks: 1,275 | Conversions:CPC ($):$0.67CPA ($):$17.71