Overview

This project demonstrates the ability to connect a live data source to a reporting dashboard, select meaningful metrics, and present data in a clear, executive-friendly format. The dashboard tracks pre-launch traction for PromptPal, a simple demo/landing page that helps users draft emails and LinkedIn posts. Visitors can try a live demo and sign up for early access.

Tool

Looker Studio connected to Google Analytics 4 (GA4)

Data Source

Real GA4 data collected from the PromptPal website between January 1 and January 25, 2026 - a 25-day pre-launch window. Traffic was generated organically through friends, family, and direct outreach. All data is real, not simulated.

Scenario

PromptPal is a pre-launch SaaS tool. Leadership wants to understand early traction before investing in paid acquisition. The dashboard answers three core questions:

• Who is visiting the site?
• What are they doing once they arrive?
• How many are converting to the waitlist?

Dashboard Widgets

The dashboard includes the following components:

Scorecards (top row)

• Total Users: 38
• Total Sessions: 68
• Demo Clicks: 41
• Early Access Signups: 28

Charts and Tables

• Users Over Time (line chart): Shows daily user activity across the 25-day window with a visible spike when outreach began