HubSpot Reporting Hacks: Automating Anniversary Data for Year-Over-Year Comparisons

Keeping track of your e-commerce performance year-over-year is crucial, especially when comparing data based on customer anniversary dates. But manually updating report filters in HubSpot can be a real time-sink. What if you could automate those changes? That's exactly what one HubSpot user explored in a recent community discussion, and the solutions are pretty insightful.

The Challenge: Fixed Anniversary Dates in HubSpot Reports

The original poster wanted to compare this year's cumulative closed deal amount with the same period last year, focusing on data up to a specific anniversary date. The problem? The report filter used a fixed date, requiring manual updates to stay accurate. They asked if there was a way to automate this process within HubSpot.

The initial report filter was set up like this:

Date entered "Closed Won" anniversary is between Jan 1 (PST) and Mar 6 (PST)

This worked to show data between those anniversary dates, but it needed constant manual adjustment.

The Solution: Leveraging HubSpot Segments for Dynamic Filtering

A community member suggested using HubSpot segments as a workaround, and it turned out to be the perfect solution. While direct automation of report filters isn't currently a feature in HubSpot, segments offer a dynamic way to filter data based on relative dates.

Here's how the original poster adapted the segment filter:

• Original Approach (Fixed): Date entered "Closed Won" anniversary is between Jan 1 (PST) and Mar 6 (PST)
• New Approach (Dynamic):
  • Date entered "Closed Won" is more than 365 days ago (PST)
  • Date entered "Closed Won" is after 01/01/2025 (PST)

By using relative date filters within a segment, the report now automatically updates to reflect the desired year-over-year comparison without manual intervention. The user cleverly used "more than 365 days ago" to approximate "exactly one year ago" since a direct relative date option wasn't available for anniversaries.

Step-by-Step: Implementing the Segment-Based Solution

Here's how you can implement a similar solution for your own HubSpot reports:

1. Create a HubSpot Segment: Navigate to Contacts > Lists > Create list (choose "Active list").
2. Define Your Filters: Use the "Date entered 'Closed Won'" property (or the relevant date property for your use case).
3. Apply Relative Date Filters: Combine filters like "is more than X days ago" and "is after a specific date" to define your desired anniversary period.
4. Create Your Report: Build your report as usual, but instead of using date filters directly on the report, filter by membership in your newly created segment.

ESHOPMAN Team Comment

This HubSpot Community discussion highlights a common challenge: the need for more dynamic reporting options. The segment workaround is clever, but it also underscores the importance of understanding HubSpot's limitations and finding creative solutions. For e-commerce businesses using ESHOPMAN and HubSpot, this approach can be particularly valuable for tracking customer cohort performance over time. We hope HubSpot will add more flexible relative date filters in the future to simplify this process.

This approach, while a workaround, demonstrates the power of combining different HubSpot features to achieve your desired reporting outcomes. It’s a great example of how understanding segments can unlock more dynamic and automated insights, especially for year-over-year comparisons. So, next time you're wrestling with fixed date filters, remember the segment solution!