Supermetrics offers 4 advanced settings that can change the date base used for data pulled from HubSpot. These are designed to give users more control over how data is obtained.
|Contacts dates based on|
|Deal dates based on|
|Email dates based on|
Ticket dates based on
The option you choose will dictate both which date field is used to fetch data for the date range, as well as what the standard date-based dimensions (like Date, Year, and Month, for example) will use.
If you wanted your Deal data based on the Deal created date rather than Deal closed date, you would set Deal dates based on to "Deal created date". This means the date range selection will use the deal created dates to fetch the data set, rather that the closed date default, and the "Date" dimensions express the "Deal created date".
Enable the settings
- Looker Studio (formerly Data Studio): Click on any report element, and then click the HubSpot data source in the sidebar. Click Edit connection, and scroll down to Contacts dates based on to find the advanced date settings.
- Google Sheets: Open the Supermetrics sidebar. Open the Options menu and scroll down to Contacts date based on to find the advanced date settings.
- Excel: Open the Supermetrics sidebar. Open the Options menu and select the advanced date setting you want from the dropdown menu.