Explore recipe: Finding articles with no views

Return to top


  • Anjie Nambiar

    Hi, this is great.


    Is there a way to filter out agent views? and make sure that the stats report only signed-in users view (or other user segments we specify)

  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi Anjie Nambiar, great question! You can add an attribute filter of Views user role - ungrouped and set it to whichever roles you want to see reflected in the report. The role options you can choose from are the Guide roles, which are described here.

    I've also added this info as a tip at the end of the recipe!

  • CJ Marcelo

    Hello, this article is helpful.

    Apologies for the ignorance though, when I try to follow these steps, I can't seem to find the "D_COUNT(Published articles)" Metric filter. All I can see is the one I created called "SUM(Views computed separately". Do I need to create that D_COUNT metric as well? What would be the exact formula do I need to use?

    In addition, how can I add the attribute filter of "Views user role - ungrouped" under this Guide - Knowledge Base dataset. I can't seem to find it in this dataset.


  • Erin O'Callaghan
    Zendesk Documentation Team

    Hi CJ Marcelo, thanks for the feedback! Make sure you've added the Published articles metric to your report (in step 6). There's no need to create a new formula for that metric—it's already included in the dataset. After you do that, the metric filter for D_COUNT(Published articles) should automatically show up in the Metric filter panel (the screenshot in step 9). 

    And it looks like the name of the Views user role - Ungrouped attribute has now changed to Engagement user role - Ungrouped instead. I've updated the recipe to reflect that name change!

  • CJ Marcelo

    Hello Erin O'Callaghan,

    Thank you. 

    We can see the zero views result if we have the following metrics and rows:

    However, when I add metrics such as SUM(Article upvotes) and SUM(Article downvotes) and set Metric filter to start at 0, the articles with zero views are not being shown in the results.

    If I also add another Row called Engagement user role - ungrouped, the zero views are being omitted from the results.

    Am I missing some steps or am I doing it incorrectly?

    In addition, is there an attribute/metric to include these?:
    - Article last updated date
    - Last edited by

    Thanks again.




Please sign in to leave a comment.

Powered by Zendesk