Overview

KYPI is a campaign performance tracking dashboard built for a client who previously relied on manual workflows to manage and analyze marketing data. Designed with simplicity and speed in mind, KYPI enables the admin to create new companies with a single click and import campaign performance data directly from a shared Google Sheet. The platform processes this data and displays it using interactive charts and metric summaries, eliminating repetitive manual tracking. Built using React, Express, and MongoDB, KYPI provides real-time insights with minimal input.

Problem Statement

The client originally used LockerStudio to create company profiles and track campaign performance across multiple marketing KPIs manually. This resulted in:

• Time-consuming company setup and data entry processes

• Redundant work in copying and pasting spreadsheet data

• Lack of centralized visualization for campaign metrics

• High risk of data inconsistency and missed performance trends

KYPI solves this by offering a centralized dashboard that connects directly with Google Sheets, providing fast, accurate, and visual campaign performance tracking.

Key Features

• One-Click Company Creation: - Admins can quickly create a new company profile on the platform. - No need for manual data model duplication.

• Google Sheets Integration: - Paste a Google Sheets link into the dashboard. - The system automatically fetches and parses campaign data.

• Data Visualization: - KPIs are displayed through dynamic charts, bar graphs, and metric cards. - Real-time updates reflect changes in the linked Google Sheet.

• Multiple Campaign Metrics: - Supports analysis of various campaign parameters (impressions, clicks, spend, conversions, etc.). - Each company can track individual and aggregate campaign data.

How It Works

1️⃣ Create Company – Admin clicks to create a new company profile.

2️⃣ Add Google Sheet – Input a public or authorized Google Sheets link containing campaign metrics.

3️⃣ Parse & Import – The system fetches data, maps the values, and stores them in MongoDB.

4️⃣ Visualize – Campaign KPIs are instantly rendered using intuitive charts and dashboards.

Technical Implementation

Frontend: React.js is used to create a fast, dynamic dashboard UI with data-driven charts and smooth admin interactions.

Backend: Express.js handles company creation, Google Sheets data parsing, and provides API endpoints for metrics retrieval.

Database: MongoDB stores company profiles, imported campaign metrics, and computed insights for quick retrieval.

Data Sync: Google Sheets API integration ensures smooth imports and synchronization with external spreadsheets.

Security & Data Handling

• Sheets are validated before import to prevent malformed data entries.

• Company data and campaign metrics are stored in a structured, query-optimized format.

• Minimal permissions are required, and access to Sheets can be configured for privacy.

Conclusion

KYPI replaces outdated manual workflows with a scalable, intelligent dashboard that puts campaign performance at the client's fingertips. By eliminating redundant tasks and introducing visual intelligence, KYPI improves decision-making, saves hours of administrative effort, and ensures that no performance trend goes unnoticed. It's campaign analytics made effortless.