-
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
Salesforce Security Model - Explained
Salesforce Security Model Salesforce Security Model Classification. Security in Salesforce is broadly classified in two sorts. They are System Level Security. Application Level Security. System…
Why Salesforce Integration Can Be Your Best Bet for Business Growth
Welcome to the age of the Customer. The only riddle that matters here is—how to connect better with them, carve meaningful relationships, address their problems…
Learn All About Apex in Salesforce | The Developer Guide
What is Apex in Salesforce? Apex is a strongly typed, object-oriented programming language that allows developers to run flow and transaction control statements on Salesforce…
Popular Salesforce Videos
Work Your Opportunities and Manage Your Pipeline (Lightning Experience) | Salesforce
In this video, Salesforce Support demonstrates how to work with deals and manage your pipeline in the Salesforce Lightning Experience. With interactive features that help…
Algoworks Is Now A Salesforce Summit (Platinum) Partner | Salesforce Consulting Services
It's been just a year since we became Salesforce gold consulting partners. Algoworks has now been recognized as a Salesforce Summit Partner (also known as…
Embedding Salesforce Einstein Predictions in Tableau with Tomasz Bacewicz
Get the most out of Salesforce Einstein Discovery and Tableau by embedding Predictions directly in your Dashboards! Learn how from a pro. Watch this video…