Advertisement data management platform

The platform for launching advertising campaigns on various platforms and analyzing their efficiency.

Customer

Industry

Entertainment

Region

Client since

2020

Our customer is one of the leading European media conglomerates providing users from over Europe with the content via television, radio, and online means of content distribution.

Detailed information about the client cannot be disclosed under the provisions of the NDA.

Challenge

The client came up with an idea of a platform that would allow the launching of advertisement campaigns via such sources as television channels and radio stations. Also, the solution should allow the client to evaluate the results of launched ad campaigns for further adjustments.

To create such a platform, Innowise’s software engineers needed to

Identify strong and weak spots in the client’s existing data flow design;
Optimize data delivery;
Automate manual processes;
Redesign the existing software architecture to allow greater scalability;
Expand the existing infrastructure’s functionality.

Solution

Innowise has built a platform that allows customers to have access to the widest possible advertising toolset, including television, radio, and online media as well as launching cross-media advertising campaigns. Our software engineers have designed the solution’s architecture and data flow that allow users to effectively launch advertising campaigns and get precise data about their efficiency.

Google Cloud Platform

The solution is based on the Google Cloud Platform because it guarantees availability at 99.95% regardless of the user location or traffic which is the best result among all popular options.

Kubernetes

All the workloads and services working on the GCP are operated by Kubernetes. This system was chosen because of its automated scalability both upwards and downwards depending on the actual demand and consequent cost efficiency of the technology.

ETL pipelines

The primary data sources provided by the client were relational databases. Our data engineers have designed ETL pipelines to aggregate data chunks from the client’s sources into the cloud storage as parquet files.

Data lake and data warehouse

All the data gathered through ETL pipelines gets transferred by Apache Airflow to the data lake for the refinement process. After the “dirty” data gets “clear”, it is sent to the data warehouse from where it can be sent directly to the users or be utilized by data scientists for building models and predictions for various advertising metrics.

Technologies & tools

Back-end

Python 3.x, Flask, Celery, WebSockets, Django REST framework, Pytest

Front-end

TypeScript

Databases

PostgreSQL

DevOps

Kubernetes, Apache Airflow, Terraform

Cloud

Google Cloud Platform

VCS

GitLab

Process

We have selected Scrum as a software development methodology, with bi-weekly sprints and a Sprint overview to demonstrate the valuable portions of functionality added. We used Jira and Confluence, and all the meetings were held in Google Meets.

Innowise’s team developed the software requirements according to the client’s vision of the solution and documented them. During the development process, we were analyzing, refining, and decomposing those requirements into tasks for easier progress tracking. After several requirements were completed, Innowise’s quality assurance engineers checked whether the solution was developed according to the requirements, had no bugs, and the whole development team was on the same page with the client’s vision and desired outcomes.

Team

Data Engineers

Front-End Developers

Back-End Developers

ML Engineer

BI Developers

Business Analyst

Project Manager

QA Engineers

Results

Innowise has built the platform via which customers can launch their advertisement campaigns through multiple media sources, track various metrics, and build predictions utilizing both refined and non-refined data.

Our software engineering team has automated an array of previously manual processes and designed the data flow to make the software product as efficient as possible.

Project duration

Since 2021
The project is still ongoing; at this stage, we support the platform and implement new features

Related cases

Need a technological solution? Contact us!

What happens next?

Having received and processed your request, we will get back to you shortly to detail your project needs and sign an NDA to ensure the confidentiality of information.

After examining requirements, our analysts and developers devise a project proposal with the scope of works, team size, time, and cost estimates.

We arrange a meeting with you to discuss the offer and come to an agreement.

We sign a contract and start working on your project as quickly as possible.