Customers- Tables and columns

Need help with something?

Talk to data expert

This document provides details on the dashboard's sub-categories, tables, and columns for all metrics used in the dashboards under the customer tab on Pulse.

For information on the formulas and definitions, click here

Dimensions

Attributes or fields that categorize data for sorting, grouping, and labelling, such as dates, locations, and channel.

Dimensions Dashboard Sub-Category Table Column
Acquisition Month  Customer Overview customer_cohortwise_pivot_cumul Acquisition_month
Brand Customer Overview customer_glance_pbi, customer_glance_customer_metrics, customer_glance_cltv_cumul, customer_rfm_segment_cumul, customer_cohortwise_pivot_cumul brand_name
Country Customer Overview customer_glance_pbi, customer_glance_customer_metrics, customer_glance_cltv_cumul, customer_rfm_segment_cumul, customer_cohortwise_pivot_cumul store_name
Customer (Customer ID) Customer Overview customer_rfm_segment_cumul customer_id
Date Customer Overview customer_glance_pbi, customer_glance_customer_metrics, customer_glance_cltv_cumul, customer_rfm_segment_cumul, customer_cohortwise_pivot_cumul date
First Order Date Customer Overview customer_rfm_segment_cumul first_order_date
Last Order Date Customer Overview customer_rfm_segment_cumul last_order_date
Most Ordered Product Customer Overview customer_rfm_segment_cumul most_ordered_product
Sales Channel Customer Overview customer_glance_pbi, customer_glance_customer_metrics, customer_glance_cltv_cumul, customer_rfm_segment_cumul, customer_cohortwise_pivot_cumul platform_name
Segment Customer Overview customer_rfm_segment_cumul segment

Measures

Measure are quantitative metrics or values that can be aggregated and analyzed, such as sales, profit, and traffic.

Measures Dashboard Sub-Category Table Column
Customers Customer Overview customer_glance_customer_metrics_pbi email
Customers Count Customer Overview customer_rfm_segment_cumul customer id
Discounts Customer Overview customer_rfm_segment_cumul discount
Orders  Customer Overview customer_glance_customer_metrics_pbi order2
Returning Customers Customer Overview customer_glance_customer_metrics_pbi email, new_or_existing
Returns Customer Overview customer_rfm_segment_cumul returned_quantity
Returns Customer Overview customer_rfm_segment_cumul returned_quantity
Reviews Customer Overview customer_rfm_segment_cumul reviews
Sales (or Revenue) Customer Overview customer_glance_customer_metrics_pbi, customer_rfm_segment_cumul revenue

Derived Measures 

Calculated fields created from existing dimensions or measures using mathematical or logical operations to provide additional insights.

Derived Measure Dashboard Sub-Category Table Column
AOV (Average order value) Customer Overview customer_rfm_segment_cumul monetary, frequency
Browser Sessions Customer Overview customer_glance_pbi browser_sessions
CAC (Customer Acquisition Cost) Customer Overview customer_glance_customer_metrics_pbi clicks, adspend
Churned Customers Customer Overview customer_glance_cltv_cumul churned_flag
CLTV (Customer Lifetime Value) Customer Overview customer_cohortwise_pivot_cumul cltv
LTV - 12m Customer Overview customer_rfm_segment_cumul revenue12m
LTV - 30d, 60d,90d Customer Overview customer_rfm_segment_cumul revenue30
Mobile Sessions  Customer Overview customer_glance_pbi mobile_sessions
Months from Acquisition Customer Overview customer_cohortwise_pivot_cumul Month_number
OTP vs Subscriptions (One-Time Purchase vs Subscriptions) Customer Overview customer_glance_customer_metrics_pbi one_time, orders
Rebill% Customer Overview customer_cohortwise_pivot_cumul customer_cnt, cohort_customer_cnt
Tablet Sessions Customer Overview customer_glance_pbi tablet_sessions
UPT (Units Per Transaction) Customer Overview customer_glance_customer_metrics_pbi units, orders