Custom Analytics Dashboard for Media Buying Operations

Optima is a growing advertising technology company headquartered in Barcelona. They specialize in media buying and monetizing ad traffic across multiple websites and providers. As their operations scaled, so did their need for reliable data and performance tracking tools. Optima turned to Peppernode for help after previously collaborating on another project, trusting our team to build a smarter, cleaner, and more scalable internal solution.

• 1 Fullstack Engineer
• 1 UI/UX Designer
• 1 QA Engineer
• 1 Project Manager

We started with a simple but strategic MVP using Django templates—no bells, no whistles. The client needed speed, and we delivered a basic version in just a couple of months. From there, the system evolved: more providers, deeper analytics, and cleaner UI. Eventually, we rebuilt the front end using React for a better, more scalable experience.

• Automated ETL pipeline that fetches raw data daily from 80+ advertising platforms. Each data source varies in format—some provide APIs, others require HTML parsing or manual CSV uploads. The ETL logic transforms these disparate formats into a unified schema for consistent analytics.
• Manual data upload and mapping UI for handling providers without automated integrations. The interface includes CSV file parsing, validation, and mapping tools to associate data correctly with internal models.
• Role-based access control (RBAC). Admins, Finance teams, Media Buyers, and Partners each see only the data relevant to their work.
• Advanced filtering and data export, including multi-select filters, date pickers, and real-time sorting for high-volume datasets. Exports are generated server-side and delivered in downloadable formats (CSV/XLSX).
• Custom analytics module visualizes KPIs such as impressions, revenue, eCPM, cost, and ROI over time using dynamic charts and trend lines built with charting libraries.
• Cost structure management allows flexible configurations including fixed CPM, revenue share percentages, or tiered pricing models. This feeds into profit calculations and performance views.
• Currency conversion engine to normalize financials across EUR/USD inputs. Admins can manually override exchange rates for any provider and sync rates monthly or daily.
• User and publisher management, including CRUD features for onboarding new media buyers, mapping websites to partners, and organizing deal structures. Custom modules let admins define business rules, automate site assignments, and review publisher performance.

While the client managed backlog and priorities on their side, our team provided end-to-end development and tech guidance. We proposed how to scale the platform, handled the technical decisions, and adjusted functionality based on business needs.

• Fully functional custom dashboard launched in just 2 months (MVP)
• 1.5+ years of ongoing development and continuous improvements
• 25–35% boost in procurement efficiency through better supplier performance tracking
• 90% faster reporting thanks to streamlined workflows
• Team size doubled since the project kicked off
• 100% automated daily data sync from over 80 providers

• Operational transparency: real-time access to performance data
• Reduced manual errors: data import and mapping streamlined
• Better decision-making: visibility into profit trends, ROI, and cost breakdowns
• Scalable infrastructure ready for future growth