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.)
- The sample data set is of Google’s Ecommerce shop
- BigQuery Export schema
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 |
|