How to schedule a single report to multiple users such that each user only receive their own records?

Typical requirement of CRM Administrator: I have a Sales team of 15 Sales Managers and need to send them report of “Opportunities nearing Close date” every week. However please note that each sales manager should receive only their records and not everyone’s.

A traditional approach to achieve this requirement using Report Scheduler App would be:

  1. Create opportunity close date report with filter: Owner Equals Current User
  2. Create 15 different “RS Configuration” records with each one having owner set as each sales manager

Isn’t that a lot of work? to not only build but also to maintain!

Zap Objects now brings to you a new innovative approach called as “Bulk Scheduling” which would achieve this requirement with just 1 report and 1 RS Configuration record…greatly simplifying the task of creating and maintaining the schedule!

To use Bulk Scheduling feature: When creating RS Configuration record:

Step 1: Under Section Email Parameters:
Field “Recipient Type – To”: Select Team option (instead of Email Address)

Step 2: Now select a team in field “Select Team”. All users of selected team will receive the report.

Step 3: Scroll down to Section: Bulk Report Scheduling
=> Filter Records based on Ownership: Set this checkbox
=> Test Mode: If test mode is checked then the emails are created but not sent. The email activity status is kept as draft. These email activities will show up in related “Activities” section (of RS Configuration record) but not in “Closed Activities” section.

In bulk report scheduling, all users of the team will receive a seperate email with report having records where they are the owner.

Points to consider when using Bulk Scheduling feature:

  1. The team used when configuring Bulk Scheduling should have no more than 20 users.

Below shows the demo of how to use Bulk report scheduling:

Leave a Reply

Your email address will not be published. Required fields are marked *