# Dashboards & Reporting

> Live dashboards that pull numbers from every tool you use into one place, updated automatically.

Page: https://mburhan.com/tag/dashboards

2 case studies in full below.

# Automated P&L & Sales Tracker for Ecommerce (Google Sheets)

> A single Google Sheets template that turns raw sales, COGS and marketing cost data into live real-vs-estimated profit numbers for any date range.

Section: Dashboards & Reporting

Page: https://mburhan.com/case/ecommerce-pnl-tracker

## Project Overview

This project delivers an automated profit and loss (P&L) tracking solution for an ecommerce business. It consolidates sales, real COGS, marketing costs, and other expenses into a single spreadsheet-based reporting system.

The tracker calculates real and estimated profit automatically, allowing the team to review financial performance across different date ranges without rebuilding reports manually.

## The Challenge

Ecommerce financial data can be spread across sales records, product costs, marketing expenses, and other operational costs. Combining these figures manually makes it harder to maintain an up-to-date view of profitability.

The main challenges included:

- **Fragmented financial data:** Sales, COGS, marketing spend, and other expenses needed to be considered together.
- **Manual reporting:** Profit and loss figures required repetitive calculations and reporting work.
- **Limited visibility:** Understanding real profit, estimated profit, and profit margins across different periods required a consolidated view.
- **Date-range comparisons:** Reviewing daily, monthly, and longer-term performance required flexible reporting.

## The Solution

A reusable Google Sheets template was developed to bring the relevant financial figures into one reporting system and calculate profitability automatically.

The solution provides:

- **Automated P&L calculations:** Combines sales, COGS, marketing costs, and other expenses to calculate profit metrics.
- **Real vs. estimated profit:** Makes both measures available for financial review.
- **Flexible date-range reporting:** Allows the team to review performance for selected periods.
- **Daily performance tracking:** Presents sales, profit, and expense metrics for day-to-day monitoring.
- **Monthly and rolling analysis:** Supports longer-term performance reviews and expense breakdowns.
- **Reusable template:** The same template can be applied to different brands, with totals recalculated for the relevant data.

## Key Dashboard Features

### Finance & Sales Reporting

An automated profit & loss tracker built in Google Sheets for an ecommerce business. Pulling sales, real COGS, marketing spend and other expenses into one model, it calculates real vs. estimated profit automatically for any date range instead of being rebuilt by hand every month.

- $1.18M: Total sales (period)
- $54.6K: Total real profit
- 4.61%: Real profit margin
- $587K: Total marketing cost

Image: Monthly sales and profit dashboard: total sales, real/estimated profit, margins and marketing cost calculated automatically from raw order data. (https://mburhan.com/case-content/ecommerce-pnl-tracker/image1.png)

Image: The same template applied to a different brand: totals, COGS and marketing cost recalculated instantly for any date range. (https://mburhan.com/case-content/ecommerce-pnl-tracker/image2.png)

### Daily and 30-day views

A daily dashboard view surfaces total and trailing-30-day sales, profit and expense metrics side by side, so the team can catch a bad week before it becomes a bad month.

Image: Daily dashboard: total and last-30-days sales, profit and expense metrics side by side for fast day-to-day monitoring. (https://mburhan.com/case-content/ecommerce-pnl-tracker/image3.png)

### Rolling breakdowns

A rolling 12-month view breaks total profit down into COGS, marketing cost, other expenses and disputes won, so the team can see exactly where margin is being gained or lost.

Image: Last-12-months pie chart breaking total profit down into COGS, marketing cost, other expenses and disputes won. (https://mburhan.com/case-content/ecommerce-pnl-tracker/image4.png)

Built as a single Google Sheets template so finance reads live profit numbers for any date range without exporting from five different tools first.

## Workflow

Image (https://mburhan.com/uploads/bf461c5edbbabdc8cfc88cbe.png)

The workflow consolidates the available financial inputs, calculates the relevant profit and margin metrics, and presents the results through reporting views for different periods.

## Technology Used

**Google Sheets** is the core platform used to organize the financial data, calculate P&L metrics, and display the dashboards.

The solution uses a reusable spreadsheet structure to support financial reporting across date ranges and brands.

## Results and Business Value

The tracker brings key ecommerce financial metrics into one place and reduces the need to rebuild reports manually.

- **Centralized financial visibility:** Sales, profit, margins, COGS, and marketing costs can be reviewed together.
- **Reduced manual reporting:** Calculations and dashboard views are organized within a reusable template.
- **Flexible analysis:** The team can review performance across daily, monthly, and rolling periods.
- **Consistent reporting:** Different brands can use the same reporting structure.
- **Improved financial oversight:** Real and estimated profit figures help the team review financial performance.

## Final Outcome

The Automated P&L & Sales Tracker provides an organized, reusable Google Sheets solution for ecommerce financial reporting. By bringing sales, costs, and profitability metrics into one place, it makes financial performance easier to review across selected date ranges and supports more consistent reporting for ecommerce operations.

---

# Weekly Marketing Performance Tracker (Google Sheets)

> A Google Sheets weekly tracker that brings Google Analytics traffic and Klaviyo email and SMS performance into one view.

Section: Dashboards & Reporting

Page: https://mburhan.com/case/weekly-marketing-performance-tracker

## 1. Project Overview

This project brings acquisition and retention metrics together in a centralized Google Sheets tracker. Marketing teams can review website traffic, customer acquisition, email and SMS sales, and subscriber growth without switching between separate platforms.

**Category:** Dashboards & Reporting

**Tools:** Google Sheets, Google Analytics, Klaviyo

## 2. The Challenge

Marketing performance data was spread across different platforms, making it harder to compare acquisition and retention results in one place.

- **Fragmented reporting:** Website traffic and email/SMS performance were tracked separately.
- **Limited visibility:** Reviewing performance across channels required switching between tools.
- **Manual comparison:** Comparing results across weeks and months required a consolidated reporting view.

## 3. The Solution

A centralized Google Sheets tracker organizes Google Analytics and Klaviyo metrics into weekly and monthly dashboards.

The tracker includes:

- **Website traffic:** Total traffic, new users, new customers, and engagement time.
- **Acquisition channels:** Organic search, organic social, paid search, paid social, direct, and other traffic sources.
- **Email performance:** Email sales, placed orders, campaigns, flows, and subscriber counts.
- **SMS performance:** SMS sales, subscriber totals, and new subscribers.
- **Historical comparison:** Weekly and monthly views for comparing performance over time.

## 4. How It Works

The tracker brings data from both platforms into one reporting view, where the team can compare acquisition and retention metrics over time.

**Workflow**

Google Analytics + Klaviyo → Consolidated Google Sheets Tracker → Weekly & Monthly Dashboards → Marketing Performance Review

## 5. Dashboard Highlights

### Weekly Dashboard

The weekly dashboard displays traffic sources alongside Klaviyo email and SMS performance. Teams can review weekly changes in website acquisition, sales, and subscriber growth.

### Monthly Dashboard

The monthly dashboard provides a broader reporting view for reviewing performance trends over a longer period.

Image: Weekly dashboard tracking Google Analytics traffic by source alongside Klaviyo email and SMS sales and subscriber counts. (https://mburhan.com/case-content/ecommerce-pnl-tracker/image5.png)

## 6. Business Value

- **Centralized reporting:** Acquisition and retention metrics are available in one spreadsheet.
- **Cross-channel visibility:** Website traffic can be reviewed alongside email and SMS results.
- **Historical comparison:** Weekly and monthly views support trend analysis.
- **Simplified reporting:** Teams can review key marketing metrics without manually assembling separate platform reports.

## 7. Final Outcome

The Weekly Marketing Performance Tracker provides a single reporting view for Google Analytics traffic and Klaviyo email and SMS performance. By organizing these metrics into weekly and monthly dashboards, it makes cross-channel performance easier to review and compare.

**Technology Stack:** Google Sheets, Google Analytics, Klaviyo
