-
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
![](https://images.forcetalks.com/wp-content/uploads/2018/06/25080808/salesforce-summer-release-700cp1.png)
Salesforce Summer ’18 Release - Key Points
Three times per year, Salesforce release a new version of their products, full of new and exciting features. The first and second weekend of June…
![](https://images.forcetalks.com/wp-content/uploads/2024/06/03102010/sa_1717409872sdg%201.jpg)
Salesforce Health Cloud for Dermatology Practice Management
In the ever-evolving landscape of healthcare, technology is critical to enhancing patient care and streamlining practice management. This is particularly true for dermatology practices as…
![](https://images.forcetalks.com/wp-content/uploads/2020/07/07101447/sa_1594116743TitleImageResizedcompressor.png)
Time for Your Salesforce Checkup
When was the last time you had the annual checkup? What about a Salesforce Checkup? Maybe it has been a few years since your company…
Popular Salesforce Videos
How to Connect to External Data | Salesforce
An external data source specifies how to access an external system. Salesforce Connect uses external data sources to access data that's stored outside your Salesforce…
Salesforce Mobile Publisher Demo
With Salesforce Mobile Publisher, you can create pixel-perfect mobile applications for employees, customers, and partners. Check out this video and learn all you need to…
Driving Gamified Interactions on Salesforce Communities With ScoreNotch | Use-Cases
A Salesforce-native, Lightning-ready solution, ScoreNotch enables you to dynamically gamify Salesforce communities. Watch this video to learn more about its use-cases. For more, please visit…