)
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 doesn’t support 3-day aggregation periods, leaving you stuck with daily views that are too granular or weekly views that are too broad. This limitation creates problems for short campaign bursts, weekend promotions, or A/B tests that run for specific 3-day windows.
Custom 3-day intervals provide the perfect granularity for analyzing short-duration marketing initiatives and promotional cycles.
Build precise 3-day campaign aggregation using Coefficient
Coefficient enables custom 3-day campaign data aggregation by importing your HubSpot data with daily granularity into HubSpot spreadsheets where you can create precise 3-day groupings. This provides optimal analysis for short-duration campaigns and promotional cycles.
How to make it work
Step 1. Import daily campaign data from HubSpot.
Use Coefficient to pull your campaign data with daily granularity, including all relevant metrics like clicks, conversions, and engagement rates. Make sure to include the date field as your primary grouping column for creating custom periods.
Step 2. Create 3-day period groupings with formulas.
Add helper columns to group dates into 3-day periods. Useto assign period numbers, andto create readable period labels like “2024-01-01 to 2024-01-03”.
Step 3. Aggregate metrics using SUMIFS or pivot tables.
Build your aggregations based on the 3-day period groupings. Use formulas liketo sum metrics for each 3-day window. Create pivot tables with your custom periods as rows and campaign metrics as values for easy analysis.
Step 4. Set up automated refresh and performance tracking.
Schedule Coefficient to refresh your data every 3 days and create alerts for performance thresholds. Use conditional formatting to highlight high-performing 3-day periods and the snapshot feature to preserve period-over-period comparisons.
Analyze short campaigns with perfect granularity
Custom 3-day aggregation provides precise control over campaign analysis timeframes, enabling accurate performance measurement for weekend promotions, flash sales, and testing cycles. Start building your custom campaign analysis today.
