Report: Recognition Details

The Recognition Details report provides a straightforward way to identify trends in employee recognition and user engagement. This guide explains the available filters for refining your data and how to interpret the visualizations provided. To view a sample Recognition Details report click here. 
 

1. Data Filters
   • Column Clarifications
2. Key Data Metrics
3. Recognitions
4. Points Awarded
5. Recognition Summary
6. Exporting Charts and Graphs
7. Source Data

Data Filters

To access the Recognition Details 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 “Recognition Details” 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: Choose a default period or set a custom date range. Use UTC for Awardco report reconciliation. The report includes recognition data based on when the recognition was completed.
• Budget: Select the budget(s) for recognition data.
• Cost Center: Choose applicable cost center(s).
• Recognition Source: Choose the source from which the recognition was sent (e.g. Platform, Slack, etc.)
• Recognition Program: Specify the program(s) to include.
• External Recognition Program (if enabled)
• Recognition Type: Filter by monetary or non-monetary recognitions, or both.
• Hashtags: Filter by specific hashtags used in recognition programs.
• Visibility: Private/Public
• From/To Full Name
• From/To Supervisor
• From/To Status: Choose between Active or Archived employees for sent/received recognitions.
• From/To Country
• From/To Metadata: Filter by employee metadata tags, if applicable.
• Giving Guide: Choose to include recognitions sent through programs where the Giving Guide was enabled (either Required or Optional).

If you plan on exporting the Recognition Details 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 example below demonstrates Recognition Details data for a user in the United States recognizing a user in the Philippines. 

*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 Recognition Details 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.

Column Clarifications

Here are more detailed explanations for the BASE AMOUNT, BASE AMOUNT (ESTIMATED), USER AMOUNT, and USER AMOUNT (ESTIMATED) columns, including when each is used and how they differ, especially regarding exchange rates (FX) and Purchasing Power Parity (PPP).

• BASE AMOUNT: The value of the awarded points, displayed in your company’s base currency. No adjustments are applied.
  • How is this different from Base Amount (Estimated)? 
    • No adjustments are applied—this is the raw value without PPP, regardless of location. BASE AMOUNT will be the same as BASE AMOUNT (ESTIMATED) only if PPP is off. When PPP is on, the two may differ if the recipient is outside the base currency. This often matches the Points Awarded column (unless your platform uses a non-1:1 point ratio).
• BASE AMOUNT (ESTIMATED): The estimated value of the recipient’s points, displayed in the platform’s base currency, with FX and PPP taken into consideration. This value is stamped on the date of awarding.
  • When is this used? 
    • This value is the estimated amount that will be pulled from the redemption account balance when an employee spends their points. It is always in the base currency. This is most often used for financial forecasting or for clients' tax calculations when employees are awarded.
  • How is this different from Base Amount? 
    • If your platform doesn't use PPP, both these values will be the same. If your account uses the PPP tool, these values are different. It's essential to understand the financial liability when an award’s recipient is in a different country than the base currency. For this reason, the BASE AMOUNT will be different from the BASE AMOUNT (ESTIMATED) if your platform uses PPP.
  • Does this value calculate Exchange Rate (FX) in addition to PPP? 
    • Yes. Both FX and PPP are calculated in BASE AMOUNT (ESTIMATED). Note, however, that an FX value is moot for base currency values as there is nothing to exchange. Also, PPP is only applied if that tool is turned on and used (not all clients opt to leverage this tool). This value does not include the platform’s tax buffer, as some redemption options (like gift cards) do not use that system. For an exact value at checkout, use the Points Redeemed report.
• USER AMOUNT: The value of the awarded points, displayed in the recipient’s currency using only the exchange rate (FX) at the time of awarding.
  • How is this different from User Amount (Estimated)? 
    • Only FX is applied—this is the raw value without PPP, regardless of location. USER AMOUNT will be the same as USER AMOUNT (ESTIMATED) only if PPP is off. When PPP is on, the two may differ if the recipient is outside the base currency.
• USER AMOUNT (ESTIMATED): The estimated value of the recipient’s points, displayed in the recipient’s currency, with FX and PPP taken into consideration. This value is stamped on the date of awarding.
  • When is this used? 
    • This value is the estimated amount the end user sees when they spend their points. This value is most often used by country-specific teams looking to calculate payroll.
  • How is this different from User Amount? 
    • If your platform doesn't use PPP, both these values will be the same. If your account uses the PPP tool, these values are different. It's essential to understand the financial liability when an award’s recipient is in a different country than the base currency. For this reason, the USER AMOUNT will be different from the USER AMOUNT (ESTIMATED) if your platform uses PPP.
  • Does this value calculate Exchange Rate (FX) in addition to PPP? 
    • Yes. Both FX and PPP are calculated in USER AMOUNT (ESTIMATED). Note: PPP is only applied if that tool is turned on and used (not all clients opt to leverage this tool). This value does not include the platform’s tax buffer, as some redemption options (like gift cards) do not use that system. For an exact value at checkout, use the Points Redeemed report.

Key Data Metrics

Right below the data filters you’ll see 4 tiles with the data metrics: People Recognizing, People Recognized, Total Recognitions, Total Points Awarded. People Recognizing shows the total unique givers that have distributed recognitions, while People Recognized displays the total unique receivers of recognitions. All four numbers reflect the time period and any other filters applied in the previous steps.
 

Recognitions

This section displays total recognitions given 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 16, 2022. The Y axis reflects the number of recognitions given 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 recognition data: Recognitions Submitted, People Recognizing, and People Recognized. Select any of these three tiles to display their respective information on the graph. You’ll see that percentage growth or decrease is also exhibited; this percentage growth or decrease represents the change in data between the time period selected and the previous time period.

If your organization utilizes hashtags in recognition programs, a Hashtag Usage tile will show. Select this tile to generate a graph showing hashtag usage. Hover over a line or specific point in time to view details about the tag usage.
 

Points Awarded 

This section displays total points awarded 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 16, 2022. The Y axis reflects the number of points given 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 four data metrics at the top that also summarize points awarded data: Total Points Awarded, Estimated Value of Points Awarded (value adjusted by PPP/exchange rate), Average Recognition Points, and Average Value of Points Awarded. 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. 
 

Recognition Summary

This section shows a pie chart that summarizes recognition data from different categories presented in the drop-down menu to the right of the graph title. The default view is "Recognition Program" which helps you see the top recognition and automated programs being utilized. 
 

Looking at the drop-down, you can select from a list of the filters applied. For example, selecting “Budget” shows you the percentage of recognitions that come from specific budgets.
 

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, budget names, and recognition program names. To view a sample Recognition Details report click here. 

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