How to Run a Report on Reports

Perhaps you are thinking about doing a Reports cleanup as part of your Lightning Transition. Salesforce has made it easy to report on Reports. Possible good use cases for using this Report type are: seeing how many reports you have in total, how many have been run recently, how many have NEVER been run (trust me you are going to have more than you expect), and lastly, which reports are now out of date.

To do this, simply go to Reports, and then search for Reports.

2019-10-05_12-46-33

Once you have your report, I recommend adding all of the columns as they each provide useful bits of information.
2019-10-05_12-47-07

For this example, I am choosing to group mine by both the Folder that the Report lives in and the Date (Quarter) it was created in.2019-10-05_12-52-05

After I have created and run the report, I can also add a chart that shows me the break down of record count by Folder and Quarter created in.2019-10-05_12-51-50

From here I can review the Last Run date and other data points to determine which Reports can be removed from the system.

2019-10-05_12-49-30

My recommendation is that before deleting reports, move them to their own Private folder so that if someone yelps about it being missing you can still put it back. I would give it about three months before deleting permanently.

I hope this helps your cleanup effort!

For making a quick move of reports make sure to check out my Reports Mover tool. 

One thought on “How to Run a Report on Reports

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s