To harvest the data, I created a scheduled job in SQL Server which is set to run nightly at 7pm. I keep all of my utility scripts and data in a database called DBADB. Each instance has its own such database.
@results = 'expert',
@output_database_name = 'DBADB',
@output_schema_name = 'dbo',
@output_table_name = 'BlitzCache'
The report I wrote is based off expert mode results. There is a plethora of data in the report so it does get fairly wide. I don't display the values in QueryText or QueryPlan on the report, but in Figure 3 you'll note I provided the syntax to obtain the query plan and/or SQL text in the header. Copy in the plan_handle or sql_handle, respectively. Another option is to directly query your BlitzCache table for it.
There are four parameters on the report: Database Name, Sample Time, Query Type and Warnings. Most column headers allow you to sort so you can zero in on a particular performance metric of concern.
Figure 1 - Parameters
Figure 2 - Report Data - these are the first set of columns in the report:
Figure 3 - Report Data, cont. - scrolling to the right is more data: