)
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.”
NetSuite saved search exports to Google Sheets with custom date range parameters work by configuring date criteria within the NetSuite saved search itself, using relative dates that update automatically with each refresh.
This approach creates dynamic date filtering that stays current without manual intervention, though the date logic is controlled in NetSuite rather than Google Sheets.
Set up dynamic date ranges with Coefficient
Coefficient imports NetSuite saved searches with all date criteria defined within the saved search itself. The system respects relative date options like “This Month” or “Last 30 Days” that update automatically with each refresh.
How to make it work
Step 1. Configure date criteria in NetSuite saved searches.
Define date filters within your NetSuite saved search using relative date options like “This Month,” “Last 30 Days,” or “Quarter to Date.” These relative dates update dynamically, so “Yesterday” changes daily and “This Fiscal Year” updates with your fiscal calendar.
Step 2. Create multiple saved searches for different date ranges.
Build separate saved searches for different time periods: “Sales – Current Month,” “Sales – Previous Month,” and “Sales – YTD.” Import each to different tabs or ranges within Google Sheets with appropriate refresh schedules.
Step 3. Use SuiteQL queries for truly dynamic parameters.
For more flexible date filtering, use Coefficient’s SuiteQL Query feature with custom date parameters:. This allows more control but requires SuiteQL knowledge.
Step 4. Align refresh scheduling with date range granularity.
Schedule daily refreshes for “Yesterday” or “Today” searches, weekly refreshes for “Last Week” searches, and consider time zones for accurate date cutoffs. Document date logic in Google Sheets for other users.
Keep your date ranges current
Well-designed NetSuite saved searches with relative date options combined with strategic refresh scheduling provide flexible date-based reporting that automatically stays current. Start building your dynamic date reports today.
