)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot’s dashboard widgets cannot display aggregated deal counts due to the absence of native COUNT functions in the custom report builder, limiting your ability to show total closed deals in a single widget.
Here’s how to create external dashboards with live HubSpot data that automatically update with sophisticated aggregations and visual flexibility beyond HubSpot’s widget limitations.
Build external dashboards with live HubSpot data synchronization using Coefficient
Coefficient provides a comprehensive solution for creating external dashboards with live HubSpot data in spreadsheets that automatically update with sophisticated aggregations, visual flexibility, and multi-object integration that HubSpot’s native widgets simply cannot provide.
How to make it work
Step 1. Set up live data sync with scheduled refresh options.
Import deals data with automatic updates from HubSpot using refresh schedules from hourly to monthly. Apply filters for closed statuses during import to focus your dashboard on relevant deal data.
Step 2. Create summary sections with total closed deal counts.
Build summary calculations using =COUNTIF(Status_Column,”Closed*”) to capture all closed deal variations. Create dynamic totals that adjust automatically as new closed deals are added during data refreshes.
Step 3. Build trend charts showing closed deals over time.
Create visual charts and graphs that show closed deal trends with conditional formatting to highlight achievement milestones. This provides visual flexibility that goes far beyond HubSpot’s limited widget options.
Step 4. Integrate multiple HubSpot objects in single dashboard view.
Combine deals with contacts, companies, and custom objects in comprehensive dashboard views. This multi-object integration provides context that HubSpot’s individual widgets cannot match.
Step 5. Set up automated notifications for dashboard changes.
Configure email or Slack notifications when totals change significantly. Use automated alerts to keep stakeholders informed when closed deal counts reach important thresholds.
Step 6. Export calculated totals back to HubSpot (hybrid approach).
Push calculated totals back to HubSpot as custom properties using Coefficient’s export capabilities. This enables display in native HubSpot dashboard widgets while maintaining advanced calculation logic in your external dashboard.
Get sophisticated dashboards that combine calculation power with familiar interfaces
This hybrid approach provides the best of both worlds: sophisticated calculations with familiar HubSpot dashboard interfaces, giving you the total closed deal widgets you need. Start building better dashboards today.
