-
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
Notes on Importing Data | Salesforce Developer Guide
Required Salesforce Editions It is available in Salesforce Classic (not accessible by and large association) and Salesforce Lightning Experience both. Your Salesforce version figures out…
How the Healthcare Industry Is Using Salesforce to Stay Ahead
The healthcare landscape is evolving rapidly, driven by new technologies, patient expectations, and the demand for connected care experiences. To keep pace, healthcare organizations are…
Salesforce ERP Integration, a Successful Combination
There are two types of systems whose implementation favors increased efficiency in the business processes of any company, these are: Customer Relationship Management (CRM) systems…
Popular Salesforce Videos
Reassign Leads using Lead Assignment Rule on Update/Upsert | Salesforce Tutorials | #SalesforceBolt
In this vlog, we will do some work around Assignment Rules. As you are aware Assignment Rule can be trigger on Insert actions. Either it…
Get Started With Empowering Your Sales Users in Salesforce Pardot
This Get Started With Empowering Your Sales Users in Pardot series will help your sales reps sell more and save time with Pardot features. The…
Prepopulate Field values in Salesforce Lightning Experience Using defaultFieldValues
Prepopulate Field values in Lightning Experience Using defaultFieldValues - Spring 20 This video demonstrates the following items: Set Record Type Id Using defaultFieldValues Enforce User…