Foco
Back to Projects
Active
Excel Add-in
Media Planning

Hoagie

The media planning toolkit that lives inside Excel.

An Excel Add-in for media agency planners that integrates UTM generation, impression forecasting, and spend pacing directly into spreadsheets.

Features

UTM Builder

Standardized campaign tracking parameters with batch-write to Excel. Generate consistent, error-free UTM strings across campaigns without leaving your spreadsheet.

Impression Forecasting

Budget allocation across channels with 5 flighting patterns. Writes live Excel formulas so forecasts stay dynamic and update as inputs change.

Spend Pacing

Track actual vs planned spend with color-coded status indicators. Spot over- and under-delivery at a glance without building manual trackers.

Pre-configured Channels

12 media channels with default CPMs across video, digital, and social. Start planning immediately with industry-standard benchmarks baked in.

Tech Stack

React
TypeScript
Office.js
Zustand
Vite
Tailwind CSS
Vitest

Who is this for?

Hoagie is built for media planners, marketing ops teams, and agency planners who live in Excel but need specialized tools to plan campaigns efficiently.

If you've ever toggled between a UTM spreadsheet, a media plan, and a pacing tracker — copying and pasting between all three — this add-in brings everything into one place.

The Problem

Media planning workflows are scattered across disconnected tools:

  • Context-switching kills velocity — planners jump between UTM builders, budget calculators, and pacing dashboards dozens of times a day.
  • Manual UTM building is error-prone — one typo in a tracking parameter means broken attribution and wasted ad spend.
  • Spreadsheet formulas break — hand-built forecasting and pacing sheets are fragile, hard to maintain, and impossible to standardize across a team.

How It Works

Install the add-in, open the taskpane inside Excel, and use the three main tabs:

  1. UTM Builder — select campaign parameters from dropdowns, generate UTM strings, and batch-write them directly into your sheet
  2. Impression Forecasting — enter a budget, pick channels and a flighting pattern, and the add-in writes live Excel formulas that update as you adjust inputs
  3. Spend Pacing — import actuals alongside your plan and get color-coded status indicators showing delivery against target
  4. Channel Library — browse 12 pre-configured media channels with default CPMs to jumpstart any plan

Use Cases

Campaign Launch Prep

Use the UTM Builder to generate all tracking URLs for a new campaign in minutes. Pair it with the forecasting tab to build an impression plan that ties directly to budget.

Mid-Flight Pacing Checks

Drop in weekly actual spend data and let the pacing tab flag channels that are over- or under-delivering. Catch issues before they snowball into end-of-quarter scrambles.

Reporting & QA

Standardized UTMs mean cleaner analytics data downstream. Use Hoagie's consistent parameter format to reduce tagging errors and simplify post-campaign reporting.

Interested in Hoagie?

Check out the source code or try the live demo.