Revenue & GTM

Revenue Alerting System

Replaced manual revenue checks, saved 50+ hours/week, and flagged changes before meetings.

My role

Sole Developer

Collaboration

I built it with the strategy and operations teams that used it every day.

Google Apps ScriptSlack WebhooksBigQueryOpenAI API

Problem

Revenue visibility was delayed and fragmented. Deal changes were discovered too late to act. Operations spent hours assembling reports instead of responding to issues.

Solution

A Slack workflow combined revenue metrics, compared day-over-day changes, flagged anomalies, and sent context to the right channel.

Outcome

Measured
50+ hrs/week
Time Saved

Saved 50+ hours/week across strategy and operations. Revenue anomalies now surface instantly instead of after 24+ hours, preventing bad decisions.

How it works

📊

Pull

Fetches daily revenue data from Sheets and BigQuery

⚙️

Compute

Calculates day-over-day and week-over-week deltas by vertical

🔍

Flag

Identifies movers, missing data, and deal state changes

🤖

Explain

Adds context about why the numbers moved

💬

Alert

Posts structured updates to the right Slack channels