Menu

Sales · Google Sheets sample

GoHighLevel Sales & Goals report template

Compare recorded won sales with goals you actually configured. Use the monthly actual-versus-target columns and current open-pipeline bars for a grounded performance review.

Sales & Goals

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

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

Recorded sales won$4,450.002 won deals
Sales goal$10,000.002026-10 · configured goal
Goal achieved44.5%2026-10 goal; 2026-10-01–2026-10-13 actual
Remaining to goal$5,550.002026-10 · target minus actual

Sales won vs target

Sales won vs target$0.00$3,333.33$6,666.67$10,000.002026-10 · Actual: $4,450.002026-10 · Target: $10,000.002026-10
ActualTarget

View chart data
Sales won vs target values
GroupValueActualTarget
2026-10$4,450.00$4,450.00$10,000.00

Open pipeline by stage

Open pipeline by stageDiscoveryDiscovery: $4,800.00$4,800.00QualifiedQualified: $6,900.00$6,900.00ProposalProposal: $0.00$0.00NegotiationNegotiation: $10,350.00$10,350.00

Current stage distribution · as of latest refresh

View chart data
Open pipeline by stage values
GroupValue
Discovery$4,800.00
Qualified$6,900.00
Proposal$0.00
Negotiation$10,350.00
Sales results
OwnerWon dealsRecorded sales wonGoalAttainmentRemaining gap
Alex Morgan0$0$4,0000%$4,000
Jamie Chen0$0$3,0000%$3,000
Sam Rivera2$4,450$3,000148.3%$0

What the metrics mean

Recorded sales won

Record grain: opportunity

Date basis: Latest qualifying status timestamp

Rules: Won only; reopened deals move historical results; missing values and other currencies excluded from sum

Sales goal

Record grain: goal period

Date basis: Monthly target period

Rules: Configured unit/currency matches actual

Goal achieved

Record grain: opportunity + configured goal

Date basis: Outcome date in goal month

Rules: Actual / goal; not clamped at 100%

Remaining to goal

Record grain: opportunity + configured goal

Date basis: Outcome date in goal month

Rules: max(goal - actual, 0); excess separate

Required data and boundaries

  • Opportunities

Goals have a period, unit, and currency. A missing or incompatible goal is not a zero target; collected cash is measured by payment reports.

Targets apply to the full goal month. Actuals use the selected outcome dates. Open pipeline is as of the latest refresh.

Latest-status basis: reopened deals can change historical won/lost results. Fixed historical outcomes require validated event history. Recorded sales won is deal value, not collected revenue.

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

Sales

Team Performance

Sales and win-rate rankings by owner.

Explore sample →
Sales

Pipeline & Follow-up

Open pipeline, sales targets and deal details.

Explore sample →
Payments & invoices

Payment Collections

Successful collections, transaction counts and payment types.

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.