StoreAnalytics Pro – Store Analytics Dashboard

WooAnalytics Pro is a comprehensive analytics plugin for WooCommerce that surfaces the business intelligence a serious store operator needs, but WooCommerce’s built-in reports don’t provide. WooCommerce natively shows revenue and order counts, but it does not calculate profit, does not segment customers by value, and does not generate actionable recommendations.   The plugin introduces five distinct analytics modules as dashboard tabs: a KPI Dashboard with trend charts, a Profit Engine that calculates true margin after cost-of-goods-sold, a Customer Analytics module with RFM (Recency-Frequency-Monetary) segmentation, an AI Insights tab powered by Anthropic Claude, and an Email Reports module for scheduled delivery of summaries to team inboxes.   Performance is a first-class concern. All KPIs are pre-computed via a nightly background aggregation job using Action Scheduler, writing to a dedicated wap_daily_stats table. The dashboard page loads read from this pre-computed table rather than running expensive live queries on wp_posts and wp_postmeta. This architecture supports stores with 100,000+ orders without degrading dashboard load times.   The plugin reads WooCommerce data exclusively; it never writes to WooCommerce tables. All custom data (daily stats, product costs, customer segments, AI insights, and email report configs) is stored in five dedicated tables with the wap_ prefix, keeping the WooCommerce data layer untouched and the plugin fully uninstallable without residual effects.

Features

KPI Dashboard

• Revenue (gross and net), orders, average order value, refund rate — daily and period-over-period
• Trend charts: 7-day, 30-day, 90-day, and custom date range
• Top products by revenue, top products by order volume
• New vs returning customer ratio
• Hourly order heatmap (identifies peak trading hours)
• Pre-computed from wap_daily_stats — instant load on any store size

Profit Engine

• Per-product COGS (cost of goods sold) input — bulk import via CSV or per-product inline editor
• True profit margin calculation: (revenue – COGS – refunds) / revenue
• Profit ranking table: all products sorted by margin %
• Loss-leader detection: products with negative effective margin flagged
• COGS vs revenue chart: visual breakeven line
• Profitability by category aggregate view

Customer Analytics & RFM Segmentation

• RFM scoring for all customers: Recency (days since last order), Frequency (number of orders), Monetary (lifetime spend)
• Automatic segment assignment: Champions, Loyal Customers, Potential Loyalists, At Risk, Hibernating, Lost
• Segment distribution chart and customer list per segment
• Customer lifetime value (LTV)  historical and projected
• Repeat purchase rate and average days between orders
• Churn risk indicator: customers who haven’t ordered in 2× their average reorder interval
• Customer CSV export (full list with LTV + segment + last order date)

AI Insights (Anthropic Claude)

• Claude analyses aggregated store KPIs and returns 3–5 prioritised, actionable recommendations
• Insight categories: pricing strategy, inventory, customer retention, marketing timing
• Insights cached for 24 hours to minimise API token usage
• User-supplied Anthropic API key, no markup, no subscription
• Insight history: view previous AI analyses and compare over time

Automated Email Reports

• Weekly or monthly scheduled reports sent to a configurable recipient list
• Report contents: revenue, orders, new customers, top 5 products, trend summary
• HTML-formatted email with inline charts (base64 encoded chart images)
• Test send button: preview report before scheduling
• Send day and time configurable (reports fire at 08:00 on chosen day)
• CSV attachments: products (with COGS + margin) and customers (with LTV + segment)

Architecture & Performance

• 5 custom DB tables: wap_daily_stats, wap_product_costs, wap_customer_stats, wap_ai_insights, wap_email_reports
• Nightly aggregation job via Action Scheduler (runs 02:00 store local time)
• Weekly customer segment refresh via Action Scheduler
• 5-minute transient cache on all REST endpoints
• Zero writes to WooCommerce core tables (wp_posts, wp_postmeta, wp_wc_order_*)
• HPOS (Custom Order Tables) compatible, reads from both legacy and HPOS order storage