Report: Points Redeemed

To effectively manage your Awardco programs, it's crucial to know if the points you're awarding are being utilized. The "Points Redeemed" report provides the insights you need by tracking point spending over time and summarizing key redemption data. Essentially, you'll gain a clear understanding of how employee points are being spent. This article will explain the filters you can apply to focus on specific data points and guide you in interpreting the provided data visualizations. Click here 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. Log In to your account
2. Select the “Admin” button at the bottom of the left navigation menu
3. Select “Insights”, “Reports”, then “Points Redeemed” from the left navigation menu

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. The report will include orders that have finished processing and whose processed date falls within the selected time 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
• Type: Filters for the type of the order. Options: Redemption, Return, or Adjustment.
• User Country
• Current Employee Status
• Employee Supervisor
• Category
• Any Metadata field listed on the user file

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 unspent points with points that have been spent. The percentage total is listed for each data point, providing another perspective on where points reside within your platform. The different colors represent points in the Company Account, points allocated to budgets, user points in their wallets, and points spent on redemption items. The legend below the graph clarifies which colors correspond to each of these data categories. The insights from this graph can indicate whether points are remaining unspent across the Company Account, budgets, and wallets, or if there's a high level of redemption, signifying strong engagement with Awardco within 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.