)
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 reporting tools can’t dynamically calculate cumulative revenue for ongoing flights because they lack the ability to perform running totals based on current date progression through flight periods.
Here’s how to build real-time cumulative revenue tracking that automatically updates as campaigns progress and shows exactly how much revenue has been earned to date.
Build dynamic cumulative revenue tracking using Coefficient
Coefficient enables sophisticated cumulative revenue tracking through dynamic calculations that HubSpot ‘s static reporting simply can’t achieve. You can create formulas that automatically calculate earned revenue based on flight progress and current date relationships.
How to make it work
Step 1. Import active flight data.
Use Coefficient to pull HubSpot line items with flight dates, total values, and deal information into your spreadsheet. This provides the foundation for cumulative tracking calculations.
Step 2. Create cumulative revenue formulas.
Build this formula to calculate earned revenue to date: =Total_Flight_Revenue * (MIN(TODAY(), Flight_End) – Flight_Start + 1) / (Flight_End – Flight_Start + 1). This automatically calculates how much revenue has been earned based on flight progress.
Step 3. Add running totals and progress tracking.
Create columns for daily cumulative totals using SUMIF functions that aggregate across all active flights. Add completion percentage tracking: =(TODAY() – Flight_Start + 1) / (Flight_End – Flight_Start + 1) capped at 100%.
Step 4. Set up historical snapshots and alerts.
Use Coefficient’s snapshot feature to capture daily cumulative totals for trend analysis. Configure automated alerts when flights reach revenue milestones like 25%, 50%, or 75% completion.
Step 5. Configure daily refresh schedule.
Set up automatic updates so cumulative totals increase daily as flights progress. This ensures your revenue tracking always reflects the most current campaign performance without manual intervention.
Get real-time revenue visibility
This provides real-time visibility into revenue accumulation that updates automatically, something HubSpot’s static reporting cannot achieve for ongoing campaign performance tracking. Build your cumulative tracking system today.
