topic Re: How to create report or dataset on all custom events (not just 5 years) in Data Hub

How to create report or dataset on all custom events (not just 5 years)

cyberwombat — Wed, 11 Jun 2025 19:31:37 GMT

Client wants to know how many entries for example of a custom event (lets call it Purchase) over the entire history. Is there a workaround to the 5 year range limit that could be used (merging datasets in reports etc). Not super useful if we cannot get historical data (fiy we have too much data for custom objects for HS to handle).

Re: How to create report or dataset on all custom events (not just 5 years)

VPathania — Thu, 12 Jun 2025 10:38:44 GMT

HubSpot’s native reporting does impose a 5-year limit for custom event data (like your "Purchase" event), but here are proven workarounds to analyze complete historical data:

Option 1: Segment & Export Time-Based Datasets (HubSpot-Only)
Best for: Quick, one-off analysis without external tools.

Create multiple reports/datasets covering 5-year chunks (e.g., 2015–2020, 2021–2025).
Export each to CSV (Reports → Export).
Combine offline using:
Excel/Sheets: Use Power Query or ={IMPORTRANGE()} to merge files.
Python: Automate with pandas.concat([df1, df2]).

Limitation: Manual effort; no real-time updates.

Export Data via API - Use the Custom Behavioral Events API to extract all historical event data (beyond 5 years). Once exported:

Store it in a data warehouse or external system (like BigQuery, Snowflake).
Use a BI tool (like Power BI or Tableau) to analyze and visualize long-term trends.

I’ll recommend submitting this as an idea in the HubSpot Community to request a product update.

Re: How to create report or dataset on all custom events (not just 5 years)

Jaycee_Lewis — Fri, 13 Jun 2025 03:33:47 GMT

Thanks @VPathania 🙌 Here the link to the Ideas Forum. — Jaycee

Re: How to create report or dataset on all custom events (not just 5 years)

cyberwombat — Fri, 13 Jun 2025 04:19:14 GMT

Thanks for the suggestions but will not work for my use case. The data is in the many millions making CSVs not practical and the client wishes the reports to be within HS as there are a lot of associations and other things related.