-
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
A Dive into Most Popular Salesforce Experience Cloud Templates
Salesforce Experience Cloud offers a user-friendly solution that is becoming the go-to choice for businesses across different industries aiming to create a standout online presence.…
Salesforce CPQ Quickstart – Implement Salesforce CPQ in Weeks, not Months!
“Quickstart” is a term that has been casually used in the technology space to project a sense of urgency and action, especially in relation to…
Salesforce Lightning Web Components Developer Guide Chapter 2: Markup Basics
Here is the second article in our series, where we delve into the LWC basics. In the previous article, we discussed the basic principles and…
Popular Salesforce Videos
Security in Salesforce | Security Levels in Salesforce
This 'Security in Salesforce' video by Edureka will help you understand the different levels of security in Salesforce. It will also talk about some of…
Customized Ideas Management on Salesforce Experience Cloud | IdeasPro by Grazitti
Learn how IdeasPro enables you to drive business growth by making the most of ideas on Salesforce communities, in this video.
Are they secure enough ? Web to Lead Forms | Validations | SPAM | CAPTCHA | Salesforce Tutorials
Are you using web to lead forms ? Do you think it's secure enough ? In this video you will get all your answers. And…