-
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
Integration of Salesforce with Google Calendar Using REST API
In this Blog, we are going to Integrate Salesforce with Google (Calendar, Email, Drive etc.) REST API. For this article, we are going to integrate…
Enhance Customer Engagement in Trading in 2024
Introduction: In the fast-paced world of trading, where every second counts, establishing and maintaining strong customer relationships is paramount. Salesforce, a leading customer relationship management…
Discover Why Salesforce Einstein Analytics is the Trump Card for E-commerce Transformation
Businesses and customers have observed humongous values in automation and insights that deliver valuable, productive and gratifying encounters. However, there is a dramatic landscape change…
Popular Salesforce Videos
How To Use RingCentral App In Salesforce | Salesforce Service Cloud
Learn how to use RingCentral App in Salesforce. This video will cover the following points - 1. Advantages Take a look at the advantages of…
Drive Adoption with In-App Guidance and our Prebuilt Salesforce Package!
With In-App Guidance generally available in the Winter ‘20 release, there’s no better time to start taking advantage of the easiest way to add informative…
Meet us at Dreamforce23 - Unleash the Ultimate Business Experience!
Dreamforce 2023 at San Francisco. Save the dates of September 12–14, 2023, and prepare for an unforgettable experience at Dreamforce 2023. Reserve your position by…