-
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
Choose Salesforce Registered Partners for your Next Project
CRM platforms have emerged as a revolutionary tool for businesses to drive growth, improve customer satisfaction, and streamline operations. Salesforce leads the CRM industry with…
Salesforce Community Cloud and Its Importance for Your Business
One of the most widely used CRM programs worldwide is Salesforce. Organizations can cater to different aspects of their operations with the help of several…
Using the runAs Method in Salesforce | Apex Developer Guide
By and large, all Apex code runs in framework mode, where the authorizations and record sharing of the current client are not considered. The framework…
Popular Salesforce Videos
How to Build an Email Using Content Builder in Salesforce Marketing Cloud
Cameron Robert steps through how to build your first email in Salesforce Marketing Cloud using Content Builder by replicating an existing Salesforce email from ReallyGoodEmails.com.…
Build Your First Salesforce IoT Project in 20 Minutes
Join us to see how you can build your first Salesforce IoT orchestration in less than 20 minutes! You will learn a quick overview of…
Highlights of the Salesforce Winter '22 Release for Nonprofits
The video includes both Winter ‘22 Salesforce Platform updates and Nonprofit Cloud tools. Chapters: 0:00 General Salesforce.com Platform Updates 8:13 Salesforce.com Release for Fundraising and…