Analytics & Reports

Overview

The Analytics feature gives vendors a data-driven view of their store’s performance. The dashboard displays key performance indicators (KPIs) like total revenue, order count, average order value, and conversion rates. Vendors can drill down into product-level analytics, order trends, and category performance. Data can be visualized in charts, filtered by date range, and exported to Excel for offline analysis.

How It Works

Dashboard KPIs

The main dashboard calculates and displays:

Metric	Description
Total Revenue	Sum of all paid order amounts in the selected period
Total Orders	Count of orders placed
Average Order Value	Revenue divided by order count
Conversion Rate	Orders divided by store visits
Top Products	Products ranked by revenue or units sold
Returning Customers	Percentage of repeat buyers

Analytics Types

Performance Statistics — Overall store health metrics with trend comparison
Product Analytics — Per-product revenue, units sold, and conversion data
Order Statistics — Order volume trends, fulfillment times, and status distribution
Category Statistics — Revenue and order breakdown by product category
Leaderboards — Top-performing products, categories, and customers
Chart Data — Time-series data for line/bar charts (daily, weekly, monthly)

Key API Endpoints

Dashboard Statistics

POST/api/dashboardstatsAuth Required

Get main dashboard KPIs (revenue, orders, AOV, conversion rate) for a date range

POST/api/performaceStatisticsAuth Required

Get performance comparison metrics (current vs. previous period)

POST/api/chartsStatsAnalyticsAuth Required

Get time-series chart data for the analytics dashboard

POST/api/getLeaderBoardsAuth Required

Get top products, categories, and customers leaderboard

Product Analytics

POST/api/products-chart-dataAuth Required

Get product-level chart data (revenue over time, units sold)

POST/api/selectedTabChartAuth Required

Get chart data for a selected analytics tab (revenue, orders, sessions)

POST/api/products/analyticsAuth Required

Get detailed product analytics table with sorting and pagination

POST/api/products/analytics/exceldownloadAuth Required

Export product analytics data to Excel file

Order Statistics

POST/api/orders-chart-statsAuth Required

Get order volume chart data over time

POST/api/orderselectedTabChartAuth Required

Get chart data for a specific order metric tab

POST/api/orders/analyticsAuth Required

Get detailed order analytics with filters

POST/api/orders/analytics/exceldownloadAuth Required

Export order analytics data to Excel file

Category Statistics

GET/api/category/searchAuth Required

Search categories with analytics data

POST/api/category-chart-dataAuth Required

Get category performance chart data

POST/api/selectedCategoryTabChartAuth Required

Get chart data for a selected category metric

Database Tables

Table	Purpose
`orders`	Source data for revenue, order count, and fulfillment analytics
`products`	Product metadata joined with order data for product analytics
`categories`	Category hierarchy used for category breakdown
`customers`	Customer data for returning customer and LTV metrics
`hourly_marketing_reports`	Marketing channel performance data (sessions, conversions)

Orders — Order data is the primary source for analytics
Products — Product performance metrics
Marketing — Marketing channel attribution data
Customers — Customer behavior and retention metrics