E-commerce Dashboard Overview

The E-commerce Dashboard in Picky Assist is a centralized view of your entire WhatsApp commerce performance. It helps businesses track orders, revenue, customers, payments, products, and inventory in real time, all from one place. Instead of checking multiple sections separately, this dashboard gives a clear and structured summary of how your business is performing on WhatsApp. By regularly reviewing these metrics, businesses can identify trends, understand customer behavior, and take informed actions to improve sales and operational efficiency.

KEY METRICS AND INSIGHTS IN THE E-COMMERCE DASHBOARD

E-commerce Performance Overview

Total Orders – This shows the total number of orders placed by customers for your business through WhatsApp.

Total Order Value – This represents the total value of all orders placed. For example, if 5 products worth ₹500 each are ordered, the total order value will be shown as ₹2,500. Total Payment Received – This is the total amount of money received by you. Not all orders placed will convert into payments; only a certain percentage of those orders will be converted into completed payments. Customers – This indicates the total number of customers who have placed at least one order through WhatsApp. Recurring Customers – This shows the total number of customers who have made repeat purchases through WhatsApp.

Here, you can also view a graph showing the daily placed orders/Amount. Additionally, there is an option to switch the view between day, week, month, and year to analyze order trends accordingly.

At the top, there is an option to change the catalog if you are using multiple catalogs. You can also modify the date range and customize the view to analyze data based on your preferred time period.

Customer Engagement, Order Value & Retention Metrics

Average Order Value – This shows the average value of orders placed by customers through WhatsApp. It is calculated by dividing the total order value by the total number of orders.

Abandoned Carts – This represents the percentage of carts that were not converted into purchases. Not all orders placed by customers result in successful payments; the orders that are not completed are counted as abandoned carts. Completed Payments – This shows the percentage of orders for which the payment has been successfully completed out of the total number of orders placed. Customer Lifetime Value (CLV) – Customer Lifetime Value indicates the total value a customer brings to the business over time. It is calculated by dividing the total order value by the total number of customers.

All data shown in the dashboard is based on the selected catalog and selected date range. Always make sure these filters are set correctly before analyzing the metrics or making business decisions.

Orders by Shops (Catalog) – Here, “shops” represent catalogs. If you are using multiple catalogs, you can switch between them to view and analyze the order statistics for each catalog individually

Customers vs Recurring Customers – This graph shows the comparison between new customers and returning customers over a selected period. The data can be viewed on a daily, weekly, monthly, or yearly basis for better trend analysis.

Payment Methods & Transaction Status Overview

Payment Mode Distribution – This shows how payments are made by customers, such as via card, UPI, or net banking. You can view both the total amount paid through each payment mode as well as the number of customers who used a particular mode.

Payment Status – This displays the current status of payments, showing how many customers fall under completed, failed, or pending payments. You can also switch the view to see either the number of customers or the total amount associated with each payment status.

Peak Sales Hours & Time-Based Performance

Sales by Time of Day – The Sales by Time of Day graph shows how many sales occur at different hours on specific days such as Monday, Tuesday, and so on. You can customize the date range and switch between viewing order count or order value. The intensity of the green color highlights peak sales hours—darker shades indicate higher sales—making it easy to identify the best-performing time slots for your business.

Top-Selling Products & Inventory Health

Total Products – This shows the total number of products that have been added to or synced with the catalog.

Return Rate – This indicates the number or percentage of products returned by customers after the order has been delivered. Returns made after successful delivery are counted under the return rate.

The Top Selling Products section shows which products are purchased most frequently by customers and the total order count for each product. Use this insight to understand customer preferences and plan your inventory, pricing, and promotional strategies more effectively.

Failed Orders Count – This represents the total number of orders that were failed or cancelled by customers.

Order Fulfillment – This shows the percentage of orders that have been successfully fulfilled and completed.

Stock Availability – The Stock Availability section shows how many products are currently in stock and available for sale, along with the number of products that are out of stock. This helps you quickly understand inventory status and take timely action to restock or manage product availability.

Order Distribution Analysis

Orders by Brand – This section displays how sales are distributed across different product brands. Since each product can be mapped to a brand, this view helps identify top-performing brands and compare others based on order count or order value, enabling better brand-wise sales planning and strategy.

Orders by Status – This provides a clear breakdown of orders across various order lifecycle stages such as Placed, Shipped, Delivered, Cancelled, and Abandoned. It helps quickly assess successful order completion, track pending or failed orders, and monitor overall operational efficiency.

Orders by Category – The Orders by Category view shows the total orders completed under each product category. As products are assigned to categories during setup, this section helps identify high-performing categories by order volume or order value, making category-level performance comparison simple and actionable.

Insights in Orders by Brand, Status, and Category are generated based on the selected catalog and date range. Always verify these filters before analysis to ensure accurate comparisons, correct performance evaluation, and informed business decisions.

The E-commerce Dashboard acts as a powerful decision-making tool, not just a reporting screen. By analyzing orders, customer behavior, payment status, and product performance, businesses can quickly identify gaps, optimize sales strategies, and plan for future growth. Regular monitoring helps maintain better control over inventory and customer engagement. Always ensure the correct catalog and date range are selected to derive accurate and meaningful insights.