)
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 sequence enrollment reporting can’t display truly fixed weekly target lines because the platform’s goal configuration works around monthly periods, causing your target line to fluctuate based on calendar variations.
You’ll learn how to create genuinely fixed weekly target lines that remain horizontal across your entire report chart.
Create genuinely fixed weekly target lines using Coefficient
The issue is that HubSpot distributes monthly goals across weeks of varying lengths, creating uneven weekly targets (15 companies in 3-week months vs 12 companies in 5-week months). Coefficient enables you to build fixed target lines in spreadsheet environments where you have complete control.
How to make it work
Step 1. Import sequence enrollment data with date-level detail.
Connect to HubSpot via HubSpot through Coefficient and import your sequence enrollment metrics. Pull the data with full date granularity so you can group it properly by week.
Step 2. Add a fixed target column that stays static.
Create a column with your consistent weekly target (like 20 companies) that remains unchanged across all weekly periods. This becomes your horizontal reference line that won’t shift with calendar math.
Step 3. Configure combination charts with separate data series.
Build charts where your enrollment data appears as bars or lines and your fixed target appears as a true horizontal reference line. Spreadsheet charting tools let you create these static references that HubSpot’s goal system can’t deliver.
Step 4. Automate data refresh while keeping targets fixed.
Use Coefficient’s scheduling to update actual enrollment data automatically while your fixed target line stays unchanged. This gives you current data with consistent benchmarks.
Build the fixed target lines you need
Spreadsheet-based visualization gives you true horizontal reference lines that don’t fluctuate with HubSpot’s monthly goal distribution quirks. Get started with fixed weekly target lines that actually stay fixed.
