
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.
- Google Sheets
- Google Analytics
- Klaviyo
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.

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