Skip to main content

Data & reporting

Unified revenue intelligence dashboard

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

One operating dashboard that pulls seven live data sources into a single, trustworthy view of spend, pipeline, and revenue for a fast-moving marketplace.

Client
Remote-staffing marketplace
Engagement
Build and ongoing maintenance
Status
In internal use
Discipline
Revenue intelligence
Stack
  • Node.js
  • Express
  • Google Ads API
  • GA4
  • Stripe
  • Semrush
  • OAuth 2.0
Context

The marketplace was spending across paid search, SEO, and cold outreach while revenue ran through Stripe, but the numbers lived in seven separate tools that nobody reconciled. Leadership could not answer basic questions about cost, pipeline, and return without someone exporting spreadsheets and stitching them together, and by the time a report existed it was already stale. They needed one place that pulled every source together, refreshed itself, and could be trusted in a weekly review. We built that operating dashboard, and we maintain it.

Constraints
01

Seven platforms, each with its own login, data shape, and definition of a conversion, had to reconcile into one consistent view.

02

Several of the sources enforce strict usage limits, so the dashboard could not simply re-fetch everything on every load.

03

The people using it are operators, not analysts, so the interface had to be readable at a glance and exportable without training.

04

Authentication had to hold across Google's advertising and analytics access at once, without breaking when a token expired.

Work performed
01

Built a single dashboard that pulls live data from seven platforms: Google Ads, GA4, Search Console, Stripe, Google Tag Manager, Semrush, and cold-email delivery, each through its own authenticated connection.

02

Implemented a fifteen-minute cache across every integration, so the view stays fresh while respecting each platform's usage limits.

03

Modeled cross-source metrics the raw tools cannot show on their own, such as cost per engaged session and revenue against spend, so the numbers answer business questions directly.

04

Added CSV export on every table and a built-in procedure editor, so operators can pull a report or document a workflow without leaving the dashboard.

Outcomes

7Live data sources unified

Google Ads, GA4, Search Console, Stripe, Google Tag Manager, Semrush, and cold-email delivery all report into one surface, instead of seven disconnected logins.

1Operating dashboard

Spend, pipeline, revenue, and search performance now sit in a single view the team reviews together, rather than a stack of exported spreadsheets.

15 minData freshness, within limits

A fifteen-minute cache keeps the numbers current enough to drive weekly decisions while staying inside every platform's usage limits.