It would be beneficial to have Date stamp & Time stamp (system time, eg. YYYY-MM-DD & HH:MM) as available properties in Hubspot. So that one can pick date or time stamps to use in snippets or workflows.
👋Hi all, I'm Rachel from the HubSpot Product team. An update - we are now in public beta for 'Create Datetime properties in HubSpot,' which allows you to create custom Datetime properties. You can opt into the beta underProduct Updates. A few notes:
When viewing and editing this property, a user’s current time zone will be used. This is based on the time zone set on their device.
When filtering with this property, your account’s time zone will be used by default.
Any custom datetime properties that had been created via a Support request / via API will now display Date & Time.
‘Date’ properties whose field type can be edited can now be converted to ‘Date and Time.’
Datetime properties will be displayed as Date in the Forms Editor. Datetime properties are notyetsupported in the new Forms Editor.
Absolutely agree. I have been trying to figure out how to export a report that shows the time between sign-up and sales contact, and it looks like we're going to have created a convoluted API property. I mean, the time is already measured in the backend... why can't we report on that?
Fully agree, this is useful to track time from a lead status change to the contact. Using last contacted can give the impression this time is very long if multiple contacts are done
one of the KPI's we'd like to measure is the amount of time that passes from when a new lead comes in - to when the sales rep calls/emails/logs an activity. This would be tremendous.
This is also something I'd like to measure. Date stamps aren't sufficient as we want to measure time from form submission to first contact, which is often under an hour.
Totally agree about the necessity for time stamps, especially on ticket submissions. For larger CX/service teams, identifying popular ticket submission trends by time of day is critical for determining staffing and schedules in order to enhance the customer experience.
Yes please!!!! This is insane guys. I was looking at past years' data to subtract trial-submission datetime from first time pricing-page viewed datetime, and there's no TIME in the pricing-page property!!!!!