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

4 comments

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
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 02 Support.