Ramp IQ
A multi-tenant marketing intelligence and campaign management platform for franchise networks.
Ramp IQ is a sophisticated backend platform designed to empower franchisors, regional managers, and marketing agencies. It centralizes the management of localized advertising campaigns, geographic territory validation, and compliance tracking across multiple digital advertising channels (Meta, Google, TikTok).
Technology stack
Problem
Franchise networks struggled with fragmented marketing data, overlapping geographic territories, and maintaining strict brand and UTM parameter compliance across hundreds of localized campaigns executed by disparate vendor agencies.
Solution
Developed a centralized, multi-tenant application that automates territory validation using geocoding pipelines, standardizes campaign metadata via dynamic JSON templates, and ensures strict data isolation between different franchisor networks.
Technical contribution
Architected the core domain models (franchisors, vendors, locations, offers) and their complex many-to-many relationships. Built robust data seeding pipelines for isolated environments and structured a scalable Django REST Framework API.
Architecture
Implemented a "shared database, isolated schema" multi-tenancy model using django-tenants and PostgreSQL. Integrated an asynchronous task queue using Celery and Redis to handle non-blocking operations like automated geographic validation (Geoapify) and secure email notifications.
Performance considerations
Optimized database interaction by heavily utilizing Django's select_related and prefetch_related within a dedicated service/selector layer, successfully mitigating N+1 query bottlenecks when retrieving deep hierarchical data.
Security considerations
Enforced granular role-based access control ensuring franchisees and vendor agencies can only access data within their specifically assigned operational territories. Secured all endpoints using JWT.
Deployment model
Containerized the application environment and managed distinct development, staging, and production configurations, routing requests dynamically via specialized tenant middleware.
Outcome
Successfully delivered the foundational MVP schema and core API, providing FranchiseRamp with a highly secure, scalable, and isolated data architecture ready for full frontend integration and analytics expansion.