Create a Language I/O Translation Word Count Report in OSC

This article walks you through the steps of generating a Language I/O translation usage report inside of the Oracle Service Cloud (OSC) agent desktop. If you bought a package of words from Language I/O, this report shows you how many words in that package you have used so far. You can group the translations by Incident, see the OSC Threads in that Incident that were translated and also see the actual source and target content of each translation. This latter piece is important because OSC is the system of record for all content that is passed to Language I/O for translation. For security reasons, once Language I/O has translated OSC Chat or Incident content and passed it back into OSC, Language I/O can not keep a record of (or store in our database) either the source content or the translated content.

Note: Full Chat reporting is only available starting with Language I/O Chat v2.0+. (In previous versions, LNThreads are only persisted if your add-in is configured not to combine incidents after chat.) If you are on an older version of Chat, please contact your Language I/O representative to update your add-in.

Language I/O uses an OSC custom object called LNThread to store content that is passed to Language I/O for translation and the translated version of that content. This object also stores important meta data including the word count of each translation request.

You can import the report definition attached at the end of this article, or create a report from scratch following the steps below:

• Navigate to Analytics => New Report => Grid Report
• Expand All Tables => Select the LNThread table.

The fields available in LNThread are defined as follows:

• We recommend that you include the following fields in your report by dragging them from the LNThread table onto the Data Area: Incident ID, translation ID, Date Created, wordCount, threadType, contentType, statusMessage and Text as shown in the example below. 

• It is helpful to add filters to better sort your results. Drag fields that you want to be able to sort on at runtime to the Docked Filters area. For a word usage report, you'll definitely want to add Date Created to Docked Filters and per below, select "Make this filter selectable at runtime."  and set the Operator to "between" so you can select a date range. 

Lastly, to get rid of 0 word count values, you can just create an invisible, permanent filter for the agent-untranslated-response thread type. These will always have a zero word count as this is content that hasn't yet been translated. To create this filter, drag the threadType field to the Docked Filters area in Design View and create a filter that removes all LNThread records from your report where the threadType value is set to "1" as shown in the example below.

• Hit OK on the new filter and save your report to a folder in Reports Explorer. When you run your report, be sure to properly set your date range. If the package of words you are using was purchased from Language I/O on January 6, 2020, you'll set that as the start date and set tomorrow's date as the end date to be sure you get all translations to date.

• Now you can select the Export button from the navigation ribbon above your report and export the contents into an Excel spreadsheet where you can sum up your wordCount field and perform other analytics on your translation data as needed.