Download Macros to improve your Data

Take your data to the next level

Back to Macro Library

Set Account Rating Based on Recent Activity

Object: Account, Field: Rating
DataQuality
Account
Enrichment

This macro dynamically updates the Account Rating field on Account objects using predefined conditions tied to the Last Activity Date.

  • Hot: Last activity occurred today.
  • Warm: Last activity occurred between 1 and 7 days ago.
  • Cold: Last activity occurred more than 7 days ago.

This flexible macro can be executed in multiple ways—manually, in batches, triggered by specific actions, or scheduled to run periodically. This allows users to customize how and when the field is updated to best align with their workflows and operational needs. By ensuring the Account Rating field remains current, the macro helps sales and customer success teams effectively prioritize follow-ups, enhance account management, and improve data accuracy.

By integrating into Salesforce Flows, triggers, or scheduled jobs, the macro provides a seamless, automated way to keep account data up to date, empowering users to stay on top of their accounts in real-time.

Download
Set Account Rating Based on Recent Activity

Automatically updates the Account Rating field (“Hot,” “Warm,” or “Cold”) based on the Last Activity Date, ensuring accounts are accurately prioritized and consistently updated according to user preferences.

Download Macro
Specifications
  • Object: Account
  • Field: Rating
  • Based on action: Mass Update

Learn how to import a Macro