How to create biweekly time series aggregation in HubSpot marketing reports

using Coefficient excel Add-in (500k+ users)

Learn how to create biweekly time series aggregation for HubSpot marketing reports using custom formulas and automated data imports.

“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.”

5 star rating coeff g2 badge

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.

500,000+ happy users
Get Started Now
Connect any system to Google Sheets in just seconds.
Get Started

Trusted By Over 50,000 Companies