-
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
Introduction and How to Use Postman | Salesforce Developer Guide
Introduction Postman is a computer application it is used for testing APIs (Application Programming Interfaces). Postman sends an HTTP request to the webserver and receives…
Strategies for Finding Your Salesforce Training Plan
The company and staff should know why Salesforce is vital. After training, don’t presume that the why is the exact same for all classes. Senior…
Salesforce Nonprofit Cloud for Fundraising
Nonprofit organizations need efficient means to raise funds so they can focus on advancing their mission. Historically, Salesforce has had solutions built specifically for the…
Popular Salesforce Videos
Use cases Automation UiPath with Salesforce
The following video demonstrates a UiPath Robot automatically populating Salesforce using data read from an Excel spreadsheet....imagine how UiPath Robots could accelerate your Salesforce activities.…
Top 5 FAQs' of Salesforce Commerce Cloud
Salesforce Commerce Cloud, formerly known as Demandware, is a user-friendly and streamlined e-Commerce platform designed with a simple goal to help a company expand its…
Salesforce Marketing Cloud Automation Studio
Automation Studio is a Marketing Cloud application used to execute multi-step marketing and data management activities on an immediate, triggered, or scheduled basis. Use Automation…