)
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 native reporting only offers daily, weekly, monthly, quarterly, and yearly aggregations. There’s no built-in option for biweekly (14-day) time series aggregation, which creates problems when your campaigns run on biweekly schedules.
Here’s how to create true biweekly aggregations that align with your actual campaign timelines and eliminate misleading weekly data splits.
Create custom biweekly aggregations using Coefficient
Coefficient solves this by importing your HubSpot marketing data directly into HubSpot spreadsheets where you can build custom 14-day groupings. You get complete control over your aggregation periods and can align reporting with your actual campaign schedules.
How to make it work
Step 1. Connect Coefficient to HubSpot and import your marketing data.
Set up your data import to include emails, campaigns, forms, and any other marketing metrics you need. Use Coefficient’s scheduled refresh feature to automatically update your data after each campaign or on your preferred schedule.
Step 2. Create biweekly period groupings with formulas.
Add a helper column that groups your dates into 14-day periods. Use this formula:to assign each date to a specific biweekly period. This creates sequential period numbers (0, 1, 2, 3…) that group your data into consistent 14-day windows.
Step 3. Aggregate your metrics using SUMIFS or pivot tables.
Build your aggregations based on the biweekly period numbers. For example:to sum all metrics from period 1. Create pivot tables using your period groupings as rows and your marketing metrics as values for easy visualization.
Step 4. Set up automated alerts and visualizations.
Use Coefficient’s alert feature to get Slack or email notifications with biweekly performance updates. Build charts based on your custom groupings and use the snapshot feature to preserve historical biweekly comparisons.
Get accurate campaign insights that match your schedule
Custom biweekly aggregation eliminates the confusion of split weekly data and provides accurate trend analysis for strategic decision-making. Start building your biweekly reporting system today.
