Home
Events
Groups
Members

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

University
Clay live events

Powered by Tightknit

Add Current Date on Row Refresh for Scoring Data in CRM

·

·

How can I add the current date when a row gets refreshed? I have a table with scoring data and I want to pass the date of that refresh to the CRM and also put it in a scoring summary in a Clay field

Add Current Date on Row Refresh for Scoring Data in CRM | Clay

4 comments

· Sorted by Oldest

Channeled
APP
·
·
Here's how you can track refresh dates and include them in scoring: 1. Use the "Format Date/Time" formatter to capture the current date when a row is refreshed. 2. You can include this date as part of your scoring criteria using the "Score Row in Clay" feature, which allows you to incorporate multiple scoring criteria (up to 15) into your evaluation. 3. For CRM integration, you can implement a "Last Enrichment Date" field in your CRM. This is a recommended best practice that helps track when records were last updated. 4. When the data is refreshed, Clay will automatically update this Last Enrichment Date in your CRM, creating a closed-loop system that maintains data freshness tracking.This approach ensures you have visibility into refresh dates both in Clay and your CRM, while also incorporating this information into your scoring logic. Sources: Keeping your CRM Up to Date With Clay [CRM Enrichment] - Clay University Intro to CRM Data Enrichment [CRM Enrichment] - Clay University Score Row in Clay with Clay Format Date/Time with Clay Formatters
Andreas W.
·
·
This works but doesn’t update ofc
Loading attachments
Andreas W.
·
·
https://app.clay.com/workspaces/271254/workbooks/wb_CVbFZ7aDfyxq/tables/t_PuZ3bf6FCqxr/views/gv_b6RfqYotW9X5
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.