Table Structures & Column Definitions

The core of the template lies in the Campaign Schedule sheet, which houses a structured table with the following columns:

Formulas Required

• =DATEDIF([@[Start Date]], [@[End Date]], "d") — Calculates duration automatically in the Campaign Schedule.
• =SUMIFS(Budget Allocation!$C:$C, Budget Allocation!$A:$A, [@Campaign ID]) — Pulls total budget from a separate sheet for validation.
• =XLOOKUP([@Campaign ID], Performance Metrics!$A:$A, Performance Metrics!$E:E) — Dynamically pulls actual KPI results into the schedule table.
• =IF([@[Variance ($)]]<0,"OVER BUDGET", IF([@[Variance ($)]]>10%*[@[Budget Assigned]], "UNDER BUDGET","ON TRACK")) — Provides automated budget health status.
• =COUNTIFS(Performance Metrics!$D:$D, ">="&TODAY(), Performance Metrics!$C:$C, "Active") — Counts active campaigns today in Overview Dashboard.

Conditional Formatting Rules

• Campaign Schedule:
  • If Status = “Delayed” → Red fill with white text.
  • If Variance ($) < 0 → Light red background.
  • If Actual KPI Value ≥ Target KPI Value → Green highlight with checkmark icon (using icon sets).
• Performance Metrics:
  • Color-scale on ROAS column: Red (below 1.5) → Yellow (1.5–3) → Green (>3).
• Budget Allocation:
  • If % Spent >90% → Bold red font.

User Instructions

1. Begin by filling out the Campaign Schedule with all planned initiatives. Use dropdowns for consistency.
2. Update “Actual Spend” and “Actual KPI Value” weekly using data from your analytics platforms (Google Analytics, Meta Ads, etc.).
3. The Overview Dashboard will auto-update with KPI summaries and spend heatmaps.
4. Use the Channel Analysis sheet to compare ROI across channels. Filter by month or channel to identify top performers.
5. Click any chart on the dashboard to drill down into related data tables.
6. To reset filters, use the “Clear Filters” button on each sheet.

Example Rows

| Campaign ID | Campaign Name          | Objective         | Channel     | Start Date | End Date   | Duration (Days) | Status    |
|-------------|------------------------|-------------------|-------------|------------|------------|-----------------|-|
CAM-2024-SPRING-01 	Email & Social Launch 	Lead Generation 	Social Media	2024-03-15	2024-03-31	    16	         Active
CAM-2024-SUMMER-PB  	Promotional Banner Ads	Sales Conversion	Paid Ads    	2024-05-01  2024-05-31	    31	         Planned

Recommended Charts & Dashboards

The Overview Dashboard features:

• Stacked Bar Chart: Total budget vs. actual spend by channel — reveals efficiency.
• Gantt-Style Timeline: Visual representation of campaign durations, color-coded by status and priority.
• Pie Chart: Distribution of KPIs achieved across campaigns (e.g., % meeting or exceeding targets).
• Line Graph: Monthly trend in Cost Per Acquisition (CPA) over time — identifies seasonality or optimization points.
• KPI Cards: Real-time summary of total campaigns active, budget utilization %, and average ROAS.

This template is not merely a schedule — it’s an analytical engine for your Marketing Plan. With every date entered and every KPI updated, the system evolves into a living diagnostic tool that answers: Where are we winning? Where are we failing? And what should we adjust next?

Designed for marketing directors, campaign managers, and analytics specialists — the Schedule Planner – Analysis View turns routine planning into strategic advantage.