URL Analytics Shortener Development Backend Only
Budget: ₹1,500 – ₹12,500 INR
Project Overview
We are looking to build a robust, modular, and scalable URL shortener service for our application. This is not a standalone project it should be integrated into our existing dashboard.
The core purpose of this service is to provide powerful link tracking, detailed analytics, and compliant data handling for all short URLs generated within our platform. You will be responsible for building the backend logic, the database schema, and test out on the already built frontend dashboard for analytics.
Project Scope & Key Features
You will be tasked with implementing the following features:
1. Core Functionality & Tracking:
Per-Recipient Click Tracking: The system must store `recipient_id`, `campaign_id`, `click_time`, and the associated `url_hash` for each click to enable personalized analytics.
Redirection & Error Logging: Implement the core redirection logic. Crucially, if a link fails to redirect (e.g., target URL is 404, blocked by a bot), this error must be logged to help users debug their campaigns.
Double-Click Prevention: Introduce a 30-second cooldown window for identical clicks from the same source to prevent spam and ensure cleaner, more realistic analytics.
2. Analytics & Privacy (Compliance-focused):
Device & Location Metadata: Capture essential metadata from the user agent, such as OS, browser, and IP address.
IP & Geo-Privacy Compliance: Ensure user privacy by anonymizing IP addresses (e.g., masking the last octet `123.45.67.*`) and storing only city/region-level location data, not exact coordinates. This is a mandatory requirement.
Consent Logging: Each click event must include a `clicked_at` timestamp and a `source` field (e.g., 'sms', 'email', 'app') .
Data Auto-Expiration (TTL): Automatically purge click metadata after 90 days.
3. Technical & Security Requirements:
HTTPS-Only:All short links and internal redirects must be served exclusively over HTTPS (SSL).
Modular API Design: The primary deliverable is a well-documented REST API that our main application can call to create, manage, and retrieve analytics for short URLs.
4. Features Must Have
Branded Short URLs (Custom Domain): The service must support the use of a custom domain (e.g., link.yourcompany.com) for generating all short links.
Dynamic URL Path Prefix: Implement the ability to add a dynamic prefixto the short URL path for compliance.(https://[YourBrandDomain]/{SenderID}/{UniqueID})
Built-in UTM Parameter Builder: A user interface to easily add and manage UTM tags (utm_source, utm_medium, utm_campaign) for destination URLs to track performance across channels like WhatsApp, SMS, and email.
Real-time Click Event Webhooks: The system must be able to trigger a webhook to an external endpoint whenever a link is clicked, sending the click data in real-time.
Analytics Data Export: A feature to export raw click data and analytics in CSV/xls/xlsx format.
Required Tech Stack
Backend:
* Runtime/Language: Node.js & TypeScript
* Framework: Express.js
* API: Designing and building robust REST APIs.
* Database/ORM: PostgreSQL/Drizzle
Frontend :
* Framework: React.js
* UI/Styling: Component library NextUI and Tailwind CSS.
* Charts: ApexCharts
* Forms/State: React Hook Form, Zod, and Zustand.
Timeline
The project timeline is flexible to ensure high-quality work, with a maximum delivery
window of 3 WEEKS.
We are looking to build a robust, modular, and scalable URL shortener service for our application. This is not a standalone project it should be integrated into our existing dashboard.
The core purpose of this service is to provide powerful link tracking, detailed analytics, and compliant data handling for all short URLs generated within our platform. You will be responsible for building the backend logic, the database schema, and test out on the already built frontend dashboard for analytics.
Project Scope & Key Features
You will be tasked with implementing the following features:
1. Core Functionality & Tracking:
Per-Recipient Click Tracking: The system must store `recipient_id`, `campaign_id`, `click_time`, and the associated `url_hash` for each click to enable personalized analytics.
Redirection & Error Logging: Implement the core redirection logic. Crucially, if a link fails to redirect (e.g., target URL is 404, blocked by a bot), this error must be logged to help users debug their campaigns.
Double-Click Prevention: Introduce a 30-second cooldown window for identical clicks from the same source to prevent spam and ensure cleaner, more realistic analytics.
2. Analytics & Privacy (Compliance-focused):
Device & Location Metadata: Capture essential metadata from the user agent, such as OS, browser, and IP address.
IP & Geo-Privacy Compliance: Ensure user privacy by anonymizing IP addresses (e.g., masking the last octet `123.45.67.*`) and storing only city/region-level location data, not exact coordinates. This is a mandatory requirement.
Consent Logging: Each click event must include a `clicked_at` timestamp and a `source` field (e.g., 'sms', 'email', 'app') .
Data Auto-Expiration (TTL): Automatically purge click metadata after 90 days.
3. Technical & Security Requirements:
HTTPS-Only:All short links and internal redirects must be served exclusively over HTTPS (SSL).
Modular API Design: The primary deliverable is a well-documented REST API that our main application can call to create, manage, and retrieve analytics for short URLs.
4. Features Must Have
Branded Short URLs (Custom Domain): The service must support the use of a custom domain (e.g., link.yourcompany.com) for generating all short links.
Dynamic URL Path Prefix: Implement the ability to add a dynamic prefixto the short URL path for compliance.(https://[YourBrandDomain]/{SenderID}/{UniqueID})
Built-in UTM Parameter Builder: A user interface to easily add and manage UTM tags (utm_source, utm_medium, utm_campaign) for destination URLs to track performance across channels like WhatsApp, SMS, and email.
Real-time Click Event Webhooks: The system must be able to trigger a webhook to an external endpoint whenever a link is clicked, sending the click data in real-time.
Analytics Data Export: A feature to export raw click data and analytics in CSV/xls/xlsx format.
Required Tech Stack
Backend:
* Runtime/Language: Node.js & TypeScript
* Framework: Express.js
* API: Designing and building robust REST APIs.
* Database/ORM: PostgreSQL/Drizzle
Frontend :
* Framework: React.js
* UI/Styling: Component library NextUI and Tailwind CSS.
* Charts: ApexCharts
* Forms/State: React Hook Form, Zod, and Zustand.
Timeline
The project timeline is flexible to ensure high-quality work, with a maximum delivery
window of 3 WEEKS.