Back to Blog

Your Guide to Salesforce Reporting: Types of Salesforce Reports, Examples, and Many More

Angela is a Salesforce user who needs to analyze the performance of her business. For analytics, Salesforce offers dashboards and reports. The latter seems to be ideal since it is good for pipeline analysis, calculation of basic sales productivity metrics, and other analytical tasks. In addition, Salesforce reports can be customized, visualized, and even exported. Wonderful!

 It would also be great to have a guide or tutorial to explain all the intricacies of reporting in Salesforce…but wait! You’re already at the right place πŸ™‚ In this article, you’ll learn how to create reports, what formats and types are available, and much other valuable information. 

What are reports in Salesforce?

Each Salesforce report is a set of data displayed in rows and columns that you can group or filter by certain criteria. You can also visualize Salesforce reports as a chart, such as a bar chart, line chart, donut, etc. Here is what it may look like:

1.1 salesforce report example

This is an example of a New Opportunity Trends report attached with a bar chart in Salesforce Lighting Experience. Angela is still using Salesforce Classic, so she should keep in mind that there are some differences between reporting in these UX versions. Here is what the same report looks like in Salesforce Classic:

2.2 salesforce classic report example

Salesforce reports permissions and levels of access

An important thing that you should consider before working with reports in Salesforce is the level of access. It is a combination of user permissions to manage, create, customize, edit, run, and view reports and report folders. There are three levels of access: Manager, Editor, and Viewer.

What it allows to do with reports in SFViewerEditorManager
View reports in a folderβœ…βœ…βœ…
See who has what level of access to the folderβœ…βœ…βœ…
Save a report in the folderβœ…βœ…
Rename a report in the folderβœ…βœ…
Delete a report from the folderβœ…βœ…
Manipulate the folderβœ…

Access levels determine access to the folders but not to the contents of them. For the latter, you need specific user permissions such as edit, run, etc. The level of access to a folder and permission set for the reports can be dissimilar.

For example, Angela has Manager access to the folder β€˜Monthly Reports’, but her user permissions are limited to View Reports. So she can only view the reports in the folder. To edit a specific report in this folder, she would need the Edit Reports permission for this particular report. 

How to create reports in Salesforce

Let’s go through the flow of creating a standard report in both Salesforce Classic and Lightning Experience. After that, we’ll also show you how to create a custom report type in Salesforce.

Salesforce reports example in Lightning Experience 

  • Go to the Reports tab and click the New Report button. 
7 new report button
  • Choose one of the standard report types and click Continue.
8 choose report type
  • The report editor with a draft of your report will open. You can configure the appearance of your report including:
    • Add, remove, or edit filters
    • Add or remove groups of data
    • Add or remove columns
    • Swap rows and columns
    • Add a chart 
    • Toggle on/off row counts, detail rows, grand total, stacked summaries
9 report editor

When the configuration is done, click Run. Your freshly baked Salesforce report is ready.

10 report created

You can edit, save, or export it if necessary. These buttons are in the top right corner of the report.

11 edit save export

Salesforce report in SF Classic 

In Salesforce Classic, the flow is mostly the same. 

  • Go to the Reports tab and click the New Report button. 
12 new report classic

Note: If you don’t see the tab on the tab bar, click + and scroll down till you find Reports

13 reports salesforce classic
  • Select the needed report type, then click Create.
14 select report type sf classic
  • Here is what the report editor with a draft of your report looks like in Salesforce Classic.
15 report editor sf classic

Compared to Lightning Experience, in Salesforce Classic report editor, you can choose the format for your report:

16 choose report format

Eventually, you need to click Run Report. Here is what it may look like:

17 report salesforce classic

To edit the report, click Customize; to save it – click Save As; to export – choose either Printable View to export the formatted report or Export Details to export raw records. 

Note: We explained the difference between these options and other information in our blog post on How to Export Salesforce Reports to Excel.

How to create custom reports in Salesforce

Now, let’s check out how you can create custom report types in Salesforce. There is not much difference in the flow between Lightning Experience and SF Classic. So, there you go:

  • Go to Salesforce Setup and enter Report Types in the Quick Find box.
18 search report types lightning experience
  • Click Report Types, then click Continue on the Custom Report Type welcome page.
19 create custom report type
  • Click New Custom Report Type, then configure it as follows:
    • Define the primary object – which data will be the focus for this report type.
    • Name your report type and add a description. Select the category for your custom report type
    • Specify the status for your custom report type: deployed or in development.

Click next to proceed to the next step.

20 define custom report type
  • Define other objects related to your primary object within this custom report type. It is okay if no related objects are available for your primary object. However, it’s possible to build a tree of multiple related objects like this:
21 report records set

In the end, click Save – you’ll see the information for your custom report type.

22 information custom report type

If the customization offered by Salesforce is not enough for your needs, we also describe an alternative method that allows you to pull Salesforce data automatically into Excel or Google Sheets and create custom reports there. Jump to the Reporting outside of Salesforce section to learn more.

Salesforce report formats

When building reports in the Lightning Experience, the report format is updated automatically. 

However, in Salesforce Classic, you need to choose the report format from the following options:

  • Tabular
  • Summary
  • Matrix
  • Joined
8 choose report type

Tabular report Salesforce

The tabular format is an ordered set of columns and rows like a regular spreadsheet. You can’t use tabular reports to group data, create charts, or in dashboards unless there is a limited number of rows. 

Here is an example of the New Opportunity Trends report in tabular format.

4.1 opportunity trends report tabular format

Summary report Salesforce

The summary format is an enhanced tabular format that allows you to group rows of data, show subtotals, and even create charts. 

Here is an example of the New Opportunity Trends report in summary format with the data grouped by Historical Stage.

4.2 opportunity trends report summary format

Matrix report Salesforce

The matrix format is an enhanced summary format πŸ™‚ The enhancement is that matrix reports allow you to group data by rows and columns. 

Here is an example of the New Opportunity Trends report in a matrix format with the data grouped by Historical Stage and Last Activity.

4.3 opportunity trends report matrix format

Salesforce joined reports

Note: Available only for Enterprise, Performance, Unlimited, and Developer Editions.

The joined format of reports in Salesforce allows you to add multiple blocks to your report. Each block has its fields, columns, sorting, and filtering. Joined reports can even contain data from different report types.

Here is an example of the New Opportunity Trends report in the joined format.

4.4 opportunity trends report joined format

Just to remind you that choosing reports formats is only possible in Salesforce Classic. For the Lightning Experience, your report format will be assigned automatically. On the other hand, the type of report is what you’ll need to select regardless of the UI version you use.

Salesforce report types

Standard reports in Salesforce

Salesforce offers out-of-the-box templates for reporting called report types. Each template corresponds to a particular set of data and columns to order this data. There are different types of reports grouped into several categories:

CategorySalesforce standard report types
Accounts & Contacts– Accounts
– Contacts & Accounts
– Accounts with Partners
Other Salesforce Account & Contacts reports– Account with Account Teams
– Accounts with Contact Roles
– Accounts with Assets
– Contacts with Assets
– Account History
– Contact History
– D&B Company with and without Accounts
Activities– Tasks and Events
– Events with Invitees
– HTML Email Status
Other Salesforce activity reports – Activities with Accounts
– Activities with Contacts
– Activities with Opportunities
– Activities with Leads
– Activities with Campaigns
– Activities with Cases
– Activities with Solutions
– Activities with Contracts
– Activities with Products
– Activities with Emotions
Administrative Reports– Users
– Reports
– Documents
Other Salesforce administrative reports– New Login Locations
– Identity Verification Methods
– Collaboration Group Report
– Collaboration Group Feed Posts Report
Campaigns– Campaigns
– Campaigns with Contacts
– Campaigns with Leads
Other Salesforce campaign reports– Campaigns with Opportunities
– Campaigns with Campaign Members
– Campaigns with Leads and Converted Lead Information
– Campaigns with Influenced Opportunities
Contracts and Orders– Contracts
– Contract History
– Contracts with Orders
Other Salesforce contracts and orders reports– Contracts with Orders and Products
– Contracts with Contact Roles
– Orders
– Orders with Products
– Orders History
Customer Support Reports– Cases
– Case Lifecycle
– Cases with Contact Roles
Other Salesforce customer support reports– Cases with Assets
– Cases with Solutions
– Case History
– Cases with Milestones
– Solutions
– Solution Categories
– Solution History
File and Content Reports– Content Report
– Library and User Report
– File and Content Report
ForecastsYou can add custom Salesforce Forecast reports.
Individuals– Individual
– Individual History
Leads– Leads
– Leads with converted lead information
– Lead History
Opportunities– Opportunities
– Opportunities with Products
– Opportunities with Contact Roles
Other Salesforce opportunity reports– Opportunities with Partners
– Opportunities with Competitors
– Opportunity History report Salesforce
– Opportunity Field History
– Opportunity Trends
– Opportunities with Contact Roles and Products
Price Books, Products, and Assets– Products
– Products with Opportunities
– Price Books with Products
Other Salesforce price books, products, and assets reports– Products with Assets
– Assets
– Assets with Cases
Other Reports (Screen Flows)– Emotions
– Screen Flows

Note: The exact collection of standard Salesforce report types may differ.

Salesforce custom report type

A custom report type is an option to customize reporting in Salesforce. It’s rather helpful if a standard report type does not provide you with the columns you need, or you want to have a custom view of standard objects. We’ll explain how you can create custom report types in Salesforce in the following sections.

Scheduled reports Salesforce

Report scheduling in Salesforce allows you to: 

  • Set up a run frequency of your reports on a daily, weekly, or monthly basis
  • Email reports to your Salesforce users on a set schedule 

Note: Manage, Create, and Edit user permissions allow you to schedule reports. 

How to schedule reports in Lightning Experience

  • Go to the Reports tab, click on the More Action arrow, and select Subscribe.
23.1 subscribe salesforce report
  • Configure the schedule and add recipients and conditions if required.
24 edit subscription

To be able to email a report to recipients, it must be:

  • Stored in a shared folder
  • The folder with the report must be shared with the required recipients
  • Recipients are Salesforce users authorized to your account

If these conditions are met, you’ll have the Edit Recipients button active and be able to add and remove recipients.

25 edit recipients

Once you have configured the schedule for your report, click Save. You’ll see a checkmark under the Subscribed column. 

26 started report subscription

How to schedule reports in Salesforce Classic

  • To enable scheduling in Salesforce Classic, first, you need to run your report. After that, you’ll have the Schedule Future Runs… option under the Run Report button. Click on it.
27 schedule future runs
  • Set up the schedule for your report and add the recipients for it. Click Save Report Schedule.
28 schedule report salesforce classic

Scheduling has been enabled!

29 schedule enabled sf classic

Reporting outside of Salesforce – why you should consider this

Both standard and custom reports in Salesforce are suitable for simple analytics, such as pipeline analysis. However, they are not fit for more advanced analytical purposes, making forecasts, and blending Salesforce records with external data. 

In addition, there are specific limitations on Salesforce reports depending on the edition you have. The pretty confusing flow of creating, scheduling, and editing the reports is not to say. It’s not as user-friendly as it could be. Those are the reasons why Salesforce users opt for external reporting using spreadsheet apps and data visualization tools.

Export Salesforce data for custom reporting

There are several ways for you to export Salesforce data that we’ve covered in our dedicated guide. Meanwhile, the most actionable solution for reporting needs is when you can automate the data flow from Salesforce to your destination app.

For example, you can do this with the help of Coupler.io, an all-in one data analytics and automation platform. It allows you to automatically extract data from 70+ apps, including Salesforce, Pipedrive, Hubspot, BigQuery, and many others. Coupler.io can import your data to Excel, Google Sheets, and BigQuery. What’s more, you can connect Salesforce to Looker Studio for data visualization purposes if you’d like.

Regardless of the destination, your data will refresh according to your preferred schedule. For example, you can create a Salesforce report in a spreadsheet and schedule automated updates for every Friday morning at 9:00 am. Coupler.io will automatically transfer the latest Salesforce data to refresh your report at that time. The interval for the updates can vary from every month to every 15 minutes. The latter allows you to create self-updating reports and dashboards for near real-time monitoring.Β 

You can choose from hundreds of Salesforce data categories, such as Opportunities, Events, Payments, and others, to load to your spreadsheet or BigQuery table. The setup flow takes several clicks and up to five minutes depending on the chosen destination. Here is what it may look like:

30 salesforce integration

With the data loaded automatically to your spreadsheet, you can build custom reports, pivot tables, and dashboards and share them easily with your teammates, partners, and third parties.

Alternatively, you can connect this auto-updating spreadsheet to a professional data visualization tool to create advanced reports or dashboards.

31 custom report example

Is the built-in Salesforce reporting any good?

There cannot be an exact definition of good or bad for Salesforce reports. You can use them for your basic reporting needs, and they are good for that. At the same time, Salesforce reports are limited in functionalities compared to Google Sheets or Excel, where you can implement complex calculations. Not to mention progressive data visualization tools like Tableau or Looker Studio where the real magic happens πŸ™‚

So, if you feel that native reports are more than enough for your reporting, then you’re all good. If they are not, it’s time to go beyond Salesforce and consider external reporting as a go option. Good luck with your data!

  • Zakhar Yung

    A content manager at Coupler.io whose key responsibility is to ensure that the readers love our content on the blog. With 5 years of experience as a wordsmith in SaaS, I know how to make texts resonate with readers' queries✍🏼

Back to Blog

Comments are closed.

Focus on your business
goals while we take care of your data!

Try Coupler.io