Online Product Views

High Level Design

Overview

This use case pertains to an e-commerce website which allows its consumers to purchase items directly from an online store. With the data that is being gathered based on website interactions by online consumers, the brand managers can analyze their own data based on their products’ views and compare it to their competitors.

Goals

Enable brands managers to improve viewers’ interactions with their products to eventually increase revenue.

Objectives

  • Enable brands managers to analyze trends and get insights on consumers’ habits with regards to their products.
  • Allow each brand manager to compare their performances with their competitors on the online sales platform.

KPI Architecture

Objectives KPIs Measures Data Source
Enable brands managers to analyze trends and get insights on the consumer’s habits regarding their products # of Views # of views: Count(Views) Views
Latest Closed Month Views:  (Count(Views),Last month)

Conditional coloring:

Red – less than precious month

Green – more than precious month

Gauge Scale – 0 – 2Xprevious month views

MoM Growth:

((Count(Views),this month) – (Count(Views),last month))/ (Count(Views),last month)

Views Trend by Month:  Count(Views) per month
Day of Week Distribution: (Count(Views),day of week) / (Count(Views), entire week)
Views Hitmap:  Count(Views) per day
Allow each brand managers to compare his\her performances with their his\her competitors on the online store site Market Share Market Share: Count(View) / (Count(Views),all(Brands)) Views
Me Vs. Others:

My Views: # of views  per category

Others Views: (Count(Views),all(Brands))-Count(View) per category

Top 5 Brands: (Count(Views),all(Brands)) per brand
Market Share Trend:

My Views: # of views  per month

Others Views: (Count(Views),all(Brands))-Count(View) per month

 

# of Competitors # of Competitors: Count(Brand,all(Brand)) – 1 Views
Top Products 10 Top Products: # of views per Product->Brand->Category->SubCategory Views; Products

 Data Requirements

# Source Table Name Table Details (Type, #Rows, Key field/s)
2 MS SQL Views Fact Table, Key = View ID
3 Products Dimension Table, Key = Product ID

Data Modeling (Elasticube Design)

Suggested data model for online product views analysis

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