America MarketingContact

Liquid Web

Software parent company with a host of WordPress plugins and services.

Visit Liquid Web ↗

5

API data aggregations

1

daily Lambda function

4

brand-specific databases

1

unified dashboard

Project Overview

Created a data analytics dashboard with key performance indicators that updates daily and unifies data between all marketing and revenue channels.

Unified Dashboard

For each of their 5 brands, I created a dashboard with a different slide for each marketing channel and revenue channel. It was back-filled with over 5 years of data and customized to include different filters and data types for each channel.

Liquid Web analytics dashboard showing KPIs and product performance
Example data for display only

Data Flow

Marketing and revenue platform integrations

Data is pulled daily from platforms like Facebook, Google Ads, Google Analytics, ActiveCampaign, and WooCommerce via AWS Lambda in Node.js.

Google BigQuery data warehouse

All sources are consolidated into Google BigQuery, creating a single source of truth for reporting across brands and channels.

Data pipeline flow into dashboards

Processed data flows into Looker Studio dashboards, refreshed automatically so stakeholders always see current performance.

Want results like this for your business?

Start a Conversation