Northern Trail Outfitters wants to know the average stage duration for all closed opportunities. How should an administrator support this request?

Using Process Builder to capture daily average duration is an overly complex and unnecessary approach, as Salesforce already calculates and provides this data through standard reports.

Salesforce provides a standard 'Opportunity Stage Duration' report type specifically designed to track and calculate the average time opportunities spend in each stage, including for closed opportunities. This is the most direct and efficient method to obtain the requested information.

Adding formula fields to track stage duration would require custom development and would essentially re-create functionality already available in standard Salesforce reporting.

Refreshing weekly reporting snapshots captures historical data for trending purposes but is not the most direct method to determine the current average stage duration for closed opportunities, which is readily available in the standard report.