-
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
No Code Salesforce and Intercom Integration
Strong customer relationships are more vital than ever. The volume and nature of internet commerce and increased client demands make establishing and maintaining those ties…
3 Key Benefits of Hiring Certified Salesforce Consultants in 2024
Businesses will still have to contend with a highly competitive market in 2024, when having the appropriate tools and tactics might be crucial. One of…
How to call Apex Method from Flow and Vice – Versa? | Salesforce Apex
Spring '23 features that align with your core admin responsibilities. Release Highlights for Admins Salesforce Admins drive innovation with four core responsibilities: User Management, Data…
Popular Salesforce Videos
How To Use Data Loader In Salesforce - Learn Salesforce Series By Algoworks
Learn how to use Data Loader in Salesforce. In this video, the following points will be covered - 1. Introduction Here you will get a…
Relationships in Salesforce | Why Relationships are Created?
In this video, Salesforce Rangers goes into detail about what relationships are in Salesforce and why they are necessary in the first place. This is…
Salesforce Agentforce for Nonprofits
With Salesforce's latest AI tool, Agentforce, you can boost your Salesforce org with AI agents that can streamline workflows, reduce costs, and improve your constituent…