Clay Icon

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

ยท
ยท

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.

  • Avatar of Channeled
    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

  • Avatar of Channeled
    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!

  • Avatar of Cindy F.
    Cindy F.
    ยท
    ยท

    I need to know how to set up the date time stamp, which column to reference to give me this detail.

  • Avatar of Owen C.
    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

  • Avatar of Jacob T.
    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.

  • Avatar of Owen C.
    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. ๐Ÿ˜Š

  • Avatar of Cindy F.
    Cindy F.
    ยท
    ยท

    great thank you will try this

  • Avatar of Owen C.
    Owen C.
    ยท
    ยท

    Sounds good, let me know how it goes.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Cindy F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: