Explore recipe: Finding articles with no views

<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 Explore recipe, you'll learn how to identify help center articles that have no views, or very few views. This shows you which articles aren't being seen by your customers.</p>
<p>Using this data, you can decide whether to <a href="https://support.zendesk.com/hc/en-us/articles/4408835056154" rel="undefined" target="_self">add labels to the articles</a> to help customers find them, or <a href="https://support.zendesk.com/hc/en-us/articles/4408838947738" target="_self">archive the articles</a> if they're no longer needed. </p>
<p><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_articles_with_no_views_0.png" width="850"></p>
<p>This article contains the following topics:</p>
<ul>
<li><a href="#h_01FTRN7ACNV4H70EFMGEZSHAZJ" target="_self">What you’ll need</a></li>
<li><a href="#h_01FTRN7H1B55ZT3C4G49SB69SD" target="_self">Creating the report</a></li>
</ul>
<h2 id="h_01FTRN7ACNV4H70EFMGEZSHAZJ">What you’ll need</h2>
<p><strong>Skill level: </strong>Intermediate</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_01FTRN7H1B55ZT3C4G49SB69SD">Creating the report</h2>
<p>For this recipe, you'll create a standard calculated metric for article views so that you can compute it separately from the list of published articles. This allows you to see articles with zero views, which would otherwise be filtered out of your results by default.</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 - Knowledge Base</strong>, then click <strong>Start report</strong>. The report builder opens.</li>
<li>To <a href="https://support.zendesk.com/hc/en-us/articles/4408824243738" target="_self">create a calculated metric</a> for views:
<ol>
<li>Go to the <strong>Calculations</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_calculations.png">) menu and select <strong>Standard calculated metric</strong>.</li>
<li>Name the metric <strong>Views computed separately</strong>.</li>
<li>In the <strong>Formula</strong> field, enter the following:
<pre>ATTRIBUTE_FIX(SUM(Article views), [Article title])</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">read this article</a> to help you enter Explore formulas in your language.</div>
</li>
<li>Select <strong>Compute separately</strong>.</li>
<li>
<span style="font-weight: 400;">Click <strong>Save</strong>.</span><img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_articles_with_no_views_1.png">
</li>
</ol>
</li>
<li>In the <strong>Metrics</strong> panel, click <strong>Add</strong>.</li>
<li>From the list, select <strong>Published articles</strong> and <strong>Views computed separately</strong> (the metric you created above), and 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 title</strong> and <strong>Article created - Date</strong>, and then click <strong>Apply</strong>.</li>
<li>To filter your results to only articles with zero views:
<ol>
<li>Go to the <strong>Result manipulation</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png">) menu and select <strong>Metric filter</strong>.</li>
<li>Under <strong>D_COUNT(Published articles)</strong>, select <strong>Remove blank values</strong>. This removes the blank line at the top of the table.</li>
<li>Under <strong>SUM(Views computed separately)</strong>, move the slider to <strong>0</strong> (or whatever threshold you want to use in the report), and click <strong>Apply</strong>.<img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_articles_with_no_views_2.png">
</li>
</ol>
</li>
<li>To add zeroes in the blank cells to make the table easier to read:
<ol>
<li>Go to the <strong>Result manipulation</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_result_manipulation.png">) menu and select <strong>Result metric calculation</strong>.</li>
<li>Click <strong>Add a new metric</strong>.</li>
<li>Name the metric <strong>Views</strong>.</li>
<li>In the <strong>Formula</strong> field, enter the following:
<pre>SUM(Views computed separately)+0</pre>
</li>
<li>Click <strong>Add</strong>.</li>
</ol>
</li>
<li>To hide the <strong>Views computed separately</strong> column (since the new <strong>Views</strong> column takes its place), go to <strong>Chart configuration</strong> (<img src="https://zen-marketing-documentation.s3.amazonaws.com/docs/en/Explore_chart_configuration.png">) menu, select <strong>Columns</strong>, and click the eye icon next to <strong>Column 4</strong>.
<div class="note tip">
<span class="tiptitle">Tip: </span>You can also click the eye icon next to <strong>Column 3</strong> to hide the <strong>Published articles</strong> column, since that will always display "1".</div>
<img class="img-screenshot" src="https://zen-marketing-documentation.s3.us-west-1.amazonaws.com/docs/en/explore_articles_with_no_views_3.png">
</li>
<li>Give your report a unique name, and 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/4418908863130",
"url": "https://support.zendesk.com/hc/en-us/articles/4418908863130-Explore-recipe-Finding-articles-with-no-views",
"headline": "Explore recipe: Finding articles with no views",
"description": "You can create a report to identify help center articles with zero or few views by calculating article views separately and filtering the results to find articles not seen by customers.",
"articleSection": "Help center reporting recipes",
"datePublished": "2022-01-31T20:23:21+00:00",
"dateModified": "2025-09-06T00:06:29+00:00",
"inLanguage": "en-US",
"mainEntityOfPage": {
"@type": "WebPage",
"@id": "https://support.zendesk.com/hc/en-us/articles/4418908863130"
},
"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>