Multi-Page Excel Template for Marketing Plan Shopping List

This comprehensive Multi-Page Excel Template for Marketing Plan Shopping List is designed specifically for marketing teams and small business owners who need to plan, track, and execute promotional campaigns with precision. Unlike a generic shopping list, this template transforms the traditional notion of a “shopping list” into a dynamic campaign resource tracker—encompassing all digital tools, print materials, software subscriptions, advertising spends, event supplies, and third-party services required to launch and sustain a marketing initiative. The Multi-Page structure ensures scalability and organization across complex campaigns that span weeks or months.

Sheet Names

The template consists of five interconnected sheets:

• Dashboard
• Campaign Overview
• Shopping List (Items)
• Budget & Spend Tracker
• Vendor & Contract Log

  Table Structures, Columns and Data Types

  Campaign Overview Sheet

  This sheet captures high-level campaign parameters. Key columns include:

  < td>Launch date of the campaign< td>Campaign end or review date< td>Real-time status tracking < td>Description of primary demographic or segment < td>Approved budget for the entire campaign

  Column	Data Type	Description
  Campaign Name	Text	Name of the marketing campaign (e.g., “Summer Launch 2024”)
  Start Date	Date
  End Date	Date
  Status	Dropdown: Not Started / In Progress / Paused / Completed
  Target Audience	Text
  Total Budget ($)	Currency

  Shopping List (Items) Sheet

  This is the core of the template — a dynamic shopping list tailored for marketing activities. Columns include:

  < td>Unique item identifier < td>Name of the marketing asset (e.g., “Facebook Ad Creatives,” “Flyers 500 pcs”)< td>How many units or licenses needed < td>Price per unit or license < td>= Quantity * Unit Cost < td>Name of supplier or platform < td>Date by which item must be delivered or activated < td>Add any instructions, links, or file references

  Column	Data Type	Description
  ID	Number (Auto-increment)
  Item Name	Text
  Type	Dropdown: Digital / Print / Software / Event / Service < td>Categorizes the nature of the item
  Quantity	Number
  Unit Cost ($)	Currency
  Total Cost ($)	Currency (Formula)
  Vendor	Text / Dropdown (linked to Vendor Log)
  Purchase Status	Dropdown: Not Ordered / Ordered / Received / Paid < td>Progress tracking for each item
  Due Date	Date
  Campaign Phase	Dropdown: Pre-Launch / Active / Post-Campaign < td>Aligns purchase with campaign timeline
  Notes	Text

  Budget & Spend Tracker Sheet

  This sheet automatically pulls data from the Shopping List and aggregates totals by category. Columns include:

  < td>Categorizes spending by type < td>Planned amount for the category < td>=SUMIFS(ShoppingList!Total Cost, ShoppingList!Type, Category) < td>= Budget Allocated - Actual Spent < td>= Actual Spent / Budget Allocated * 100

  Column	Data Type	Description
  Category	Text (e.g., “Digital Ads,” “Print Materials”)
  Budget Allocated ($)	Currency
  Actual Spent ($)	Currency (Formula: SUMIFS)
  Variance ($)	Currency (Formula)
  Percentage Used (%)	Percentage (Formula)

  Vendor & Contract Log Sheet

  This sheet ensures accountability with vendor management:

  < td>Name of provider < td>Contact details < td>When service agreement ends < td= COUNTIFS(ShoppingList!Vendor, Vendor Name) < td>User-rated vendor performance

  Column	Data Type	Description
  Vendor Name	Text
  Contact Info	Text / Email / Phone (hyperlinked)
  Contract Expiry Date	Date
  Past Orders Count	Number (COUNTIFS)
  Rating (1–5)	Number

  Formulas Required

  • Total Cost in Shopping List: =[@Quantity]*[@[Unit Cost ($)]]
  • Total Spent by Category: =SUMIFS(ShoppingList!F:F, ShoppingList!E:E, [@[Category]])
  • Variance: =[Budget Allocated ($)]-[Actual Spent ($)]
  • Percentage Used: =[Actual Spent ($)]/[Budget Allocated ($)]*100
  • Count of Vendor Orders: =COUNTIFS(ShoppingList!G:G, [@[Vendor Name]])

  Conditional Formatting

  • Shopping List: Highlight “Due Date” cells in red if due within 3 days and status is “Not Ordered.”
  • Budget Tracker: Color code percentage used: green (≤75%), yellow (76–95%), red (>95%).
  • Vendor Rating: Apply a 5-star icon set based on rating value.
  • Purchase Status: Green for “Received/Paid,” orange for “Ordered,” gray for “Not Ordered.”

  User Instructions

  1. Begin by filling out the Campaign Overview sheet with your campaign goals and timeline.

  2. Use the Shopping List to log every item required — from Canva Pro subscriptions to branded pens for events.

  3. Update Purchase Status daily; this triggers conditional formatting and keeps your team aligned.

  4. Budget Tracker automatically calculates spending; adjust allocations if scope changes.

  5. Maintain the Vendor Log: Rate every vendor after delivery to improve future decisions.

  6. Review the Dashboard weekly — it visualizes spend vs budget, overdue items, and top categories.

  Example Rows

  Shopping List Example:
  ID: 01 | Item Name: “Facebook & Instagram Ads (3-week run)” | Type: Digital | Quantity: 1 | Unit Cost ($): $850.00 | Total Cost ($): $850.00 | Vendor: Meta Ads Manager | Purchase Status: Ordered | Due Date: 2024-11-30
  ID: 47 | Item Name: “Print Flyers (5x7”, 250 pcs)” | Type: Print | Quantity: 1 pack | Unit Cost ($): $98.50 | Total Cost ($): $98.50 | Vendor: Vistaprint Inc. | Purchase Status: Received

  Recommended Charts & Dashboards

  The Dashboard sheet features four interactive charts:

  1. Pie Chart: “Budget Allocation by Category” — shows proportion of spending per type (Digital, Print, etc.).
  2. Bar Chart: “Spend vs Budget Per Category” — compares allocated budget with actual spend.
  3. Timeline Gantt Chart: Visualizes purchase due dates against campaign phases using conditional formatting bars.
  4. KPI Summary Box: Displays total spent, % of budget used, number of overdue items, and pending vendor approvals.

  This Multi-Page Excel Template transforms the mundane “shopping list” into a strategic marketing execution tool. By integrating campaign planning with procurement tracking — all within one file — teams eliminate silos between strategy and execution. The template is scalable for small campaigns or enterprise-level multi-channel rollouts, making it indispensable for any marketer aiming to spend wisely and deliver on time.

  ⬇️ Download as Excel✏️ Edit online as Excel