Google Analytics 360 - Transaction and Revenue Dashboard

High Level Design

Overview

Google Analytics 360 is Google’s flagship for digital reporting and analytics. It has reporting and tracking abilities and it includes features, such as multi-channel funnel reports, enhanced ecommerce, and attribution modeling

One of the greatest premium features of GA 360 is unsampled data.

With the BigQuery integration feature, all your raw data can be automatically imported into Google BigQuery where you can then query it to your heart's delight.

Among the areas that GA 360 covers are Traffic, Content, E-Commerce, Revenues, Sources, Geo, Google Ads and more.

(Attribution modeling uses machine learning to assign weights to each touchpoint of a user’s journey. It spans different devices and channels, combining data from Google Analytics, AdWords, and Doubleclick to comprehensively determine Digital Attribution.)

Goals

Improve ROI from data analytics, by improving conversion rates, optimize ecommerce accessibility for visitors, focus on core countries and recognize developing markets.

Objectives

  • Monitoring total revenue and transactions on the eshop
  • Calculating conversion rates between transaction’s phases
  • Understanding clients trends and sources
  • Discovering the clients’ geo distribution

KPIs Architecture

Objectives

KPIs

Measures

Data Source

 Monitoring total revenue and transactions on the eshop

Month To Date Revenue

(Indicator)

MTD Revenue

Change from last month

([Total hits.transaction.transactionRevenue] )/1000000

GrowthPastMONTH(([Total hits.transaction.transactionRevenue] )/1000000)

ga_sessions

Month To Date Transactions

(Indicator)

MTD # Transactions

Change from last month

[# of hits.transaction.transactionRevenue]

 

GrowthPastMONTH([# of hits.transaction.transactionRevenue])

Daily Heat Map Revenue

(Calendar Heatmap)

 

Date

Color

 

 

 

Days in VisitDateAdjusted

sum([Totals.total Transaction Revenue])/1000000

Calculating conversion rates between  transaction’s phases

Conversion Funnel

(bar chart)

All below values stacked in 1 category to simulate a funnel effect

Visitor Could not be measured

(Indicator)

 

Could not be measured

 

 

% from Total Visits

 

 

 

( sum([Totals.visits]), [ActionTypeforFunnel1]=Could not be measured)

 

[Could not be measured] / [Totals.visits]

Click through of product lists

(Indicator)

 

Click through of product lists

 

 

% from Total Visits

 

 

 

( sum([Totals.visits]), [ActionTypeforFunnel1]=Click through of product lists)

 

[Click through of product lists] / [Totals.visits]

Product Detail Views

(Indicator)

 

Product Detail Views

 

 

% from Total Visits

 

 

 

( sum([Totals.visits]), [ActionTypeforFunnel1]=Product Detail Views)

 

[Product Detail Views] / [Totals.visits]

Add product(s) to cart

(Indicator)

 

Add product(s) to cart

 

 

% from Total Visits

 

 

 

( sum([Totals.visits]), [ActionTypeforFunnel1]=Add product(s) to cart)

 

[Add product(s) to cart] / [Totals.visits]

Check Out

(Indicator)

 

Check Out

 

 

% from Total Visits

 

 

 

( sum([Totals.visits]), [ActionTypeforFunnel1]=Check Out)

 

[Check Out] / [Totals.visits]

Completed Purchase

(Indicator)

 

Completed Purchase

 

 

% from Total Visits

 

 

 

( sum([Totals.visits]), [ActionTypeforFunnel1]=Completed Purchase)

 

[Completed Purchase] / [Totals.visits]

Understanding clients trends and sources

 

 

Monthly Trend of Revenue by Medium

(Column  Chart)

 

Categories

Values

Break by

 

 

 

 

Months in VisitDateAdjusted

sum([Totals.total Transaction Revenue])/1000000

Medium

Monthly Trend of Revenue by Source (top 5)

(Column  Chart)

 

Categories

Values

Break by

 

 

 

 

Months in VisitDateAdjusted

sum([Totals.total Transaction Revenue])/1000000

Source

Hourly Trend of Revenue and Hits

(Line  Chart)

 

Categories:

Revenue

# Of Hits

 

 

 

Hours

sum([Totals.total Transaction Revenue])/1000000

dupcount([Hits.hour])

Total Revenue by City

(Scatter Map)

 

Location

Size

 

 

 

sum([Totals.total Transaction Revenue])/1000000

City

 

Plugins

  1. customBarColumnChart
  2. distributeWidgetsEqually
  3. styleWidgetTitle

Scripts

  1. Disable Mouse Scroll Zoom On Scatter Map
  2. Center / Zoom Scatter Map

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation