Customers- Data Dictionary
Customers- Data Dictionary
This document contains the formulas and definitions for all terms used in the customers overview dashboards on Pulse.
For details on the tables and columns used in the same dashboard, click here.
Dimensions
Attributes or fields that categorize data for sorting, grouping, and labelling, such as dates, locations, and channel.
| Dimensions | Formula | Definition |
|---|---|---|
| Acquisition Month | Acquisition month from sales | Acquisition month from sales |
| Brand | Filter by brand | Includes brand name from input given by the user when creating the integration. This filter enables users to analyze data specific to a particular brand. |
| Country | Filter by store | This filter helps users view data specific to a particular country where their products are sold. |
| Customer (Customer ID) | Customer id of customer | Includes list of customer id from sales |
| Date | Filter by date | Filter by a given date range. This allows users to analyze data within a specific timeframe. |
| First Order Date | First order date of customer | Includes first order date of customers from Sales |
| Last Order Date | Last order date of customer | Includes last order date of customers from Sales |
| Most Ordered Product | Most ordered product of customer | Includes most ordered product of customers from Sales |
| Sales Channel | Filter by platform | This filter allows users to view data based on the platform or channel through which sales are made, such as Amazon, Shopify, or others. |
| Segment | Customer segment | Customer segment as per their recency, frequency and revenue of sales |
Measures
Measure are quantitative metrics or values that can be aggregated and analyzed, such as sales, profit, and traffic.
| Measures | Formula | Definition |
|---|---|---|
| Customers | Count of distinct customers | Count of distinct customers |
| Customers Count | Sum of customer count | Total customers from Sales data |
| Discounts | Sum of discounts from Sales | Total discount from sales |
| Orders | Count of distinct orders | |
| Returning Customers | Count of distinct returning customers | Count of distinct returning customers |
| Returns | Sum of returned quantity from Sales | Total returned quantity from Sales |
| Reviews | Sum of reviews from sales | Total reviews from Sales |
| Sales (or Revenue) | Sum of revenue | Total revenue from Sales data |
Derived Measures
Calculated fields created from existing dimensions or measures using mathematical or logical operations to provide additional insights.
| Derived Measures | Formula | Definition |
|---|---|---|
| AOV (Average order Value) | Sum of revenue divided by sum of orders | Ratio of total revenue to total orders |
| Browser Sessions | Sum of browser sessions | Total browser sessions from traffic data |
| CAC (Customer Acquisition Cost) | Sum of ad spend divided by sum of clicks | Ratio of total ad spend to total clicks from Sponsored brands, Sponsored products, Sponsored display for Amazon and Google Ads, Facebook Ads and Bing Ads for Shopify platform |
| Churned Customers | Sum of churned customers | Total churned customers from Sales data |
| CLTV (Customer Lifetime Value) | Sum of life time value till selected date range | Total life time value till selected date range |
| LTV - 12m | Sum of total first 12 months revenue | Sum of total first 12 months revenue for each customer from sales data |
| LTV - 30d, 60d,90d | Sum of total first 30,60,90 days revenue | Sum of total first 30,60,90 days revenue for each customer from sales data |
| Mobile Sessions | Sum of mobile sessions | Total mobile sessions from traffic data |
| Months from Acquisition | Month from Acquisition | Month from Acquisition |
| OTP vs Subscriptions (One-Time Purchase vs Subscriptions) | Sum of one-time purchase orders divided by sum of total orders | Ratio of total one time purchase orders to total orders from sales |
| Rebill% | Count of customers with sales in a month from a cohort divided by count of customers in the cohort | Ratio of customer with sales in a month from a cohort to total customers in the same cohort |
| Tablet Sessions | Sum of tablet sessions | Total tablet sessions from traffic data |
| UPT (Units Per Transaction) | Sum of total units divided by sum of total orders | Ratio of total units to total orders from Sales |