Pernod Ricard · Internal Tool

Agency
Campaign Portal

A centralised platform to manage, track and report all agency campaign projects — across brands, agencies and territories.

✓ Multi-role access
✓ Real-time collaboration
✓ Excel import/export
localhost:3000
📋 Campaigns
🏢 Agencies
👥 Users
🏷️ Brands
🔄 Statuses
🔍 Audit
▾
What it does

Everything you need to
manage campaigns

From project creation to budget tracking — all in one place.

📋
Campaign Projects
Track every agency project with full details: brand, PO, dates, budget, status and revisions.
💰
Budget Tracking
Monitor 1st quote, agency fees, AI optimisation costs, third-party fees and auto-calculated totals.
🔍
Smart Filtering & Sort
Multi-column sorting and per-column filters on every field — like Excel, but faster.
👥
Role-Based Access
Super Admin, PR Admin, Viewer (by brand), and Agency users — each with tailored permissions.
📊
Excel Import / Export
Export full reports or import multiple projects at once from a formatted spreadsheet.
🏷️
Master Data
Manage brands, statuses and agencies with integrity rules — no deletion if in use.
Campaign Projects

All your projects,
one view

Each project records all commercial and operational data: brand, agency, PO number, budget breakdown, dates and status.

📋 Copy a project in one click
💡 Auto-calculated Total Invoiced & Delta
🔒 Agency users see only their own projects
Campaign Projects
+ New Project
↓ Export
BrandAgencyRef.Status1st QuoteDelta
Absolut McCann Paris ABS-2024-001 75% 85 000 € +3 000 €
Jameson BETC JAM-2024-003 Completed 120 000 € +0 €
Ricard Publicis RIC-2024-007 50% 65 000 € -2 500 €
Beefeater Havas Paris BEF-2024-002 On hold 45 000 € —
Sort & Filter

Excel-like
multi-column sort

Click any column header to sort. Stack multiple sorts with priority badges. Use per-column filters for instant narrowing.

①
Click to sort
1st click = ascending ▲, 2nd = descending ▼, 3rd = removes sort
②
Stack sorts
Click multiple columns — priority numbers show the order
③
Filter per column
Text input or dropdown on every column header row
Active filters & sorts
Brand ▲ 1
Status ▼ 2
Agency = McCann
Brand ▲ ① Agency Status ▼ ② 1st Quote
AbsolutMcCann Paris75%85 000 €
AbsolutMcCann Paris50%42 000 €
✕ Clear Sort
Access Control

Four roles,
precisely scoped

Every user sees exactly what they need — no more, no less.

👑
Super Admin
  • Full access
  • User management
  • Audit log
  • All master data
🛡️
PR Admin
  • All projects
  • Agency management
  • Brands & Statuses
  • User management
👁️
Viewer
  • Read-only access
  • Filtered by brand
  • All agencies visible
  • Export Excel
🏢
Agency User
  • Own projects only
  • Create & edit
  • No master data
  • No other agencies
Master Data

Brands, Statuses
& Agencies

Admins manage the reference data that drives all project forms — with integrity rules ensuring consistency.

🏷️ Brands — Absolut, Jameson, Ricard…
🔄 Statuses — custom values, ordered display
🏢 Agencies — McCann, BETC, Publicis…
🔒 Integrity rule: a brand or status in use cannot be deleted — preventing broken project data.
🏷️ Brand Management
+ New Brand
Brand NameStatusProjectsActions
AbsolutActive12✏️
JamesonActive8✏️
RicardActive5✏️
BeefeaterInactive0✏️ 🗑️
Excel Integration

Import & export
in one click

Export the full project list to a formatted Excel workbook — or import dozens of projects at once from a spreadsheet.

↓ Export Excel
Full report with all columns, auto-calculated totals and agency summary sheet
↑ Import Excel
Same column format — bulk create projects, with row-level error reporting
📗
Agency_Campaigns_2024.xlsx
Brand
Agency
Project Ref.
Status
1st Quote (€)
Delta (€)
Absolut
McCann Paris
ABS-2024-001
Completed
85 000
+3 000
Jameson
BETC
JAM-2024-003
75% completed
120 000
—
Ricard
Publicis
RIC-2024-007
50% completed
65 000
-2 500
Built for Pernod Ricard

Portal at a glance

4
User Roles
23
Project Fields
∞
Projects & Agencies
1
Click to Export
Tech Stack
Node.js Express SQLite / better-sqlite3 JWT Auth Vanilla JS SheetJS (XLSX)