Automating Repeat Purchase Predictions in HubSpot Using Order History

Hi HubSpot Community,

I’m trying to figure out how to analyze and automate repeat purchase behavior for my contacts within HubSpot. Specifically, I want to leverage historical order data to predict when a customer is likely to place their next order so my team can reach out proactively, without manually going through each contact’s purchase history to calculate averages.

Here’s what I’m trying to achieve:

  1. Tracking Historical Orders/Deals:

    • I want to pull data from HubSpot to track when each customer placed orders in the past. For example, if a customer has consistently ordered every March and September for the past few years, I’d like HubSpot to identify this pattern.
  2. Predicting Future Purchases:

    • Based on the historical order data, I’d like HubSpot to predict when a customer is likely to place their next order (e.g., a task or alert generated when a customer is likely to order again in September based on their past behavior).
  3. Automating Tasks and Alerts:

    • I’m looking for a way to have HubSpot automatically create tasks or display reminders when a customer is likely to place their next order, so my sales team can follow up proactively. This would be something like: “Follow up with [Customer] — Likely to place order in September.”
  4. Custom Workflows and Automation:

    • How can I set up workflows in HubSpot that automatically generate reminders based on repeat purchase patterns? I want to automate this process, so I don’t have to manually calculate when customers are likely to reorder.
  5. RFM Analysis Concerns:

    • I’ve considered using RFM (Recency, Frequency, Monetary) analysis, but I’m not sure if it would work well for my specific needs. As I understand it, RFM gives a numerical score to assess customer behavior, but it doesn’t specifically help me predict when a customer is likely to place their next order. I’m really focused on the timing of future orders, so my team can reach out to the right customers at the right time. Does anyone have experience using HubSpot to build something that can predict order timing based on past behavior, rather than just scoring customer engagement?
  6. Segmentation and Reporting:

    • How can I segment customers based on their order timing so we can focus on high-potential leads? I want to create reports that show when each customer is most likely to order again, rather than just looking at frequency and monetary value.
  7. Best Practices:

    • Does anyone have tips or best practices on how to set this up effectively? I’m specifically interested in making the process scalable and efficient so my team can engage with leads without having to manually sift through historical purchase data.

I’d really appreciate any insights or examples of how you’ve automated repeat purchase tracking and predictions for future orders within HubSpot. Thanks in advance for your help!

Hi @matthew44589! That sounds like a big, robust system. Kudos to you to thinking through it and laying it out so well.

I googled this and came back with this hit:

Improve forecasting with AI projections (BETA)

Oct 18, 2024 — In HubSpot, you can use Breeze, HubSpot’s AI, to project future sales based on closed won deals in the past three months.

Improve forecasting with AI projections (BETA)

Looks like HubSpot might be working on this. I would also check out the Marketplace to see if there’s a partner who already has a solution in place.

@matthew44589, did you ever find a solution?
I’ve built similar campaigns and workflows in Salesforce. I’m new the Hubspot ecosystem and interested in doing something similar. Here’s how I approached it in the past:
1. Calculate Average Days Between Orders (Data Setup) for customers with at least 3 purchases.

  • Look at all historical orders for the customer and calculate average number of days between orders.

2. Automate Segment when Outside Normal Pattern

  • Segment Trigger**:** When the calculated “Days since last order” property exceeds the “Average days between orders” property by a certain percentage.

3. Action: automate series of emails and notifications for sales to call customer
We had great success; reduced our 120-day churn rate by 10%.
Do I need Hubspot’s data sku for this or can I use formula’s / calculated fields? I have orders all intergrated into Hubspot.

Hey there @LBodkin! Thank you for your question!

I found this Knowledge Base article that helps answer your questions:

I also want to tag a few community experts for more ideas. Hey there @Crystal_Hopper @SteveHTM @webdew I hope you’re having a great week! Any additional insights here?

Thanks

Victor