Explore recipe: Reporting on article and translation languages

<div class="article-banners">
<div id="docs-wmp-link"><a href="https://support.zendesk.com/hc/en-us/articles/5411234991258-plan" rel="noopener" target="_blank">What's my plan?</a></div>
<div class="article-banner" id="suite_pee">
<table>
<tbody>
<tr>
<td>
<strong>All Suites</strong>
</td>
<td>Professional, Enterprise, or Enterprise Plus</td>
</tr>
</tbody>
</table>
</div>
<div class="article-banner" id="support_with_explore_pe">
<table>
<tbody>
<tr>
<td>
<strong>Support with</strong>
</td>
<td>Explore Professional or Enterprise</td>
</tr>
</tbody>
</table>
</div>
</div>
<p>In this recipe, you’ll learn how to report on the languages for the articles and translations in your knowledge base.</p>
<p>This article contains the following topics:</p>
<ul>
<li><a href="#h_01FRKC6F4EWHV4A02D853A62A1" target="_self">What you’ll need</a></li>
<li><a href="#01H7WSFFGBMJG25DB0SG7B82HC">Creating the report</a></li>
<li><a href="#h_01FRKC6NP5H7DEGC63JZBXDX62">Enhancing the report (Enterprise only)</a></li>
</ul>
<h2 id="h_01FRKC6F4EWHV4A02D853A62A1">What you’ll need</h2>
<p><strong>Skill level:</strong> Beginner</p>
<p><strong>Time required:</strong> 10 minutes</p>
<ul>
<li>Zendesk Explore Professional or Enterprise</li>
<li>Editor or Admin permissions (see <a href="https://support.zendesk.com/hc/en-us/articles/4408836002970" target="_self">Giving users access to Explore</a>)</li>
<li>Article and translation data in Zendesk Guide</li>
</ul>
<h2 id="01H7WSFFGBMJG25DB0SG7B82HC">Creating the report</h2>
<ol>
<li>In Explore, click the reports (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_query_icon.png">) icon.</li>
<li>In the <strong>Reports library</strong>, click <strong>New report</strong>.</li>
<li>On the <strong>Select a dataset</strong> page, click <strong>Guide</strong> &gt; <strong>Guide - Knowledge Base</strong>, then click <strong>Start report</strong>. The report builder opens.</li>
<li>In the <strong>Metrics</strong> panel, click <strong>Add</strong>.</li>
<li>From the list, select <strong>Published translations</strong>, then click <strong>Apply</strong>.</li>
<li>In the <strong>Rows</strong> panel, click <strong>Add</strong>.</li>
<li>From the list, select <strong>Article translation language</strong>, then click <strong>Apply</strong>.</li>
<li>(Optional) <a href="https://support.zendesk.com/hc/en-us/articles/4408825475354#topic_enj_1pk_zwb">Add a filter</a> for <strong>Article created - Date</strong> to narrow your results.</li>
</ol>
<p><img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/explore_recipe_article_and_translation_languages.png" width="600"></p>
<div class="note note">
<span class="notetitle"> Note:</span> 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 <strong>Published articles</strong> metric instead, but you cannot slice that result by the <strong>Article translation language</strong> attribute.</div>
<h2 id="h_01FRKC6NP5H7DEGC63JZBXDX62">Enhancing the report (Enterprise only)</h2>
<p>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.</p>
<p>In the example below, you'll create two separate reports. The first report will measure the number of articles created in each language.</p>
<ol>
<li>In Explore, click the reports (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_query_icon.png">) icon.</li>
<li>In the Reports library, click <strong>New report</strong>.</li>
<li>On the <strong>Select a dataset</strong> page, click <strong>Guide</strong> &gt; <strong>Guide - Team Publishing</strong>, then click <strong>Start report</strong>. The report builder opens.</li>
<li>In the <strong>Metrics</strong> panel, click <strong>Add</strong>.</li>
<li>From the list, select <strong>Articles created</strong>, then click <strong>Apply</strong>.</li>
<li>In the <strong>Rows</strong> panel, click <strong>Add</strong>.</li>
<li>From the list, select <strong>Event article language</strong>, then click <strong>Apply</strong>.</li>
<li>(Optional) <a href="https://support.zendesk.com/hc/en-us/articles/4408825475354#topic_enj_1pk_zwb">Add a filter</a> for <strong>Event - Date</strong> to narrow your results.</li>
</ol>
<p><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_recipe_reporting_on_article_translations_1.png" width="850"></p>
<p>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 <strong>Article created metric</strong> with <strong>Translations created</strong>.</p>
<p><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_recipe_reporting_on_article_translations_2.png" width="850"></p>
<p>Additionally, you can report on other Team Publishing events (like <strong>Articles published</strong> or <strong>Translations edited</strong>) by adding those metrics to your report. You can also include <strong>Article translation title</strong> as a row to see the exact articles (or translations) that were created, edited, or published.</p>
<p><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_recipe_reporting_on_article_translations_3.png" width="850"></p><script id="docs-schema-markup" type="application/ld+json">{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4415797336346",
"url": "https://support.zendesk.com/hc/en-us/articles/4415797336346-Explore-recipe-Reporting-on-article-and-translation-languages",
"headline": "Explore recipe: Reporting on article and translation languages",
"description": "You can create reports to analyze the languages of articles and their translations in your knowledge base using specific datasets and metrics, with additional options available for Enterprise users to include unpublished content and detailed publishing events.",
"articleSection": "Help center reporting recipes",
"datePublished": "2022-01-04T20:31:13+00:00",
"dateModified": "2025-09-06T00:06:30+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4415797336346"
},
"author": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"publisher": {
"@type": "Organization",
"name": "Zendesk",
"@id": "https://www.zendesk.com"
},
"isPartOf": {
"@type": "WebSite",
"name": "Zendesk Help",
"@id": "https://support.zendesk.com/hc/"
},
"about": {
"@type": "SoftwareApplication",
"name": "Zendesk",
"@id": "https://www.zendesk.com",
"softwareAddOn": {
"@type": "SoftwareApplication",
"name": "Explore",
"@id": "https://support.zendesk.com/hc/en-us/sections/4405298856346"
}
}
}</script>