Explore recipe: Reporting on article views for all 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>
<div class="note tip wysiwyg-text-align-left">
<span class="notetitle"><img alt="" height="20" src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/community_trophy.png" width="20"> Contributed by community member <a href="https://support.zendesk.com/hc/en-us/profiles/1263213802069-CJ-Johnson" rel="undefined" target="_self">CJ Johnson</a>. <br></span>For the original conversation, see <a href="https://support.zendesk.com/hc/en-us/community/posts/4409217340058-Return-Article-Title-in-1-language-roll-up-of-all-Language-views-" target="_self">Return Article Title in 1 language, roll up of all Language views?</a>
</div>
<p>In this recipe, you’ll learn how to create a report that shows you how many views each article in your knowledge base received, regardless of language, grouped under one title in your preferred language. This report is both streamlined (no duplicate rows for multiple languages) and human readable (no article IDs in place of reader-friendly article titles).</p>
<p><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/report_article_views_all_languages.png" width="850"></p>
<p>This article contains the following topics:</p>
<ul>
<li><a href="#h_01FJ0ECG1DVQ09Q5J814TAS2QE" target="_self">What you’ll need</a></li>
<li><a href="#h_01FJ0ECN8E5P9A8DHX84WWSC0C" target="_self">Creating the report</a></li>
</ul>
<h2 id="h_01FJ0ECG1DVQ09Q5J814TAS2QE">What you’ll need</h2>
<p><strong>Skill level:</strong> Easy</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 agents access to Explore</a>)</li>
<li>Article data in Zendesk Guide</li>
</ul>
<h2 id="h_01FJ0ECN8E5P9A8DHX84WWSC0C">Creating the report</h2>
<p>As part of this report, you’ll create one standard calculated metric and two standard calculated attributes.</p>
<p><strong>To create the metric</strong></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 -</strong> <strong>Knowledge Base</strong>, then click <strong>Start report</strong>. The report builder opens.</li>
<li>Click the <strong>Calculations</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_calculations.png">) menu &gt; <strong>Standard calculated metric</strong>.</li>
<li>Name this metric <strong>Views for all languages</strong>.</li>
<li>In the <strong>Formula</strong> field, enter the following:
<pre>ATTRIBUTE_FIX(SUM(Article views), [Article ID])</pre>
<div class="note tip">
<span class="tiptitle">Tip:</span> If you're working in a language other than English, <a href="https://support.zendesk.com/hc/en-us/articles/4408820266906" target="_self">read this article</a> to help you enter Explore formulas in your language.</div>
</li>
<li>Click <strong>Save</strong>.</li>
</ol>
<div class="note tip">
<span class="tiptitle">Tip:</span> If you’re interested in learning more about the ATTRIBUTE_FIX function used in this metric, see <a href="https://support.zendesk.com/hc/en-us/articles/4408845551258" target="_self">Working with aggregation level functions</a>.</div>
<p><strong>To create the first attribute</strong></p>
<ol>
<li>Click the <strong>Calculations</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_calculations.png">) menu &gt; <strong>Standard calculated attribute</strong>.</li>
<li>Name this attribute <strong>Location plus article ID</strong>.</li>
<li>In the <strong>Formula</strong> field, enter the following:
<pre>IF [Article ID] != "" THEN<br>[Article ID] + [Article locale]<br>ENDIF</pre>
</li>
<li>Click <strong>Save</strong>.</li>
</ol>
<p>Now that you’ve created this attribute, incorporate it into the next attribute to return only the English article title for a given article ID.</p>
<p><strong>To create the second attribute</strong></p>
<ol>
<li>Click the <strong>Calculations</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_calculations.png">) menu and click <strong>Standard calculated attribute</strong>.</li>
<li>Name this attribute <strong>English article title</strong> (you can replace “English” with any other language you’re using).</li>
<li>In the <strong>Formula</strong> field, enter the following (if you're working in a different language, replace "en-us" with your own language code.):
<pre>IF (CONTAINS(LOWERCASE([Location plus article ID]),"en-us"))<br>THEN [Article title]<br>ENDIF</pre>
</li>
<li>Click <strong>Save</strong>.</li>
</ol>
<p><strong>To create the report</strong></p>
<ol>
<li>In the <strong>Metrics</strong> panel, click <strong>Add</strong> and select <strong>Calculated metrics</strong> &gt; <strong>Views for all languages</strong> (the metric you created above).</li>
<li>In the <strong>Rows</strong> panel, click <strong>Add</strong> and select <strong>Calculated attributes</strong> &gt; <strong>English article title</strong> (the second attribute you created above).</li>
<li>Name your report <strong>Article views for all languages</strong>.</li>
<li>Click <strong>Save</strong>.</li>
</ol><script id="docs-schema-markup" type="application/ld+json">{
"@context": "https://schema.org",
"@type": "TechArticle",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408835118106",
"url": "https://support.zendesk.com/hc/en-us/articles/4408835118106-Explore-recipe-Reporting-on-article-views-for-all-languages",
"headline": "Explore recipe: Reporting on article views for all languages",
"description": "You can create a report that aggregates article views across all languages under a single title in your preferred language by using calculated metrics and attributes in the reporting tool.",
"articleSection": "Help center reporting recipes",
"datePublished": "2021-10-16T04:00:16+00:00",
"dateModified": "2025-09-06T00:07:08+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4408835118106"
},
"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>