-
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
Learn About Users Permissions and Access in Salesforce
1. User Permissions User permissions determine what tasks users can perform and what features users can access. For example, users with the “View Settings and…
Guide to Install an App from AppExchange
Thank you for your interest in knowing how to install apps from AppExchange for Salesforce. Use my blog as a guide, it will help you…
Trends to watch in Cloud Computing – 2017
Over the past few years, ease of access and enhanced security features has made cloud to attain great popularity. As a result of which, today,…
Popular Salesforce Videos
Dynamic Forms in Salesforce
Hello Everyone, in this video, we will talk about what the dynamic form is and how to work with the dynamic form in Salesforce. Watch…
Algoworks is Now a Salesforce Gold Partner
Being just a registered partner back in 2013, the journey to striking Gold in 2020 has been long. On the way to getting that Gold,…
5 Reasons To Choose Marketing Automation For Your Business | Salesforce
With the advancement in technology, it has become imperative to move towards more advanced methods to grow your business. Marketing automation is one method that…