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.

• 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.