Target New and Existing users from a certain date in a workflow

Hi, We are looking for help with our problem sending to not only new users from a certain date but also those users who came in again on that date but already existed.

Problem:

We are trying to send a daily text using the Slicktext integration to everyone who filled out our form 31 days ago, The issue is we can’t seem to account for every user using (createdate) as everyday we have 1-2k people who has previously submitted before and is thus already in hubspot so it just updates their record. We tried using (lastmodifieddate) as the enrollment criteria that still wasn’t getting the right number as I was told via support. That variable is very flimsy and shouldn’t be used as a number of events will change lastmodified date example: leaving a workflow, entering a workflow, adding to a list.

Evidence:

The workflow when I switch the enrollment criteria from ‘createdate’ to ‘lastmodifieddate’ is still not producing the number I’d expect. If I look at just my contacts and look at lastmodified 31 days ago so Jan 12 I get 1564 records but my workflow says its going to send 744 sends tomorrow?

If I look at created date is 31 days ago in contacts I get: 1,577. Neither of these match the 744 that look to be queued up to be sent tomorrow.

Question:

Is there a better way to accomplish being able to grab everyone 31 days ago who either entered fresh and those whose status were updated on that day? Is there a hubspot object suited for this? Do we need to create our own (lp_lastmodified) field so that only we update it and exiting workflows and lists wont impact it?

Hi @BHenry86,

Thank you for reaching out to the Community!

I would like to invite our subject matter experts to this conversation.

Hi @himanshurauthan, @rikkilear, @Josh - Do you have any workflow suggestions for @BHenry86?

Thank you!

Best,

Kristen

Hello @BHenry86
According to my knowledge and understanding, i think you’re trying to create a workflow in HubSpot that targets both new users and existing users who submitted a form on a specific date. However, you’re having difficulty determining which criteria to use as the enrollment criteria in the workflow.
Here are a few suggestions that might help:
1. Use a custom property to track the date that the form was submitted: One way to solve this problem is to create a custom property in HubSpot and use it to track the date that the form was submitted. You can then use this custom property as the enrollment criteria in your workflow.
To create a custom property, go to your contacts settings and select “Properties.” Then, click “Create a property” and choose “Date picker” as the property type. Give the property a name that describes its purpose (e.g., “Form Submission Date”). Then, make sure to update this property for both new and existing contacts whenever they submit a form.
Once you have this property set up, you can use it as the enrollment criteria in your workflow.Set the enrollment trigger to “Contact property” and choose the custom property you just created. Then, set the date range to “exactly 31 days ago.” This should ensure that the workflow targets all contacts who submitted the form exactly 31 days ago, regardless of whether they were new or existing contacts.
2. Use a combination of enrollment triggers: Another way to approach this problem is to use a combination of enrollment triggers in your workflow. For example, you could set up two enrollment triggers: one based on the “Created date” property and another based on the custom property you just created. This way, the workflow will enroll both new contacts who submitted the form 31 days ago and existing contacts who had their “Form Submission Date” property updated on that date.
To set this up, go to the enrollment criteria section of your workflow and click “Add enrollment trigger.” Then, choose “Contact property” and select the custom property you just created. Set the date range to “exactly 31 days ago.” Next, click “Add another enrollment trigger” and choose “Created date.” Set the date range to “exactly 31 days ago” as well. Make sure to set the enrollment trigger to “All” so that contacts need to meet both criteria to enroll in the workflow.
3. Use a combination of filters and actions: If neither of the above options work, you could also try using a combination of filters and actions to achieve your desired outcome. For example, you could create a list of contacts who submitted the form exactly 31 days ago using the custom property you created earlier. Then, you could use this list as the starting point for a workflow that sends a text message to these contacts.
To set this up, go to the “Contacts” section of HubSpot and click “Lists.” Then, click “Create list” and choose “Contacts who have a specific date property” as the criteria. Select the custom property you created earlier and set the date range to “exactly 31 days ago.” Save the list and name it something descriptive (e.g., “Form Submissions 31 Days Ago”).
Next, go to the “Workflows” section of HubSpot and create a new workflow. Use the “List membership” enrollment trigger and choose the list you just created as the starting point. Then, add an action to send a text message to these contacts. Make sure to set up the text message properly and test it before activating the workflow.
Note: there are several ways to approach this problem, and the best solution may depend on your specific use case and data structure. However, using a custom property or a combination of triggers and filters should help you achieve your desired outcome.
Thanks & Regards
Himanshu Rauthan