My Firm Benefits Attribute Benchmark Report
The My Firm Benefits Attribute Benchmark Report report provides a "snapshot" of your firm's data for a single benefit attribute and in force date.
This report is available from either the Executive tab or Benchmarking tab of the BenefitPoint Business Intelligence window. Use the Executive Tab when you want to generate results for a single attribute; use the Benchmarking Tab when you want to review data for multiple attributes and look for trends.
This is a Data Mart report: only data entered as of 9 p.m. (Pacific Time) the previous day is included.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Requirements
Role:
Permissions:BBI Benefits Benchmark
How to Access
- From the main BenefitPoint window, click Business Intelligence in the top navigation menu. The Business Intelligence window opens.
- Select the Executive tab.
- In the hierarchy on the left, expand the Benchmarking category.
- Select My Firm Benefits Attribute Benchmark Report from the list: the pane on the right expands to display the selection parameters.
- Choose the selection criteria for your report and click Run Report.
- Once you have run the report, select a format for the report (such as Excel, or PDF) and click the link to view the report.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
Selection parameters enable you to select (or filter) the data that is included in the report results. For example, if you select the Account Type "Prospect" then only data for prospect accounts is included on the report.
* Required selection parameter.
Filter by Group Size and Industry
SELECTION PARAMETER | DESCRIPTION |
Account Status
|
Use this parameter to select Active or Inactive accounts for inclusion on the report. |
Account Type
|
Select an Account Type to filter the accounts that appear on the report: Client, Prospect, Informational, Other, or Marketing Group. |
Account(s)
|
Select up to five accounts to include on the report. Click the arrows to move your selection(s) between the Available and Selected lists. The list of available accounts is based on your User ID and permissions. |
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
OPTION | DESCRIPTION |
Report Results Title |
Use this field to enter your own title for the report. |
Show Parameters |
If selected, the report will list the parameters used to create the report. |
To get Report Results in |
The following output options are available for this report:
|
Save Report Parameters |
If you run this report with this set of parameter selections frequently, enter a title to save the set of parameters you just entered. You can run the report again at any time by selecting the saved parameter set on the My Reports tab. |
Save Report Results |
To save the report with the results, so that you can easily view the report again later, enter a title and click Save. You can view the report again at any time by selecting the report on the My Reports tab. |
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
FIELD | DESCRIPTION |
Business Segment (first column heading) |
The Business Segment can be Group Size, Coverage Type, Account Location, Account Industry, or By Renewal years, depending on your selection in the Group Results By parameter. Each group within the selected business segment is represented on a single row. For example, if Group Size was selected, the rows would be 1 (individual), 2 to 50, 51 to 100, 101 to 250, 251 to 500, 501 to 1000, 1001 to 2500, and Over 2500. |
Benchmark Ranges |
The columns vary depending on the Coverage Type and Benefit Attribute selected. The Benchmark Ranges correspond to the standard values for the attribute. For example, the attribute Benefit Frequency:Exam Vision, standard values are 12 months, 24 months, or Other. The report columns would display the percentage of plans that allow exams every 12, 24, or other number of months. If you select Orthodontia as the Benefit Attribute for Dental coverage, the possible values are Yes, No, or Other. These columns would display the percentage of plans that have Yes, No, and Other as the value for the attribute. See Benefit Attributes UOM and Acceptable Benchmark Ranges for the benchmark ranges for each coverage. |
Cases |
For each business segment group, the total number of accounts included in the data set based on the selected report parameters. |
Average Value |
For each business segment group, the average value for the attribute (sum of all values for the row divided by the number of data points). Average value is not calculated for some attributes. |
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
The sample report opens as an .xlsx spreadsheet.