)
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 create accurate month-over-month flight revenue comparisons because they lack the ability to properly distribute flight revenue across months and perform period-over-period calculations with prorated amounts.
Here’s how to build comprehensive month-over-month analysis that accounts for actual flight activity and revenue recognition timing, providing accurate trend analysis.
Build accurate month-over-month comparisons using Coefficient
Coefficient enables sophisticated month-over-month flight revenue comparison through advanced calculations that HubSpot ‘s standard reporting simply can’t achieve. You can create comparisons that properly account for flight timing and revenue distribution across periods.
How to make it work
Step 1. Import historical flight data.
Import HubSpot line items with flight dates and revenue using Coefficient, including historical data for comparison periods. This provides the foundation for accurate period-over-period analysis.
Step 2. Distribute revenue by month.
Create formulas that distribute each flight’s revenue to the appropriate months based on actual flight days per month. This ensures your comparisons reflect actual campaign activity rather than simplified monthly estimates.
Step 3. Build comparison calculations.
Create month-over-month formulas: =(Current_Month_Revenue – Previous_Month_Revenue) / Previous_Month_Revenue. Add year-over-year tracking: =(This_Year_Month – Last_Year_Month) / Last_Year_Month for deeper trend analysis.
Step 4. Add flight count and trend analysis.
Track number of active flights per month alongside revenue for deeper insights. Use Google Sheets charts that update automatically with Coefficient data refreshes to visualize trends over time.
Step 5. Set up automated reporting and snapshots.
Create pivot tables that automatically group revenue by month and calculate percentage changes. Capture month-end data using Coefficient snapshots to maintain accurate historical comparisons. Set up automated monthly reports that email stakeholders with comparison analysis.
Get accurate revenue trend analysis
This creates comprehensive month-over-month analysis that accounts for actual flight activity and revenue recognition timing, providing accurate trend analysis that HubSpot’s standard reporting cannot achieve. Build your comparison reports today.
