Menu

Sales · Google Sheets sample

GoHighLevel Forecast & Changes report template

Review weighted opportunities and movement since a selected saved cutoff. This report makes configured probabilities and snapshot availability visible.

Forecast & Changes

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

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

Recorded weighted forecast$1,830.002026-10 · explicit probability and expected-close inputs only
Period target$10,000.002026-10 · matching sales-value goal and currency required
Forecast-versus-actual errorNot enough dataRequires saved forecast and resolved period outcomes
Deals with slipped close dates1Change since selected saved cutoff

Weighted pipeline by owner

Weighted pipeline by ownerAlex MorganAlex Morgan: $1,830.00$1,830.00Jamie ChenJamie Chen: $0.00$0.00Sam RiveraSam Rivera: $0.00$0.00UnassignedUnassigned: $0.00$0.00

View chart data
Weighted pipeline by owner values
GroupValue
Alex Morgan$1,830.00
Jamie Chen$0.00
Sam Rivera$0.00
Unassigned$0.00

Forecast changes

Forecast changes$0.00$610.00$1,220.00$1,830.00Saved: $1,830.00Olivia Bennett · Service quote: $0.00Liam Carter · Service quote: $0.00Current: $1,830.00SavedOlivia Bennett · Ser…Liam Carter · Servic…Current

Movement since selected saved cutoff

View chart data
Forecast changes values
GroupValue
Saved$1,830.00
Olivia Bennett · Service quote$0.00
Liam Carter · Service quote$0.00
Current$1,830.00
Changed deals
DealOwnerSaved closeExpected closeExplicit probabilityChange
Olivia Bennett · Service quoteAlex Morgan2026-10-102026-10-2560%$0

What the metrics mean

Recorded weighted forecast

Record grain: opportunity

Date basis: As of latest refresh

Rules: Expected close in forecast month with explicit 0–1 probability and known reporting-currency value

Period target

Record grain: goal period

Date basis: Forecast month

Rules: Configured goal

Forecast-versus-actual error

Record grain: saved forecast + opportunity

Date basis: Resolved saved forecast period

Rules: Absolute forecast versus actual error; unavailable until period resolved

Deals with slipped close dates

Record grain: opportunity

Date basis: Change since selected saved cutoff

Rules: Expected close date later than saved date

Required data and boundaries

  • Compatible saved snapshots
  • Opportunities
  • Configured probabilities and forecast period

Weighted pipeline needs explicit probabilities and eligible close dates. Snapshot movement requires compatible saved coverage and is not a promise of forecast accuracy.

7 open deals excluded: missing / out-of-period forecast input or other currency. No probabilities inferred from customer outcomes.

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

Pipeline & Follow-up

Open pipeline, sales targets and deal details.

Explore sample →
Sales

Sales & Goals

Actual sales, targets and open pipeline.

Explore sample →
Sales

Stage Conversion & Bottlenecks

Stage conversion and completed time in stage.

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.