Marketing Plan - Weekly Planner - Summary View

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

Week	Objective	Key Activities	Channels	Budget ($) Expected Results Status
< / t d < <0.00

Marketing Plan Weekly Planner – Summary View Excel Template

The Marketing Plan Weekly Planner – Summary View is a streamlined, data-driven Excel template designed for marketing professionals and teams to track, analyze, and optimize campaign performance on a weekly basis. Unlike detailed daily trackers or granular activity logs, this template focuses exclusively on high-level metrics and strategic summaries—making it ideal for executives, team leads, and stakeholders who require rapid insight into marketing effectiveness without sifting through noise. The "Summary View" design principle ensures clarity, visual hierarchy, and fast decision-making by distilling complex data into digestible KPIs, trends, and forecasts.

Sheet Structure

This template comprises four well-organized sheets:

Weekly Summary – The primary dashboard where all key metrics are aggregated and visualized.
Data Input – A structured table for entering weekly campaign activities and results.
Performance Benchmarks – Reference data for industry standards or internal goals to compare performance against.
Notes & Insights – A freeform area for qualitative commentary, strategy adjustments, and team feedback.

Data Input Sheet: Table Structure and Columns

The Data Input sheet functions as the engine of the template. It uses a clean table format with the following columns:

Date (Week Start) – Date type (e.g., 2024-06-17). Auto-populated via dropdown for consistency.
Campaign Name – Text. Examples: “Summer Email Blast”, “Instagram Influencer Collab”.
Channel – Dropdown (Text): Email, Social Media (FB/IG), Paid Ads (Google/FB), SEO, Events, Partnerships.
Budget Allocated ($) – Currency format. Used for ROI calculation.
Budget Spent ($) – Currency format. Automatically capped at or below allocated budget.
Impressions – Number (Integer). Total views or reach across platforms.
Clicks – Number (Integer).
Conversions – Number (Integer). Leads, sign-ups, purchases tracked via UTM parameters.
CAC ($) – Formula column: =Budget Spent / Conversions. Calculates Customer Acquisition Cost.
ROAS – Formula column: =Revenue Generated / Budget Spent. Requires input in “Revenue Generated” field.
Revenue Generated ($) – Currency format (optional; can be linked to CRM).
Status – Dropdown: Planned, Active, Paused, Completed.
Notes – Text field for brief qualitative context (e.g., “Holiday promo drove 30% spike”)

All data rows are formatted as an Excel Table (Ctrl+T) for dynamic range expansion and seamless formula referencing.

Weekly Summary Dashboard: Formulas & Conditional Formatting

The Weekly Summary dashboard pulls aggregated data from the Data Input sheet using structured references and powerful formulas:

Total Campaigns This Week: =COUNTIFS(DataInput[Date], “>=”&TODAY()-WEEKDAY(TODAY())+1, DataInput[Date], “<=”&TODAY()-WEEKDAY(TODAY())+7)
Total Budget Spent: =SUMIFS(DataInput[Budget Spent ($)], DataInput[Date], “>=”&TODAY()-WEEKDAY(TODAY())+1, DataInput[Date], “<=”&TODAY()-WEEKDAY(TODAY())+7)
Total Conversions: =SUMIFS(DataInput[Conversions], DataInput[Date], “>=”&TODAY()-WEEKDAY(TODAY())+1, DataInput[Date], “<=”&TODAY()-WEEKDAY(TODAY())+7)
Average CAC: =AVERAGEIF(DataInput[Date], “>=”&TODAY()-WEEKDAY(TODAY())+1, DataInput[CAC])
Overall ROAS: =SUMIFS(DataInput[Revenue Generated ($)], DataInput[Date], “>=”&TODAY()-WEEKDAY(TODAY())+1, DataInput[Date], “<=”&TODAY()-WEEKDAY(TODAY())+7) / SUMIFS(DataInput[Budget Spent ($)], DataInput[Date], “>=”&TODAY()-WEEKDAY(TODAY())+1, DataInput[Date], “<=”&TODAY()-WEEKDAY(TODAY())+7)
Conversion Rate %: =Total Conversions / SUMIFS(DataInput[Clicks], ...) * 100

Conditional Formatting Rules:

CAC values above the benchmark (from Performance Benchmarks sheet) are highlighted in light red.
ROAS values exceeding 3.0 are shaded in light green.
Channels with zero conversions show a warning icon (using icons sets) and text “Underperforming – Review Strategy”.
Budget overrun (Spent > Allocated) triggers a red border around the entire row in Data Input sheet.

User Instructions

1. Begin each week by updating the “Date (Week Start)” field on the Data Input sheet with Monday’s date. 2. Add new campaign entries under their respective channel, budget, and results. 3. Update “Revenue Generated” if you have direct attribution from your CRM or sales system. 4. Use dropdowns for Channel and Status to ensure data consistency. 5. Never edit formulas in the Weekly Summary sheet—they are locked to prevent errors. 6. Review the dashboard daily for red flags (e.g., CAC spikes, ROAS drops). 7. Log insights in the “Notes & Insights” sheet—this becomes your weekly strategy log.

Example Rows

| Date | Campaign Name | Channel | Budget Allocated ($) | Budget Spent ($) | Impressions | Clicks | Conversions | CAC ($) | ROAS | |------------|------------------------|----------------|----------------------|------------------|-------------|--------|-------------|----------|--------| | 2024-06-17 | Summer Email Blast | Email | 5,000 | 4,850 | 25,341 | 3,987 | 189 | $25.66 | 3.7 | | 2024-06-17 | TikTok Influencer | Social Media | 3,000 | 3,200 | 189,541 | 8,754 | 68 | $47.06 | 2.1 | | 2024-06-17 | Google Search Ads | Paid Ads | 2,500 | 2,300 | 15,789 | 1,893 | 45 | $51.11 | 4.2 |

Recommended Charts & Dashboards

- Bar Chart: Weekly Channel Performance by ROAS (compare channels). - Line Chart: Trend of CAC over the past 6 weeks. - Donut Chart: Budget Allocation vs. Actual Spend. - KPI Tiles: Display real-time totals for Total Conversions, Overall ROAS, and Avg. CAC on top of the Weekly Summary sheet. This template transforms chaotic marketing data into a clear narrative of performance—exactly what a Marketing Plan demands. The Weekly Planner structure ensures routine discipline, while the Summary View removes clutter to focus on what truly matters: impact, efficiency, and growth.

⬇️ Download as Excel ✏️ Edit online as Excel

Create your own Excel template with our GoGPT AI prompt:

GoGPT