Executive Report

Loading...

build: pending 7d 30d 90d
to Previous equal-length period will be compared automatically.

Week-on-Week Comparison

Loading periods...
New Contacts
—
—
Opps Created
—
—
Meetings
—
—
Closed Won
—
—
Email Opens
—
—
Email Clicks
—
—
LinkedIn DMs
—
—
LinkedIn Replies
—
—
Recorded Visits
—
GA4 recorded visits
Contacts
—
GHL
Opps Created
—
GHL
Meetings
—
GHL
Closed Won
—
GHL
Revenue
—
GHL

Metric Glossary

Definitions as shown
Traffic

Recorded visits are the visits GA4 captured in the selected window. Users are unique visitors and are the primary denominator for the funnel cards below.

Lead Capture

Contacts are GHL contacts created in the window from any source. Form metrics remain stored but are not shown here until tracking is validated.

Funnel Efficiency

User → Contact shows how efficiently unique visitors become CRM contacts. Form conversion is not shown until form tracking is validated.

Attribution Coverage

Contacts Created in Window are new contacts created in the window. Source Coverage means usable source fields exist, Bridge Matched means the contact was linked to a GA4 recorded visit, and Sale Matched means it was linked to an opportunity.

Acquisition Sources

This section shows contact-level source / medium / campaign attribution. It is the visible home for the dashboard's acquisition source view.

UTM / Campaign Breakdown

This table shows observed UTM traffic rows. A UTM created in GHL will only appear here once it is actually observed in traffic or matched through the bridge.

Sales Panels

Active Opportunities Summary is the team-wide open-deal view. Duplicate deal panels are omitted so the same opportunity payload is not counted twice visually.

SDR Performance

Per-owner breakout for the end-of-month SDR assessment. Booked counts Regulated Ads calendar appointments (start date in the window) attributed to the SDR via appointment → contact → opportunity assigned to. Showed / No-show / Cancelled use the GHL appointment status saved on each record — status is not yet updated after meetings, so Showed stays 0 until the Phase-3 status-update automation. SQLs Created = Sales Outreach opportunities created in the window by owner. MQL→SQL = MQL opportunities that entered Sales Outreach in the window. Won / Lost / Revenue = closed opportunities created in the window by owner. Unassigned opportunities roll into an explicit Unassigned row; owner-coverage % is surfaced in Source Health.

Lead Source — MQL & SQL

Breakout of MQLs Entered (Warm Qualified stage entries in the window) and SQLs Created (Sales Outreach opportunities created in the window) by the originating lead source. Each MQL/SQL opportunity is joined to its contact; the lead source is resolved from the contact's first UTM source/medium/campaign, falling back to the traffic-to-lead bridge attribution, then to the GHL contact source field. Coverage is bounded by the leads snapshot — rows without a resolvable source are grouped under Unknown / Unattributed, and the coverage note shows how many MQLs/SQLs were attributed in the window.

Calls & Conversations

This panel shows GHL conversation call records. It groups calls by the raw CRM status so the team can see answered, missed, and voicemail activity without guessing from SMS or Twilio data.

Active Opportunities

Active Open counts the latest opportunity snapshot whose status is still open as of the selected end date. It is not the same thing as opportunities created in the window.

Worked Opportunities

Worked counts active opportunities that were updated or had a stage change inside the selected window. This is the closest dashboard proxy for deals that were definitely touched.

Stage Movers

Stage Movers counts active opportunities that changed stage at least once inside the selected window. The stage lists below show where those open deals currently sit.

Social Posts

Post Placements counts each platform/account destination in GHL Social Planner. One composed post published to Instagram and three LinkedIn accounts therefore counts as four placements. Likes, comments, and shares are the latest post-ledger values. Reach, impressions, and saves show N/A until authenticated account statistics are available.

Date Ranges

7d, 30d, and 90d are trailing complete days ending yesterday. Example: clicking 7d on a Tuesday shows the previous Tuesday through Monday.

Channel Breakdown

This is the GA4 channel summary for the selected window. It is traffic volume, not contact volume.

Channel Breakdown

GA4
Waiting for data...

Channel Detail

GA4 + GHL
Loading...

Meta Ads Overview

Meta Ads source data
Spend
—
Clicks
—
Impressions
—
Leads
—

Meta Campaign Performance

Meta Ads source data
No Meta data yet...

Contact Acquisition Sources

Attribution
Loading...

Most Visited Pages

GA4 landing pages
Loading page summary...

Funnel Efficiency

GHL + GA4
User → Contact
—
Contact → Opp
—
Opp → Meeting
—
Meeting → Won
—
Best Channel
—

Attribution Coverage

GHL Bridge
Contacts Created in Window
—
With Source Fields
—
Bridge Matched
—
Sale Matched
—
Source Coverage
—
Bridge Match Rate
—

Capture Gaps — Absolute Volume

GHL
Recorded Visits
—
Contacts
—
Opportunities
—
Meetings
—
Closed Won
—

Pipeline Overview

GHL
Warm
—
Sales Outreach
—
Sales
—
Loading stage data...

Sales Quality

GHL
Avg. Cycle
—
Won Revenue
—
Won Deals
—
Lost Deals
—
Win Rate
—
Best Channel
—
Active Deals by Current Stage
Loading deal data...

UTM / Campaign Breakdown

GA4 + GHL
Waiting for UTM data...

Active Opportunities Summary

GHL
Active Open
—
Worked
—
Stage Movers
—
Pipeline Value
—

Meetings (Cameron's Calendar)

GHL Appointments
Total
—
Showed
—
No-show
—
Cancelled
—
Loading appointment data...

SDR Performance

GHL owner attribution
SDRBookedShowedNo-showCancelledSQLs CreatedMQL→SQLWonLostRevenue
Loading SDR performance data...

Lead Source — MQL & SQL

What is working
Lead SourceMediumMQLs EnteredSQLs Created
Loading lead source data...

GHL Calls

Conversations
Total Calls
—
Answered
—
Missed
—
Voicemail
—
Inbound
—
Outbound
—
Loading call data...
Outbound Call Outcomes
Loading call outcome data...

Campaign Channels

Email + LinkedIn + Instagram + SMS + VAPI
ChannelCampaignSMS SentSMS RepliesTracked DeliveredUnique OpensUnique Open RateUnique ClickersUnique Click RateUnique RepliesUnique Response RateBouncedLI InvitesLI AcceptedLI DMsLI RepliesIG DMsIG RepliesVAPI CallsAnsweredQualifiedBooked
Loading campaign channel data...

Campaign Breakdown

Email + LinkedIn + Instagram + SMS + VAPI by campaign
CampaignOpportunitiesTracked DeliveredUnique OpensUnique Open RateUnique ClickersUnique Click RateUnique RepliesBouncedLI InvitesLI AcceptedLI DMsLI RepliesIG DMsIG RepliesSMS SentSMS RepliesVAPI CallsAnsweredQualifiedBooked
Loading campaign breakdown...

MQL & LinkedIn State Snapshot

Current CRM state
MQL
Total MQLs
—
MQLs Converted to SQL
—
Current MQLs (awaiting Sales)
—
SQL Contacts
—
Entered MQLs This Period
—
Converted This Period
—
LinkedIn State
LinkedIn Ready
—
LinkedIn Requested
—
LinkedIn Connected
—
Follower Messaged
—
LinkedIn DM Active
—
LinkedIn DM Completed
—
Total State Rows
—
Weekly Requests
—
Weekly Accepts
—
Weekly DMs Sent
—
Weekly Replies
—

Social Posts

GHL Social Planner
Post Placements
—
Published Placements
—
Failed
—
Facebook
—
Instagram
—
LinkedIn
—
Ledger Likes
—
Ledger Comments
—
Ledger Shares
—
Account Reach
—
Account Impressions
—
Account Posts
—
Account Likes
—
Account Followers
—

Site Traffic

GA4
Recorded Visits
—
Users
—
Engaged
—
Top Page
—
Eng. Rate
—

Source Health

Runtime, pipeline, and snapshot freshness
GHL
—
GA4
—
n8n
—
Postgres
—
GSC
Pending
Appointments
Pending
Meta Ads
Pending