-
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
How the Salesforce1 Mobile App Can Help Businesses
To understand “how the Salesforce1 mobile app can help the business”, we must first understand the how and the difference between Salesforce and Salesforce1. The…
Optimize Customer Support Services With Salesforce Service Cloud Implementation
The power to make or break a brand rests solely with the customers today. With ever-evolving customer needs, preferences, and expectations, businesses explicitly focus on…
How to Improve Your Customer Service with Salesforce Workflow Automation
Workflow automation drives service agents’ productivity due to quicker and more effective case resolution, which can’t but lead to better customer service quality and happier…
Popular Salesforce Videos
How to Create a Connected App in Salesforce? | What is a Connected App?
Watch this video to learn how to create a Salesforce connected app to enables an external application to integrate with Salesforce using APIs. If you…
Is Trailhead enough to crack Salesforce Interview?
In this video, Shrey answered one of the most asked questions related to Salesforce Interview. Let's see how beautifully Shrey answered this Question. We hope…
5 Important Topics to Crack Salesforce Platform Developer 1 Exam
In this video, Shrey gives you an important topic which gonna be really very helpful for crack the Platform Developer 1 Certification. Without mastering these…