Data sets in the new reporting module

When creating custom reports, you can choose from several data sets. A data set is a data source consisting of several dimensions (data sub-sets).

Data sources

There are several available data sources:
  • File Translation Status

    This data source shows an entry for each target file in the system, as well as tabular data about the human workflow. The data about translation and review workflow steps is displayed on one line. If the workflow does not contain all the steps, the columns reserved for them show null placeholders.

    The metrics included in this data source are:
    • Total number of source words
    • Total number of words translated in the pre-translated task (and their distribution)
    • Total number of human-translated words
    • Total number of human-reviewed words
    • Total workflow duration (from project creation to finalization)

    The data for the File Translation Status data source becomes available after the Analysis workflow task has been completed.

  • Task Status

    This data source shows metrics for each task executed in the system.

    The metrics included in this data source are:
    • Actual duration
    • Estimated duration
    • Delivery duration
    • Word count

    The data for the Task Status data source becomes available after the Analysis workflow task has been completed and is updated every time a workflow task is completed.

  • TQA Review Summary

    This data source shows metrics about the overall translation quality, collected during the Linguistic Review and Customer Review tasks.

    The data for the TQA Review Summary data source becomes available after the Linguistic Review or Customer Review task has been completed.

  • Language Revenues

    This data source shows the costs of each language direction.

    The metrics included in this data source are:
    • Translation cost per target language
    • Additional cost per target languages
    • Additional cost per project
    • Total cost
    • Total number of source words per source language
    • Total number of files per source language
    • Discounts

    The data for the Language Revenues data source becomes available after the Customer Quote Generation task has been completed.

  • Language Revenue Details

    This data source shows the costs of each project per language direction.

    The metrics included in the data source are:
    • Total revenue
    • Total number of units that generated revenue

    The data for the Language Revenue Details data source becomes available after the Customer Quote Generation task has been completed.

  • Projects

    This data source provides users an overview of all the projects they work with, irrespective of project status. Moreover, the Projects data source allows users to interrogate project data directly, without the need to start building queries at task level or file level. The Projects data source consists of the all the fields in the Projects dimension, plus the following fields: Customer ID, Customer Name, and Project Origin. The Projects data source cannot be joined with other data sources.

  • Translation Assessment

    This data source shows metrics about how the reviewer evaluated the translation.

    The data for the Translation Assessment data source becomes available after the reviewer has made at least one change and has completed the review task.

  • Translation Productivity

    This data source shows metrics about what the translator changed during the translation task.

    The data for the Translation Productivity data source becomes available after the translator has translated at least one segment and has completed the translation task.

  • Translation Productivity Assessment

    This data source shows metrics about what the translator did during the translation task and about how the reviewer evaluated the translation.

    The data for the Translation Productivity Assessment data source is updated each time a translation or review task is completed.

  • Translation Leverage

    This data source shows information about the translation leverage metrics obtained as a result of automated translation. The data source exposes file-level metrics detailing the number of words for each leverage bucket.

    The data for the Translation Leverage data source becomes available after the Analysis workflow task has been completed.

  • Translation Quality Estimation

    This data source shows details about the evaluation done with Smart Review and MTQE (Evolve) in a project. This data source takes into account all project segments, and does not currently provide information for individual segments.

  • Vendor Cost

    This data source shows metrics about the costs associated with each vendor for each project and language direction.

    The data for the Vendor Cost data source becomes available after the Vendor Quote Generation task has been completed.

  • Data Overview

    This data source shows metrics about the leverage and costs associated with each target language in a project.

    Compared to other data sources, which are updated in near real time, the Data Overview data source is updated only three times per day, at 9 AM, 4 PM, and 11 PM UK time.

Check the table below for an overview of the dimensions (data sub-sets) in each data source:
DimensionFile Translation Status

(data source)

Task Status

(data source)

TQA Review Summary

(data source)

Language Revenues

(data source)

Language Revenue Details

(data source)

Projects (data source)Translation Assessment

(data source)

Translation Productivity

(data source)

Translation Productivity Assessment

(data source)

Translation Leverage

(data source)

Translation Quality Estimation (data source)Vendor Cost

(data source)

Approve Datesnononoyesnononononononono
Currenciesnononoyesyesnonononononoyes
Current Task Statenoyesnononononononononono
Customer Review Dateyesnonononononononononono
Customer Reviewersyesnonononononononononono
Customersyesyesyesyesyesnoyesyesyesyesyesyes
File Translation Statusyesnonononononononononono
Finalization Dateyesnonononononononononono
Final Translation Originsnonononononoyesyesyesnoyesno
Human Originating Tasksnonononononononoyesnonono
Initial Translation Originnonononononoyesyesyesnoyesno
Language Pairsyesyesyesyesyesnoyesyesyesyesyesyes
Language Revenue Detailsnonononoyesnonononononono
Language Revenuesnononoyesnononononononono
Leverage Bandsnononononononononoyesnono
On Time Delivery Bandsnoyesnononononononononono
Project Creation Dateyesnononoyesnonononononono
Projectsyesyesyesyesyesyesyesyesyesyesyesyes
Quote Approversnononoyesnononononononono
Quote Datesnononoyesyesnonononononono
Revenue Typesnonononoyesnonononononono
Review Dateyesnoyesnononoyesnonononono
Reviewersyesnoyesnononoyesnononoyesno
Service Typesnononononononononononoyes
Source Filesyesyesyesnononoyesyesyesyesyesno
Task Datenonononononononoyesnonono
Task Ownersnoyesnononononononononono
Task Statusnoyesnononononononononono
Task Typesnoyesyesnononoyesyesnonoyesno
TQA Errorsnonononononononoyesnonono
TQA Pairsnonononononoyesnonononono
TQA Review Summarynonoyesnonononononononono
Translation Assessmentnonononononoyesnonononono
Translation Dateyesnonononononoyesnoyesnono
Translation Leveragenononononononononoyesnono
Translation Productivitynononononononoyesnononono
Translation Productivity Assessmentnonononononononoyesnonono
Translatorsyesnonononononoyesyesnoyesno
Translation Quality Estimationnonononononononononoyesno
Translation Quality Estimation Categoriesnonononononononononoyesno
Vendor Costnononononononononononoyes
Vendor Order Templatesnononononononononononoyes

Dimensions

Dimensions enable you to aggregate and filter the data in a data source.

Approve Dates
The Approve Dates dimension can be found in the Language Revenues data source. All the dates are expressed in UTC format.
  • Approve Date - Displays the date (yyyy-mm-dd)
  • Approve Day - Displays the day as a number (1-31)
  • Approve Day Of Week - Displays the position of a day in a week (1-7)
  • Approve Day Of Week Name - Displays the day name
  • Approve Day Of Year - Displays the position of a day in a year (1-365)
  • Approve Month - Displays the month as a number (1-12)
  • Approve Month Name - Displays the month name
  • Approve Quarter - Displays the position of a quarter in a year (1-4)
  • Year - Displays the year
Currencies
The Currencies dimension can be found in the following data sources: Language Revenues, Language Revenue Details, and Vendor Cost.
  • Currency Code - Displays the currency abbreviation
  • Currency Name - Displays the currency name in English
  • Currency Symbol - Displays the currency symbol
Current Task State
The Current Task State dimension can be found in the Task Status data source.
  • Task Status Key - Displays the status of the task, as generated internally by the system
  • Task Status Name - Displays the status of the task, as displayed in the UI
Customer Review Date
The Customer Review Date dimension can be found in the File Translation Status data source. All the dates are expressed in UTC format.
  • Customer Review Date - Displays the date (yyyy-mm-dd)
  • Customer Review Day - Displays the day as a number (1-31)
  • Customer Review Day Of Week - Displays the position of a day in a week (1-7)
  • Customer Review Day Of Week Name - Displays the day name
  • Customer Review Day Of Year - Displays the position of a day in a year (1-365)
  • Customer Review Month - Displays the month as a number (1-12)
  • Customer Review Month Name - Displays the month name
  • Customer Review Quarter - Displays the position of a quarter in a year (1-4)
  • Customer Review Year - Displays the year
Customer Reviewers
The Customer Reviewers dimension can be found in the File Translation Status data source.
  • Customer Reviewer Account Id - Displays the unique ID generated by Trados Enterprise for an account
  • Customer Reviewer Account Name - Displays the account name
  • Customer Reviewer Account User Id - Displays the unique ID generated by Trados Enterprise for an account user
  • Customer Reviewer Account User Location Id - Displays the unique ID generated automatically by Trados Enterprise for the folder where the account user is created (added)
  • Customer Reviewer Author - Displays the account ID of the person who added the user to an account
  • Customer Reviewer Author Hashed - Displays the hashed account ID of the person who added the user to an account
  • Customer Reviewer Creation Date - Displays the date and time (in UTC format) when the user was added to an account
  • Customer Reviewer Deletion Date - Displays the date and time (in UTC format) when a user was deleted
  • Customer Reviewer First Name - Displays the first name of the account user
  • Customer Reviewer First Name Hashed - Displays the hashed first name of the account user
  • Customer Reviewer Is Deleted - Displays if the user is deleted (1 - true) or not (0 - false)
  • Customer Reviewer Last Modification Date - Displays the date and time (in UTC format) when the user details were last modified
  • Customer Reviewer Last Name - Displays the last name of the account user
  • Customer Reviewer Last Name Hashed - Displays the hashed last name of the account user
  • Customer Reveiwer Membership - Displays the type of membership the user has with the account: member, collaborator (guest), null
  • Customer Reviewer Status - Displays if the user is active or deleted
  • Customer Reviewer User Email - Displays the email address of the account user
  • Customer Reviewer User Email Hashed - Displays the hashed email address of the account user
  • Customer Reviewer Vendor Id - Displays the unique ID generated automatically by Trados Enterprise for the vendor where the account user is a member. If the account user is not a member of a vendor, the column displays N/A.
  • Customer Reviewer Vendor Name - Displays the name of the vendor where the account user is a member. If the account user is not a member of a vendor, the columns displays N/A.

Users with the Manage Users in Group permission can see the email, last name. and first name of users as part of custom reports, while users without this permission can see only hashed information.

Customers
The Customers dimension can be found in the following data sources: File Translation Status, Task Status, TQA Review Summary, Language Revenues, Language Revenue Details, Translation Assessment, Translation Productivity, Translation Productivity Assessment, Translation Leverage, and Vendor Cost.
  • Customer Changed At - Displays the date and time (in UTC format) of the last customer update
  • Customer Changed By - Displays the user ID of the last user who updated the customer details
  • Customer Created At - Displays the date and time (in UTC format) when a customer was created
  • Customer Created By - Displays the user ID of the user who created the customer
  • Customer Custom Fields - Displays all the available custom fields associated with a customer
  • Customer Custom Field 1 - Displays one of the custom fields associated with a customer
  • Customer Custom Field 2 - Displays one of the custom field associated with a customer
  • Customer Deleted - Displays if the customer is deleted (1 - true) or not (0 - false)
  • Customer Id - Displays the unique ID generated automatically by Trados Enterprise for a customer
  • Customer Key Contact Email - Displays the email of the key contact
  • Customer Key Contact Id - Displays the unique ID generated by Trados Enterprise for the key contact
  • Customer Location Id - Displays the unique ID generated automatically by Trados Enterprise for the folder where the customer is created (added)
  • Customer Name - Displays the customer name
  • Customer Rag Status Name - Displays the custom flag set for customers: N/A (-1), green (0), amber (1), red (2)
Data Overview
The Data Overview dimension is a part of the Data Overview data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed directly within the data source.
  • All Fuzzy - Displays the number of fuzzy matches in each target language
  • All Fuzzy Costs - Displays the costs associated with fuzzy matches for each target language
  • Completed At - Displays the date and time (in UTC format) when the task was completed
  • Created At - Displays the date and time (in UTC format) when the task was created
  • Creator Id - Displays the account ID of the user who created the project
  • Creator Name - Displays the full name of the user who created the project
  • Cross-Document Repetition - Displays the number of repeated words across documents for each target language
  • Cross-Document Repetition Costs - Displays the costs associated with cross-document repetitions for each target language
  • Currency Code - Displays the currency in which costs are expressed
  • Custom Fields - Displays all the available custom fields
  • Customer Name - Displays the customer name
  • Due by Date - Displays the date and time (in UTC format) when the task is due
  • Fuzzy 1-6 - Displays the number of fuzzy matches in each leverage band (1-6)
  • Fuzzy Costs 1-6 - Displays the costs associated with fuzzy matches for each leverage band (1-6)
  • In Context Match - Displays the number of words translated as In Context Match for each target language
  • In Context Match Costs - Displays the costs associated with In Context matches for each target language
  • Language Additional Cost - Displays the additional cost per target language
  • Language Pair Id - Displays the ID of each language pair (source and target language)
  • Locked - Displays the number of words that must not be changed during translation for each target language
  • Locked Costs - Displays the costs associated with locked words for each target language
  • Match 100 - Displays the number of 100% matches in each target language
  • Match 100 Costs - Displays the costs associated with 100% matches for each target language
  • MT Match - Displays the number of words translated with an MT engine for each target language
  • MT Match Costs - Displays the costs associated with machine-translated words for each target language
  • New Words - Displays the number of words that could not be translated automatically for each target language
  • New Words Costs - Displays the costs associated with new words for each target language
  • Originating Customer ID - Displays the ID of the customer
  • Perfect Match - Displays the number of words translated as Perfect Match for each target language
  • Perfect Match Costs - Displays the costs associated with Perfect Matches for each target language
  • Project Additional Costs per Language - Displays the additional costs of the project, divided by the number of target languages in that project; for example, if a project has 4 target languages and an additional cost of 100 monetary units, the additional cost will be 25 for each target language
  • Project Group Name - Displays the name of the project group as entered by the user
  • Project Id - Displayed the unique ID generated by Trados Enterprise for a project
  • Project Name - Displays the project name
  • Quote Approved At - Displays the date and time (in UTC format) when the quote was approved
  • Repetitions - Displays the number of repeated words in each target language
  • Repetitions Costs - Displays the costs associated with repetitions for each target language
  • Short Id - Displays a shorter ID generated by Trados Enterprise for a project; for older projects, this will be 0 (zero)
  • Source English Name - Displays the source language in English
  • Source Language Code - Displays the ISO source language code
  • Status - Displays the project status: N/A, not_started, in_progress, canceled, completed
  • Target Costs - Displays the costs associated with each target language
  • Target English Name - Displays the target language in English
  • Target Language Code - Displays the ISO target language code
  • Target Words - Displays the number of words in each target language
  • Translation Cost Per Language - Displays the total translation-related costs for each target language
  • Word Count - Displays the number of words for each target language
File Translation Status
The File Translation Status dimension is a part of the File Translation Status data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Cross File Repetition Words - Displays the number of repeated words across files
  • Exact Match Words - Displays the number of words translated as Exact Match
  • Fuzzy Match Words - Displays the number of words translated as Fuzzy Match
  • Human Translated Characters - Displays the number of characters translated by translators
  • Human Translated Segments - Displays the number of segments translated by translators
  • Human Translated Words - Displays the number of words translated by translators. The number of words is computed based on the segment level statistics and represents the sum of words from all the segments with "interactive" translation origin as the final one.
  • In Context Match Words - Displays the number of words translated as In Context Match
  • Locked Words - Displays the number of words that must not be changed during translation
  • Machine Translation Words - Displays the number of words translated with an MT engine
  • New Match Words - Displays the number of words that could not be translated using automated means
  • Perfect Match Words - Displays the number of words translated as Perfect Match
  • Pipeline Duration (minutes) - Displays the duration in minutes from the project creation date to finalization task completion
  • Repetition Words - Displays the number of repeated words at file level
  • Review Duration (minutes) - Displays the review task duration (Start Date - Completion Date) in minutes
  • Reviewed Characters - Displays the number of characters changed by a reviewer
  • Reviewed Segments - Displays the number of segments changed by a reviewer
  • Reviewed Words - Displays the number of words changed by the reviewer. The number of words is computed based on the segment level statistics and represents the sum of words from all the segments with "interactive" translation origin as the final one.
  • Source Words - Displays the number of source words at file level
  • Translation Duration (minutes) - Displays the translation task duration (Start Date - Completion Date) in minutes
Finalization Date
The Finalization Date dimension can be found in the File Translation Status data source. All the dashboard dates are expressed in UTC format.
  • Finalization Date - Displays the date (yyyy-mm-dd)
  • Finalization Day - Displays the day as a number (1-31)
  • Finalization Day Of Week - Displays the position of a day in a week (1-7)
  • Finalization Day Of Week Name - Displays the day name
  • Finalization Day Of Year - Displays the position of a day in a year (1-365)
  • Finalization Month - Displays the month as a number (1-12)
  • Finalization Month Name - Displays the month name
  • Finalization Quarter - Displays the position of a quarter in a year (1-4)
  • Finalization Year - Displays the year
Final Translation Origins
The Final Translation Origins dimension can be found in the following data sources: Translation Assessment, Translation Productivity, and Translation Productivity Assessment.
  • Final Translation Origin Description - Displays the workflow name of the task
  • Final Translation Origin Source - Displays the internal code of the translation origin
Human Originating Tasks
The Human Originating Tasks dimension can be found in the Translation Productivity Assessment data source.
  • Human Originating Tasks Name - Displays the name of the task
Initial Translation Origins
The Initial Translation Origins dimension can be found in the following data sources: Translation Assessment, Translation Productivity, and Translation Productivity Assessment.
  • Initial Translation Origin Description - Displays the workflow name of the task
  • Initial Translation Origin Source - Displays the internal code of the translation origin
SourceDescription
N/AN/A
amtAdaptive Machine Translation
auto-alignedAuto Aligned
auto-propagatedAuto-Propagated
automatic-translationAutomatic translation
document-matchDocument Match
interactiveInteractive or Human modification
mtStatistical Machine Translation
nmtNeural Machine Translation
not-translatedNot Translated
retrofitAutomated Translation
sourceSource
tmTranslation Memory
unknownUnknown
defaultNew
Language Pairs
The Language Pairs dimension can be found in the following data sources: File Translation Status, Task Status, TQA Review Summary, Language Revenues, Language Revenue Details, Translation Assessment, Translation Productivity, Translation Productivity Assessment, and Vendor Cost.
  • Source English Name - Displays the source language in English
  • Source Language Code - Displays the ISO source language code
  • Source Parent Language Code - Displays the ISO parent source language code
  • Target English Name - Displays the target language in English
  • Target Language Code - Displays the ISO target language code
  • Target Parent Language Code - Displays the ISO parent target language code
Language Revenue Details
The Language Revenue Details dimension is a part of the Language Revenue Details data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Number of Units - Displays the number of units that generated the revenue
  • Revenue - Displays the revenue incurred from translation work
Language Revenues
The Language Revenues dimension is a part of the Language Revenues data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Language Additional Price - Displays the additional cost of the translation calculated at language-pair level
  • Language File Count - Displays the total number of files per language
  • Language Word Count - Displays the word count per language
  • Project Additional Price - Displays the additional costs related to translation at project level
  • Project Additional Price per Language - Displays the additional costs related to a target language at project level
  • Savings - Displays the amount of money saved by using the system
  • Total Project Revenue - Displays the total project cost
  • Translation Price - Displays the cost of the translation calculated at language-pair level
Leverage Bands
The Leverage Bands dimension can be found in the Translation Leverage data source.
  • Band Name - Displays the default pricing model bands (New Words, In Context Match, Exact Match, Perfect Match, Repetition, Machine Translation, Cross-file Repetitions, Locked, x%-y% Match), as well as any custom pricing model bands.
On Time Delivery Bands
The On Time Delivery Bands dimension can be found in the Task Status data source.
  • Band Name - Displays the band name: very early, early, on time, late, very late
  • Maximum Value (hours) - Displays the maximum value (in hours) for a band
  • Minimum Value (hours) - Displays the minimum value (in hours) for a band
Band nameMinimum value (hours)Maximum value (hours)Notes
1.VERY_EARLY-2147483648-48earlier by more than 48 hours
2.EARLY-48-24at least 24 hours earlier, but no more than 48 hours earlier
3.ON_TIME-2424delivered less than 24 hours in advance or with a 24-hour delay
4.LATE2448late by more than 24 hours, but no more than 48 hours
5.VERY_LATE482147483648late by more than 48 hours
Project Creation Date
The Project Creation Date dimension can be found in the following data sources: File Translation Status and Language Revenue Details. All the dashboard dates are expressed in UTC format.
  • Project Creation Date - Displays the date (yyyy-mm-dd)
  • Project Creation Day - Displays the day as a number (1-31)
  • Project Creation Day Of Week - Displays the position of a day in a week (1-7)
  • Project Creation Day Of Week Name - Displays the day name
  • Project Creation Day Of Year - Displays the position of a day in a year (1-365)
  • Project Creation Month - Displays the month as a number (1-12)
  • Project Creation Month Name - Displays the month name
  • Project Creation Quarter - Displays the position of a quarter in a year (1-4)
  • Project Creation Year - Displays the year
Projects
The Projects dimension can be found in the following data sources: File Translation Status, Task Status, TQA Review Summary, Language Revenues, Language Revenue Details, Translation Assessment, Translation Productivity, Translation Productivity Assessment, and Vendor Cost.
  • Project Character Count - Displays the total number of characters in a project
  • Project Comment Users - Displays the total number of users who added comments to the project
  • Project Comments - Displays the total number of comments added to the project
  • Project Completed At - Displays the date and time (in UTC format) when the project is manually marked as Completed
  • Project Created At - Displays the date and time (in UTC format) when the project was created. The format is 'yyyy-MM-dd HH:MM:ss'
  • Project Creator Id - Displays the account user ID of the user who created the project
  • Project Creator Name - Displays the full name of the user who created the project
  • Project Currency Code - Displays the currency of the project quote
  • Project Custom Fields - Displays all the available custom fields associated with a project
  • Project Custom Field 1 - Displays one of the available custom fields associated with a project
  • Project Custom Field 2 - Displays one of the available custom fields associated with a project
  • Project Custom Field 3 - Displays one of the available custom fields associated with a project
  • Project Custom Field 4 - Displays one of the available custom fields associated with a project
  • Project Custom Field 5 - Displays one of the available custom fields associated with a project
  • Project Delivered At - Displays the date and time (in UTC format) when the last file for a given language is available for delivery
  • Project Delivery Time Diff - Displays the difference between the completion date (the date when the last file was translated) and the due date in seconds
  • Project Description - Displays the project description
  • Project Due At - Displays the date and time (in UTC format) when the project is due
  • Project File Count - Displays the total number of files in a project
  • Project Group Id - Displays the ID generated by the system for a project group
  • Project Group Name - Displays the name of the project group as entered by the user
  • Project Group Short Id - Displays a shorter ID generated by the system for a project group; for older projects, this will be 0 (zero)
  • Project Id - Displays the unique ID generated by Trados Enterprise for a project
  • Project Is Deleted - Displays if the project is deleted (1 - true) or not (0 - false)
  • Project Location Id - Displays the unique ID generated by Trados Enterprise for a location (or folder). This is where both the project and the files are stored.
  • Project Name - Displays the project name
  • Project On Time Status - Displays the name of the delivery band corresponding to the project: N/A, very early, early, on time, late, very late
  • Project Origin System - Displays the application where the project originated from
  • Project Quote Approved At - Displays the date and time (in UTC format) when the quote was approved
  • Project Quote Created At - Displays the date and time (in UTC format) when the quote was generated automatically by the system based on the pricing model
  • Project Revenue - Displays the total revenue (decimal value) of the project
  • Project Savings - Displays a decimal number representing the total value of the project savings calculated based on the following formula: SUM for each language pair [(cost of new words x number of words) - translation cost]
  • Project Segment Count - Displays the total number of segments in a project
  • Project Short Id - Displays a shorter ID generated by Trados Enterprise for a project; for older projects, this will be 0 (zero)
  • Project Source Language - Displays the language code of the source files
  • Project Status - Displays the project status: N/A, not_started, in_progress, canceled, completed
  • Project Target Languages - Displays the language codes of the target files in the form of a comma-separated list
  • Project Template Id - Displays the unique ID generated by Trados Enterprise for a project template
  • Project Template Name - Displays the project template name
  • Project Word Count - Displays the total number of source words in a project
Project Group Name
This dimension contains the attachment status between the project and project groups.
  • Project ID - Displays the ID of the project as generated by the system
  • Project Group ID - Displays the ID of the project group as generated by the system
  • Project Group Name - Displays the name of te project group as entered by the user
  • Project Location ID - Displays the ID of the location where the project group was created
  • Project Group Creator ID - Displays the ID of the user who created the project group
  • Created At - Displays the date and time (yyyy-mm-dd hh:mm:ss) (in UTC format) when the project group was created
  • Last Modified Date - Displays the date and time (yyyy-mm-dd hh:mm:ss) (in UTC format) when the project group was last modified (name, details, associated projects)
  • Account ID - Displays the ID of the account as generated by the system
  • Project Added At - Displays the date and time (yyyy-mm-dd hh:mm:ss) (in UTC format) when the project was added to the group
  • Project Removed At - Displays the date and time (yyyy-mm-dd hh:mm:ss) (in UTC format) when the project was removed from the group
  • Project Assigned - Displays whether a project is assigned to a group (value = true) or not (value = false)
  • Is Deleted - Displays whether the project group was deleted (value = false) or not (value = true)
Quote Approvers
The Quote Approvers dimension can be found in the Language Revenues data source.
  • Quote Approver Account Id - Displays the unique ID generated by Trados Enterprise for an account
  • Quote Approver Account Name - Displays the account name
  • Quote Approver Account User Id - Displays the unique ID generated by Trados Enterprise for an account user
  • Quote Approver Account User Location Id - Displays the unique ID generated automatically by Trados Enterprise for the folder where the account user is created (added)
  • Quote Approver Author - Displays the account ID of the person who added the user to an account
  • Quote Approver Author Hashed - Displays the hashed account ID of the person who added the user to an account
  • Quote Approver Creation Date - Displays the date and time (in UTC format) when the user was added to an account
  • Quote Approver Deletion Date - Displays the date and time (in UTC format) when a user was deleted
  • Quote Approver First Name - Displays the first name of the account user
  • Quote Approver First Name Hashed - Displays the hashed first name of the account user
  • Quote Approver Is Deleted - Displays if the user is deleted (1 - true) or not (0 - false)
  • Quote Approver Last Modification Date - Displays the date and time when the user details were last modified
  • Quote Approver Last Name - Displays the last name of the account user
  • Quote Approver Last Name Hashed - Displays the hashed last name of the account user
  • Quote Approver Membership - Displays the type of membership the user has with the account: member, collaborator (guest), null
  • Quote Approver Status - Displays if the user is active or deleted
  • Quote Approver User Email - Displays the email address of the account user
  • Quote Approver User Email Hashed - Displays the hashed email address of the account user
  • Quote Approver Vendor Id - Displays the unique ID generated automatically by Trados Enterprise for the vendor where the account user is a member. If the account user is not a member of a vendor, the column displays N/A.
  • Quote Approver Vendor Name - Displays the name of the vendor where the account user is a member. If the account user is not a member of a vendor, the columns displays N/A.

Users with the Manage Users in Group permission can see the email, last name. and first name of users as part of custom reports, while users without this permission can see only hashed information.

Quote Date
The Quote Date dimension can be found in the Language Revenues and Language Revenue Details data sources. All the dates are expressed in UTC format.
  • Quote Date - Displays the date (yyyy-mm-dd)
  • Quote Day - Displays the day as a number (1-31)
  • Quote Day Of Week - Displays the position of a day in a week (1-7)
  • Quote Day Of Week Name - Displays the day name
  • Quote Day Of Year - Displays the position of a day in a year (1-365)
  • Quote Month - Displays the month as a number (1-12)
  • Quote Month Name - Displays the month name
  • Quote Quarter - Displays the position of a quarter in a year (1-4)
  • Quote Year - Displays the year
Revenue Types
The Revenue Types dimension can be found in the Language Revenue Details data source.
  • Revenue Type Category - Displays the following categories the revenue applies to: file, language, project
  • Revenue Type Name - Displays the name of the revenue type
  • Revenue Type Unit - Displays the unit that is used when computing the price (Words, Characters, Files, and so on)
Review Date
The Review Date dimension can be found in the File Translation Status, Translation Assessment, and TQA Review Summary data sources. All the dates are expressed in UTC format.
  • Review Date - Displays the date (yyyy-mm-dd)
  • Review Day - Displays the day as a number (1-31)
  • Review Day Of Week - Displays the position of a day in a week (1-7)
  • Review Day Of Week Name - Displays the day name
  • Review Day Of Year - Displays the position of a day in a year (1-365)
  • Review Month - Displays the month as a number (1-12)
  • Review Month Name - Displays the month name
  • Review Quarter - Displays the position of a quarter in a year (1-4)
  • Review Year - Displays the year
Reviewers
The Reviewers dimension can be found in the File Translation Status, Translation Assessment, and TQA Review Summary data sources.
  • Reviewer Account Id - Displays the unique ID generated by Trados Enterprise for an account
  • Reviewer Account Name - Displays the account name
  • Reviewer Account User Id - Displays the unique ID generated by Trados Enterprise for an account user
  • Reviewer Account User Location Id - Displays the unique ID generated automatically by Trados Enterprise for the folder where the account user is created (added)
  • Reviewer Author - Displays the account ID of the person who added the user to an account
  • Reviewer Author Hashed - Displays the hashed account ID of the person who added the user to an account
  • Reviewer Creation Date - Displays the date and time (in UTC format) when the user was added to an account
  • Reviewer Deletion Date - Displays the date and time (in UTC format) when a user was deleted
  • Reviewer First Name - Displays the first name of the account user
  • Reviewer First Name Hashed - Displays the hashed first name of the account user
  • Reviewer Is Deleted - Displays if the user is deleted (1 - true) or not (0 - false)
  • Reviewer Last Modification Date - Displays the date and time (in UTC format) when the user details were last modified
  • Reviewer Last Name - Displays the last name of the account user
  • Reviewer Last Name Hashed - Displays the hashed last name of the account user
  • Reveiwer Membership - Displays the type of membership the user has with the account: member, collaborator (guest), null
  • Reviewer Status - Displays if the user is active or deleted
  • Reviewer User Email - Displays the email address of the account user
  • Reviewer User Email Hashed - Displays the hashed email address of the account user
  • Reviewer Vendor Id - Displays the unique ID generated automatically by Trados Enterprise for the vendor where the account user is a member. If the account user is not a member of a vendor, the column displays N/A.
  • Reviewer Vendor Name - Displays the name of the vendor where the account user is a member. If the account user is not a member of a vendor, the columns displays N/A.
Service Types
The Service Types dimension can be found in the Vendor Cost data source.
  • Allow Customer - Whether or not the service type can be assigned to users
  • Allow Internal - Whether or not the service type can be assigned to tasks/users
  • Allow Vendor - Whether or not the service type can be assigned to vendor order templates
  • Last Modified Date - Displays the date when the entry was last modified
  • Service Type Id - Displays the ID of the service type
  • Service Type Name - Displays the name of the service type
Source Files
The Source Files dimension can be found in the following data sources: File Translation Status, Task Status, Translation Assessment, Translation Productivity, Translation Productivity Assessment, Translation Leverage, and TQA Review Summary.
  • Source File Batch - Displays the number of the batch where the file was added
  • Source File Character Count - Displays the number of characters in a file
  • Source File Creation At - Displays the date and time (in UTC format) when the source file was added to the project
  • Source File Id - Displays the unique ID generated by Trados Enterprise for a file
  • Source File Location Id - Displays the unique ID generated by Trados Enterprise for a location (or folder). This is where both the project and the file are stored.
  • Source File Name - Displays the file name
  • Source File Project Id - Displays the unique ID generated by Trados Enterprise for a project
  • Source File Project Name - Displays the name of the project
  • Source File Role - Displays how the file is used in the translation process: translatable or reference
  • Source File Segment Count - Displays the number of segments in a file
  • Source File Source Language Code - Displays the detected language code for a file
  • Source File Type Settings Id - Displays the unique ID generated by Trados Enterprise for a file type setting
  • Source File Word Count - Displays the number of words in a file
Task Date
The Task Date dimension can be found in the Translation Productivity Assessment data source. All the dates are expressed in UTC format.
  • Task Date - Displays the date (yyyy-mm-dd)
  • Task Day - Displays the day as a number (1-31)
  • Task Day Of Week - Displays the position of a day in a week (1-7)
  • Task Day Of Week Name - Displays the day name
  • Task Day Of Year - Displays the position of a day in a year (1-365)
  • Task Month - Displays the month as a number (1-12)
  • Task Month Name - Displays the month name
  • Task Quarter - Displays the position of a quarter in a year (1-4)
  • Task Year - Displays the year
Task Owners
The Task Owners dimension can be found in the Task Status data source.
  • Task Owner Account Id - Displays the unique ID generated by Trados Enterprise for an account
  • Task Owner Account Name - Displays the account name
  • Task Owner Account User Id - Displays the unique ID generated by Trados Enterprise for an account user
  • Task Owner Account User Location Id - Displays the unique ID generated automatically by Trados Enterprise for the folder where the account user is created (added)
  • Task Owner Author - Displays the account ID of the person who added the user to an account
  • Task Owner Author Hashed - Displays the hashed account ID of the person who added the user to an account
  • Task Owner Creation Date - Displays the date and time (in UTC format) when the user was added to an account
  • Task Owner Deletion Date - Displays the date and time (in UTC format) when a user was deleted
  • Task Owner First Name - Displays the first name of the account user
  • Task Owner First Name Hashed - Displays the hashed first name of the account user
  • Task Owner Is Deleted - Displays if the user is deleted (1 - true) or not (0 - false)
  • Task Owner Last Modification Date - Displays the date and time (in UTC format) when the user details were last modified
  • Task Owner Last Name - Displays the last name of the account user
  • Task Owner Last Name Hashed - Displays the hashed last name of the account user
  • Task Owner Membership - Displays the type of membership the user has with the account: member, collaborator (guest), null
  • Task Owner Status - Displays if the user is active or deleted
  • Task Owner User Email - Displays the email address of the account user
  • Task Owner User Email Hashed - Displays the hashed email address of the account user
  • Task Owner Vendor Id - Displays the unique ID generated automatically by Trados Enterprise for the vendor where the account user is a member. If the account user is not a member of a vendor, the column displays N/A.
  • Task Owner Vendor Name - Displays the name of the vendor where the account user is a member. If the account user is not a member of a vendor, the columns displays N/A.
Task Status
The Task Status dimension is a part of the Task Status data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Actual Duration (minutes) - Displays the value calculated as Completion Date - Start Date in minutes
  • Completed At - Displays the date (mm/dd/yyyy) and exact timestamp (in UTC format) when the task was completed
  • Delivery (minutes) - Displays the value calculated as Actual Duration - Estimated Duration in minutes
  • Due By - Displays the date (mm/dd/yyyy) and exact timestamp (in UTC format) when the task is due
  • Estimated Duration (minutes) - Displays the value calculated as Due Date - Start Date in minutes
  • Started At - Displays the date (mm/dd/yyyy) and exact timestamp (in UTC format) when the task was started. For human-assigned tasks, this field does not take into consideration the date when users start working on that task.
  • Task Word Count - Displays the total number of words in the task input
Task Types
The Task Types dimension can be found in the Task Status, TQA Review Summary, Translation Assessment, and Translation Productivity data sources. The task type values are:
  • Automated Task - A flag that marks if a task is an automated one or a human one
  • Task Business Key - Displays the business key of the task
  • Task Type Key - Displays the key of the task type. Possible values are:
    • N/A
    • apply_translation_memory
    • analysis
    • scan
    • copy_to_target
    • convert
    • engineering
    • document_content_analysis
    • plan
    • project_content_analysis
    • quote_customer
    • vendor_quote_review
    • vendor_quote_sign_off
    • customer_quote_review
    • customer_quote_sign_off
    • quote_vendor
    • error
    • extension-task (custom tasks)
    • export (download package)
    • import (upload package)
    • human_translation
    • human_review
    • generate_target
    • update_translation_memory
    • apply_machine_translation
    • custom (add-on or API enabled tasks)
    • generate_linguistic_resources
    • automated_qa_check
    • human_sign_off
    • remove_feedback
    • dtp
    • implement_customer_review
    • final_check
    • nmt
    • convert_with_target
  • Task Workflow Name - Displays the workflow name of the task
TQA Errors
The TQA Errors dimension can be found in the Translation Productivity Assessment data source.
  • TQA Category Id - Displays the unique ID generated by Trados Enterprise for a TQA category
  • TQA Category Name - Displays the TQA category name
  • TQA Penalty - Displays the penalty points assigned to the TQA error
  • TQA Severity Id - Displays the system ID of the severity
  • TQA Severity Name - Displays the TQA severity name
  • TQA Severity Type - Displays the TQA severity type
TQA Pairs
The TQA Pairs dimension can be found in the Translation Assessment data source.
  • TQA Category Id - Displays the unique ID generated by Trados Enterprise for a TQA category
  • TQA Category Name - Displays the TQA category name
  • TQA Penalty - Displays the penalty points assigned to the TQA error
  • TQA Severity Id - Displays the system ID of the severity
  • TQA Severity Name - Displays the TQA severity name
  • TQA Severity Type - Displays the TQA severity type
TQA Review Summary
The TQA Review Summary dimension is a part of the TQA Review Summary data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • First Evaluation - Displays the first review performed for the file
  • Is Canceled - A flag that shows whether the target file has been canceled
  • Number of Segments with TQA - Displays the number of segments that have TQA errors
  • Number of TQA Errors - Displays the number of TQA errors that were added as part of the review
  • Pass Indicator - A flag that shows whether the translation has passed the quality requirements
  • Quality Indicator - Computes the translation quality against the threshold defined in the profile. The formula used to calculate this indicator is: [(wordCount - reviewScore) / wordCount]*100
  • Review Score - Displays the penalty accumulated during a Review step
  • Reviewed Character Count - Displays the number of characters in the target file
  • Reviewed Segment Count - Displays the number of segments in the target file
  • Reviewed Word Count - Displays the number of words in the target file
Translation Assessment
The Translation Assessment dimension is a part of the Translation Assessment data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Number of Segments - Displays the total number of segments that the reviewer changed
  • Number of Segments with Edit Distance 0 - No segment was changed
  • Number of Segments with Edit Distance 1 - 10 - Displays the total number of segments that the reviewer changed and have the edit distance equal to 1 - 10
Translation Date
The Translation Date dimension can be found in the following data sources: File Translation Status, Translation Productivity, and Translation Leverage. All the dates are expressed in UTC format.
  • Translation Date - Displays the date (yyyy-mm-dd)
  • Translation Day - Displays the day as a number (1-31)
  • Translation Day Of Week - Displays the position of a day in a week (1-7)
  • Translation Day Of Week Name - Displays the day name
  • Translation Day Of Year - Displays the position of a day in a year (1-365)
  • Translation Month - Displays the month as a number (1-12)
  • Translation Month Name - Displays the month name
  • Translation Quarter - Displays the position of a quarter in a year (1-4)
  • Translation Year - Displays the year
Translation Leverage
The Translation Leverage dimension is a part of the Translation Leverage data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Band Characters - Displays the number of characters that fall in a specific leverage band in a target file.
  • Band Segments - Displays the number of segments that fall in a specific leverage band in a target file.
  • Band Words - Displays the number of words that fall in a specific leverage band in a target file.
  • Canceled - Displays if the target file was canceled (value = false) or not (value = true).
  • Character Count - Displays the number of characters in the target file.
  • Segment Count - Displays the number of segments in the target file.
  • Word Count - Displays the number of words in the target file.
Translation Productivity
The Translation Productivity dimension is a part of the Translation Productivity data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Number of Segments - Displays the total number of segments that the translator changed
  • Number of Segments with Edit Distance 0 - No segment was changed
  • Number of Segments with Edit Distance 1 - 10 - Displays the total number of segments that the translator changed and have the edit distance equal to 1 - 10
Translation Productivity Assessment
The Translation Productivity Assessment dimension is a part of the Translation Productivity Assessment data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Number of Segments - Displays the total number of segments that the translator changed
  • Number of Segments with Edit Distance 0 - No segment was changed
  • Number of Segments with Edit Distance 1 - 10 - Displays the total number of segments that the translator changed and have the edit distance equal to 1 - 10
Translators
The Translators dimension can be found in the File Translation Status, Translation Productivity, and Translation Productivity Assessment data sources.
  • Translator Account Id - Displays the unique ID generated by Trados Enterprise for an account
  • Translator Account Name - Displays the account name
  • Translator Account User Id - Displays the unique ID generated by Trados Enterprise for an account user
  • Translator Account User Location Id - Displays the unique ID generated automatically by Trados Enterprise for the folder where the account user is created (added)
  • Translator Author - Displays the account ID of the person who added the user to an account
  • Translator Author Hashed - Displays the hashed account ID of the person who added the user to an account
  • Translator Creation Date - Displays the date and time (in UTC format) when the user was added to an account
  • Translator Deletion Date - Displays the date and time (in UTC format) when a user was deleted
  • Translator First Name - Displays the first name of the account user
  • Translator First Name Hashed - Displays the hashed first name of the account user
  • Translator Is Deleted - Displays if the user is deleted (1 - true) or not (0 - false)
  • Translator Last Modification Date - Displays the date and time (in UTC format) when the user details were last modified
  • Translator Last Name - Displays the last name of the account user
  • Translator Last Name Hashed - Displays the hashed last name of the account user
  • Translator Membership - Displays the type of membership the user has with the account: member, collaborator (guest), null
  • Translator Status - Displays if the user is active or deleted
  • Translator User Email - Displays the email address of the account user
  • Translator User Email Hashed - Displays the hashed email address of the account user
  • Translator Vendor Id - Displays the unique ID generated automatically by Trados Enterprise for the vendor where the account user is a member. If the account user is not a member of a vendor, the column displays N/A.
  • Translator Vendor Name - Displays the name of the vendor where the account user is a member. If the account user is not a member of a vendor, the columns displays N/A.
Translation Quality Estimation (TQE)
The Translation Quality Estimation dimension can be found in the Translation Quality Estimation data source.
  • Average Edit Distance - Displays the average of the changes made with TQE
  • Evaluation Date - Displays the date when the evaluation was produced
  • Number of Segments with Edit Distance 0-10 - Displays the changes made with TQE as a numerical value
  • Total Segments - Displays the total number of segments corresponding to an edit distance.
Translation Quality Estimation Categories
The Translation Quality Estimation Categories dimension can be found in the Translation Quality Estimation data source.
  • Evaluation Category - Displays the TQE category: red, orange, green
  • Evaluation Engines - Displays the engine or the LLM model which performed the evaluation
  • Evaluation Max Values - Displays the maximum value of a category
  • Evaluation Min Values - Displays the minimum value of a category
  • Evaluation System - Displays whether the segment was evaluated by Smart Review (trados-smartreview) or by Evolve (lw-qe).
Vendor Cost
The Vendor Cost dimension is a part of the Vendor Cost data source. Its elements, however, are not grouped under a specific folder; instead, they are displayed at the bottom of the data source.
  • Additional Cost - Displays the total additional costs
  • File Count - Displays the total number of files from the cost
  • Language Cost - Displays the total language-related costs
  • Quote Approved At - Displays the date and time (in UTC format) when the quote was approved
  • Quote Created At - Displays the date and time (in UTC format) when the quote was created
  • Quote Reviewed At - Displays the date and time (in UTC format) when the quote was reviewed
  • Quote Updated At - Displays the date and time (in UTC format) when the quote was updated
  • Target Word Count - Displays the total number of target words from the cost
  • Translation Cost - Displays the total translation-related costs
Vendor Order Templates
The Vendor Order Templates dimension can be found in the Vendor Cost data source.
  • Order Template Account Id - Displays the ID of the Trados account
  • Order Template Creation Date - Displays the date and time (in UTC format) when the vendor order template was created
  • Order Template Id - Displays the internal ID of the vendor order template
  • Order Template Is Deleted - A flag that shows whether the vendor order template is active or has been deleted
  • Order Template Location Id - Displays the ID of the location where the vendor order template is stored
  • Order Template Name - Displays the name of the vendor order template
  • Order Template Vendor Id - Displays the internal ID of the vendor
  • Order Template Vendor Name - Displays the name of the vendor