Analytics
The Analytics section gives you a live view of how your business is performing - across products, orders, customers, inventory, and your connected WooCommerce store. Everything is calculated in real time from your actual transaction data, and you can export any dataset as a CSV file directly from the dashboard.
Go to Analytics in your dashboard to get started. Use the time range selector at the top to filter data across five preset windows: last 7 days, 30 days, 90 days, 12 months, or all time.
Time Range
Products Tab
Get a clear picture of which products are driving your revenue and which ones are sitting idle.
Overview Cards
Four summary cards appear at the top of the Products tab:
- Revenue - Total revenue from all products in the selected period
- Products Sold - Number of distinct products with at least one sale
- Avg Units per Order - Average number of items per completed order
- Zero-Sales Products - Products in your catalog that had no sales in the period
Revenue Charts
Two charts break down your product revenue visually:
- Revenue by Category - A donut chart showing which product categories contributed the most to your total revenue. Hover over each segment to see the exact amount.
- Top Products by Revenue - A horizontal bar chart of your best-performing individual products, ranked by revenue generated in the selected period.
Product Lists
Below the charts, two ranked lists appear side by side:
- Top by Revenue - Your highest-earning products, with the revenue amount and number of units sold shown for each.
- Top by Units Sold - Products ranked by quantity sold, which may differ from the revenue ranking for lower-priced high-volume items.
Product Search and Drill-Down
Use the search bar at the top of the Products tab to find any specific product by name. As you type, matching products appear in a dropdown. Select one to open its detail panel.
The product detail panel shows:
- Revenue earned in the selected period
- Total units sold
- A revenue-over-time area chart for that product only
- The individual orders that included this product, with date, customer, and amount
Close the panel by clicking the X icon or clearing the search field.
Zero-Sales Products
The zero-sales count tells you how many of your active products had no completed orders in the selected period. This is a useful signal for reviewing your catalog - a product with no sales in 90 days may need a price adjustment, better photos, or a promotion.
Orders Tab
The Orders tab gives you a high-level view of order volume, a full revenue breakdown, and a day-by-day detail table.
Summary Cards
Four cards appear at the top:
- Total Orders - Number of orders placed in the period across all statuses
- Avg Order Value - Average revenue per qualifying order, with % change vs the previous equivalent period
- Fulfilment Rate - Percentage of orders that reached completed or delivered status
- Cancellation Rate - Percentage of orders that were cancelled
Revenue Breakdown
Below the summary cards, six revenue cards give you a forensic view of where your money is coming from and where it is going. Each card shows the figure for the selected period and a percentage change compared to the previous equivalent period:
- Gross Revenue - Total item value before any deductions (calculated as: order total + discounts - shipping - tax)
- Discounts - Total discount value applied across all orders in the period
- Net Revenue - Gross Revenue minus Discounts
- Shipping - Total shipping fees collected
- Tax - Total tax collected
- Total Revenue - The final amount collected from customers (order totals)
Which orders count?
Gross vs Net Revenue Chart
An area chart shows your daily Gross Revenue and Net Revenue side by side across the selected period. The gap between the two lines represents the total discount value applied each day. Hover over any point to see the exact figures.
Order Volume and AOV Charts
Two additional charts track order activity over time:
- Order Volume Over Time - Total, completed, and cancelled orders per day as stacked bars
- AOV Trend - Average order value per day as a line chart, useful for spotting if promotions are pulling down your average ticket size
Revenue by Day Table
A paginated table below the charts shows one row per day, aggregating all qualifying orders placed on that day. Each row shows:
- Date - The calendar day
- Orders - Number of qualifying orders on that day
- Gross Revenue - Combined gross across all orders that day
- Discounts - Total discounts applied that day
- Net Revenue - Gross minus discounts
- Shipping - Shipping fees collected that day
- Tax - Tax collected that day
- Total - Total order value collected that day
A Totals row at the bottom always shows the sum for the entire selected period, not just the current page. Use the rows-per-page selector (10, 25, or 50) and the previous/next page controls to navigate. Click the Date column header to toggle between newest-first and oldest-first ordering.
Order Status Breakdown
A summary list breaks down your orders by status - completed, processing, pending, cancelled, and failed - with a count and percentage bar for each. A high cancellation or failure rate may indicate a payment flow issue worth investigating.
Orders by State
Orders are grouped by Nigerian state based on the shipping address entered at checkout. This is useful for planning local delivery partnerships or targeted promotions.
Analytics Settings
Click the gear icon next to the date range selector to open the Analytics Settings panel. Here you can configure which order statuses are counted as revenue across the entire Orders tab:
- Completed - Fully delivered or fulfilled orders (default: on)
- Processing - Orders accepted and being prepared (default: on)
- On Hold - Orders awaiting payment confirmation (default: off)
- Pending - Orders not yet confirmed (default: off)
Your selection is saved automatically in your browser and persists across sessions. Changing the selection immediately re-fetches the analytics with the updated filter applied.
Customers Tab
Understand who your best customers are, how often they buy, and how much they spend over time.
Summary Cards
- Total Customers - Unique buyers who placed at least one order in the period
- Avg Lifetime Value - Average total spend per customer across all time
- Repeat Customers - Customers who placed more than one order
- Repeat Rate - Percentage of customers who came back to buy again
Top Customers
A ranked list of your highest-value customers, showing their name, email, total spend, and number of orders. This gives you a clear picture of who your most loyal buyers are.
Customer Search and Drill-Down
Search for any customer by name or email address. Selecting a customer opens their detail panel, which includes:
- Lifetime spend (all time, not filtered by date range)
- Total number of orders placed
- Date of first and most recent purchase
- A list of recent orders with status and amount
Repeat Rate
Inventory Tab
The Inventory tab shows the current stock health of your product catalog. Unlike other tabs, it reflects the current state of your inventory - not a specific date range.
Stock Health Cards
- Total Products - Total number of active products in your catalog
- In Stock - Products with stock quantity above your low-stock threshold
- Low Stock - Products below the low-stock threshold (default: 5 units)
- Out of Stock - Products with zero stock remaining
Product Stock Table
A full table lists all your products with their current stock quantity and stock status badge. Products are sorted so that out-of-stock and low-stock items appear first, so urgent restocks are easy to spot.
Use the search bar to find a specific product by name.
Stock Alerts
When a product falls below the low-stock threshold, Vaendora can send you an email alert. Configure this under Settings - Notifications. Out-of-stock products are also flagged in red in the product table so they are never missed.
Stock Tracking
WooCommerce Tab
If you run a WooCommerce store alongside your Vaendora storefront, the WooCommerce tab pulls your order and product data directly from your WordPress site and displays it in the same analytics dashboard.
Who is this for?
Connecting Your Store
Before any data appears, you need to link your WooCommerce store using its REST API credentials. This is a one-time setup.
Go to WooCommerce Integration settings
Navigate to Integrations - WooCommerce in your Vaendora dashboard. Scroll to the Analytics - Store Connection section.
Get your WooCommerce REST API keys
In your WordPress admin panel, go to WooCommerce - Settings - Advanced - REST API. Click Add key, give it a description (e.g. "Vaendora Analytics"), set Permissions to Read, and click Generate API key.
Copy your credentials
WooCommerce shows the Consumer Key and Consumer Secret once. Copy both immediately - you cannot retrieve them again after leaving the page.
Paste and connect
Enter your Store URL, Consumer Key, and Consumer Secret into the connection form in Vaendora, then click Connect Store. Vaendora verifies the credentials before saving them.
Keep credentials safe
Revenue Breakdown Cards
Once connected, eight revenue cards appear in two rows, giving you the same forensic breakdown as WooCommerce's own Revenue Analytics screen. Every card shows a percentage change compared to the previous equivalent period:
Row 1 - Revenue flow:
- Gross Sales - Total item subtotals from line items, before any deductions
- Returns - Total value of refunds issued in the period
- Coupons - Total coupon discount value applied across orders
- Net Sales - Gross Sales minus Returns and Coupons
Row 2 - Additional charges and volume:
- Tax - Total tax collected
- Shipping - Total shipping fees collected
- Total Sales - Net Sales plus Tax plus Shipping (what customers actually paid)
- Orders - Total number of orders across all statuses in the period
Period comparison
Revenue Over Time Chart
An area chart shows your WooCommerce daily revenue across the selected period. Hover over any point to see the exact amount for that day.
Revenue by Day Table
A paginated table below the chart shows one row per calendar day, aggregating all completed and processing WooCommerce orders from that day. Each row shows:
- Date - The calendar day
- Orders - Number of qualifying orders on that day
- Gross Sales - Combined line-item subtotals for that day
- Returns - Refunds issued for orders on that day
- Coupons - Coupon discounts applied that day
- Net Sales - Gross minus Returns and Coupons
- Tax - Tax collected that day
- Shipping - Shipping collected that day
- Total Sales - What customers actually paid that day
The Totals row always shows the full-period sum regardless of which page you are on. Use the rows-per-page selector (10, 25, or 50) and the page controls to navigate. Click the Date column header to toggle sort order.
WooCommerce Products
Two ranked lists show your WooCommerce product performance:
- Top by Revenue - Products ranked by total revenue generated, with units sold shown alongside each.
- Top by Units Sold - Products ranked by quantity, useful for identifying high-volume but lower-margin items.
You can also search for any WooCommerce product by name. Selecting one opens a detail panel with its revenue and units sold for the period.
Order Status Breakdown
A breakdown of WooCommerce orders by status - completed, processing, on-hold, pending, cancelled, refunded, and failed - with counts and percentages for each.
WooCommerce Customers
A ranked list of your top WooCommerce customers by lifetime value, showing name, email, total spend, and order count. You can also search for a specific customer by name or email to see their spending summary and last order date.
Orders by State
WooCommerce orders are broken down by the Nigerian state in the customer's shipping address, showing order count and revenue per state. This mirrors the geography view available for Vaendora storefront orders.
Stock Health
The WooCommerce tab also shows the current stock status of your WooCommerce products, pulled directly from your WordPress store:
- Out of Stock - Products set to "outofstock" in WooCommerce
- Low / Backorder - Products with backorder status enabled
- In Stock - Products with available stock
A table of products needing attention lists any out-of-stock or backordered items by name, so you can act quickly without logging into WordPress.
Updating or Disconnecting
To update your credentials - for example, if you regenerate your API keys in WooCommerce - click Update next to the connected store and re-enter the new keys.
To unlink the store entirely, click Disconnect. This removes your stored credentials and clears the WooCommerce tab. You can reconnect at any time.
Exporting Data
Every analytics tab that shows data tables or ranked lists has an Export CSV button. Clicking it downloads a CSV file directly to your device - no loading screen, no email, no waiting. The file is ready to open in Excel, Google Sheets, or any other spreadsheet tool.
What gets exported
The four export points and their columns:
- Products tab - Button appears above the Top Products lists. Downloads every product that had at least one sale in the period. Columns: Product Name, Revenue (NGN), Units Sold. Filename:
products-30d-vaendora.csv(range varies). - Orders tab - Button appears above the Revenue by Day table. Downloads one row per calendar day with a full revenue breakdown. Columns: Date, Orders, Gross Revenue, Discounts, Net Revenue, Shipping, Tax, Total. Filename:
orders-revenue-30d-vaendora.csv. - Customers tab - Button appears in the header of the Top Customers card. Downloads the full customer list sorted by lifetime value. Columns: Name, Email, Lifetime Value (NGN), Total Orders. Filename:
customers-30d-vaendora.csv. - WooCommerce tab - Button appears above the Revenue by Day table. Downloads the WooCommerce daily revenue breakdown. Columns: Date, Orders, Gross Sales, Returns, Coupons, Net Sales, Tax, Shipping, Total Sales. Filename:
woocommerce-revenue-30d-vaendora.csv.
Currency values
Tips for Getting the Most from Analytics
Daily fluctuations are noisy. Set the time range to "Last 30 days" and check once a week to spot real trends rather than one-off spikes.
The day-by-day table is your best tool for matching analytics figures to your bank deposits or accounting records. Every row is a complete revenue breakdown for that single day.
Products with no sales in 90 days are worth reviewing. Either improve their listing with better photos and descriptions, discount them, or retire them to keep your storefront focused.
If you sell on both your WooCommerce store and your Vaendora storefront, compare the two tabs side by side to understand which channel is growing faster.
The Orders by State breakdown shows you where demand already exists organically. Target those states first with paid ads for the highest conversion rates.
Use the Inventory tab to spot products approaching low-stock before they hit zero. An out-of-stock product during a promotion loses sales that are hard to recover.