Question 1

How is the platform worthiness score calculated?

Accepted Answer

The worthiness score is calculated using six weighted factors: ROI (30%), Profit Margin (20%), Delivery Rate (15%), Return Rate (10%), Orders Per Day (15%), and Daily Revenue Target Achievement (10%). Each factor is scored on a 0-100 scale and weighted accordingly to produce a final score from 0-100. Scores of 80+ indicate EXCELLENT performance, 65-79 GOOD, 50-64 FAIR, 35-49 POOR, and below 35 CRITICAL.

Question 2

What is the minimum daily revenue target and why ₱5,000?

Accepted Answer

The minimum daily revenue target is ₱5,000 per platform. This threshold represents the minimum viable daily revenue needed to cover operational costs including staff salaries (₱1,500/day), rent and utilities (₱1,000/day), marketing expenses (₱1,000/day), and miscellaneous costs (₱1,500/day). Platforms below this threshold receive a scaled score from 0-69%, while those meeting or exceeding the target receive scores from 70-100%.

Question 3

How is Net Profit calculated?

Accepted Answer

Net Profit = Revenue - (Platform Fees + COGS + Fulfillment Cost). Platform fees are calculated as Revenue minus Total Paid Amount. COGS (Cost of Goods Sold) is the total product cost. Fulfillment Cost is calculated as 10% of COGS, representing warehousing, packing, and handling expenses.

Question 4

What data sources power this dashboard?

Accepted Answer

All data is pulled via direct integration with the custom-built legacy sales tracking system developed in-house for Wholesale Dito Store. The system tracks orders from Lazada, Shopee, and TikTok platforms, including order status, payment confirmation, shipping logistics, return reasons, and product-level sales data. Orders with 'Cancelled' status are excluded from all calculations.

Question 5

How often is the data updated?

Accepted Answer

The dashboard refreshes automatically every 30 seconds with live data from the database. Users can also manually refresh by clicking the refresh button in the top-right corner. The last update timestamp is displayed next to the refresh button.

Question 6

What time periods can I analyze?

Accepted Answer

The dashboard supports five time period filters: Current Month, Previous Month, Last 3 Months, This Quarter, and Current Year. Each filter dynamically recalculates all metrics including revenue, profit, ROI, delivery rates, return rates, orders per day, and daily average revenue based on the selected period.

Question 7

How is the Orders Per Day metric calculated?

Accepted Answer

Orders Per Day = Total Orders / Number of Days in the selected period. The target benchmark is 10 orders per day, which aligns with operational efficiency for courier pickups and contributes 15% to the overall worthiness score. Platforms achieving 10+ orders per day receive a score of 100% for this metric, with linear scaling below that threshold.

Question 8

What payment methods are tracked and analyzed?

Accepted Answer

The dashboard tracks all payment methods used across platforms including COD (Cash on Delivery), Credit Card, Digital Wallets, Bank Transfers, and Installment payments. The Payment Method Analysis section shows order distribution, revenue contribution, and return rates for each payment method across all platforms combined.

Question 9

How is courier performance measured?

Accepted Answer

Courier performance is measured by delivery success rate (successful deliveries / total deliveries × 100) per platform. Each courier receives a rating from 0-5 stars based on their overall success rate. The bar chart visualizes delivery rates across different couriers for each platform, helping identify which logistics partners perform best on specific marketplaces.

Question 10

What return reasons are captured and how are they used?

Accepted Answer

The system captures return reasons including 'Defective Product', 'Wrong Item', 'Customer Changed Mind', 'Shipping Damage', and 'Other'. These are analyzed to identify product quality issues, logistics problems, or customer satisfaction trends. The top 5 return reasons are displayed in a doughnut chart with percentage distribution.

E-commerce Marketplace & Courier Worthiness Ratings & Analytics - LIVE DEMO

Courier Performance

Return Reasons

Wholesale Dito Store Top Performing Products on 3rd-Party Platforms