-
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
Salesforce Configuration Vs Salesforce Customization and Their Best Practices
What Is Configuration In Salesforce? Salesforce design is everything you can do inside the CRM framework. This implies you can add another field to your…
How To Set Up Your Company in Salesforce
Use the corporate Information page in Setup to trace what’s important about your company’s organization in Salesforce. you'll also manage your licenses and entitlements. This…
Popular Salesforce Videos
Introduction To Salesforce | Salesforce Training Videos For Beginners
Are you confused to choose the best edition tool? For CRM and Branding then here is the information for you! Salesforce is one of the…
Which Salesforce Certifications are Really Important?
If you really want to know which Salesforce certifications are really important then this video is for you. If you have any doubts or concerns,…
Einstein Analytics – Release Readiness, Spring '18
Discover the new and exciting features that you can expect from Einstein Analytics in the Spring '18 Release. These include: - a new enhanced explorer…