Trust Ads

Trust Ads is a digital advertising platform engineered to streamline the management, optimization, and reporting of paid marketing campaigns on major social platforms.

• Managing complex, multi-platform ad data with high operational friction.
• Building and maintaining advertiser trust through transparent reporting and automated performance monitoring.
• Need for a centralized system to handle campaign automation rules and smart previews effectively.

• Data Latency Bounds: Campaign metrics from third-party networks (e.g., Meta, Google) must be fetched, normalized, and updated within 15-minute windows without hitting API rate limits.
• Lock Contention: Automation rules run concurrently across millions of active campaigns, creating high write load on MySQL database transaction logs.
• Dynamic Previews: Rendering ad configurations with live media requires responsive and low-latency storage access.

• API Gateway & Routing: Apache and reverse proxy configurations with strict CORS and rate-limiting blocks.
• Queue Pipeline: Decoupled message queue workers managing API fetch dispatch and campaign rule evaluation.
• Data Model: Optimized MySQL database schemas with composite indexes on campaign_id and timestamp to accelerate time-series reads.

• Why Async Queue Processing?: Executing third-party API queries synchronously within HTTP request-response cycles blocked web server processes under high traffic. Decoupling the data ingestion to message queues resolved thread starvation.
• Alternatives Rejected: A NoSQL storage model (MongoDB) was rejected. Although NoSQL handles unstructured metrics easily, the system required strict transactional integrity (ACID) for budget rule triggers to prevent overspending, making relational MySQL with composite indexes a safer choice.
• Trade-offs: Implementing asynchronous processing introduced eventual consistency. Advertisers see campaign adjustments within a 5-minute window rather than real-time, which was accepted in exchange for system stability and zero thread blocking.

• Centralized campaign management dashboard.
• Performance tracking and reporting tools.
• Budget monitoring and optimization insights.
• Client-friendly reporting views.

• Decoupling API ingestion pipelines from write-heavy databases is critical to maintain web server responsiveness.
• Database index cardinality matters; building composite indexes tailored for specific analytical query patterns reduced reporting latency from 8 seconds to 120 milliseconds.