AD MANAGEMENT PLATFORM

AD MANAGEMENT PLATFORM
AD MANAGEMENT PLATFORM
AD MANAGEMENT PLATFORM
The Ad Management Platform is developed for effective controlling ads on Google Ads and Bing Ads. The system is able to create millions of ad groups and keywords and manages every advertisement based on internal rules. The largest number of ads was created during Black Friday and Cyber Monday. It was about 100 million keywords.
Challenge 1/4:
Find the best database that will support doing 100K updates per second and can scale linearly

Solution:

We've investigated a lot about different databases and made a decision to use the Apache Cassandra cluster and fine-tune the system to meet the client's requirement
Challenge 2/4:
Implement the platform that will be able to manage any amount of ads at the same time

Solution:

The client received a scalable system for creating and controlling any amount of advertising. We had about 40 servers in production. 12 of them were Apache Cassandra servers and 28 were the application servers. We used RabbitMQ for distributing the messages across the system
Challenge 3/4:
Reduce the infrastructure cost, implement on-demand scaling

Solution:

The solution was to implement ETL on-the-fly data streaming in BigQuery using the streaming API, in order to decrease reports generation and data warehouse cost. Implemented the system that allows to deploy or stop some servers depend on different metrics - CPU load, RAM usage, etc)
Challenge 4/4:
Develop the real-time model that process every single click and make a decision about the ad - change a price or stop it

Solution:

We've implemented a model of tracking and price changes in real time on top of DynamoDB.It processed every click and made a decision on advertising on the fly
LANGUAGES
DATABASES
TOOLS
Made on
Tilda