Skip to Content
ส่วนเสริมและเอกสารอ้างอิงKPI Tracking

KPI TRACKING TEMPLATE, TICK ALAIDERM

Excel Template สำหรับบันทึก KPI ประจำวัน/สัปดาห์/เดือน

วิธีใช้ Template นี้

  1. Copy ตัวอักษรและตัวเลขในส่วนท่อ Excel
  2. Paste ลงใน Excel Sheet ของคุณ
  3. กรอก ตัวเลข KPI ทุกวัน/สัปดาห์/เดือน
  4. Graph สูตรจะคำนวณอัตโนมัติ
  5. Compare ดูเทรนด์ (↑ / → / ↓)

DAILY KPI LOG (บันทึกประจำวัน)

┌────────────────────────────────────────────────────────────────────┐
│ DAILY KPI LOG, ติ๊ก อะไหล่เดิม                                     │
│ วันที่: ________________________                                    │
└────────────────────────────────────────────────────────────────────┘

DATE            | 2024-06-01 | 2024-06-02 | 2024-06-03 | 2024-06-04 | 2024-06-05
────────────────┼────────────┼────────────┼────────────┼────────────┼────────────
<Icon name="Coins" /> REVENUE      |            |            |            |            |
Target/day      |   10,000   |   10,000   |   10,000   |   10,000   |   10,000
Actual          |   12,500   |    8,900   |   15,200   |    9,500   |   11,800
Status          |     <Icon name="CheckCircle" />     |     <Icon name="AlertTriangle" />️     |     <Icon name="CheckCircle" />     |     <Icon name="AlertTriangle" />️     |     <Icon name="CheckCircle" />
% of Target     |   125%     |    89%     |   152%     |    95%     |   118%
────────────────┼────────────┼────────────┼────────────┼────────────┼────────────
<Icon name="Package" /> ORDERS       |            |            |            |            |
Target/day      |      3     |      3     |      3     |      3     |      3
Actual          |      4     |      2     |      5     |      2     |      3
Status          |     <Icon name="CheckCircle" />     |     <Icon name="AlertTriangle" />️     |     <Icon name="CheckCircle" />     |     <Icon name="AlertTriangle" />️     |     <Icon name="CheckCircle" />
────────────────┼────────────┼────────────┼────────────┼────────────┼────────────
<Icon name="Banknote" /> AVG ORDER    |            |            |            |            |
VALUE (AOV)     |            |            |            |            |
Target          |   3,333    |   4,450    |   3,040    |   4,750    |   3,933
Actual          |   3,125    |   4,450    |   3,040    |   4,750    |   3,933
Status          |     <Icon name="AlertTriangle" />️     |     <Icon name="CheckCircle" />     |     <Icon name="CheckCircle" />     |     <Icon name="CheckCircle" />     |     <Icon name="CheckCircle" />
────────────────┼────────────┼────────────┼────────────┼────────────┼────────────
<Icon name="ShoppingCart" /> ABANDONED    |            |            |            |            |
CART            |            |            |            |            |
Rate            |     42%    |     35%    |     38%    |     45%    |     40%
Target          |  &lt; 40%     |  &lt; 40%     |  &lt; 40%     |  &lt; 40%     |  &lt; 40%
Status          |     <Icon name="XCircle" />     |     <Icon name="CheckCircle" />     |     <Icon name="CheckCircle" />     |     <Icon name="XCircle" />     |     <Icon name="CheckCircle" />
────────────────┼────────────┼────────────┼────────────┼────────────┼────────────
⭐ RATING       |            |            |            |            |
Avg Rating      |     4.8    |     4.7    |     4.8    |     4.6    |     4.7
Reviews         |      2     |      1     |      3     |      1     |      2
Complaints      |      0     |      0     |      0     |      1     |      0
────────────────┼────────────┼────────────┼────────────┼────────────┼────────────
<Icon name="Pin" /> NOTES        |            |            |            |            |
                | Promotion  | Slow day   | Good day!  | Ads down   | Back to
                | worked!    |            |            |            | normal
                |            |            |            |            |

วิธีกรอก:

  • ทำเวลา 4 PM หรือ 5 PM ทุกวัน
  • Copy ตัวเลขจาก WooCommerce → Analytics
  • ใส่หมายเหตุในแถวสุดท้าย
  • Status:
    • = ดี (เกินเป้า)
    • ️ = ปกติ (เท่าหรือใกล้เป้า)
    • = แย่ (ต่ำกว่าเป้า)

WEEKLY KPI SUMMARY (สรุปสัปดาห์)

┌────────────────────────────────────────────────────────────────────┐
│ WEEKLY KPI SUMMARY                                                  │
│ สัปดาห์ที่: _____ (วันที่: __________ - __________)                │
└────────────────────────────────────────────────────────────────────┘

KPI METRIC          | THIS WEEK | LAST WEEK | CHANGE | TARGET  | STATUS
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
<Icon name="Coins" /> REVENUE          | 85,900 ฿  | 78,500 ฿  | +8.4%  | 120,000 | <Icon name="AlertTriangle" />️
<Icon name="Coins" /> Revenue/day avg  |  12,271 ฿ |  11,214 ฿ | +9.4%  |  17,143 | <Icon name="AlertTriangle" />️
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
<Icon name="Package" /> ORDERS           |     21    |     19    |  +2    |    25   | <Icon name="AlertTriangle" />️
<Icon name="Package" /> Orders/day avg   |    3.0    |    2.7    |  +0.3  |   3.6   | <Icon name="AlertTriangle" />️
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
<Icon name="Banknote" /> AOV              | 4,090 ฿   | 4,132 ฿   | -1.0%  | 5,000 ฿ | <Icon name="AlertTriangle" />️
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
% CONVERSION        |   2.3%    |   2.8%    | -17.9% |  2.5%   | <Icon name="XCircle" />
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
<Icon name="ShoppingCart" /> ABANDONED CART   |   43%     |   38%     |  +5%   |  &lt; 40%  | <Icon name="XCircle" />
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
<Icon name="Banknote" /> CAC              |  245 ฿    |  320 ฿    | -23.4% | &lt; 250 ฿ | <Icon name="CheckCircle" />
────────────────────┼───────────┼───────────┼────────┼─────────┼────────
⭐ AVG RATING       |   4.73    |   4.80    | -0.07  |  4.5    | <Icon name="CheckCircle" />
⭐ REVIEWS          |     9     |     8     |  +1    |   10    | <Icon name="AlertTriangle" />️
⭐ COMPLAINTS       |     1     |     0     |  +1    |    0    | <Icon name="AlertTriangle" />️
────────────────────┼───────────┼───────────┼────────┼─────────┼────────

<Icon name="Trophy" /> TOP 5 PRODUCTS THIS WEEK:
────────────────────┬─────────┬──────────┬──────────┬──────────
PRODUCT NAME        | UNITS   | REVENUE  | % OF ALL | TREND
────────────────────┼─────────┼──────────┼──────────┼──────────
1. ผ้าเบรก           |   12    | 10,680 ฿ |  12.4%   |   ↗️
2. ไฟหน้า LED        |    8    |  8,000 ฿ |   9.3%   |   ↗️
3. กันตก WAVE125i   |    7    |  5,110 ฿ |   5.9%   |   →
4. กระบอกสูบ        |    5    |  11,850 ฿|  13.8%   |   ↙️
5. ล้อแม็ก          |    4    |  10,160 ฿|  11.8%   |   ↗️
────────────────────┴─────────┴──────────┴──────────┴──────────

<Icon name="TrendingDown" /> BOTTOM 5 PRODUCTS THIS WEEK:
────────────────────┬─────────┬──────────┬──────────┬──────────
PRODUCT NAME        | UNITS   | REVENUE  | % OF ALL | ACTION
────────────────────┼─────────┼──────────┼──────────┼──────────
1. ชิวหน้า          |    0    |      0 ฿ |   0.0%   | <Icon name="XCircle" /> Discount?
2. ฝาสูบ            |    1    |   1,200 ฿|   1.4%   | <Icon name="AlertTriangle" />️ Promote
3. ขาตั้ง          |    1    |     410 ฿|   0.5%   | <Icon name="AlertTriangle" />️ Check stock
4. เบาะ OEM         |    2    |   4,000 ฿|   4.7%   | → OK
5. สวิตช์เปิด-ปิด  |    2    |     600 ฿|   0.7%   | <Icon name="AlertTriangle" />️ Bundle?
────────────────────┴─────────┴──────────┴──────────┴──────────

<Icon name="Target" /> ANALYSIS & ACTION:
────────────────────────────────────────────────────────────────
<Icon name="CheckCircle" /> WHAT WENT WELL:
  • CAC ลดลง 23% (Ad targeting ดีขึ้น)
  • Top 5 products ขายดี (especially ผ้าเบรก & ไฟ)
  • Rating ยังสูง 4.73 ⭐

<Icon name="AlertTriangle" />️ WHAT NEEDS IMPROVEMENT:
  • Revenue ต่ำกว่าเป้า 28% (ต้องเพิ่มสต็อก?)
  • Abandoned cart สูง 43% (Checkout ยังคงปัญหา)
  • Conversion ลดลง 17.9% (Traffic หาย?)
  • 1 complaint (ต้องตรวจสอบ)

<Icon name="Target" /> ACTION ITEMS FOR NEXT WEEK:
  <Icon name="Square" /> ลด Abandoned cart: เช็ค Checkout UX
  <Icon name="Square" /> เพิ่ม Traffic: Social ads + SEO
  <Icon name="Square" /> Bottom products: Discount 15% (ทดลอง)
  <Icon name="Square" /> Top products: Stock up
  <Icon name="Square" /> Respond complaint: Contact customer

MONTHLY KPI REPORT (รายงานเดือน)

┌────────────────────────────────────────────────────────────────────┐
│ MONTHLY KPI REPORT                                                  │
│ เดือน: _______________________ ปี _______                           │
└────────────────────────────────────────────────────────────────────┘

KPI METRIC          | MAY 2569  | JUNE 2569 | CHANGE  | TARGET   | TREND
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
<Icon name="Coins" /> REVENUE          |485,600 ฿  |521,400 ฿  | +7.4%   |500,000 ฿ | ↗️
<Icon name="Coins" /> Revenue/day avg  | 15,668 ฿  | 17,380 ฿  | +10.9%  | 16,667 ฿ | ↗️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
<Icon name="Package" /> ORDERS           |     92    |    102    |  +10    |   100    | ↗️
<Icon name="Package" /> Orders/day avg   |    2.97   |    3.40   | +14.5%  |   3.33   | ↗️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
<Icon name="Banknote" /> AOV              | 5,278 ฿   | 5,112 ฿   | -3.1%   | 5,000 ฿  | ↙️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
% CONVERSION        |   2.8%    |   2.9%    | +3.6%   |  2.5%    | ↗️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
<Icon name="ShoppingCart" /> ABANDONED CART   |   42%     |   40%     | -2%     |  &lt; 35%   | ↙️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
<Icon name="Banknote" /> CAC              | 240 ฿     | 235 ฿     | -2.1%   | &lt; 250 ฿  | ↙️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
⭐ AVG RATING       |   4.70    |   4.75    | +0.05   |  4.5     | ↗️
⭐ REVIEWS          |    85     |    98     |  +13    |   100    | ↗️
⭐ COMPLAINTS       |     3     |     2     |  -1     |   &lt; 5    | ↙️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────
<Icon name="BarChart" /> REPEAT CUSTOMERS |   22%     |   26%     | +18.2%  |   25%    | ↗️
────────────────────┼───────────┼───────────┼─────────┼──────────┼───────

<Icon name="Trophy" /> TOP 10 PRODUCTS (THIS MONTH):
────────────────────────┬──────────┬──────────┬──────────
PRODUCT                 | UNITS    | REVENUE  | % OF ALL
────────────────────────┼──────────┼──────────┼──────────
1. ผ้าเบรก              |   58     | 51,620 ฿ |   9.9%
2. ไฟหน้า LED           |   45     | 45,000 ฿ |   8.6%
3. กระบอกสูบ            |   32     | 75,840 ฿ |  14.5%
4. กันตก WAVE125i      |   28     | 20,440 ฿ |   3.9%
5. ล้อแม็ก             |   24     | 60,960 ฿ |  11.7%
6. เบาะ OEM             |   18     | 36,000 ฿ |   6.9%
7. ชุดกุญแจ             |   15     | 13,500 ฿ |   2.6%
8. ขาตั้ง              |   14     | 5,740 ฿  |   1.1%
9. สวิตช์เปิด-ปิด      |   12     | 3,600 ฿  |   0.7%
10. ฝาสูบ              |    8     | 9,600 ฿  |   1.8%
────────────────────────┴──────────┴──────────┴──────────
Others (40+ SKU)        |  154     | 198,600 ฿|  38.1%

<Icon name="BarChart" /> PRODUCT CATEGORY BREAKDOWN:
────────────────────────┬──────────┬──────────┬──────────
CATEGORY                | UNITS    | REVENUE  | % OF ALL
────────────────────────┼──────────┼──────────┼──────────
Engine (เครื่องยนต์)     |   89     | 165,200 ฿|  31.7%
Brakes (ระบบเบรก)       |   104    | 102,480 ฿|  19.6%
Electrical (ระบบไฟ)     |   78     | 112,680 ฿|  21.6%
Suspension (ช่วงล่าง)   |   65     | 104,000 ฿|  19.9%
Frame & Bodywork (โครงรถ)|   48    | 37,040 ฿ |   7.1%
────────────────────────┴──────────┴──────────┴──────────

<Icon name="Coins" /> PROFIT ANALYSIS:
────────────────────────────────────────────────────────────────
Total Revenue           | 521,400 ฿
Less: COGS (Cost)       | 312,840 ฿ (60% avg)
Gross Profit            | 208,560 ฿
Less: Discount/Promo    |  15,400 ฿
Less: Shipping cost     |  20,200 ฿
Less: Operating cost    |  25,000 ฿
────────────────────────┴──────────────────────────────────────
NET PROFIT              | 147,960 ฿
Profit Margin           |   28.4%
────────────────────────┴──────────────────────────────────────

<Icon name="Megaphone" /> MARKETING CAMPAIGN PERFORMANCE:
────────────────────────┬──────────┬──────────┬──────────┬─────────
CAMPAIGN                | BUDGET   | RESULT   | REACH    | ROI
────────────────────────┼──────────┼──────────┼──────────┼─────────
Summer Sale (Coupon)    |  5,000 ฿ | 145,000 ฿| 2,500    | 2,800%
Facebook Ads            |  8,000 ฿ | 189,000 ฿| 3,200    | 2,263%
Email Newsletter        |    500 ฿ |  67,400 ฿| 1,200    | 13,380%
Influencer (1 post)     |  3,000 ฿ |  45,000 ฿|   800    | 1,400%
────────────────────────┴──────────┴──────────┴──────────┴─────────

<Icon name="Target" /> ANALYSIS:
────────────────────────────────────────────────────────────────
<Icon name="CheckCircle" /> HIGHLIGHTS:
  • Revenue ↗️ 7.4% YoY (exceed target!)
  • Orders ↗️ 10 units more (102 vs 92)
  • AOV slightly down but Orders up = good strategy
  • Repeat customers ↗️ 26% (loyalty program working)
  • Email marketing: BEST ROI (13,380%)
  • Rating ↗️ 4.75 ⭐ (customer satisfied)

<Icon name="AlertTriangle" />️ CHALLENGES:
  • AOV ↙️ 3.1% (need to bundle more)
  • Abandoned cart still 40% (target &lt;35%)
  • Bottom 10 SKU very slow (need action)

<Icon name="Target" /> RECOMMENDATIONS FOR NEXT MONTH:
────────────────────────────────────────────────────────────────
<Icon name="Square" /> REVENUE: +15% → increase Facebook ads + Email campaign
<Icon name="Square" /> AOV: +10% → create bundle offers (e.g., Brake pads + fluid)
<Icon name="Square" /> CONVERSION: Improve checkout UX (reduce cart abandonment)
<Icon name="Square" /> PRODUCTS: 
   <Icon name="CheckCircle" /> Keep: Brake pads, Light, Engine parts (top 3)
   <Icon name="AlertTriangle" />️ Promote: Bottom 10 → discount 20%, bundle, highlight
   <Icon name="XCircle" /> Consider: Discontinue very slow items (\&lt;1% revenue)
<Icon name="Square" /> CUSTOMER: Continue email + referral program
<Icon name="Square" /> INVENTORY: Restock top 5 → ensure never out of stock

QUICK ENTRY FORM (ป้อนข้อมูลเร็ว)

DATE: _____________

REVENUE TODAY:
  Target: 10,000 ฿    Actual: ____________ ฿
  Status: <Icon name="CheckCircle" /> <Icon name="AlertTriangle" />️ <Icon name="XCircle" />

ORDERS TODAY:
  Target: 3           Actual: ____________
  Status: <Icon name="CheckCircle" /> <Icon name="AlertTriangle" />️ <Icon name="XCircle" />

ABANDONED CART:
  Rate: ____________ % (Target: &lt; 40%)
  Status: <Icon name="CheckCircle" /> <Icon name="AlertTriangle" />️ <Icon name="XCircle" />

REVIEWS/RATING:
  New reviews: ____________
  Avg rating: ____________ ⭐
  Complaints: ____________

NOTES:
  _________________________________________________________________
  _________________________________________________________________

ACTION NEEDED:
  <Icon name="Square" /> Restock: _____________________
  <Icon name="Square" /> Reply to: _____________________
  <Icon name="Square" /> Fix: _____________________
  <Icon name="Square" /> Promote: _____________________

Logged by: _________________ Time: _________

CALCULATION FORMULAS (สูตรใน Excel)

สูตรที่ใช้ใน Excel:

1. AOV (Average Order Value):
   = Total Revenue ÷ Total Orders
   = SUM(Revenue) / COUNT(Orders)

2. Conversion Rate (%):
   = (Orders ÷ Visitors) × 100
   = (SUM(Orders) / Website_Visitors) * 100

3. Abandoned Cart Rate (%):
   = (Cart Started - Completed) ÷ Cart Started × 100
   = (A2 - B2) / A2 * 100

4. CAC (Customer Acquisition Cost):
   = Marketing Cost ÷ New Customers
   = SUM(Ad_Budget) / COUNT(New_Orders)

5. ROI (%):
   = (Revenue - Cost) ÷ Cost × 100
   = (Revenue - Cost) / Cost * 100

6. Profit Margin (%):
   = (Net Profit ÷ Revenue) × 100
   = Net_Profit / Revenue * 100

7. Repeat Customer Rate (%):
   = Repeat Orders ÷ Total Orders × 100
   = COUNT(Repeat) / COUNT(All) * 100

8. Week over Week Growth (%):
   = (This Week - Last Week) ÷ Last Week × 100
   = (C2 - B2) / B2 * 100

INTERPRETATION GUIDE

KPI                | <Icon name="CheckCircle" /> GOOD     | <Icon name="AlertTriangle" />️ OK       | <Icon name="XCircle" /> BAD
───────────────────┼─────────────┼─────────────┼──────────────
Revenue vs Target  | > 100%      | 80–100%     | &lt; 80%
Orders            | > Target    | = Target    | &lt; Target
AOV               | 4,500–6,000 | 3,500–4,500 | &lt; 3,500
Conversion        | > 3%        | 2–3%        | &lt; 2%
Abandoned Cart    | &lt; 35%       | 35–45%      | > 45%
CAC               | &lt; 200 ฿     | 200–250 ฿   | > 250 ฿
Rating            | 4.5+ ⭐     | 4.0–4.5 ⭐  | &lt; 4.0 ⭐
Complaints        | 0–2         | 2–5         | > 5
Repeat Customer   | > 25%       | 20–25%      | &lt; 20%
Profit Margin     | > 25%       | 20–25%      | &lt; 20%

NOTES & REMINDERS

<Icon name="CheckCircle" /> บันทึกทุกวัน (เมื่อ 4–5 PM)
<Icon name="CheckCircle" /> ดูแนวโน้ม (↑ up, → level, ↓ down)
<Icon name="CheckCircle" /> เปรียบเทียบกับ target และ last week
<Icon name="CheckCircle" /> ทำ action ถ้าต่ำกว่าเป้า
<Icon name="CheckCircle" /> ฉลองถ้าเกินเป้า! <Icon name="PartyPopper" />

<Icon name="XCircle" /> อย่าลืมบันทึก (จะเสียหายข้อมูล)
<Icon name="XCircle" /> อย่าเปลี่ยน formula (ระบบจะหลวม)
<Icon name="XCircle" /> อย่า hard-code ตัวเลข (ต้องนำมาจาก Analytics)
<Icon name="XCircle" /> อย่าให้ใครแก้ไขสุ่ม (เก็บไว้แค่เจ้าของ)

วิธีสร้าง Chart ใน Excel

เลือกข้อมูล → Insert → Chart

RECOMMENDED CHARTS:
──────────────────────────────────────────────────────
ประเภท              | ใช้สำหรับ              | วิธี
──────────────────────────────────────────────────────
Line Chart          | Revenue trend (วันต่อวัน)
                    | ดูแนวโน้ม/Seasonality

Bar Chart           | Revenue vs Target
                    | เปรียบเทียบ KPI

Pie Chart           | Top 10 products (%)
                    | Category breakdown

Area Chart          | Revenue cumulative
                    | ดูยอดสะสมตลอดเดือน

Combo Chart         | Revenue + Orders + AOV
                    | ดูหลาย metrics พร้อม
──────────────────────────────────────────────────────

Version: 1.0
Created: June 2569
For: TICK ALAIDERM Team
Usage: Daily / Weekly / Monthly tracking

Template นี้สามารถ Copy ไปใช้ใน Excel, Google Sheets, หรือ Numbers ได้
ปรับแต่งตัวเลข Target ตามของคุณ

Last updated on
Process FlowchartSEO Optimized