HubSpot’s reporting tools can’t determine if a line item’s flight is “active today” because they lack dynamic date comparison functions that reference the current date in real-time.
Here’s how to create a system that automatically identifies which flights are currently running and updates daily without manual intervention.
Track active flights with dynamic date formulas using Coefficient
Coefficient solves this limitation by connecting your HubSpot line items to spreadsheets where you can build dynamic formulas that automatically identify active flights. This creates real-time visibility that HubSpot alone simply can’t provide.
How to make it work
Step 1. Import flight data from HubSpot.
Connect your HubSpot line items including flight start dates, end dates, and associated deal information to your spreadsheet via Coefficient. This gives you the raw data needed for active flight identification.
Step 2. Create the active flight formula.
Use this formula: =IF(AND(TODAY()>=Flight_Start, TODAY()<=Flight_End), "Active", "Inactive"). This automatically compares today's date against each flight's start and end dates to determine current status.
Step 3. Set up filtering and alerts.
Apply filtering to show only active flights, or use your spreadsheet’s filtering on the “Active” column. Configure Coefficient alerts to notify you when flights become active or end, so you never miss important campaign transitions.
Step 4. Schedule automated daily updates.
Set Coefficient to refresh this data daily. Your active flight status will update automatically as campaigns start and end, ensuring your dashboard always reflects current campaign activity.
Never miss an active campaign again
This creates a dynamic dashboard that updates automatically, giving you real-time visibility into revenue-generating campaigns. Build your active flight tracker today.