Back to top image

Smartling's Data Access Tool for Business Intelligence

Smartling's Data Access tool allows you to import your Smartling data into your own Tableau instance or other Business Intelligence (BI) tool for deeper data analysis and integration into your own data repositories. 

How It Works

Smartling provides credentials to an AWS S3 bucket where reports are stored in CSV format. You can then download the files and import them into your BI tool of choice. 

The reports are refreshed on a set schedule. You can view when a report was last updated in the "Modified" column. Each CSV file contains up to three years of data, depending on your start date with Smartling and the dataset. Each dataset can be used on its own, it is not necessary to join between files. 

Getting Started

Interested in using Smartling's Data Access tool? Please contact your Smartling Customer Success Manager to activate this feature for your account.

First, set up Data Access in Smartling. Then, follow the instructions to access the reporting data in your AWS S3 Bucket. After you have retrieved the data, you can import it into your own BI environment.

Setup Data Access in Smartling

    1. Navigate to Account Settings > Integrations > Data Access.
    2. Next, click Generate Credentials and enter a name for the credentials. These will be the credentials you use to access your S3 Bucket. Once you have entered a name, click Create. 
      generate-credentials.png

    3. A window will appear with your Bucket, Region, Access Key Id, and Secret Access Key.

      Be sure to take note of your Secret Access Key, as you will not be able to access it after closing the modal window. You will need the Secret Access Key to access your S3 Bucket. Use the Copy Credentials button to copy your credentials in JSON format.

      When finished, click Close. 
    4. Under Scheduled Reports you can view all reports that are available in your S3 Bucket.

      scheduled-reports.png

      If this is your first time using Smartling's Data Access tool, no reports will be listed. To have reports added to your account, please contact your Customer Success Manager. A list of all available reports can be found below.

Access Reports in Your S3 Bucket

To access the reports in your S3 bucket, you need to have an AWS account. If you do not already have an AWS login you can create a free tier account. 

To retrieve the data: 

  1. Access the AWS S3 Bucket using your Access Key Id and Secret Access Key. 
    • There are several different ways to access your S3 Bucket. The steps to access the S3 bucket depend on your preferred access method. Since the bucket is owned by Smartling, the bucket will not appear in your AWS UI. You will need to access the bucket programmatically (e.g., via the AWS CLI, Cloudshell, or API) or use a third-party FTP tool such as Cyberduck.
  2. Once you have downloaded the data files from your S3 bucket, you can import them into your Business Intelligence tool for analysis. 

Available Reports

To add or delete a report from your account, please contact your Customer Success Manager. 

Report Name  File Name Description 
Context Coverage context_coverage.csv Context coverage by project, file, word count.
Files files.csv Files created and modified over time.
Fuzzy Match Leverage fuzzy_match_leverage.csv TM leverage by project, job, locale, workflow over time.
Issues  issues.csv Issues created and resolved by project, job, user, workflow over time.
Job Files  job_files.csv Files as part of a job by type.
Job Information  job_information.csv Job status, authorized, and completed over time.
Job Progress job_progress.csv Job status, authorized, completed date by locale, workflow, and word count over time.
Job Workflow Word Counts  job_workflow_word_counts.csv Word counts for a job locale, workflow, workflow step over time.
Project Word Counts project_word_counts.csv Project word counts data over time.
Projects projects.csv Projects created over time.
Due Date Variance due_date_step_variance.csv On time delivery data based on due dates per job and workflow step.
Translator Quality Performance - 90 Days translator_quality_performance.csv Translator quality performance data via edit_distance by project, job, workflow step. 
Users users.csv List of all users and their roles.

Table of Contents