Table Structures and Column Definitions

Sales Tracker (Daily): This is the core data entry sheet, structured as a transactional log with the following columns:

• Date (Date) – Standard Excel date format (DD/MM/YYYY). Users input daily sales activity.
• Campaign ID (Text) – Unique identifier for each marketing campaign (e.g., CAM-001, FB-AD-2024).
• Campaign Name (Text) – Human-readable name of the campaign (e.g., “Summer Sale - Instagram”).
• Channel (Text) – Marketing channel used: Email, Social Media, PPC, SEO, Event, Referral.
• Lead Source (Text) – How the lead was acquired (e.g., “Facebook Ad”, “Google Search”).
• Closed Deals (Number) – Total number of sales converted on that day.
• Total Revenue ($) – Monetary value of closed deals. Formatted as currency.
• CAC ($) – Customer Acquisition Cost for the campaign. User-inputted or auto-calculated from Settings sheet.
• ROI (%) – Automatically calculated using formula: =((Total Revenue - (Closed Deals * CAC)) / (Closed Deals * CAC)) * 100
• Status (Text) – Dropdown list: “Active”, “Completed”, “On Hold”.

Campaign Performance: This sheet summarizes data aggregated from the Sales Tracker. Columns include:

• Campaign ID (linked to Sales Tracker)
• Total Deals Closed (SUMIFS formula referencing Sales Tracker)
• Total Revenue Summed
• Average CAC
• Overall ROI (%)
• Conversion Rate (%) = Total Deals / Total Leads (user inputs “Total Leads” column)

Marketing Plan Overview: This sheet allows users to define quarterly or annual goals. Columns:

• Quarter (Text: Q1, Q2, etc.)
• Campaign Goal (e.g., “Acquire 500 new customers”)
• Budget Allocation ($)
• Target ROI (%)
• Projected Revenue ($)

Essential Formulas

• ROI Calculation (Sales Tracker):=IF([@[CAC]] > 0, (([@[Total Revenue]] - ([@[Closed Deals]] * [@[CAC]])) / ([@[Closed Deals]] * [@[CAC]])) * 100, “N/A”)
• Monthly Sales Sum (Dashboard):=SUMIFS([Sales Tracker]!$G:$G, [Sales Tracker]!$A:$A, “>=”&E2, [Sales Tracker]!$A:$A, “<=”&EOMONTH(E2,0))
• Campaign ROI Ranking (Campaign Performance):=RANK.EQ([@[Overall ROI]], $F:$F, 0)
• Goal Progress (%):=SUM(Campaign Performance!$D:$D) / Marketing Plan Overview!$B$2 * 100

Conditional Formatting Rules

• Sales Tracker - ROI Column: Green if >50%, Yellow if 10%-50%, Red if <10%.
• Campaign Performance - Total Revenue: Gradient color scale from light to dark blue based on value.
• Marketing Plan Overview - Budget vs Actual: Conditional icons (Up Arrow if under budget, Down Arrow if over-budget).

User Instructions

Begin by navigating to the “Settings & Instructions” sheet. Here you will find a step-by-step guide, including how to input your default CAC per channel, define campaign IDs, and connect your own brand colors. Input all campaign details into the Marketing Plan Overview sheet first—this populates dropdowns in the Sales Tracker. Daily sales data must be entered into “Sales Tracker (Daily)”. Avoid deleting rows; use filters to hide inactive entries. The Dashboard automatically updates with new entries. To reset data, clear only cells highlighted in yellow—not formulas or protected ranges.

Example Data Rows

Recommended Charts & Dashboards

The “Dashboard Summary” sheet features four interactive charts:

• Revenue vs Budget Trendline (Line Chart) – Compares monthly actual sales against planned targets.
• Campaign ROI Heatmap (Matrix with Color Scale) – Shows top-performing campaigns across channels.
• CAC Efficiency Radar Chart – Visualizes cost efficiency per marketing channel, helping prioritize spend.
• Pie Chart: Channel Distribution of Revenue – Reveals which channels generate the most income.

All charts are linked to live data and auto-resize as new entries are added. Users can click any chart to filter the Sales Tracker view by campaign or channel.

Final Notes

The strength of this template lies in its dual function: it’s not merely a tracker—it’s a living document for your Marketing Plan. Because it is fully Editable, users can modify budgets, add new channels, rename campaigns, and adapt to seasonal trends without external help. Unlike static templates, this one evolves with your business strategy. Whether you're a startup testing three channels or an enterprise managing 50+ campaigns simultaneously, this Excel tool provides clarity, control, and measurable growth—all in one Editable Marketing Plan Sales Tracker.