Viewing CU Reports

Introduction

The REPORTS page allows underwriters and managers to view and generate on-demand reports that show key metrics and details about submissions that match specific criteria, view and analyze trends to better understand their team's performance and a portfolio dashboard that allows them to surface customer data through a PowerBI integration.

The REPORTS page has three main parts:

• On-Demand Reports
• Trends Reports
• Portfolio View

This page describes how to use the REPORTS page to find the data you need to understand where your submissions are in the underwriting process, how well your team is performing and where they need more support, and how to access your customer data in other systems in the Connected Underwriting P&C solution.

On-Demand Reports tab

Connected Underwriting P&C allows you to generate and view on-demand reports that provide real-time data about all submissions in the underwriting pipeline for a given period or submissions that match specific criteria. The up-to-date information in these reports gives you greater confidence in your decisions because you know the data is current and accurate.

Key metrics at the top of this page provide a quick snapshot of where your business stands with regard to submissions resulting in new business, renewals, acceptance, and declines.

Generating on-demand reports

When you navigate to the REPORTS page, by default, the On-Demand Report tab is selected, and Connected Underwriting P&C displays an on-demand report for all New Businesses for the current date.

To generate a new on-demand report that matches specific criteria, apply one or more filters and click GENERATE REPORT. The resulting report displays key metrics and data for the submission data you want to see.

Available filters include:

• Report Type: Users can select to generate an on-demand report for a specific type only. Report types options include: New Business, Renewals, Accept, and Decline.
• Date Range: Users can select to look at the report data over time using the data range picker (start and end dates). By default, the on-demand report dashboard displays the current date as the start and end time.
• Insurance Line of Business: The business classification defined by the insurer and associated with submissions. Selections include Commercial Auto, Commercial Package, and Commercial Property.
• Broker Office: The broker office who submitted the submission for a customer.
• Customer State: The US territory for a customer associated with a submission.

Viewing reports

After generating an on-demand submission report, you can see key metrics that summarize the submissions that match your filter criteria, including the total number of new submissions that account for new business, new business accepted, new business declined, and the average time it takes to reach a submission decision.

In addition, you can view a list of all the submissions in the report grid. To get detailed data about a particular submission, locate the submission record in the report grid and click the associated link to drill down into the submission record.

Exporting reports

Do you need to view or reference an on-demand report outside the solution? Whether you need to share submission data with other teams for collaboration or compliance or make the data more accessible by making it available in a different format, Connected Underwriting P&C makes it easy for you to export an on-demand report to Excel by clicking the download icon.

Trends tab

The Trends tab gives underwriting and managers insights into how their teams perform by allowing them to view productivity metrics and determine where submissions are in the underwriting process. This data can help them quickly identify their teams' caseload and throughput, any bottlenecks in the process, and any reoccurring positive or negative patterns by team, line of business, state, and more.

The Trends tab includes the following reports:

• Volume By Line of Business
• Submission by Broker Office
• Average Cycle Time
• Submission Creation by Type
• Submission Decisions
• Volume By Customer State
• Declined Submission Reasons

Need to see your team's productivity during a specific date range or determine the number of submissions created for a specific line of business? The Trends page allows you to apply one or more filters to adjust the data shown in all the reports to display only the data that match your filter criteria. For example, select a start and end date filter to display the data for a specific date range or select one or more LOBs to display the data for specific lines of business for a given date range.

A start and end date are required for the Trends reports. By default, the display data for all lines of business and all customer states for the current date.

Volume By Line of Business report

The Volume By Line of Business pie chart displays the volume of submissions by percentage for each line of business.

As an underwriting manager or admin, you can use this chart to answer the following questions:

• What is the total volume of submissions my organization is handling:
  • During a specific time (start and end date)?
  • For a specific customer state or across all customer states?
  • For a specific line of business or across all lines of business?

You can also apply one or more filters to the Trends tab to narrow the data displayed in this chart to return only the submissions that match specific criteria.

Submission By Broker Office report

The Submission By Broker Office stacked bar chart displays the count of the top five submissions with an accept or decline decision by the broker office. To view a list of all submissions across your broker offices, click the View All link associated with this chart.

Want more detailed information about the submissions for a specific broker office? Hover over a specific bar in the chart to see the number of accepted vs. declined submissions for that broker office.

Additionally, when you hover over a specific bar, you can click the Accept link or Decline link to see a list view of all the submissions with an accept or decline decision for that particular broker.

As an underwriting manager or admin, you can use this chart to answer the following questions:

• What is the total number of submissions for each broker office that have reached an accept or decline decision:
  • During a specific time (start and end date)?
  • For a specific customer state or across all customer states?
  • For a specific line of business or across all lines of business?

You can also apply one or more filters to the Trends tab to narrow the data displayed in this chart to return only the submission data that match specific criteria.

Average Cycle Time report

The Average Cycle Time section displays two data points: the average number of days it takes for your organization to make a submission acceptance decision and the average number of days it takes to decline a submission.

You can also apply one or more filters to the Trends tab to narrow the data displayed in this section to return only the average number of days it takes your organization to accept or decline a submission for:

• A specific time (start and end date)?
• A specific customer state or across all customer states?
• A specific line of business or across all lines of business?

Submission Creation by Type report

The Submission Creation by Type line graph compares the number of submissions that resulted in new business vs. renewals that your organization handled during the prior six months.

Additionally, when you hover over a specific point on the line graph, Connected Underwriting P&C shows the exact number of submissions that resulted in new business or renewals.

You can also apply one or more filters to the Trends tab to narrow the data this line graph displays to return only the submissions that resulted in new business vs. renewals for:

• A specific customer state or across all customer states?
• A specific line of business or across all lines of business?

By default, the results returned map to the submission data for the prior six months.

Submission Decisions report

The Submission Decisions pie chart displays the percentage of submissions your organization handled that were accepted vs. declined.

As an underwriting manager or admin, you can apply one or more filters to the Trends tab to narrow the data this pie chart displays to return only the submissions that were accepted or declined for:

• A specific time (start and end date)?
• A specific customer state or across all customer states?
• A specific line of business or across all lines of business?

Volume By Customer State report

The Volume By Customer State stacked bar chart displays the volume of submissions your organization handled for each line of business by customer state. By default, this chart only shows the top 5 submission results.

You can also apply one or more filters to the Trends tab to narrow the data displayed in this chart to return only the submission data that match specific criteria.

To view this data in list form, click the View All link associated with this chart. Connected Underwriting P&C will display the data by customer state, showing the total number of submissions for commercial property, commercial auto, and commercial package.

Click on the submission count for any line of business to see a complete list of the submission records. Use this view to locate a specific submission record, and click the record link to drill down and see more details. You can also access the customer record from this view.

As an underwriting manager or admin, you can use this chart to answer the following questions:

• What is the total number of submissions your organization handled for each line of business by customer state:
  • During a specific time (start and end date)?
  • For a specific customer state or across all customer states?
  • For a specific line of business or across all lines of business?

You can also apply one or more filters to narrow the data in this graph down to return the results that match your filter criteria.

Declined Submission Reasons report

The Declined Submission Reasons pie chart shows an underwriting manager the percentage of submissions that were declined by reason. Options include: Submission Withdrawn, Coverage Not Offered, Loss Exposure, Loss History, and Other, which consists of any submissions that were declined for reasons that do not match one of the other decline categories.

You can use this chart to answer the following questions:

• How many submissions were declined because your company did not offer the type of coverage requested?
• How many submissions were declined by the customer was considered high risk?
• How many submissions were declined for any reason during a specific time (start and end date)?
• How many submissions were declined for a specific line of business?
• How many submissions were declined for a specific customer state?

Portfolio View tab

Having a macro view of your entire business is critical to decision-making. Connected Underwriting P&C provides a way for you to surface a portfolio view of your external data sources through a Microsoft PowerBI integration.

Once this integration is set up and configured, you'll have access to the Portfolio View tab on the REPORTS page as an underwriting manager. This tab provides a dashboard view that allows you to surface reports and data from your external systems into your Connected Underwriting P&C solution, providing a centralized view of all the information you need to understand your health of your business operations at any time. Have the insights you need to identify and track key performance indicators that tell you how well your teams are doing against major goals and initiatives and make sound decisions about changes, risks, and other factors that impact your business.

See Integrating with Microsoft PowerBI for instructions on how to set up the connected system and configure the Microsoft PowerBI integration with your Connected Underwriting P&C solution.

Feedback