-
How to create a report in Salesforce which will achieve following goals?
Hi all. I'm a SF admin but only because no one else in my organization is. I'm not a developer. I would like to create a report which will:
- Generate itself daily at a scheduled time, say 8:00am, my time.
- Randomly select 10 accounts with contact name, phone number, all notes associated with the account.
- Will not select any account more than once until all accounts have been reported.
- The account must be a prospect, not a customer.
- The account must not have recorded any activity within the previous 60 days.
- Keep track of the dates & accounts reported.
The goal here is to keep up with prospects regularly but not too often. The challenge is to get the date reporting correct. For example, if the report shows Acme, Inc today & Acme, Inc. was created 61 days ago then I shouldn't see Acme, Inc. again until all of the accounts which meet the criteria have been reported to me.
Thanks for your ideas in advance.
Steve?
Log In to reply.
Popular Salesforce Blogs

9 Tips to Keep Your Data Secure in Salesforce
The increase in remote working and reliance on automation makes many businesses make extra efforts to enhance the Salesforce security. Cybercriminals are on the rise…

How to Plan and Execute Successful Salesforce Lightning Migration
In the competitive business landscape of today, staying ahead requires embracing innovation and leveraging the latest technology to enhance productivity and customer satisfaction. For organizations…

To Do Checklist Before Code Commit In Production
TO DO CHECKLIST BEFORE CODE COMMIT IN PRODUCTION Proper commenting in code (Test Class, Apex Class, Trigger, Vf page), if you modified or create new…
Popular Salesforce Videos
What can Salesforce Service Cloud do for your Businesses
Salesforce Service Cloud allows you to Streamline Workflow, Automate Service Processes, and Surface Key Topics, Articles, and Experts to transform the agent experience. It simplifies…
Web Chats In Salesforce | Service Cloud | Kanika Chauhan
Salesforce Web Chat (previously known as Salesforce Live Agent) is a feature that allows customers to communicate with the company via the web through instant…
Salesforce Spring ’20 Release - Our Top 10 Features
The Salesforce Spring ’20 release is just around the corner - so it’s time to get ready for some great new features. Here's our top…