Skip to main content

Data & reporting

Unified revenue intelligence dashboard

In use

We built one dashboard that pulls every marketing, sales, and support number into a single place the team can actually trust to make decisions from.

One operating dashboard that brings nine live sources into a single view of spend, search, sign-ups, payments, and customer conversations for a fast-moving marketplace. It also makes guarded changes to Google Ads and tracks the goals the whole team shares.

Client
Remote-staffing marketplace
Engagement
Build and ongoing maintenance
Status
In use
Discipline
Revenue intelligence
What we built
  • Ads and search
  • Payments, refunds
  • Live chat insight
  • Team playbooks
  • Shared team goals
  • Google Ads controls
Stack
  • Node.js
  • Express
  • Postgres
  • Google Ads API
  • GA4
  • Stripe
  • Gemini

Before

The marketplace was spending across paid search, SEO, and cold email while revenue ran through Stripe and customer questions ran through live chat. Every number lived in a different tool, and nobody reconciled them. A simple question about cost per sign-up meant exporting spreadsheets and stitching them together, and by then the answer was stale. They needed one place that pulled every source together, refreshed on its own, and could be trusted in a team meeting. We built that dashboard, and we maintain it.

What made it hard

01

Nine sources, each with its own login, data shape, and idea of a conversion, had to read as one consistent view.

02

Several sources ration their API use, so each one refreshes on its own schedule, from ten minutes to an hour, instead of on every page load.

03

The people using it are operators, not analysts, so it had to read at a glance and export without training.

04

It holds customer conversations and live ad controls, so it needed real security: a content security policy, rate limits, request-forgery protection, and no secrets in the code.

What we built

01

Connected nine live sources: Google Ads, GA4, Search Console, Tag Manager, Semrush, Stripe, cold-email delivery, the marketplace's own admin data, and live chat.

02

Built 18 views, including cost per engaged session, revenue against ad spend, and a tag health check that finds paused, duplicate, or outdated tags.

03

Loaded every live chat conversation into a searchable database with AI tagging, plus an assistant that answers questions about what customers are asking.

04

Added a shared goals view (new paying employers, activation, monthly revenue trend, and cost to acquire a customer), saved every day.

05

Added guarded Google Ads controls (pause, budgets, negative keywords) with a change log and a daily drift check, CSV export on nearly every table, and a built-in procedure editor.

Results

9Live sources, one view

Ads, analytics, search, tags, payments, outreach, platform data, and live chat report into one dashboard instead of nine separate logins.

18Views the team works from

From ads and search to payments, chat, and shared goals, with CSV export on nearly every table.

DailyGoal snapshots

The team's shared measures are saved every day, so the trend is there without anyone building a report.

Where it stands

In use. Maintained since May 2026, with the latest update in October 2026.