PROJECT / CASE STUDY
APTI Insight
APTI Insight is a real-time influencer and referral marketing platform that helps brands launch reward campaigns, track referral conversions, and automate payouts for promoters.
Industry: Influencer & Affiliate MarketingAWS LambdaNode.jsPostgreSQLSequelize ORMAWS SQSAWS S3AWS SES
Overview
A complete campaign and referral management platform built for modern brands and creators. Powered by AWS serverless architecture and real-time tracking, it streamlines the full marketing lifecycle: dynamic form creation, unique shortlink generation with social media previews, conversion tracking, fraud detection, and automated wallet payouts.
Challenge
- Social Link Previews: Social apps like WhatsApp need rich preview cards, while real visitors need instant redirection without losing referral tags.
- Fake Referrals: Users attempting self-referrals, bot submissions, or repeated clicks to claim unearned rewards.
- High Concurrency: Spikes in concurrent form submissions and reward payouts risking double-spending or wallet balance errors.
- Custom Forms: Brands needing custom questions and input fields for different campaigns without backend code changes.
- Background Workloads: Processing fraud analysis, emails, and ledger updates without slowing down page load times.
Solution
- Smart Edge Redirector: Dedicated Next.js service (apti.li) that serves rich preview cards to crawler bots and instantly redirects users.
- Multi-Layer Anti-Fraud: Device fingerprinting, IP velocity checks, and referral graph validation to filter out fake conversions.
- Database-Level Locking: PostgreSQL row locking (t.LOCK.UPDATE) and integer-paise ledger to ensure accurate, zero-overdraft balance updates.
- Dynamic Form Builder: Intuitive drag-and-drop builder using JSON schemas to configure custom campaign forms on the fly.
- Async SQS Queue: AWS SQS workers handle fraud checks, rewards, and notifications asynchronously to keep APIs fast.
Have a project in mind?
Tell us what you're building. We'd love to help.
Done!
Thanks for your message. We'll get back as soon as possible.