HubSpot Segmentation Secrets: Mastering Custom Date Ranges for Smarter Retargeting

Hey there, ESHOPMAN readers! Ever found yourself scratching your head trying to pull a super-specific list of contacts in HubSpot, only to be frustrated by the 'Last 30 Days' or 'Last Year' options? You’re not alone. HubSpot’s segmentation tools are incredibly powerful, but sometimes finding that exact filter you need can feel like a treasure hunt. Luckily, the HubSpot Community is a goldmine of insights, and a recent discussion perfectly illustrates how a simple tweak can unlock a whole new level of precision.

We recently spotted a fantastic exchange in the HubSpot Community that tackles a common challenge: creating segments based on a precise, custom date range. This isn't just a minor technicality; for RevOps professionals, marketers, and anyone running an e-commerce operation, precise date-based segmentation is critical for effective retargeting, nurturing, and sales strategies.

The Challenge: Pinpointing Contacts in a Custom Date Window

The original poster in the community thread had a clear goal: they wanted to create a retargeting list for contacts stuck in a specific deal stage. The catch? They needed to filter these contacts based on a custom date range for their 'Last Activity Date' – something like 'January 2024 to December 2024'.

As many of you have probably experienced, when you dive into HubSpot’s segmentation builder for properties like 'Last Activity Date', the default relative date options are things like:

• Last 7 days
• Last 30 days
• Last 90 days
• Last year
• Last 365 days

While useful for broad strokes, these don't help when you need to target a very specific period, perhaps tied to a past marketing campaign, a seasonal sale, or a specific quarter for sales reporting. The original poster even shared a screenshot, showing these limited options:

The 'Aha!' Moment: Unlocking the 'Between' Filter

Thankfully, a helpful community member jumped in with the perfect solution, which was surprisingly simple once you knew where to look! The key lies in a dropdown menu that sometimes gets overlooked or is hidden by other interface elements.

Instead of relying on the relative date options, you can switch to a 'between' filter, allowing you to specify exact start and end dates. Here’s how to do it, step-by-step:

1. Navigate to your Contacts: In your HubSpot portal, go to CRM > Contacts.
2. Create a New List: Click 'Create list' in the top right. Choose whether it's an active or static list.
3. Add Your Filter: In the list builder, click 'Add filter'.
4. Select Your Date Property: Search for and select the date property you want to filter by, such as 'Last Activity Date', 'Create date', 'Deal close date', or any custom date property.
5. Find the Operator Dropdown: This is the crucial step! Look for the dropdown menu right above the relative date options (e.g., 'Last 30 days'). It usually defaults to something like 'is less than', 'is more than', or 'is any of'.
6. Choose 'is between': From this dropdown, select the 'is between' option.
7. Enter Your Custom Dates: Once 'is between' is selected, two date pickers will appear, allowing you to manually input your desired start and end dates for your custom range (e.g., January 1, 2024, to December 31, 2024).

The community member provided a visual aid to illustrate this exact point:

The original poster immediately confirmed this was the solution they needed, expressing their gratitude for the simple yet effective workaround!

Why This Matters for E-commerce and RevOps

For ESHOPMAN users, RevOps teams, and marketers leveraging HubSpot for their e-commerce business, this seemingly small detail is a game-changer. Here’s why:

• Precision Retargeting: Imagine you ran a specific holiday sale from November 15th to December 24th last year. With the 'between' filter, you can easily segment contacts who engaged with your store or made a purchase during that exact period. This allows for highly targeted follow-up campaigns this year, perhaps offering early bird access to new holiday deals.
• Nurturing Stalled Deals: The original poster's use case for contacts stuck in a deal stage is perfect. You can identify deals that haven't had activity between specific dates, indicating they might be stalled. This enables your sales team to re-engage with a personalized approach, perhaps offering a new resource or a check-in call.
• Seasonal Marketing Analysis: Want to understand customer behavior from a specific season or quarter in the past? This filter lets you pull data for precise date ranges, helping you analyze trends, campaign effectiveness, and customer lifetime value for particular periods.
• Targeting Customers from Specific Launches: If you've worked hard to add a storefront to HubSpot website and launched new products or collections at specific times, you can now segment customers who bought during those launch windows. This is invaluable for cross-selling, upselling, or gathering feedback.
• Audience Segmentation for Ads: Beyond email, these precise segments can be synced with ad platforms for highly targeted ad campaigns, ensuring your budget is spent reaching the most relevant audiences based on their past activity during specific times.

ESHOPMAN Team Comment

This community discussion perfectly highlights a common HubSpot 'gotcha' that, once solved, unlocks significant strategic advantages. We at ESHOPMAN believe that granular segmentation is non-negotiable for effective e-commerce and RevOps. The ability to precisely define date ranges means you're no longer guessing; you're building campaigns on solid, time-specific data. This simple tip empowers you to run much more impactful and relevant marketing and sales initiatives, especially when managing customer data flowing directly from your HubSpot-integrated storefront.

So, next time you're building a list in HubSpot and those relative date options just aren't cutting it, remember the 'is between' filter. It's a powerful, yet often overlooked, feature that can dramatically improve the accuracy and effectiveness of your segmentation. By mastering these small but mighty HubSpot functionalities, you're not just creating lists; you're building smarter, more responsive customer journeys that drive real results for your business.

Happy segmenting!