Vadym/obsidian
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
obsidian/wiki/client-knowledge/loreal.md
Vadym Samoilenko 4442916df4 vault backup: 2026-05-14 21:09:52
2026-05-14 21:09:52 +01:00

3.3 KiB
Raw Permalink Blame History

title aliases tags sources created updated
L'Oréal — Client Knowledge
loreal
l'oreal
loreal-global
client
loreal
box
make
php
sla
global-to-local
01 Projects/loreal-global-kickoff
01 Projects/loreal-sla-calculator
2026-04-15 2026-04-15

L'Oréal

Oliver Agency works with L'Oréal on campaign asset management (global → local transformation) and SLA timeline tooling.

Key Takeaways

  • L'Oréal uses Box for campaign asset exchange and folder hierarchy encodes campaign numbers
  • Make.com is used as the automation backbone (webhook on submission)
  • The "Global to Local" workflow transforms global campaign CSVs into regional market CSVs
  • SLA calculator replaces Excel — 9 brief types, 8 stages, Gantt view
  • PHP backend for the global kickoff tool (not Python/Node)

Projects

Project Purpose Entry Point
01 Projects/loreal-global-kickoff/Loreal Global Kickoff Asset submission + global-to-local CSV transform PHP server
01 Projects/loreal-sla-calculator/Loreal SLA Calculator SLA timeline calculator for eCom Content Factory PMs docker compose up
01 Projects/loreal-timelog-viewer/Loreal Timelog Viewer Static Vite SPA for viewing time logs; served at /timelog/ subpath on optical-dev Apache static files

L'Oréal OMG Assistant Capabilities

  • Master Global Asset Submission — submit Box assets with metadata
  • Auto-populate campaign number from Box folder hierarchy
  • Global to Local — transform global CSVs into regional market CSVs
  • Webhook to Make.com on submission

L'Oréal SLA Calculator Capabilities

  • Replaces Excel for SLA timeline management
  • 9 brief types × 8 stages
  • Gantt chart view + date verdict
  • CSV + iCal export
  • Client Estimator (client.html) — simplified 4-input version

Tech Preferences

  • PHP for server-rendered web apps (not Python or Node)
  • Box API for file storage and folder-based campaign organization
  • Make.com for automation/workflow orchestration
  • CSV as data exchange format for global → local transforms
  • Docker for SLA calculator (simpler tool)

Quirks & Lessons

  • Campaign number is encoded in the Box folder hierarchy — must traverse parent folders to extract it
  • Make.com webhook triggers on every submission — design idempotent handlers
  • The "Global to Local" transform needs to understand regional market codes in CSV headers
  • SLA calculator has two UX modes: full PM calculator vs simplified client estimator
  • L'Oréal uses eCom Content Factory workflow — their PM team are the primary users of the SLA tool
  • Timelog Viewer was deployed as a pre-built dist/ without source — required <base href="/timelog/"> workaround in index.html to fix asset 404s on subpath; see wiki/concepts/vite-prebuilt-subpath-workaround
  • Timelog Viewer deploy = git pull not rsync — project is now in Git; after adding source, deploy with git pull on optical-dev, then rebuild dist/ locally if needed. Do NOT use rsync to sync dist/ manually.
  • loreal-timelog-viewer lives on optical-dev at /timelog/ Apache alias

Related