TABLE STRUCTURES & COLUMNS

The core of this template is the Campaign Orders sheet, which functions as the central order tracker for all marketing-led sales. Each row represents a unique customer order initiated by a marketing campaign.

Campaign Orders Table Structure:

The Budget & Spend sheet contains monthly marketing budget allocations by channel and actual spend tracked against targets. It includes columns for Monthly Budget ($), Actual Spent ($), Remaining ($), and % Utilized (calculated as Actual / Budget). This enables startups to maintain fiscal discipline while scaling.

The Customer Timeline sheet visualizes the customer journey: Lead → Click → Order → Payment → Delivery. Each milestone has a timestamp field, enabling teams to optimize conversion funnels.

FORMULAS REQUIRED

• Campaign Orders!J2: =IF(F2>0,G2/F2,"N/A") — Calculates CAC only if order value exists.
• Campaign Orders!I2: =WORKDAY(B2,3) — Adds 3 business days to order date for delivery estimate.
• Budget & Spend!E2: =C2-D2 — Remaining budget per channel.
• Budget & Spend!F2: =D2/C2 — % Utilized, formatted as percentage.
• Dashboard!B5: =COUNTIF('Campaign Orders'!H:H,"Delivered") — Total delivered orders.
• Dashboard!B6: =SUMIF('Campaign Orders'!H:H,"Delivered",'Campaign Orders'!F:F) — Total revenue from delivered orders.
• Dashboard!B7: =AVERAGEIFS('Campaign Orders'!J:J,'Campaign Orders'!H:H,"Delivered") — Average CAC of successful conversions.

CONDITIONAL FORMATTING

• CAC Column (J): Red if > 0.3 (CAC exceeds 30% of order value), Yellow if between 0.15–0.3, Green if < 0.15.
• Status Column (H): Light green for “Delivered,” orange for “Shipped,” red for “Cancelled.”
• Budget Utilization (F): Red if > 110%, Yellow if 90–110%, Green if < 90%.
• Date Received (C): Highlight in light red if older than 7 days and status is still “New.”

INSTRUCTIONS FOR THE USER

This template is designed for non-technical startup teams. Begin by entering your marketing campaign names in the dropdown list on the “Campaign Orders” sheet. Every time a customer places an order via marketing (e.g., from a Facebook ad), log it in one row: fill in Campaign Name, Customer Name, Order Value, and Marketing Cost spent to acquire them. Use the Status dropdown to update progress — once delivered, the Dashboard automatically updates KPIs. Update your monthly budget on the “Budget & Spend” sheet weekly. Review the Dashboard every Friday to spot underperforming campaigns (high CAC or low delivery rate) and reallocate funds accordingly. Never leave orders in “New” status longer than 48 hours — follow up immediately.

EXAMPLE ROWS

RECOMMENDED CHARTS & DASHBOARD

The Dashboard sheet includes four interactive visualizations:

• Bar Chart: Revenue by Campaign Type — Compares total sales generated per marketing channel.
• Line Chart: Weekly Order Volume & CAC Trend — Shows how order volume grows as CAC decreases over time (ideal startup curve).
• Pie Chart: Budget Allocation vs. Actual Spend — Visualizes where the budget was spent and if any channel is overspending.
• KPI Cards: Total Orders Delivered, Total Revenue, Average CAC, ROI (Revenue ÷ Total Marketing Cost).

This template transforms chaotic startup marketing efforts into a measurable growth engine. By embedding an Order Tracker within your Marketing Plan framework — and tailoring it for the resource constraints of a Startup — you gain clarity, accountability, and the ability to scale profitably.