Menu

Commerce · Google Sheets sample

GoHighLevel Order Performance report template

Review completed order value, order count, average order value, and pending orders. Keep the order header as the primary counting grain.

Order Performance

Invented sample · Fixed as of October 13, 2026 · USD · America/Chicago

Change filters to explore the sample locally. No account connection.

Completed order value$2,800.00Order created date; current completed status
Completed orders2Recorded date in selected period
Average completed order value$1,400.00Order created date; completed order total / completed orders
Pending orders1Recorded date in selected period

Completed order value over time

Completed order value over time$0.00$733.33$1,466.67$2,200.002026-10-01: $0.002026-10-02: $0.002026-10-03: $0.002026-10-04: $2,200.002026-10-05: $0.002026-10-06: $0.002026-10-07: $0.002026-10-08: $600.002026-10-09: $0.002026-10-10: $0.002026-10-11: $0.002026-10-12: $0.002026-10-13: $0.002026-10-012026-10-042026-10-072026-10-102026-10-13

2026-10-01–2026-10-13 · Daily · Order created date

View chart data
Completed order value over time values
GroupValue
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

Orders by current status

Orders by current statusCompletedCompleted: 22PendingPending: 11CancelledCancelled: 11

View chart data
Orders by current status values
GroupValue
Completed2
Pending1
Cancelled1
Order records
OrderCustomerCreatedCurrent statusOrder total
Order 1001Ava Wilson2026-10-04Completed$2,200
Order 1002Ethan Brooks2026-10-08Completed$600
Order 1003Olivia Bennett2026-10-09Pending$350
Order 1004Noah Davis2026-10-10Cancelled$400

What the metrics mean

Completed order value

Record grain: order

Date basis: Order created date; current completed status

Rules: One contributing record per typed ID

Completed orders

Record grain: order

Date basis: Recorded date in selected period

Rules: One contributing record per typed ID

Average completed order value

Record grain: order

Date basis: Order created date; completed order total / completed orders

Rules: One contributing record per typed ID

Pending orders

Record grain: order

Date basis: Recorded date in selected period

Rules: One contributing record per typed ID

Required data and boundaries

  • Order headers
  • Contacts

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.

From this sample to a connected report

Choose the template

Use the report whose definitions match the decision you need to make.

Check required inputs

Confirm source access, relevant mappings, history, and any configured goals.

Create the worksheet

The early-access design reuses compatible imports and creates a report worksheet.

Choose freshness

Select source refreshes deliberately. New executions transferring records add usage.

Related report samples

Commerce

Product Sales

Sold quantities and line amounts by sale-time product.

Explore sample →
Payments & invoices

Payment Collections

Successful collections, transaction counts and payment types.

Explore sample →
Customer accounts

Customer Payments

Customer collections, current balances and linked payment records.

Explore sample →

Bring your own reporting question.

Make this your reporting workflow.

Explore the samples now. Join the existing waitlist to request connected early access, or discuss a predictable subscription for larger workloads.

Analytics preferences

Optional analytics require your consent before any analytics requests are sent. Hosted forms have their own provider controls.