Report Templates

Overview

Sugar's Reports module comes with a number of pre-built, template reports. These reports display information from Sugar modules (e.g., Accounts, Contacts, Opportunities, etc.) that will help provide insights into your CRM data. This page lists the template reports that come with the current version of Sugar and helps explain the type of information provided in each report.

Please note that Sugar ships with over 100 template reports, which may vary by version. For descriptions of template reports that shipped with previous versions of Sugar, please refer to the Understanding Legacy Stock Reports article. In addition to template reports, users can create their own reports. For more information on creating reports, please refer to the Reports documentation.

Viewing Report Templates

All of Sugar's template reports can be accessed via the Reports module. From the Reports list view, template reports can be identified using the template tag, report template filters, or viewing an enabled checkbox in the Template column. You may also preview a template report from list view to read its description and other information from the report's fields. For more information on previewing reports, please refer to the User Interface documentation.

Please note that you will only be able to see reports as allowed by your team membership, user access type, and assigned roles. For more information on teams and roles, please refer to the Team Management and Role Management documentation in the Administration Guide.

Template Tag

Report templates are automatically tagged in Sugar with the "Template" tag. Each report also has a category tag such as "Administrative" or "Sales and Marketing". The reports listed on this page under Report Templates by Category are organized by the reports' category tags in Sugar. Users can filter the Reports list view by tag as explained in the User Interface documentation.

Report Template Filters

The Reports list view search provides a filter option that allows users to narrow the list of visible reports. In addition to the default module filters, the following filters are available for the Reports module:

Templates: Filter the list view to show only template reports.
Non Templates: Filter the list view to hide all template reports.
With Charts: Filter the list view to show only reports designed with charts.

Users can further refine the results by typing a search query in the search bar and can create and save their own custom filters. For more information on searching and filtering the list view, please refer to the Search documentation.

Using Report Templates

Any user may view a report template according to their role and team permissions. These templates are crafted with stock Sugar fields so that you can start visualizing your data immediately. Report templates cannot be added, edited, mass-updated, or deleted. If you want to edit the contents of a report, you must duplicate the report template and save the edited copy with a new name. Report templates can also be duplicated directly from the list view actions menu.

Many of the reports are designed with run-time filters so that you can filter your results further. These filters can be used without duplicating the report. For information on how to navigate a report in the results view, refer to the Reports documentation.

Note: The only fields you can edit on a report template are "Assigned to" and "Teams". You can edit these fields via Preview.

Report Templates by Category

The reports on this page have been shipped with the current version. For more information on reports that shipped with previous versions but are no longer being shipped in current versions of Sugar, please refer to the Understanding Legacy Stock Reports article.

Administration Reports

The following reports were designed for administrators to gain insight into teams and users, usage patterns, and the performance of their Sugar instance. The reports in this section are tagged "Template" and "Administrative" in the Reports module.

Note: The tracker settings must be enabled via Admin > Trackers before tracker data becomes reportable in Sugar. Please refer to the Understanding Tracker Reports article for in-depth descriptions of each template tracker report.

Name	Module	Type	Chart Type	Description
Active User Sessions (Last 7 Days)	Tracker Sessions	Rows and Columns		Lists the duration of all user sessions over the last 7 days.
Licensed User List ¹	Users	Rows and Columns		Administrators can refer to this report to periodically check the number of active users counting against their license and ensure they are not close to exceeding their limit.
List of Teams and Licensed Users ¹	Teams	Summation with details		Provides the list of teams and the number of users in the team. Group and portal users are excluded from this list.
Modules Used By My Direct Reports (Last 30 Days)	Trackers	Summation	Horizontal Bar	Displays a summary of module usage in the past 30 days for all users who report to the current user.
My Module Usage (Last 30 Days)	Trackers	Summation	Horizontal Bar	Displays a summary of module usage in the last 30 days for the current user.
My Module Usage (Last 7 Days)	Trackers	Summation	Horizontal Bar	Displays a summary of module usage in the last 7 days for the current user.
My Module Usage (Today)	Trackers	Summation	Horizontal Bar	Displays a summary of module usage so far today for the current user.
My Recently Modified Records (Last 30 Days)	Trackers	Rows and Columns		Lists records assigned to the current user that were saved in the last 30 days.
My Records Modified (Last 7 Days)	Trackers	Rows and Columns		Lists records assigned to the current user that were saved in the last 7 days.
My Usage Metrics (Last 30 Days)	Tracker Performance	Summation		Shows the total server response time in seconds, total number of database round trips, and total number of files accessed by the current user in the last 30 days.
My Usage Metrics (Last 7 Days)	Tracker Performance	Summation		Shows the total server response time in seconds, total number of database round trips, and total number of files accessed by the current user in the last 7 days.
My Usage Metrics (Today)	Tracker Performance	Summation		Shows the total server response time in seconds, total number of database round trips, and total number of files accessed by the current user so far today.
Records Modified By My Direct Reports (Last 30 Days)	Trackers	Rows and Columns		Lists records saved in the last 30 days by users who report to the current user.
Slow Queries	Tracker Queries	Rows and Columns		Lists the details for queries that took longer than the query threshold limit defined in Admin > Trackers.
User Sessions Summary (Last 7 Days)	Tracker Sessions	Summation		Summarizes the number of session roundtrips and total active time for each user over the last 7 days.
Users Usage Metrics (Last 30 Days)	Tracker Performance	Summation		Shows the total server response time in seconds, total number of database round trips, and total number of files accessed for each user in the last 30 days.
Users Usage Metrics (Last 7 Days)	Tracker Performance	Summation		Shows the total server response time in seconds, total number of database round trips, and total number of files accessed for each user in the last 7 days.

¹This report is also available for regular users.

General Reports

The following reports will help many types of users. The reports in this section are tagged "Template", "Customer Service", and "Sales and Marketing" in the Reports module.

Name	Module	Type	Chart Type	Description
Call Activity by User	Calls	Summation with details	Vertical Bar	Number of calls held this year grouped by the assigned user. The call status, time period, and assigned user can be adjusted using the run-time filters.
Customers By Tier	Accounts	Summation	Vertical Bar	Number of accounts at each service level. The assigned to user and service level tier can be adjusted with the run-time filters.
My Open Tasks by Priority and Status	Tasks	Matrix	Horizontal Bar	Open tasks assigned to the current user grouped by priority and status. The assigned user and task status can be adjusted with the run-time filters. This report allows users to focus on higher-priority tasks that are near completion.
Open Calls	Calls	Rows and Columns		List of calls assigned to the current user that are scheduled or canceled in the last 7 days. The call status, start time, and assigned user can be adjusted with the run-time filters.
Open Cases for My Customers	Cases	Summation with details	Treemap	Number of cases that are new, assigned, or pending input that are associated with an account the current user is assigned to. These cases are grouped by account name to give you insight into which accounts have the most open cases. The user can be changed with the run-time filter.

Customer Service Reports

The following reports will help customer service users and managers gather important information about cases and bugs in Sugar. The reports in this section are tagged "Template" and "Customer Service" in the Reports module.

Name	Module	Type	Chart Type	Description
All Cases Due Today and Overdue ¹	Cases	Summation	Horizontal Bar	All cases with a follow-up date that has passed or is today. Defaults to all cases with a follow-up date in the past 30 days.
All Open Cases by Followup Date ¹	Cases	Summation with details	Vertical Bar	Number of open cases grouped by the follow-up date.
Average Difference From Follow-Up Date by Week by Agent ¹	Cases	Matrix	Vertical Bar	The average difference from the targeted follow-up date in business hours by week for each agent. Includes cases created in the last 30 days, but this range can be changed using the run-time filter. A run-time filter can also filter by cases that either met or missed their first response SLA.
Average Time to First Response by Agent ¹	Cases	Summation	Horizontal Bar	The average time in business hours until the first response on a case, per agent. Includes cases created in the last 30 days, but this range can be changed using the run-time filter.
Average Time to Resolution by Week by Agent ¹	Cases	Summation	Horizontal Bar	The average time in business hours it takes to resolve cases by week for each agent. Includes cases resolved in the last 30 days, but this range can be changed using the run-time filter.
Average Time to Resolution by Week by Type ¹	Cases	Summation	Horizontal Bar	The average time in business hours it takes to resolve cases by week for each case type. Includes cases resolved in the last 30 days, but this range can be changed using the run-time filter.
Bugs by Product Category by Status	Bugs	Matrix	Horizontal Bar	Number of bugs created by category and their current status. This report gives a sense of which area of the product generates bugs. The time period can be adjusted in the report using run-time filters.
Bugs Created by Month By Category	Bugs	Matrix	Vertical Bar	Number of bugs created each month summarized by the category. This report provides a trend on the number of bugs being generated across the category.
Bugs Created by Month By Priority	Bugs	Matrix	Vertical Bar	Number of bugs created each month summarized by their priority. This report provides a trend on the number of bugs.
Cases That Missed the First Response SLA ¹	Cases	Matrix	Vertical Bar	The number of cases that missed their first response SLA in the last 7 days. The time period can be changed using the run-time filter.
Cases with No Calls, Meetings, Tasks, or Emails	Cases	Matrix		Summary count of cases where no activity has taken place or is scheduled. Those cases are counted that have no calls, meetings, or tasks scheduled or completed.
Closed Cases by Time to Resolution	Cases	Summation with details	Horizontal Bar	Number of closed cases grouped by assigned user and summarized by average hours to resolution. The status of the case can be changed with the run-time filter.
Daily Average Time to First Response ¹	Cases	Summation	Horizontal Bar	The daily average time in business hours until the first response on a case. Includes cases created in the last 7 days, but this range can be changed using the run-time filter.
First Response SLA Success Rate ¹	Cases	Summation	Pie	All cases created in the last 30 days, separated by whether or not their first response SLA was met. The run-time filters can be used to change the time period or narrow the results to only cases assigned to a specific agent.
List of Changes to Case Status ¹	Change Timers	Rows and Columns		List of all changes to case status. Includes cases created in the last 30 days, but this range can be changed using the run-time filter.
List of Recently Resolved Cases ¹	Cases	Rows and Columns		A list of recently closed cases across all business centers. The time period can be adjusted in the report.
My Average Difference From Follow-Up Date by Week ¹	Cases	Summation	Vertical Bar	The average difference from the targeted follow-up date in business hours by week for the current user. Includes cases created in the last 30 days, but this range can be changed using the run-time filter. A run-time filter can also be used to filter by cases that either met or missed their first response SLA.
My Cases Due Today and Overdue ¹	Cases	Summation	Horizontal Bar	All cases assigned to the current user with a followup date that has passed or is today. Defaults to all cases with follow-up date in the past 30 days.
My Cases in the Last Week by Status ¹	Cases	Summation	Horizontal Bar	Cases modified by the current user in the last 7 days, grouped by the status of the case. The time period can be adjusted in the report. This report makes it easy to identify recently worked on cases.
My Cases Resolved this Month by Week ¹	Cases	Summation	Vertical Bar	This report displays a chart for all cases that were closed in the selected time period and groups them by week.
My Open Bugs by Priority	Bugs	Summation	Pie	List of open bugs assigned to the current user summarized by priority.
My Open Cases by Followup Date ¹	Cases	Summation with details	Vertical Bar	Number of open cases assigned to the current user grouped by the follow-up date.
My Open Cases by Priority	Cases	Summation	Horizontal Bar	List of open cases assigned to the current user summarized by priority.
My Open Cases by Status ¹	Cases	Summation	Pie	This pie chart shows the percent of cases that are open by status for the current user.
My SLA Success Rate ¹	Cases	Summation	Vertical Bar	The history of cases the current user responded to that either met or missed their first response SLA. Includes cases in the last 30 days, but this range can be changed using the run-time filter.
New Cases by Business Center by Week ¹	Cases	Summation	Vertical Bar	Number of cases created for each business center by week. The time period can be adjusted in the report.
New Cases by Customer Tier by Week ¹	Cases	Summation	Vertical Bar	Number of cases created by the service level of the customer (customer tier) by week. The time period can be adjusted in the report.
New Cases Opened by Month	Cases	Summation with details	Vertical Bar	Number of cases grouped by the month in which they were created. The time period can be adjusted with the run-time filter.
New Portal Users Awaiting Activation ¹	Contacts	Rows and Columns		A list of portal users created but not yet activated. Includes contacts created in the last 7 days, but this range can be changed using the run-time filter.
Open Bugs by User by Priority	Bugs	Matrix		Number of bugs assigned to each user grouped by priority of the bug. This report gives a sense of which bugs need attention the most.
Open Bugs by User by Status	Bugs	Matrix		Number of bugs assigned to each user and the priority of the bug. This report gives a sense of the workload of users working on the bugs.
Open Cases Awaiting First Response That Missed SLA ¹	Cases	Rows and Columns		All open cases that missed the first response SLA and are still awaiting first response.
Open Cases Awaiting First Response Within SLA ¹	Cases	Rows and Columns		All open cases that are within their SLA and awaiting first response.
Open Cases by Customer Tier and Priority ¹	Cases	Matrix	Horizontal Bar	A summary of open cases grouped by the service level of the customer (customer tier) and priority.
Open Cases By Month By User	Cases	Summation	Vertical Bar	List of open cases by created month and grouped by user.
Open Cases by User by Priority	Cases	Matrix	Horizontal Bar	Number of cases assigned to each user and the priority of the bug. This report gives a sense of the workload of users working on the cases.
Open Cases by User by Status	Cases	Matrix	Horizontal Bar	Number of cases assigned to each user and the current status of the bug. This report gives a sense of which cases need attention the most.
Recently Created Cases ¹	Cases	Rows and Columns		A list of all recently created cases across all business centers. The time period can be adjusted in the report.
Status of Open Tasks Assigned by Me ¹	Tasks	Summation with details	Vertical Bar	Open tasks that the current user has assigned to others. This report helps users know who to follow up with.
Summary of Bugs by Priority by Week Created	Bugs	Matrix	Vertical Bar	Number of bugs created each week by priority. The time period can be adjusted in the report using the run-time filters.
Summary of Bugs by Source by Week Created	Bugs	Matrix	Vertical Bar	Number of bugs created each week by source. The time period can be adjusted in the report using the run-time filters.
Summary of Bugs by Status by Week Created	Bugs	Matrix	Vertical Bar	Number of bugs created each week by status. The time period can be adjusted in the report using the run-time filters.
Summary of Cases by Priority by Week Created	Cases	Matrix	Vertical Bar	Number of cases created each week by priority. The time period can be adjusted in the report using the run-time filters.
Summary of Cases by Source by Week Created	Cases	Matrix	Vertical Bar	Number of cases created each week by source. The time period can be adjusted in the report using the run-time filters.
Summary of Cases by Status by Week Created	Cases	Matrix	Vertical Bar	Number of cases created each week by status. The time period can be adjusted in the report using the run-time filters.
Summary of Open Cases by Priority	Cases	Summation	Horizontal Bar	Number of cases that are still open summarized by priority of bug.
Total Cases Resolved this Month by Agent ¹	Cases	Summation	Horizontal Bar	Number of cases that were resolved during the month grouped by agent and priority. The time period can be adjusted in the report.
Total Cases Resolved this Month by Business Center ¹	Cases	Matrix	Horizontal Bar	Number of cases that were resolved during the month grouped by business center and priority. The time period can be adjusted in the report.
Total Time Spent on Cases by Week by Case Type ¹	Change Timers	Summation	Vertical Bar	The total time in business hours spent on cases for each week by case type. Includes cases created in the last 30 days, but this range can be changed using the run-time filter.

¹This report is only available for Sugar Serve or Enterprise users.

Sales and Marketing Reports

The following reports will help sales and marketing professionals manage sales activities and identify key performance indicators (KPIs). The reports in this section are tagged "Template" and "Sales and Marketing" in the Reports module.

Name	Module	Type	Chart Type	Description
Accounts by Assigned to User	Accounts	Summation		Number of accounts for each assigned user. This report helps in making sure that account workload is optimized across the sales team. Use run-time filters to narrow down by type or industry.
Accounts By Type By Industry	Accounts	Summation	Horizontal Bar	Number of accounts summarized by account type and industry.
Accounts Created by User by Month	Accounts	Matrix	Vertical Bar	Number of accounts created by month by assigned user during the current year. The time period can be adjusted in the report using the run-time filters.
All Closed Opportunities	Opportunities	Rows and Columns		List of all closed opportunities.
All Open Opportunities	Opportunities	Rows and Columns		List of open opportunities.
BDR Revenue By Period	Opportunities	Summation with details	Horizontal Bar	Number of closed won opportunities grouped by assigned user. The opportunity status, assigned user, and expected close date time period can be modified with run-time filters.
Contacts Created by User by Month	Contacts	Matrix	Vertical Bar	Count of all contacts created this year by each assigned user by month. The time period can be adjusted in the report using the run-time filters.
Lead Conversion Rate	Leads	Summation with details	Pie	Number of leads that are not recycled or dead grouped by their status. You can adjust which leads to include in the report with the run-time filter. Hover over the pie chart slices to see the conversion rate.
Leads By Lead Source	Leads	Summation	Vertical Bar	Number of leads grouped by lead source. The lead sources included in the report can be adjusted with the run-time filter.
Leads Converted - Lost by Month	Leads	Matrix	Vertical Bar	Number of leads converted and lost each month. The time period can be adjusted in the report using the run-time filters.
Leads Converted by User	Leads	Summation		This report provides the number of leads converted by each user in the current quarter. The time period can be adjusted in the run-time filter.
Leads Created by Source per Month	Leads	Matrix	Vertical Bar	Leads created each month by source. The time period can be adjusted in the report using the run-time filters.
Leads Created by User per Month	Leads	Matrix	Vertical Bar	Leads created each month by user. The time period can be adjusted in the report using the run-time filters.
Leads with No Calls, Meetings, Tasks, or Emails	Leads	Summation		Summary count of leads where no activity has taken place or is scheduled. Those leads are counted that have no calls, meetings or tasks scheduled or completed.
Marketing Campaign ROI	Opportunities	Summation with details	Vertical Bar	Number of closed won opportunities that originated from a lead generated by a campaign. These opportunities are grouped by campaign name and summarized by the sum of likely revenue so you can see which campaigns generated the most opportunities and revenue. The opportunity status, lead source, expected close date, and assigned user can be adjusted with run-time filters.
MQL Leads by Period by Status	Leads	Summation with details	Vertical Bar	Number of leads grouped by status. The lead status, assigned user, and date created can be adjusted with run-time filters.
My Customers by Area	Accounts	Rows and Columns		A list of customers in a given area (City or Zip Code). This report only lists accounts that are assigned to the person viewing the report. You can use this report to create a trip plan.
My New Customer Accounts	Accounts	Rows and Columns		List of new customers recently opened and assigned to the current user.
My Open Leads	Leads	Rows and Columns		List of all leads assigned to the current user.
My Open Opportunities	Opportunities	Rows and Columns		List of opportunities assigned to the current user that are still open and are expected to close this month. The time period can be adjusted in the report using the run-time filters.
My Pipeline Funnel (Revenue Line Items)	Revenue Line Items	Summation with details	Funnel	Number of open revenue line items assigned to the current user with an expected close date grouped by the sales stage. The revenue line items are summarized with the sum of likely revenue. The sales stage, assigned user, and expected close date can be adjusted with run-time filters.
New Leads This Quarter by Lead Source	Leads	Summation with details	Horizontal Bar	Number of leads created this quarter grouped by lead source. The lead source, assigned user, lead status, and time period can be adjusted with run-time filters.
New Sales by Month	Opportunities	Summation	Vertical Bar	Number of opportunities with an expected close date in the current fiscal year grouped by the month they are expected to close. These opportunities are summarized by the sum of likely revenue. The expected close date can be adjusted with the run-time filter.
Number of Leads Created by Week	Leads	Summation	Vertical Bar	Number of leads created for each week this year. The time period can be adjusted in the report using the run-time filters.
Number of Open Tasks by Users by Week	Tasks	Matrix		Number of open tasks by each user by week due.
Number of Opportunities Created by Team by Month	Opportunities	Matrix	Vertical Bar	Summary of the number of all opportunities created this year grouped by the primary team assigned. This gives a sense of which teams are generating opportunities. The time period can also be adjusted in the run-time filters.
Number of Opportunities created by User by Month	Opportunities	Matrix	Vertical Bar	Summary of the number of all opportunities created this year by each user. This gives a sense of which salespeople are generating opportunities. The time period can also be adjusted in the run-time filters.
Number of Quotes created by Users by Month	Quotes	Matrix	Vertical Bar	Number of quotes created by each user by month. The time period can be adjusted in the report using the run-time filter.
Open Leads by User	Leads	Summation	Horizontal Bar	List of open leads grouped by assigned user.
Open Meetings	Meetings	Rows and Columns		List of meetings assigned to the current user that are scheduled or canceled in the last 7 days. The meeting status, start time, and assigned user can be adjusted with the run-time filters.
Open Opportunities and Number of Calls	Opportunities	Summation		A list of all open opportunities and the number of calls currently scheduled for each. Use the run-time filters to select only scheduled or held meetings. Select the opportunity status to filter on opportunities that are closed won or lost.
Open Opportunities and Number of Meetings	Opportunities	Summation		A list of all open opportunities and the number of meetings currently scheduled for each. Use the run-time filters to select only scheduled or held meetings. Select the opportunity status to filter on opportunities that are closed won or lost.
Open Opportunities by Expected Close Month	Opportunities	Summation	Vertical Bar	Summary of all open opportunities by expected close month. Details of the opportunities are also listed in this report.
Open Opportunities by Type by Expected Closed Month	Opportunities	Matrix	Vertical Bar	Summary of opportunities by expected close month grouped by type.
Open Opportunities by User by Expected Close Month	Opportunities	Matrix	Vertical Bar	Summary of opportunities for each user by expected close month.
Open Quotes by Stage	Quotes	Summation	Pie	A list of all open quotes summarized by stage.
Open Quotes by Stage by Close Month	Quotes	Matrix	Vertical Bar	Summary of quoted amounts that are open by their expected close month and grouped by stage. This report indicates which quotes to prioritize and close.
Open Quotes by Stage by User	Quotes	Matrix		Summary of quoted amounts that are open for each assigned user grouped by stage. This report gives a sense of where the quotes are in terms of stages for each salesperson.
Open Quotes Expiring This Month	Quotes	Rows and Columns		A list of quotes that are expiring this month. The time period can be adjusted in the report using the run-time filter.
Open Tasks	Tasks	Rows and Columns		List of open tasks.
Opportunities Created by Lead Source by Month	Opportunities	Matrix	Vertical Bar	Monthly summary of all opportunities created this year grouped by lead source. This report gives a sense of which sources are generating most opportunities. You can also toggle between open or closed won opportunities. Use the run-time filter to change the time period.
Opportunities with No Calls, Meetings, Tasks, or Emails	Opportunities	Summation	Horizontal Bar	Summary count of opportunities where no activity has taken place or is scheduled. Those opportunities are counted that have no calls, meetings or tasks scheduled or completed.
Opps Closed Won v Lost by Rep	Opportunities	Summation with details	Vertical Bar	Number of opportunities that are closed won or closed lost grouped by assigned user and status. The opportunities are summarized by the sum of the likely revenue. Opportunity status, expected close date, and assigned user can be adjusted with run-time filters.
Pipeline by Month: Forecast Include/Exclude	Revenue Line Items	Summation with details	Vertical Bar	Number of open revenue line items that are included or excluded from the forecast grouped by expected close date month and forecast stage. The revenue line item sales stage, assigned user, forecast stage, and expected close date can be modified with the run-time filters.
Pipeline by Rep and Stage	Revenue Line Items	Summation with details	Horizontal Bar	Number of open revenue line items grouped by assigned user and sales stage. The revenue line item sales stage, assigned user, and expected close date can be adjusted with run-time filters.
Pipeline By Team By User	Opportunities	Summation	Horizontal Bar	Summary count of opportunities where no activity has taken place or is scheduled. Those opportunities are counted that have no calls, meetings or tasks scheduled or completed.
Pipeline By Type By Team	Opportunities	Summation	Horizontal Bar	Summarizes the open pipeline by team.
Pipeline Funnel (Revenue Line Items)	Revenue Line Items	Summation	Funnel	This report shows a funnel chart of the revenue line item pipeline. Use the run-time filters to include only forecasted revenue line items.
Quotes Created by Users by Month	Quotes	Matrix	Vertical Bar	Total quote amount created by each user by month. The time period can be adjusted in the report using the run-time filter.
Quotes Won Lost by Month	Quotes	Matrix	Vertical Bar	Quoted amounts won and lost each month this year. The time period can be adjusted in the report using the run-time filter.
Quotes Won Lost by User	Quotes	Matrix		Quoted amounts won and lost this quarter by each assigned user. The time period can be adjusted in the report using the run-time filter.
Recently Closed Quotes	Quotes	Rows and Columns		A list of all recently closed quotes.
Revenue Line Items by Product	Revenue Line Items	Summation		Summary of all RLIs by product. Use the run-time filters to include only forecasted revenue line items. You can also change the time period and the sales stage of the revenue line item.
Revenue Line Items Sold by Type this Quarter	Revenue Line Items	Matrix	Vertical Bar	This report provides a summary of all closed won sales for each quarter this year grouped by the lead source. This provides an indication of which sources of leads are generating sales. The time period can be adjusted on the report using the run-time filter.
Revenue Year Over Year	Revenue Line Items	Summation with details	Vertical Bar	Number of closed won revenue line items grouped by the year they are expected to close. The revenue line item sales stage, assigned user, and expected close date can be modified with run-time filters.
Sales Leaderboard	Revenue Line Items	Summation with details	Horizontal Bar	Number of closed won revenue line items grouped by assigned user. The revenue line item sales stage, assigned user, and expected close date can be adjusted with run-time filters.
Sales per Quarter by Lead Source	Opportunities	Matrix	Vertical Bar	This report provides a summary of all closed won sales for each quarter this year grouped by the lead source. This provides an indication of which sources of leads are generating sales. The time period can be adjusted on the report using the run-time filter.
Sales Pipeline	Revenue Line Items	Summation with details	Funnel	Number of open revenue line items grouped by sales stage. The revenue line item sales stage, assigned user, and expected close date can be adjusted with run-time filters.
SQL Leads by Rep	Leads	Summation with details	Vertical Bar	Number of converted leads grouped by assigned user. The lead status, date created, and assigned user can be adjusted with run-time filters
Tasks Completed by Users by Week this Quarter	Tasks	Matrix		Number of tasks completed by each user by week in this quarter. The time period can be adjusted in the report using the run-time filter.
Tasks Due This Week	Tasks	Rows and Columns		List of tasks due this week. The time period can be adjusted in the report using the run-time filter.
Top Grossing Products This Year	Revenue Line Items	Summation	Horizontal Bar	Monthly sales of products this year. The time period can be adjusted in the report using the run-time filters.
Top Sales Reps This Quarter	Opportunities	Summation		This report summarizes total sales by each assigned user for the current quarter. The time period can be adjusted in the report using the run-time filters.
Total Sales by Quarter	Opportunities	Matrix	Vertical Bar	Number of closed won opportunities this year grouped by the quarter they are expected to close and the opportunity type. The opportunity status, expected close date, and assigned user can be adjusted using the run-time filters.
Total Sales by Quarter by User	Opportunities	Matrix	Vertical Bar	This report summarizes total sales by each assigned user for each quarter of this year. This report can be used to compare sales person performance. The time period can be adjusted in the report using the run-time filters.
Upcoming Calls Scheduled by Account	Calls	Summation with details		Number of calls scheduled by account in the coming weeks.
Upcoming Meetings Scheduled by Account	Meetings	Summation with details		Number of meetings scheduled by account in the coming weeks.
Weekly Calls Held This Quarter by User	Calls	Matrix	Vertical Bar	Number of calls held by each user by week in this quarter. The time period can be adjusted in the report using the run-time filter.
Weekly Calls Scheduled This Quarter by User	Calls	Matrix	Vertical Bar	Number of calls scheduled by each user by week in this quarter. The time period can be adjusted in the report using the run-time filter.
Weekly Meetings Held This Quarter by User	Meetings	Matrix	Vertical Bar	Number of meetings held by each user by week in this quarter. The time period can be adjusted in the report using the run-time filter.
Weekly Meetings Scheduled This Quarter by User	Meetings	Matrix		Number of meetings scheduled by each user by week.
Wins and Losses by Users this Quarter	Opportunities	Matrix		The total amount of opportunities won vs lost by each assigned user in the current quarter. The time period can be adjusted in the run-time filters.

Data Privacy Reports

The following reports will help data privacy managers and marketing users make privacy-related insights and identify leads, contacts, and targets who have opted in to or out of marketing communications. The reports in this section are tagged "Template" and "Data Privacy" in the Reports module.

Name	Module	Type	Chart Type	Description
Count of Contacts by Country	Contacts	Summation		Total count of existing contacts grouped by country.
Count of Leads (unconverted) by Country	Leads	Summation		Total count of existing leads (unconverted) grouped by country.
Count of Targets by Country ¹	Targets	Summation		Total count of existing targets grouped by country.
Data privacy activity completed and rejected each month	Data Privacy	Matrix	Vertical Bar	Number of data privacy activities completed or rejected each month. The month is based on date closed.
Data Privacy Activity Due Now	Data Privacy	Summation with details	Horizontal Bar	List of all data privacy activity that is due shortly. Use the run-time filter to adjust the time period.
Data Privacy Activity Overdue	Data Privacy	Summation with details	Horizontal Bar	List of all data privacy activity that are still open and the due date is in the past.
List of Contacts with No Consent	Contacts	Rows and Columns		List of all contacts who have not provided any consent for any business purpose.
List of Emails Opted In	Email Address	Rows and Columns		List of all emails currently opted in.
List of Emails Opted Out	Email Address	Rows and Columns		List of all emails currently opted out.
List of Leads with no Consent ¹	Leads	Rows and Columns		List of all leads who have not provided any consent for any business purpose.
List of Open Data Privacy Activities	Data Privacy	Rows and Columns		A list of all data privacy activities that have a status of open.
List of Open Data Privacy Activities assigned to me	Data Privacy	Rows and Columns		List of open data privacy activity assigned to the current user.
Number of Data Privacy Activity created each month by type	Data Privacy	Matrix	Vertical Bar	Number of data privacy activities created each month by activity type.
Open Data Privacy Activities by Type	Data Privacy	Summation with details	Horizontal Bar	List of all open data privacy activity grouped by activity type.
Recently Created Data Privacy Activity	Data Privacy	Rows and Columns		A list of all recently created data privacy activity. The time period can be adjusted in the report using the run-time filters.

¹ This report is only available for Sugar Sell or Enterprise users.