What Is Gross Merchandise Value?
Gross merchandise value is the total transaction value of all goods or services sold through a marketplace or platform in a given period, before any deductions for fees, refunds, or discounts, and it is the primary top-line metric for marketplace and e-commerce businesses. Most teams calculate it from a transaction export that mixes completed sales, cancelled orders, and refunded transactions in the same dataset.
See the exact formula, how to exclude cancelled and refunded transactions correctly, and how to segment it by category and seller in a spreadsheet.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| transaction_id |
| transaction_date |
| seller_id |
| buyer_id |
| product_category |
| gross_value |
| take_rate |
| net_revenue |
| status |
| refund_amount |
What usually goes wrong with it
Cancelled orders included in the total
The status column contains 'completed', 'cancelled', and 'refunded' values — summing gross_value without filtering for completed transactions overstates the metric by including orders that never settled.
DataMimi Datamimi filters to completed status rows only before summing gross_value so cancelled orders are excluded from the calculation.
Refund amounts not deducted
Gross merchandise value is a gross figure, but refund_amount is often listed as a separate positive column rather than a negative row — teams that include refunds understate the real transaction volume incorrectly.
DataMimi It treats refund_amount as a reduction only if the business definition calls for net GMV, or excludes it entirely for gross GMV — the choice is applied consistently.
Multiple currencies in a single marketplace export
Cross-border marketplaces list gross_value in the seller's local currency without a USD equivalent column, making total aggregation meaningless without conversion.
DataMimi It applies currency conversion to gross_value by transaction_date so multi-currency marketplaces produce a single normalized total.
Take rate confuses net revenue with the metric
take_rate and net_revenue are also in the export — teams sometimes sum net_revenue instead of gross_value, measuring the platform's cut rather than total marketplace transaction volume.
DataMimi It clearly separates gross_value from net_revenue columns so the metric always reflects total transaction volume rather than platform revenue.
Common questions
What is gross merchandise value?
Gross merchandise value (GMV) is the total value of goods sold through a marketplace or platform in a period, calculated by summing the gross transaction value of all completed orders before fees or deductions.
How is GMV different from revenue?
GMV is the total value of all transactions on the platform; revenue is the platform's earnings from those transactions (the take rate applied to GMV) — a marketplace with $10M GMV and a 15% take rate has $1.5M revenue.
How do I calculate GMV in a spreadsheet?
Filter the transaction export to status = 'completed'; sum the gross_value column; exclude cancelled and refunded rows; the result is your gross merchandise value for the period.
Why do investors focus on GMV for marketplace businesses?
GMV reflects the scale of economic activity on the platform, which determines the take rate revenue ceiling; a growing GMV indicates marketplace liquidity and seller/buyer density regardless of monetization rate.
How much does Datamimi cost?
Datamimi offers a Free plan at $0/month (40 credits, no credit card required), Lite at $9/month (400 credits), Starter at $24/month (1,500 credits, up to 3 simultaneous files), Pro at $59/month (5,000 credits with rollover), and Team at $199/month (20,000 credits, 5 users).
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file