How to Set Up a Date Time Stamp for Column Enrichment in HubSpot

Cindy F. · 2025-01-28 15:21:00.023091+00

Hi all, im looking for a date time stamp to when the column / enrichment ran. Any ideas how to set this up, i wish to to stamp the date in Hubspot as to when last i enriched that row, but i need to reference a column and im struggling to get real time output.

How to Set Up a Date Time Stamp for Column Enrichment in HubSpot | Clay

9 comments

· Sorted by Oldest

Channeled
APP
·
·
Here's how to set up a timestamp for your enrichment updates in HubSpot: 1. Create a custom property in HubSpot called "Last Enrichment Date" to track when records are updated. 2. When mapping fields in Clay's Hubspot integration: • Ensure your date format follows Unix time set to midnight for CRM compatibility • Map the timestamp to your custom "Last Enrichment Date" property 3. The system will automatically update this timestamp whenever Clay updates or enriches the record, creating a closed-loop system that tracks data freshness.This timestamp can then be used to: ** Create dynamic lists based on enrichment age ** Track when data was last refreshed * Set up automated refresh cycles for records Sources: Keeping your CRM Up to Date With Clay [CRM Enrichment] - Clay University Hubspot integration overview | Documentation | Clay University Intro to CRM Data Enrichment [CRM Enrichment] - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Cindy F.
·
·
I need to know how to set up the date time stamp, which column to reference to give me this detail.
Owen C.
·
·
Hey Cindy, thanks for reaching out. You can do this by using a formula column and our AI formula generator to type what's shown below: Replace the "Run Zenrows Scrape" with the column you're hoping to monitor and capture the time it runs. Hope this helps! Give this a try and let me know how it goes. :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1355043678/7acefdd94dedd6381981c8dbab5c/CleanShot+2025-01-28+at+11_27_01%402x.png?expires=1738083600&signature=11a806f66ed9df560594da1f2f9a75b7977c36e6ba53a31fc1daa472a53b7a59&req=dSMiE8l6nodYUfMW1HO4zYCsoNZrW7vaZh3a6f16sqZ1itc80wxL%2BvKWSiUT%0A%2BHiU%0A
Jacob T.
·
·
Cindy F. I don't believe this is a native feature of Clay. We set up our own server to take care of this type of operation.
Owen C.
·
·
This is indeed a temporary workaround for now, as the ability to track which enrichments ran and at what time is on our roadmap. 😊
Cindy F.
·
·
great thank you will try this
Owen C.
·
·
Sounds good, let me know how it goes.
👍1
Channeled
APP
·
·
Hi Cindy F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Channeled
APP
·
·
Here's how to set up a timestamp for your enrichment updates in HubSpot: 1. Create a custom property in HubSpot called "Last Enrichment Date" to track when records are updated. 2. When mapping fields in Clay's Hubspot integration: • Ensure your date format follows Unix time set to midnight for CRM compatibility • Map the timestamp to your custom "Last Enrichment Date" property 3. The system will automatically update this timestamp whenever Clay updates or enriches the record, creating a closed-loop system that tracks data freshness.This timestamp can then be used to: ** Create dynamic lists based on enrichment age ** Track when data was last refreshed * Set up automated refresh cycles for records Sources: Keeping your CRM Up to Date With Clay [CRM Enrichment] - Clay University Hubspot integration overview | Documentation | Clay University Intro to CRM Data Enrichment [CRM Enrichment] - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Cindy F.
·
·
I need to know how to set up the date time stamp, which column to reference to give me this detail.
Owen C.
·
·
Hey Cindy, thanks for reaching out. You can do this by using a formula column and our AI formula generator to type what's shown below: Replace the "Run Zenrows Scrape" with the column you're hoping to monitor and capture the time it runs. Hope this helps! Give this a try and let me know how it goes. :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1355043678/7acefdd94dedd6381981c8dbab5c/CleanShot+2025-01-28+at+11_27_01%402x.png?expires=1738083600&signature=11a806f66ed9df560594da1f2f9a75b7977c36e6ba53a31fc1daa472a53b7a59&req=dSMiE8l6nodYUfMW1HO4zYCsoNZrW7vaZh3a6f16sqZ1itc80wxL%2BvKWSiUT%0A%2BHiU%0A
Jacob T.
·
·
Cindy F. I don't believe this is a native feature of Clay. We set up our own server to take care of this type of operation.
Owen C.
·
·
This is indeed a temporary workaround for now, as the ability to track which enrichments ran and at what time is on our roadmap. 😊
Cindy F.
·
·
great thank you will try this
Owen C.
·
·
Sounds good, let me know how it goes.
👍1
Channeled
APP
·
·
Hi Cindy F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: