If you plan to run a game that uses one or more KPIs that can't be tracked by using Microsoft Dynamics 365 (online), you can update the scores for those KPIs by using a Microsoft Excel template.
To minimize the ongoing effort required to run a game, we recommend that you rely on KPIs defined in Dynamics 365 (online).
Update scores by using the Excel file
Go to Games > Games.
Click the Excel Point Scoring ( ) button.
Select the game you want to update the scores from, and then click the game period you want to update.
Click Download Excel template , and then update the scores in the file.
The manually scored data needs to be up-to-date for the respective game period. All other KPIs will continuously sync from Dynamics 365 (online).
Click Upload Excel file to upload the file, including the manually updated scores.
The selected KPIs are now updated in Gamification for the selected game period.