Skip to main content
All projects
Pest Insights Dashboard — project screenshot

Case study

Pest Insights Dashboard

Location KPIs

views

Sheets

import

MERN

stack

Overview

Operational dashboard for pest-control services with scheduling, routing, and business KPIs.

Problem

Pest-control operators needed location-level KPIs — appointments, tech time on site, production, re-service rate — without rebuilding reports in spreadsheets every month.

Solution

I built Pest Insights as an operational dashboard: React charts and admin flows, Express APIs for company creation and metrics, MongoDB storage, and Google Sheets import so campaign and location data stay in one place.

Architecture & delivery

  • React.js dashboard with charts and location tables
  • Express.js APIs for companies and KPI endpoints
  • MongoDB for profiles and campaign metrics
  • Google Sheets API for data import