# 客戶集中度

## 計算欄

• `Sales_flat_order/customer_entity` 表格

• （輸入） `reference`

• Column type: – `Same table > Calculation`

• Inputs: – `entity_id`

• Calculation： - A為null然後為null的情況，否則1結束

• Datatype: – `Integer`

• `Customer concentration` 表格(這是您上傳的檔案，編號為 `1`)

• 客戶數量

• Column type: – `Many to One > Count Distinct`

• 路徑 — `sales_flat_order.(input) reference > Customer Concentration.Primary Key``customer_entity.(input)reference > Customer Concentration.Primary Key`

• 選取的欄 — `sales_flat_order.customer_email``customer_entity.entity_id`

• `customer_entity` 表格

• 客戶數量

• Column type: – `One to Many > JOINED_COLUMN`

• 路徑 — `customer_entity.(input) reference > Customer Concentration. Primary Key`

• 選取的欄 — `Number of customers`

• （輸入） `Ranking by customer lifetime revenue`

• Column type: – `Same table > Event Number`

• 事件所有者 — `Number of customers`

• 事件排名 — `Customer's lifetime revenue`

• 客戶的收入百分位數

• Column type: – `Same table > Calculation`

• Inputs: – `(input) Ranking by customer lifetime revenue`, `Number of customers`

• Calculation： - 當A為null然後為null時的情況，否則(A/B) 100個結尾​*

• Datatype: – `Decimal`

• `Sales_flat_order` 表格

• 客戶數量

• Column type: – `One to Many > JOINED_COLUMN`

• 路徑 — `sales_flat_order.(input) reference > Customer Concentration.Primary Key`

• 選取的欄 — `Number of customers`

• （輸入）依客戶期限收入排名

• Column type: – `Same table > Event Number`

• 事件所有者 — `Number of customers`

• 事件排名 — `Customer's lifetime revenue`

• 篩選 — `Customer's order number = 1`

• 客戶的收入百分位數

• Column type: – `Same table > Calculation`

• Inputs: – `(input) Ranking by customer lifetime revenue`, `Number of customers`

• Calculation： - 當A為null然後為null時的情況，否則(A/B) 100個結尾​*

• Datatype: - `Decimal`

NOTE

## 量度

• 客戶期限值總計
• `customer_entity` 表格
• 此量度會執行 Sum
• `Customer's lifetime revenue`
• 排序依據： `Customer's first order date` timestamp

## 報表

• 客戶集中度

• Metric: `Total customer lifetime value`

• Filter: `Customer's revenue percentile IS NOT NULL`

• Metric: `Total customer lifetime value`

• Filter: `Customer's revenue percentile IS NOT NULL`

• 群組依據: `Independent`

• 量度 `A``Total customer lifetime revenue by percentile`

• 量度 `B``Total customer lifetime revenue (ungrouped)`

• Time period: `All time`

• Interval: `None`

• Group by: `Customer's revenue percentile`

• 顯示頂端/底端： `100% of Customer's revenue percentile Name`

• Chart type: `Line`

• 前10%集中

• Filter: `Customer's revenue percentile <= 10`

• 量度 `A``Total customer lifetime revenue`

• Time period: `All time`

• Interval: `None`

• 隱藏圖表

• 群組依據: `Email`

• Chart type: `Table`

• 僅需一次購買即可達到最低50%的集中度

• 量度 `A``Total customer lifetime revenue`

• `Customer's revenue percentile <= 50`

• `Customer's lifetime number of orders = 1`

• Filter:

• Time period: `All time`

• Interval: `None`

• 隱藏圖表

• 群組依據: `Email`

• Chart type: `Table`

• 底部10%濃度

• Filter: `Customer's revenue percentile > 90`

• 量度 `A``Total customer lifetime revenue`

• Time period: `All time`

• Interval: `None`

• 隱藏圖表

• 群組依據: `Email`

• Chart type: `Table`

recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc