Case Study — Advertising & Digital Media

A performance-first platform built for Nepal's fastest-growing ad agency

Softsaro Nepal engineered Adsaro Nepal's digital platform end-to-end — a Next.js frontend backed by a Node.js API layer, ClickHouse for analytics at scale, and a hardened VPS infrastructure — purpose-built for speed, data volume and 24/7 uptime.

Read the case study

Client: Adsaro Nepal
Industry: Advertising & Digital Media
Service area: Nepal & Regional
Project type: High-performance ad agency platform

Fig. 01 Platform overview & dashboard

Next.js

SSR & static rendering for SEO + performance

Node.js

High-throughput API layer with async processing

ClickHouse

Columnar analytics — billions of rows, sub-second queries

VPS / Linux

Hardened server, Nginx proxy, zero-downtime deploys

Exhibit A — Overview

Project Overview

Softsaro Nepal Adsaro Nepal needed more than a website — they needed a platform capable of handling real-time campaign data, high-throughput analytics queries and a polished client-facing interface that could scale with their business. Softsaro Nepal designed and built every layer of the stack.

Client Challenge

Ad agencies live and die by data speed. The challenge was building a system that could ingest and query millions of ad event rows in real time, surface insights to clients without latency, and do so inside a maintainable, cost-efficient VPS architecture rather than expensive managed cloud.

Exhibit A — Overview

Our Solution

Softsaro Nepal delivered end-to-end Web Development Services — We chose Next.js for its server-side rendering performance and SEO control, Node.js for the API middleware, and ClickHouse as the analytics database — its columnar storage delivers sub-second queries on hundreds of millions of rows. The entire stack is deployed on a hardened VPS with Nginx, automated backups and zero-downtime deployment pipelines.

We also help performance-focused businesses grow organic traffic with SEO Services.

Infrastructure

Why ClickHouse & VPS?

Sub-second analytics

ClickHouse's columnar format delivers analytical query results in milliseconds — critical for live campaign dashboards with high row counts.

Cost-efficient at scale

VPS infrastructure keeps costs predictable as data volume grows, unlike per-query managed cloud services that penalise heavy analytical workloads.

Full stack control

Owning the server means custom Nginx configuration, fine-tuned caching, and zero-downtime blue-green deployments without third-party constraints.

SSR with Next.js

Server-side rendering gives Adsaro's public pages excellent Core Web Vitals scores and full SEO indexability — without sacrificing React's dynamic client features.

Async Node.js API

The Node.js middleware handles concurrent requests efficiently, acting as a clean boundary between frontend, analytics DB and any third-party integrations.

Automated backups

Scheduled snapshots and offsite database dumps ensure data integrity and recovery capability without manual intervention.

Specification

Key Features

Server-side rendered Next.js frontend

Node.js REST API layer with JWT authentication

ClickHouse columnar analytics database

Real-time campaign performance dashboards

Client portal with campaign reporting

Automated VPS deployment & zero-downtime releases

Nginx reverse proxy with SSL termination

SEO-optimised service and case study pages

Built With

Technology Stack

Next.js

Node.js

ClickHouse

JavaScript

PostgreSQL

Redis

Nginx

VPS / Linux

Sequence

Development Process

01 Architecture Design

02 API Planning

03 UI/UX

04 Frontend Dev

05 Backend Dev

06 ClickHouse Setup

07 VPS Deploy

08 Launch

Plate

Project Screenshots

01 Homepage

Daley Bhai Real Estate — Property overview

02 Property overview

Daley Bhai Real Estate — Client challenge view

03 Client challenge view

04 Solution page

Daley Bhai Real Estate — Results dashboard

05 Results dashboard

06 Listing page

Exhibit A — Overview

Results & Outcomes

Adsaro Nepal now runs a platform that handles real-time campaign analytics, client dashboards and public-facing content from a single, cohesive codebase — with query response times measured in milliseconds, not seconds, even under load.

Next Steps