The Recognition Details report makes it easy to identify data trends in recognition and user engagement. This guide covers the filters available to refine your data and how to interpret the provided visualizations. To view a sample Recognition Details report click here.
- Data Filters
- Key Data Metrics
- Recognitions
- Points Awarded
- Recognition Summary
- Exporting Charts and Graphs
- Source Data
Data Filters
To access the new Recognition Details report:
- Access “Admin Settings”
- Click on the “Reports” tab at the top of the screen.
- Find the “Recognition Details” report on the “Featured” tab
- Click “Open”
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.
- Budget: Select the budget(s) for recognition data.
- Cost Center: Choose applicable cost center(s).
- Recognition Program: Specify the program(s) to include.
- Recognition Type: Filter by monetary or non-monetary recognitions, or both.
- Hashtags: Filter by specific hashtags used in recognition programs.
- From Status/To Status: Choose between Active or Archived employees for sent/received recognitions.
- From Metadata/To Metadata: Filter by employee metadata tags, if applicable.
-
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 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.
| Header | Example | Description |
|---|---|---|
| DATE* | 3/15/2023 17:50 | MM/DD/YYYY and time of the recognition. |
| FROM FULL NAME* | Dan Anderson | The full name of the user giving the recognition. |
| TO FULL NAME* | Aaron Cellier | The full name of the user receiving the recognition. |
| POINTS AWARDED* | 10 | The number of points awarded. The awarded points may deviate from the nominated amount based on the approver's discretion when the nomination reaches their queue. |
| TAGS* | Teammate, Dedicated | Hashtags attached to the recognitions. These are selected by the recognizer and will be separated by a comma if several are selected. |
| PROGRAM ID | 21186 | An Id assigned by the platform to the recognition program. |
| FROM PREFERRED NAME | Dan | The preferred name of the user giving the recogniton. |
| TO PREFERRED NAME | Aaron | The preferred name of the user receiving the recognition. |
| NOMINATION AMOUNT | 10 | The point amount recommended by the nominator for approval within the recognition queue. |
| PROGRAM NAME* | 2116 | An Id assigned by the platform to the recognition program. |
| RECOGNITION NOTE | Thanks for everything!! | Text attached to the recognition input by the recognizer. |
| RECOGNITION SOURCE | Platform | The source of the recognition. This value will either be: Platform, Microsoft Outlook, Microsoft Teams, Slack, Workplace by Meta, API, Queued, Birthday, Onboarding, Service Awards, Website Tab for Microsoft Teams, Manual MemoryBook, Lifestyle Spending Account, Survey, External Recognition, Health Rewards, AwardCode, Microsoft Bundle, or Encore. |
| VISIBILITY | Public | How the recognition appears on the social feed. Options are "Public" or "Private". |
| FROM EMPLOYEE ID | 55330 | Employee Id of the user giving the recognition. |
| FROM SUPERVISOR ID | 54891 | Employee Id of the supervisor of the user giving the recognition |
| FROM EMAIL | dan.anderson@abc.com | The email of the user giving the recognition. |
| FROM STATUS | Active | The employment status of the person giving the recognition. This value will either be "Active" or Archived". |
| FROM COUNTRY | US | ISO 2 letter country code associated with the user giving the recognition. |
| TO EMPLOYEE ID | 55357 | Employee Id of the user receiving the recognition. |
| TO SUPERVISOR ID | 54994 | Employee Id of the supervisor of the user receiving the recognition. |
| TO EMAIL | aaron.cellier@abc.com | The email of the user receiving the recognition. |
| TO STATUS | Active | The employment status of the person receiving the recognition. This value will either be "Active" or Archived". |
| TO COUNTRY | PH | ISO 2 letter country code associated with the user receiving the recognition. |
| BASE AMOUNT (ESTIMATED) | 10 | The value of the points given to the recipient of the recognition in the platform’s base currency. This number is adjusted for PPP, the tax buffer, and exchange rate. |
| BASE CURRENCY | USD | Currency code of the platform base currency. |
| USER AMOUNT (ESTIMATED) | 552.92 | The value the user receives in their country’s currency. This number is adjusted for PPP, the tax buffer, and exchange rate. |
| USER CURRENCY | PHP | The code of the user's local currency. |
| EXCHANGE RATE | 55.291875 | Exchange rate at time of recognition. |
| RECOGNITION ID | 26577119 | An Id assigned to recognition by the platform. |
| COST CENTER ID | USS190 | Id assigned to the cost center. This field only appears if you’ve implemented cost centers. |
| COST CENTER NAME | United States Sales 190 | Name assigned to the cost center. This field only appears if you’ve implemented cost centers. |
| BUDGET | Value Recognition | Name of the budget the points came from. |
| BUDGET ID | 3467802 | An Id assigned to the budget upon creation by the platform. |
| PARENT BUDGET | United States | The budget the defines the grouping via metadata or hierarchy. This is applicable if utilizing Budget Point Interface. |
| PARENT BUDGET ID | 3467801 | The ID associated to the parent budget grouping. his is applicable if utilizing Budget Point Interface. |
| TAXABLE | Yes | A “Yes” or “No” value specifying the taxability of the points awarded. This setting was determined in the set up of the budget - not an Awardco defined configuration. |
| UTC DATE/TIME | 3/15/2023 17:50 | MM/DD/YYYY and time of recognition in Universal Coordinated Time. |
| TOTAL REACTIONS | 15 | The number of reactions/emoji users left on the recognition in the social feed. |
| TOTAL COMMENTS | 2 | The number of comments users left on the recognition in the social feed. |
| CLAIM CODE | 2897NGVTMEUFRNE | AwardCode claim code associated with recognition. |
| FROM meta : [value] | From Meta: Job Title (VP of Human Resources) | Any metadata value associated with the user giving the recognition. |
| TO meta : [value] | To Meta: Department (Human Resources) | Any metadata value associated with the user receiving the recognition. |
| ADDITIONAL QUESTIONS | Question responses asked in the recognition form. | |
| EXTERNAL ADDITIONAL QUESTIONS | Question responses asked in External recognition programs. |
*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.
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.