Jul 28, 202110:10 AM - edited Jul 28, 202110:11 AM
Random Value for contact properties
Hello Guys, thanks for the update / infos on this. Not the most satisfiying answers 🙈.
So we bought the Enterprise Edition of HubSpot in December and therfore the Operations Hub wasn't included unfortunately. And I also have to say the pricing here doesn't really make sense for us. We almsot have all the features the Operations Hub provides exept for the Custom Code and the connection to other tools. And to pay just for these 2 features 700 € a month extra is extremely high, especially if we already pay for enterprise.
Zapier could be a solution but since we have a lot of contacts in HubSpot Zapier could become even more pricey.
What i want to do is bascially have some sort of A/B testing in workflows since HubSpot also doesn't offer a split audience functionality in the workflows. So everytime a contact is crated a property either gets Label A or Label B. This would then be used to separate these contacts in Workflows and A/B Test.
Also the next benefit is that we currently can't connect workflow analytics to our BI Tool Looker. We only can do this with Contact Analytics. So there we could at least extract this property with the random value and see the analytics in Looker with or other KPIs.
I hope you understand why this is important to us.
This is definitely more complicated to achieve than it should be, I agree. There are a few ways you could approach this.
You can achieve the same effect by using the Zapier integration, sending contacts to a Google Sheets, assigning them a random number there and pulling that information back into HubSpot. Not as neat but it would work.
Another odd way for doing this that was first suggested to me by a HubSpot support rep a while ago is by leveraging the "Rotate objects between multiple owners" action in workflows. You would first create a new custom HubSpot user type property, and then rotate your records between two users within this new property. HubSpot assigns these randomly. If a record is assigned to the first user, you could label it as A, if it is assigned to the second user, you could label it as B. The obvious downside of this workaround are the notifications sent to these owners or the fact that Sales Pro seats are needed.
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
@PhilZ87 - Great question. So first off, this can be ultimately accomplished in Operations Hub. Assuming you don't have it, then a workflow that triggers the creation and then chooses the values by some other default could work. The problem is that it would be systematic and not random.
An alternative would be to build it in Integromat or Zapier and find a "Random" function that could parse your selected values.
If you can tell me more about your use case I could probably help you find a better solution.
Hope this helps.
✔️ Was I able to help answer your question? Help the community by marking it as a solution.