Report: Points Redeemed (Legacy)

When running your Awardco programs, it’s helpful to know if points given are actually being utilized. The Points Redeemed report gives you exactly what you need in terms of tracking point spend period-over-period, and assists in summarizing top redemption data. Essentially, you’ll be able to see where employee’s points are being spent. This article will explain filters you can apply to narrow down specific data points, and how to interpret the data visualizations provided. Click here a for a downloaded sample report. 
 

1. Data Filters
2. Spend
3. Points Spent Comparison
4. Summarize By
5. Exporting Charts and Graphs
6. Source Data

Data Filters

To access this report:

1. Access “Admin Settings”
2. Click on the “Reports” tab at the top of the screen.
3. Find the “Points Redeemed” report on the “Featured” tab
4. Click “Open”

Before running the report, apply filters to narrow down your data. Unselected filters default to “Select All.” Available filters include:

• Time Frame: Select the time frame from which you’d like the report to pull data. Select an option from the list of default periods or specify a custom date range. Use the drop-down menu to the right to pull the report in your preferred time zone. UTC is recommended for reconciliation with Awardco reports. 
• Award Option
• User Country
• Current Employee Status
• Any Metadata field listed on the user file
• Data Visibility: Filter data based on organizational hierarchy:
  • Immediate Reports: View data for direct reports.
  • All Reports: Access data for all users in your downline.
  • Everyone: See data for the entire organization.
  • Peers: Review data for colleagues with the same manager.

If you plan on exporting the Points Redeemed report, use the drop-down menu on the right to select columns that will appear on your exported .csv file. The column options are as follows:

Note: The examples below show an employee mapped to Mexico with a platform base in USD.
 

*If no column specifications are applied, these columns will load by default.
 

Once you’ve selected your preferred filters, select “Run the Report” to display the data. If you’d like to export the data in a .csv format, select “Export”. If you’d like to save these search parameters, select “Save View” and enter a name for your saved view. The next time you access the Points Redeemed report you can access this saved view in the drop-down menu at the top right. If you “star” or favorite a saved view, it will be the default report that loads first and runs automatically. If you'd like a saved view to be sent to your email on a regular cadence, please visit our Sending Scheduled Reports article to find out more on how to configure this option. 
 

Now that you’ve run the report, you’ll see below several data visualizations and graphs. The following sections will explain each and help you interpret engagement trends and recognition program usage.
 

Spend

This stacked bar graph compares the points unspent and the points spent. The percentage total is listed by each data point to provide another view of where points exist in your platform. The different colors presented represent points in the Company Account, points found in budgets, user points in wallets, and points spent on redemption items; the legend below specifies the colors that match their respective data points. Depending on what this graph displays, you could either see that points are left unspent in the Company Account, budgets and wallets, or you could see high redemption and that Awardco is being highly utilized in your organization.
 

Points Spent Comparison

Below the Spend summary, we’ll find the Points Spent Comparison section. This part of the report provides redemption data in the form of a line graph. The X axis represents the time period selected; in this case the data is from January 1, 2022 to May 26, 2022. The Y axis reflects the number of redemptions made on the presented day, week, month, year etc. The solid line shows real time data and the dotted line represents data from the previous time period. There are three data metrics at the top of the graph that also summarize redemption data: Points Spent, Average Points Per Order, and number of Orders. You’ll see that percentage growth or decrease is also exhibited; this growth or decrease represents the change in data between the time period selected and the previous time period. Select any of the three data points to access historical data on the line graph. 
 

Summarize By

This section shows a pie chart that summarizes redemption data from different filter categories presented in the drop-down menu to the right of the graph title. The initial filter applied here is Award Option. This view provides insight into what redemption options employees value the most.
 

If we look at the drop-down we’ll see we can select from a list of the filters we applied. If we select “Award Item”, the top redemption item details are shown.
 

Exporting Charts and Graphs

If you'd like to export any chart, graph, or data visualization as a single PNG image, click on the circular icon at the top right of any graph. 
 

Source Data

At the bottom of the page you’ll find the raw data that the data visualizations draw from above. If you were to export the report to a .csv/JSON file, this is the same format you would find. Use the search bar to search for keywords such as employee names, award options, and item values. Click here for a sample report. 
 

If you have any questions, please contact Awardco Admin Support.