# 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
