Completed order value
Record grain: order
Date basis: Order created date; current completed status
Rules: One contributing record per typed ID
Commerce · Google Sheets sample
Review completed order value, order count, average order value, and pending orders. Keep the order header as the primary counting grain.
Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago
Change filters to explore the sample locally. No account connection.
2026-10-01–2026-10-13 · Daily · Order created date
| Group | Value |
|---|---|
| 2026-10-01 | $0.00 |
| 2026-10-02 | $0.00 |
| 2026-10-03 | $0.00 |
| 2026-10-04 | $2,200.00 |
| 2026-10-05 | $0.00 |
| 2026-10-06 | $0.00 |
| 2026-10-07 | $0.00 |
| 2026-10-08 | $600.00 |
| 2026-10-09 | $0.00 |
| 2026-10-10 | $0.00 |
| 2026-10-11 | $0.00 |
| 2026-10-12 | $0.00 |
| 2026-10-13 | $0.00 |
| Group | Value |
|---|---|
| Completed | 2 |
| Pending | 1 |
| Cancelled | 1 |
| Order | Customer | Created | Current status | Order total |
|---|---|---|---|---|
| Order 1001 | Ava Wilson | 2026-10-04 | Completed | $2,200 |
| Order 1002 | Ethan Brooks | 2026-10-08 | Completed | $600 |
| Order 1003 | Olivia Bennett | 2026-10-09 | Pending | $350 |
| Order 1004 | Noah Davis | 2026-10-10 | Cancelled | $400 |
Record grain: order
Date basis: Order created date; current completed status
Rules: One contributing record per typed ID
Record grain: order
Date basis: Recorded date in selected period
Rules: One contributing record per typed ID
Record grain: order
Date basis: Order created date; completed order total / completed orders
Rules: One contributing record per typed ID
Record grain: order
Date basis: Recorded date in selected period
Rules: One contributing record per typed ID
Order value is not collected cash. Status and currency matter, and this report does not claim traffic conversion or gross margin without additional sources.
Order value is neither a payment nor recognized revenue. Order-header totals are summed once. Cancelled orders are excluded from completed totals; status changes can revise a created-date cohort.
CRM coverage only · USD; other currencies excluded. Financial units and relationship namespaces are simulated, not provider-validated.
Early access · These public previews use invented records. Join early access to discuss connecting your own GoHighLevel account.
Use the report whose definitions match the decision you need to make.
Confirm source access, relevant mappings, history, and any configured goals.
The early-access design reuses compatible imports and creates a report worksheet.
Select source refreshes deliberately. New executions transferring records add usage.
Successful collections, transaction counts and payment types.
Explore sample →Customer collections, current balances and linked payment records.
Explore sample →Explore the samples now. Join the existing waitlist to request connected early access, or discuss a predictable subscription for larger workloads.