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.
| Advanced setting | Options |
|---|---|
| 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.
Example
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
- Google Sheets: Open the Supermetrics sidebar and find the HubSpot query. Open the Options menu and scroll down to find the advanced date 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 find the advanced date settings.
- Excel: Open the Supermetrics sidebar. Select a cell with HubSpot query data and click Modify in the sidebar. Open the Options menu and scroll down to find the advanced date settings.
- Power BI: Open the query list on the Supermetrics Hub and select a HubSpot query to modify. In the sidebar, click Options and scroll down to find the advanced date settings.
- The Supermetrics API (Query Manager): Select a HubSpot query to modify. In the sidebar, click Options and scroll down to find the advanced date settings.
- Data warehouse: On the Transfers page on the Supermetrics Hub, select a HubSpot transfer. Click the 3-dot icon and select Edit transfer. Scroll down to find the advanced date settings.
- BigQuery (marketplace): Select the HubSpot transfer to modify and click Edit. Under Third party connection, click Change configuration. Click Continue to see the transfer configuration in a new window. Advanced date settings are under General settings. Make your changes and click Submit and then Save to save the new settings.