> ## Documentation Index
> Fetch the complete documentation index at: https://docs.woopilot.xyz/llms.txt
> Use this file to discover all available pages before exploring further.

# Financial Analytics & Executive Dashboards

> Instant real-time revenue, profit margins, average order value, and cohort analytics delivered directly into Telegram

# Financial Analytics at the Speed of Thought 📊

Say goodbye to static, confusing spreadsheet exports and slow WordPress reporting plugins. WooPilot AI calculates complex e-commerce financial metrics across your entire store history in milliseconds and presents them either as clean text summaries or high-resolution graphic dashboards.

```text theme={null}
┌─────────────────────────────────────────────────────────────────────────────┐
│ 💬 TELEGRAM CHAT PROMPT:                                                    │
│ "Show yesterday's sales summary with top 3 products and average check"      │
├─────────────────────────────────────────────────────────────────────────────┤
│ 🤖 WOOPILOT AI RESPONSE (Retina PNG Infographic + Text Breakdown):          │
│ • Net Revenue: $4,250.00 (+18.4% vs prev day)                               │
│ • Total Orders: 64 orders (Processing: 58, Completed: 6)                    │
│ • Average Order Value (AOV): $66.40                                         │
│ • Top Category: Running Shoes ($2,140.00 | 32 items)                        │
└─────────────────────────────────────────────────────────────────────────────┘
```

***

## 📈 Supported Financial Metrics & Calculations

WooPilot AI calculates all standard e-commerce key performance indicators (KPIs) with exact precision:

* **Net & Gross Revenue:** Real-time calculation deducting discounts, refunds, and taxes.
* **Profit Margin & COGS:** Cross-referenced product cost of goods and gross profit margins.
* **Average Order Value (AOV):** Dynamic calculation by date range, customer segment, or product category.
* **Customer Lifetime Value (LTV):** Historic purchase frequency and average monetary contribution per buyer.
* **Cohort & Retention Analysis:** Retention rates, purchase intervals, and churn rates across customer registration months.
* **Abandoned Cart & Checkout Health:** Analysis of unpaid, failed, and pending orders across payment gateways.

***

## 💬 Example Natural Language Queries

You can query your store's finances using natural human phrases:

### 1. Daily & Weekly Summaries

```text theme={null}
"Give me a morning sales summary for yesterday with top items and payment methods"
"How is this week performing compared to the same period last week?"
"What was our peak sales hour yesterday?"
```

### 2. Deep Comparative & Margin Analysis

```text theme={null}
"Compare Q3 revenue with Q2 and break down growth by category"
"Calculate our refund rate for the last 30 days and show the most refunded products"
"What is the average order value for first-time vs returning customers this month?"
```

### 3. Dynamic Card Styling & Customization

```text theme={null}
"Render an executive infographic dashboard for this month's revenue"
"Switch the dashboard theme to dark luxury and add a return rate metric"
```

***

## 🎨 Zero-Click Retina PNG Dashboards

When you request visual summaries, WooPilot AI uses an in-memory rendering pipeline powered by **Satori + Rust Resvg**.

* **0ms Disk Latency:** Infographics are synthesized entirely in server RAM without temporary file storage.
* **Retina Resolution:** High-DPI crystal-clear typography and color-coded trend badges optimized for mobile smartphone screens.
* **Dynamic Layouts:** Visual cards automatically adapt their height based on the number of KPI blocks, leaderboards, and category breakdown bars.


## Related topics

- [Introduction](/introduction.md)
- [0-Click Dynamic Infographics](/capabilities/dynamic-infographics.md)
- [AI Context & Tone of Voice](/tma/ai-tone-of-voice.md)
- [WooAuto: The 24/7 Autopilot](/wooauto/overview.md)
- [Frequently Asked Questions](/faq.md)