The total number of orders that received a full or partial refund.
Refund Count = COUNT ( Orders ) WHERE refund_amount > 0
| Metadata | |
|---|
| Type | Number |
| Data Source | Shopify |
| Aggregation | Count |
Example
Your store processed 127 refunds in March across 2,450 total orders:
| Week | Refunds | Rate |
|---|
| Week 1 | 28 | 4.8% |
| Week 2 | 31 | 5.2% |
| Week 3 | 42 | 6.9% (new SKU issue) |
| Week 4 | 26 | 4.3% |
How It Works
Refund Count tracks every order that had any refund processed in Shopify. Both full and partial refunds increment this count. Orders with multiple refunds count once.
When to Use
| Scenario | Action |
|---|
| Return rate analysis | Compare refund count to total orders for return rate |
| Product quality issues | Spike in refunds may indicate defective batch |
| Customer satisfaction | High refund counts signal experience problems |
| Seasonal patterns | Track if returns increase after holidays or promotions |
| Metric | Relationship |
|---|
| Refund Amount | Dollar value of these refunds |
| Refund % | Refund Count ÷ Orders |
| Refund Per Order | Average refund value per refunded order |
| Cancelled Orders | Orders cancelled before fulfillment |
| Orders | Total orders (denominator for rate) |
