Explore recipe: Reporting on article and translation languages

What's my plan?

In this recipe, you’ll learn how to report on the languages for the articles and translations in your knowledge base.

This article contains the following topics:

• What you’ll need
• Creating the report
• Enhancing the report (Enterprise only)

What you’ll need

Skill level: Beginner

Time required: 10 minutes

• Zendesk Explore Professional or Enterprise
• Editor or Admin permissions (see Giving users access to Explore)
• Article and translation data in Zendesk Guide

Creating the report

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Guide > Guide - Knowledge Base, then click Start report. The report builder opens.
4. In the Metrics panel, click Add.
5. From the list, select Published translations, then click Apply.
6. In the Rows panel, click Add.
7. From the list, select Article translation language, then click Apply.
8. (Optional) Add a filter for Article created - Date to narrow your results.

Note: The report above doesn’t include articles that have no translations. For example, if you created some articles in English and never created any translations for those articles, they won’t be represented in the numbers above. To get an accurate count of overall articles, you can use the Published articles metric instead, but you cannot slice that result by the Article translation language attribute.

Enhancing the report (Enterprise only)

If you're on an Enterprise plan, you have access to the Team Publishing dataset that includes more information about specific publishing actions taken in Guide. With this extra information, you can include unpublished (such as draft) articles and translations in your report.

In the example below, you'll create two separate reports. The first report will measure the number of articles created in each language.

1. In Explore, click the reports () icon.
2. In the Reports library, click New report.
3. On the Select a dataset page, click Guide > Guide - Team Publishing, then click Start report. The report builder opens.
4. In the Metrics panel, click Add.
5. From the list, select Articles created, then click Apply.
6. In the Rows panel, click Add.
7. From the list, select Event article language, then click Apply.
8. (Optional) Add a filter for Event - Date to narrow your results.

The translations for each article will be in different languages and can be reported on separately. Use the same instructions as above, but swap the Article created metric with Translations created.

Additionally, you can report on other Team Publishing events (like Articles published or Translations edited) by adding those metrics to your report. You can also include Article translation title as a row to see the exact articles (or translations) that were created, edited, or published.