Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Identifying Last Activity Date Equivalent in Hubspot Import Clay Table | Clay

Identifying Last Activity Date Equivalent in Hubspot Import Clay Table

·Dec 05, 2025 02:11 PM·

which of these datapoints resembles the Hubspot property last activity date in this Hubspot import clay table

Loading attachments

7 comments

· Sorted by Oldest

Clay Support
APP
·
·
Hs Last Sales Activity Timestamp is your closest match to HubSpot's "last activity date" property. [1]
This field captures the most recent sales activity timestamp (2024-05-06T09:26:20.837Z in your case), which aligns with HubSpot's general "last activity date" tracking. [2]
The other fields are more specific - email activities, notes, or analytics - rather than the comprehensive activity tracking that "last activity date" typically represents.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help understanding the HubSpot import data points or have more questions about your table, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?
Emile v.
·
·
dates seem a bit odd dont you think?
Loading attachments
Clay Support
APP
·
·
You're absolutely right - those 1970-01-20 dates are problematic. That's the Unix epoch date, indicating missing or null values in HubSpot that Clay is interpreting as zero timestamps.
To fix this, use our Format Date/Time formatter to normalize these dates. Select Unix Timestamp as your output format and keep the column type as text to avoid formatting issues. [1] [2]
This will clean up those odd epoch dates and make your data more reliable for analysis.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with cleaning up or understanding the date data in your HubSpot import, I’m here to assist. Would you like to share more about what you’re trying to resolve or any specific issues you’re encountering?