Marketing Plan - Sales Tracker - Weekly
Download and customize a free Marketing Plan Sales Tracker Weekly Excel template. Perfect for business, legal, and personal use. Editable and ready to boost your productivity.
Weekly Marketing Plan Sales Tracker Excel Template
The Weekly Marketing Plan Sales Tracker is a comprehensive, dynamic Excel template designed for marketing teams and sales managers to monitor campaign performance, track revenue generation, and optimize conversion strategies on a weekly basis. This template integrates the strategic planning elements of a Marketing Plan with the real-time tracking functionality of a Sales Tracker, all structured around weekly intervals to enable agile decision-making. Whether you're managing digital advertising campaigns, email marketing initiatives, social media promotions, or event-driven sales drives, this template provides an intuitive dashboard to visualize progress against goals and identify underperforming channels quickly.
Sheet Names
- Weekly Summary – The main dashboard showing key metrics and visualizations.
- Sales Data (Weekly) – Raw data input sheet where weekly sales transactions are logged.
- Campaign Tracker – Tracks individual marketing campaigns, their budgets, channels, and ROI.
- Goals & KPIs – Defines weekly targets for revenue, leads, conversion rates, and customer acquisition cost (CAC).
- Notes & Insights – A free-form section for team members to record observations, challenges, or opportunities.
Table Structures & Columns
The core data input is housed in the “Sales Data (Weekly)” sheet. This table includes the following columns with specified data types:
| Column | Data Type | Description |
|---|---|---|
| Date (MM/DD/YYYY) | Date | Date the sale occurred. |
| Campaign ID | Text (e.g., FB-2024-W17) | Unique identifier linking to Campaign Tracker sheet. |
| Campaign Name | Text | |
| Channel | Text (Dropdown) | |
| Lead Source | Text | |
| Sale Amount ($) | Currency | |
| Quantity Sold | Number | |
| CAC ($) | Currency | |
| Status | Text (Dropdown) | |
| Notes | Text |
Formulas Required
The template relies on essential formulas to automate calculations:
- =SUMIFS(SalesData[Sale Amount], SalesData[Date], ">="&TODAY()-WEEKDAY(TODAY())+1, SalesData[Date], "<="&TODAY()) – Calculates total weekly sales.
- =COUNTIFS(SalesData[Status], "Converted") – Counts total converted leads for the week.
- =SUM(CampaignTracker[Budget]) / COUNTIF(SalesData[Status], "Converted") – Calculates average CAC per campaign.
- =IFERROR(SUMIFS(SalesData[Sale Amount], SalesData[Campaign ID], CampaignTracker[@[Campaign ID]]) / CampaignTracker[@Budget], 0) – Computes ROI for each campaign (Revenue / Budget).
- =AVERAGE(SalesData[Sale Amount]) – Average deal size for the week.
- =SalesData!B2 + 7 – Auto-generates next week’s date range for planning purposes.
Conditional Formatting Rules
To enhance visual analysis:
- Green fill (≥ target): Applied to weekly revenue cells exceeding the goal in “Goals & KPIs” sheet.
- Red fill (< 70% of target): Highlights campaigns with ROI under 70%, signaling underperformance.
- Yellow fill (CAC > $150): Alerts when CAC exceeds predefined threshold for cost-efficiency.
- Icon sets (↑↓→)** in “ROI” column**: Arrows indicate trend compared to last week’s performance.
Instructions for the User
- Begin each week by updating the "Goals & KPIs" sheet with new targets for revenue, leads, and CAC.
- Input all sales data into “Sales Data (Weekly)” daily — ensure Campaign ID matches entries in “Campaign Tracker”.
- Add new campaigns to the “Campaign Tracker” sheet with their budget, channel, and start/end dates. The template auto-updates linked fields.
- Review the “Weekly Summary” dashboard daily for real-time updates on KPIs and trends.
- Use the “Notes & Insights” sheet to document why certain campaigns outperformed or failed — this builds institutional knowledge.
- Refresh all pivot tables and charts weekly (Data > Refresh All) if using external data connections.
Example Rows
Sales Data Example:
| 4/15/2024 | FB-2024-W16 | Spring Promo - Facebook | Paid Social | John Doe | $399.99 | 1 | $85.00 | Converted | |
| Google Ads | Jane Smith | $599.50 | 1 | $130.00 | Converted | ||||
| Robert Brown | $79.99 | 3 | $65.00 | Converted |
Recommended Charts & Dashboards (Weekly Summary)
- Line Chart: Weekly Revenue Trend – Tracks daily revenue over 7 days; reveals spikes or slumps.
- Bar Chart: Campaign ROI Comparison – Shows which campaigns delivered highest returns per dollar spent.
- Pie Chart: Channel Contribution to Revenue – Visualizes the percentage of sales from each marketing channel (Email, Paid Social, etc.).
- Combo Chart: Sales vs. CAC Over Time – Dual-axis chart comparing revenue growth against average CAC — critical for identifying cost inflation.
- KPI Tiles: Real-time displays for “Total Weekly Revenue”, “Conversion Rate %”, “Average Deal Size”, and “Budget Utilization %”.
Conclusion
The Weekly Marketing Plan Sales Tracker is more than a data collection tool — it is a decision-making engine. By aligning weekly sales performance directly with marketing campaign inputs, this template ensures that every dollar spent on marketing can be quantified, analyzed, and optimized. It transforms abstract strategy into actionable insights and empowers teams to adjust tactics quickly based on real data rather than assumptions. Designed for clarity and scalability, this template adapts effortlessly across industries — from e-commerce to B2B services — making it an indispensable asset in any modern marketing arsenal.
⬇️ Download as Excel✏️ Edit online as ExcelCreate your own Excel template with our GoGPT AI prompt:
GoGPT