Skip to main content

Upgrade Candidates Report

The Upgrade Candidates report is particularly useful in identifying subscribers who are regularly maxing out their current plan and would benefit by upgrading their capacity to a faster tier of service. Be sure to include them in your next campaign for bringing awareness about alternative plan offerings that would make for a more enjoyable internet experience.

This report offers marketeers a view of critical statistics, including the number of subscribers per each speed tier, and a detailed table showing subscriber's current experienced upload and download speeds, plus experience scores and an indicator of feasibility for upgrading to a faster plan. When selecting an individual subscriber from the table, a chart appears showing the current tier to which they are subscribed to alongside potential tiers to which they can upgrade.

The data from the charts and the table can be viewed on screen or exported in various formats to your local drive to be consumed offline.

Follow these steps to access this report...

  1. Select the (Promote) icon from the left navigation bar.

  2. Select Upgrade Candidates from the series of rounded buttons across the top of the page.

The resulting page displays the following three tiles:

  • Speed Tiers: A circular chart that groups subscribers by plan type.

  • Upgrade Tiers: A bar chart showing the current tier to which a selected subscriber is subscribed, along with potential tiers to which they can upgrade.

  • Upgrade Candidates: A detailed table with a row for each subscriber showing current experienced upload and download speed, experience scores and an indicator of feasibility for upgrading to a faster plan.

The content of each of these tiles is described in detail in the following sections.

Speed Tiers Chart​

In the upper-left tile, the Speed Tiers tallies up your subscribers and groups them by currently subscribed speed tier.

Each segment on the circular chart represents a different tier and is expressed in a different color. Refer to the legend below the chart to find the significance of each color. Hover your mouse over any colored segment in the circular chart to reveal the details about that speed tier.

You can interactively customize the chart to display only the color slices/categories of your choosing. Select the text in the legend to toggle each slice/category off (legend color dot will be gray) or on (legend color dot returns to the designated color for that category).

Export or Print Chart Data​

To export data from this tile to your local hard drive, select the hamburger menu icon near the upper right of the chart, and then choose an appropriate file format from the options displayed in the resulting drop-down list.

The following formats are available for export:

  • SVG: Scalable Vector Graphics, an image file format

  • PNG: Portable Network Graphics, an image file format

  • JPG: Joint Photographic Experts Group, an image file format

  • CSV: A comma-separated, raw text file

  • XLS: Microsoft Excel format

Additional options for alternate views of chart data are also available from the same hamburger menu , and include:

  • View in full screen

  • Print chart

  • View data table

Upgrade Tiers Chart​

At the bottom of the screen, the Upgrade Tiers table shows the current tier to which a selected subscriber is subscribed, along with potential tiers to which they can upgrade.

The Upgrade Tiers chart is blank until an individual subscriber is selected from the Upgrade Candidates table at the bottom of the screen.

The subscriber's existing package is shown in dark blue on the bar chart. The alternate tier offerings are shown in teal blue.

The labels immediately below each pair of bars refer to the speed tier associated with the upgradeable package.

The vertical axis of the bar chart represents the cost associated with the tiers displayed. Hovering the mouse cursor on any of the bars in the chart also reveals this statistic in a tool tip.

Export or Print Chart Data​

Just like the Speed Tiers chart, the data from this chart can also be exported to various formats to your local drive.

To export data from this tile to your local hard drive, select the hamburger menu icon near the upper right of the chart, and then choose an appropriate file format from the options displayed in the resulting drop-down list.

The following formats are available for export:

  • SVG: Scalable Vector Graphics, an image file format

  • PNG: Portable Network Graphics, an image file format

  • JPG: Joint Photographic Experts Group, an image file format

  • CSV: A comma-separated, raw text file

  • XLS: Microsoft Excel format

Additional options for alternate views of chart data are also available from the same hamburger menu , and include:

  • View in full screen

  • Print chart

  • View data table

Upgrade Candidates​

At the bottom of the page, the Upgrade Candidates table provides current experienced upload and download speed, experience scores, and a Yes or No indicator of feasibility for upgrading to a faster plan for each subscriber.

The table contains following subscriber data:

Column         Description

Full Name         The first and last name of the subscriber.

Account Number     The account number associated with the subscriber.

Service Type       The medium by which this subscriber is serviced.

note

Possible values for this column are: Broadband, Cable, Wireless

Site Name          The name of the chassis that services this subscriber.

Package          The name of the subscription plan to which this customer currently subscribes.

Download Speed (Mbps)      The download speed associated with the subscription rate for this subscriber.

Upload Speed (Mbps)       The upload speed associated with the subscription rate for this subscriber.

Download Experience Score   This value indicates how often this subscriber is consuming most or all of their available download                  bandwidth.

note

Expressed as a percentage of time, in a range from 0-100 where 100 indicates the subscriber is not experiencing any bandwidth related performance issues.

Upload Experience Score     This value indicates how often this subscriber is consuming most or all of their available download                   upload.

note

Expressed as a percentage of time, in a range from 0-100 where 100 indicates the subscriber is not experiencing any bandwidth related performance issues.

DSL Upgrade Feasible  

info

Returns a value of Yes when there is a subscription package available at a rate above this subscriber's current rate but is also less than or equal to the attainable rate of the loop that services their site.

info

A value of No is returned when no such subscription package is available. This indicator is available only for DSL subscribers

Filter And Sort The Table​

Select Custom Filtering​

Filters of your choosing can be applied to this table. By selecting the button adjacent to the header for columns containing numeric data, upper and lower limits can then be set by dragging the endpoints.

  • Drag the right endpoint of the filter toward the left to set the upper limit.

  • Drag the left endpoint of the filter toward the right to set the lower limit.

For filtering columns containing non-numeric data, a free-form text field appears instead of the above described interface. Simply key in the string you want to use for filtering, then press the Enter key.

Filter With Charts​

Filters can also be applied by using the charts above the table. Select the appropriate variable for the filter you would like to apply. Selecting the variable in the color key below each chart will not apply filters to the table.

Change The Sort Order​

The sort order of the data columns can also be changed. Hover your mouse over the column header to reveal a small arrow pointing upward.

And upwards arrow indicates that the sort order for that column is ascending. Select the arrow to toggle the sort order to descending. The arrow now points downward.

Select the downward pointing arrow icon again to revert the sort order to ascending. The table can only be sorted by one column. Secondary and tertiary sorting is not supported.

Clearing Filters​

To clear all applied filters, select the Clear Filters button at the top right of the table.

Export The Table Data​

Select the blue, rounded Export button just beneath the table title to export the data to CSV format. A common save dialogue will appear so that you can choose where the file will be saved on your local hard drive.