📊

Customer Analytics Report

อัปโหลดไฟล์ Excel หรือโหลดข้อมูลจาก API เพื่อสร้างรายงาน 4 หน้าอัตโนมัติ

ลากไฟล์มาวางที่นี่

หรือคลิกเพื่อเลือกไฟล์ .xlsx / .xls

เลือกไฟล์ Excel

ข้อมูลประมวลผลในเบราว์เซอร์เท่านั้น ไม่มีการส่งข้อมูลออกภายนอก

📊

CUSTOMER PROFITABILITY OVERVIEW

Overview of customer performance and profitability

–

💡 Key Takeaway

Total Revenue

—

💰

Total Gross Profit

—

📈

Avg Margin %

—

💹

# of Customers

—

👥

Total Volume (TON)

—

🚚

Customer Profitability Map (Revenue MB vs Margin %)

Bubble Size =
Gross Profit (MB)

Quadrant

Revenue Contribution by Segment

Customer Distribution by Segment

Gross Profit (MB) by Segment

Top 10 Customers by Revenue

Customer	Revenue (MB)	Margin %

Top 5 High Cost-to-Serve Customers

Customer	Cost-to-Serve	CTS / Rev

Key Insights

🏷️

CUSTOMER SEGMENTATION

Segment customers based on Value and Profitability

–

💡 Key Takeaway

Customer Segmentation Matrix (Value vs Profitability)

High

Profitability (Margin %)

Low

Value (Revenue)

High

Segment Breakdown

Segment	# Customers	% of Revenue	Margin %

Recommended Actions

Segment Detail Overview

Key Insights

กำลังรอข้อมูล...

📈

CUSTOMER BEHAVIOR ANALYSIS

Analyze customer purchasing behavior and trends

–

💡 Key Takeaway

Total Revenue

—

💰

# of Orders

—

📋

Avg Order Size

—

📦

Order Frequency

—

🔄

Repeat Customer Rate

—

⭐

Revenue Trend by Customer (Top 6)

Order Frequency Trend (Orders / Month)

Behavior Segmentation (RFM)

Order Frequency vs Avg Order Size (Bubble = Revenue)

Customer Behavior Summary

	Type	Description	#	Rev%	Action

Top 5 Customers by Order Frequency (Orders / Month)

Distribution of Order Size (Ton / Order)

Order Size vs Cost-to-Serve (Bubble = Customers)

Key Insights

🚛

COST-TO-SERVE ANALYSIS

Understand the cost to serve each customer

–

💡 Key Takeaway

Total Transport Cost

—

🚚

Avg Cost-to-Serve

—

💱

High CTS Customers (>5%)

—

⚠️

Total Billing Lines

—

📋

Avg Order Size

—

📦

Top 10 Customers by Transport Cost (MB)

Transport Cost vs Revenue (Each bubble = a customer)

Low Cost (<2%) Medium (2–5%) High (>5%)

Cost Structure Breakdown (% of Total Transport Cost)

Cost Breakdown Detail

Cost Type	Amount (MB)	% Share

Top 10 Customers by Cost-to-Serve %

Customer	Revenue	Transport	CTS%

Key Insights

Recommended Actions

🔄

CUSTOMER SEGMENTATION & MIGRATION

Understand customer movement between segments to drive action

Period A

–

Period B

–

💡 Key TakeawayUpload data to see migration insights.

CURRENT SEGMENT OVERVIEW (Current Period)

Total Customers

—

👥

Total Revenue

—

💰

Total Margin

—

📊

Avg Margin %

—

💹

REVENUE & MARGIN BY SEGMENT (Comparison)

H1 H2

MIGRATION INSIGHTS (Transition Matrix)

Top Movements

SEGMENT DISTRIBUTION (Customer Count Comparison)

Upload data to view comparison

NET CHANGE

(A → B)

—

REVENUE BY SEGMENT (Revenue Comparison)

Upload data to view comparison

REVENUE CHANGE

(A → B)

—

Key Insights

เลือกช่วงเวลา Period A และ B เพื่อดู Key Insights