L'Oréal
As part of an agency enablement programme, we created a digital experience that enables and measures the digital maturity for 1P, YouTube and Search initiatives for L'Oreal's agencies. The web app made a "reporting dashboard" less boring, by bringing in a gamification element of a "scoreboard" to rank business units against one another.
- Custom dashboard using HTML, CSS, JS, PHP, SQL
- Figma to Webflow conversion for phase 1 of build.
- Google sheets reading from API.
- Custom script to import data from sheets into SQL database (AI assisted).
- Using PHPMailerlibrary to send emails to user inbox where stats is retrieved from database.
- Using Chart.js library for graphs and extracted manipulated data.
