Campaign emissions needed more than a spreadsheet.
Media emissions depend on different activity metrics: duration, contacts, spots, circulation, faces, ad size, days, impressions, markets, media types, assumptions, and reporting needs.
MEDIA SUSTAINABILITY
Campaign CO2 calculations moved into a structured application.
Media teams needed a repeatable way to capture campaign inputs, calculate emissions across media types, and review assumptions before using the numbers in reports.
Campaign inputsEmissions logicDashboardsReporting viewsMultilingual UI
01 InputCampaign data
Market, media type, and activity details are captured.
02 StructureNormalize fields
Inputs are cleaned into a consistent model.
03 CalculateCO2 logic
Media-specific assumptions produce emissions output.
04 ReviewCheck assumptions
Users inspect inputs and calculation context.
05 ReportDashboard views
Campaign outputs become visual reporting.
THE WORKFLOW
From scattered campaign data to reviewed sustainability outputs.
The application captured structured media campaign inputs across video, audio, print, out-of-home, content, and digital, applied emissions logic, and presented results through dashboards and reporting views.
SYSTEMS
Connected stack
- • React and TypeScript
- • Express backend
- • PostgreSQL and Drizzle ORM
- • Vite and Tailwind CSS
- • Multilingual interface in English, Estonian, Lithuanian, and Latvian
- • Campaign reporting views and CO2 impact charts
A campaign calculator with operational views.
The build included campaign creation, personal and shared campaign views, archive flows, media-type inputs, emissions calculation logic, dashboard views, monthly averages, media distribution charts, and a multilingual interface.
Assumptions stay visible.
Users can review campaign inputs, calculation assumptions, and visual outputs before using the numbers externally.
A repeatable workflow for sustainability reporting.
Campaign emissions moved into a structured process with clearer input handling and more consistent reporting views.
NEXT STEP
Need a calculator around operational rules?
Start with the data model, assumptions, review flow, and reporting output.
Scope an implementation sprint