)
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 monthly goal settings create uneven weekly goal lines because months contain varying numbers of weeks (4-5 weeks), making your 20 companies per week target appear as stepped patterns rather than consistent horizontal benchmarks.
Here’s how to create properly calculated weekly goal lines that stay consistent regardless of calendar variations.
Build consistent weekly goal lines using Coefficient
The core problem is mathematical – you can’t evenly distribute monthly targets across weeks since months don’t align with week boundaries. Coefficient solves this by letting you import sequence enrollment data into spreadsheets where you can create properly calculated weekly goal lines.
How to make it work
Step 1. Import your sequence enrollment data from HubSpot.
Connect HubSpot to HubSpot through Coefficient and pull your sequence enrollment metrics. Make sure to include enrollment dates and counts with date-level granularity so you can group by week properly.
Step 2. Create a weekly goal column with your consistent target.
Add a calculated column that shows your 20 companies per week target for each weekly period. This stays static regardless of how many weeks are in each month, giving you the horizontal benchmark line HubSpot can’t provide.
Step 3. Build custom charts with both data series.
Use your spreadsheet’s charting tools to display actual enrollment data and the consistent weekly goal line as separate data series. Format the goal line as a horizontal reference that doesn’t fluctuate with calendar variations.
Step 4. Set up automatic data updates.
Schedule Coefficient’s imports to run daily or weekly to keep your enrollment data current while maintaining the proper goal line visualization. Your actual data refreshes but the goal line stays consistent.
Get the weekly goal visualization you actually need
This approach eliminates the monthly vs weekly period mismatch entirely, giving you consistent weekly target benchmarks that HubSpot’s native goal settings simply can’t provide. Start building your proper weekly goal charts today.
