reports.atlassian.com (RAC) currently queries TAC database every day and calculates aggregate data. The results are stored in the RAC database, on which RAC is then able to run reports.

Note, that every time (i.e. every day) the data is pulled from TAC into RAC, all the TAC data in RAC is deleted, and then then the attached queries are run on TAC db and the results are reinserted into the RAC db.

Please check the queries to ensure they do what we need and fix the problems that you find so that we can give the fixed queries back to John R.

The most important thing is to track the amount of translations that are done per day, per language, per user. For now, do not worry about tracking whether the translations are done through the UI or through an import.

Couple of things I already know that need fixing:

1. Change queries to group data per day, rather than per month
2. Ensure the type of translations is reported correctly. The type means that it was translated by a real user or Google, etc. We changed how this works so I suspect the current query is broken
3. Ensure everything works for all products supported by TAC, inlcuding GreenHopper and add Team Calendars