Menu

Sales · Google Sheets sample

GoHighLevel Business Overview report template

A working overview for an agency owner reviewing sales outcomes, lead intake, attended appointments, and overdue work together. Use it to decide which underlying report deserves attention next.

Business Overview

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

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

New leads8Contact created date
Recorded sales won$4,450.002 won deals
Appointments attended3Appointment start date
Overdue follow-ups2As of latest refresh

Sales won over time

Sales won over time$0.00$1,383.33$2,766.67$4,150.002026-10-01: $0.002026-10-02: $0.002026-10-03: $0.002026-10-04: $1,700.002026-10-05: $0.002026-10-06: $0.002026-10-07: $2,750.002026-10-08: $0.002026-10-09: $0.002026-10-10: $0.002026-10-11: $0.002026-10-12: $0.002026-10-13: $0.002026-10-01: $0.002026-10-02: $0.002026-10-03: $0.002026-10-04: $0.002026-10-05: $0.002026-10-06: $0.002026-10-07: $0.002026-10-08: $0.002026-10-09: $0.002026-10-10: $4,150.002026-10-11: $0.002026-10-12: $0.002026-10-13: $0.002026-10-012026-10-042026-10-072026-10-102026-10-13
ActualPrevious period

2026-10-01–2026-10-13 · Daily · Outcome date · comparison 2026-09-01–2026-09-13

View chart data
Sales won over time values
GroupValuePrevious period
2026-10-01$0.00$0.00
2026-10-02$0.00$0.00
2026-10-03$0.00$0.00
2026-10-04$1,700.00$0.00
2026-10-05$0.00$0.00
2026-10-06$0.00$0.00
2026-10-07$2,750.00$0.00
2026-10-08$0.00$0.00
2026-10-09$0.00$0.00
2026-10-10$0.00$4,150.00
2026-10-11$0.00$0.00
2026-10-12$0.00$0.00
2026-10-13$0.00$0.00

Top 5 customers by sales won

Top 5 customers by sales wonEthan BrooksEthan Brooks: $2,750.00$2,750.00Ava WilsonAva Wilson: $1,700.00$1,700.00

View chart data
Top 5 customers by sales won values
GroupValue
Ethan Brooks$2,750.00
Ava Wilson$1,700.00
Needs attention
Customer / dealReasonResponsible personRelevant date
Olivia BennettOverdue taskAlex Morgan2026-10-08
Noah DavisOverdue taskJamie Chen2026-10-09
Liam CarterTask due todayAlex Morgan2026-10-13
Mia PatelTask due todayJamie Chen2026-10-13
Ethan BrooksTask due todaySam Rivera2026-10-13
Liam CarterStage age exceeds 14 daysAlex Morgan2026-09-15
Olivia BennettStage age exceeds 14 daysAlex Morgan2026-09-15
Ava WilsonAttendance not recordedSam Rivera2026-10-04
Sophia LeeAttendance not recordedAlex Morgan2026-10-08

What the metrics mean

New leads

Record grain: contact

Date basis: Contact created date

Rules: Validated lead definition; contacts without it use New contacts

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

Appointments attended

Record grain: appointment occurrence

Date basis: Appointment start date

Rules: Validated Attended status

Overdue follow-ups

Record grain: task

Date basis: As of latest refresh

Rules: Incomplete tasks with due day before local today

Required data and boundaries

  • Contacts
  • Opportunities
  • Appointments and calendar scope
  • Contact tasks

The sample combines a sales trend with top-customer ranking. Its operational counters remain separate facts; it does not label won deals as accounting revenue.

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

Leads & Sources

Lead volume, recorded sources and linked opportunities.

Explore sample →
Sales

Pipeline & Follow-up

Open pipeline, sales targets and deal details.

Explore sample →
Payments & invoices

Cash & Invoices

Collections and overdue invoices.

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.