Internal Agency Dashboard for Party Rental

A centralized performance dashboard tracking revenue, bookings, customer growth, and marketing across all GHL subaccounts.

Role Full-Stack Developer
Tech Stack
Node.jsReactSQLAWSGHL CRM APIGoogle Ads API

Overview

The client, an agency managing multiple party rental businesses, needed a centralized dashboard to monitor GHL CRM subaccount performance and help reduce churn.

Before this solution, each subaccount used different booking systems and social media tools. Tracking revenue, orders, and marketing performance was manual and time-consuming. It was difficult to identify underperforming accounts or suggest targeted improvements.

I built a custom internal dashboard that tracks customer revenue month-by-month, number of orders, and new customers; monitors rental items and utilisation; measures conversation response rates; aggregates Google Ads performance; and consolidates data across all booking systems.

Key Business Benefits

Technical Details

My Role

Full-Stack Developer — designed, implemented, and maintained the microservice-based dashboard that fetches, aggregates, and visualises client data.

Core Features

Revenue & Orders Tracking

Month-by-month revenue for each client and subaccount, with number of orders, rental items, and new customers.

Customer Engagement Metrics

Conversation response rates, social media linkage, and posting frequency tracked per account.

Marketing Performance

Aggregates Google Ads performance metrics and combines marketing and CRM data to provide actionable growth insights.

Automated Reporting

Generates monthly performance reports automatically and provides insights to clients for growth and improvement.

Scalable Microservices Architecture

Each data source (booking system, social media, ads) handled by a separate microservice. Enables efficient scaling as the agency adds more subaccounts.

Outcomes

← Back to Case Studies Start a Similar Project