)
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 native reports limit you to predefined date ranges and don’t allow custom selectors that stakeholders can adjust without rebuilding the entire report each time they want to analyze different time periods.
Here’s how to create truly interactive marketing source reports with dropdown time frame selectors that update your deal data automatically.
Build interactive time frame selectors for deal attribution using Coefficient
Coefficient’s dynamic filtering feature lets you create dropdown cells in your spreadsheet that control the time frame for your HubSpot deals import. When users change the selection, the report updates to show closed won deals for that specific period without needing to modify filters in HubSpot’s interface.
How to make it work
Step 1. Create dropdown selectors for time frame options.
Set up a dropdown cell with options like “Last 30 Days,” “This Quarter,” “Year to Date,” and “Custom Range.” Use data validation to create the dropdown list and place it prominently at the top of your report where stakeholders can easily access it.
Step 2. Build calculated date cells that respond to your dropdown.
Create “Start Date” and “End Date” cells that populate based on your dropdown selection using IF statements and date functions. For example, IF(A1=”Last 30 Days”, TODAY()-30, IF(A1=”This Quarter”, start of current quarter)). These calculated dates will feed into your Coefficient import filters.
Step 3. Configure your deals import to reference the calculated dates.
Set up your Coefficient import with filters for “Deal Stage = Closed Won” and “Close Date” within your calculated date range. Use dynamic filtering to reference your “Start Date” and “End Date” cells so the import automatically adjusts when users change the dropdown selection.
Step 4. Add refresh controls for stakeholder convenience.
Enable Coefficient’s on-sheet refresh button so users can update the data after changing their time frame selection. You can also set up scheduled refreshes to keep the data current, or use manual refresh for more control over when the data updates.
Give stakeholders the control they need
Interactive time frame selectors transform static reports into dynamic analysis tools that stakeholders can adjust themselves without technical assistance. Start creating interactive deal attribution reports that adapt to any time period.
