See Azure web app pages with zero views in Azure Application Insights

Question

If it is even possible...

Goal: See a report of the number of views each page in my Azure web app has, and include the pages that have received zero views

Currently the page views report in Azure Application Insights that I have managed to create (based on the default report, shows all pages with >= 1 view. I would like to include in that report pages that have 0 views.

This is bare-bones version of the query I'm using in logs:

pageViews 
| where timestamp between(datetime("2020-03-06T00:00:00.000Z")..datetime("2020-06-06T00:00:00.000Z"))
| summarize Ocurrences=count() by tostring(url)

The pages are in an Azure web app.

Does anyone know how to accomplish this, either using this method or another I'm not thinking of? Thank you for any help.

Do you mind hard-code these zero-viewed pages in your query? — Ivan Glasenberg, Jun 04 '20 at 00:44
Ideally I wouldn't hard code, but if that is the only way to do it, then I would. — hcdocs, Jun 04 '20 at 01:17
Because the application insights cannot detect the pages which are not visited, you may hard-code these pages in the query or in your web project. — Ivan Glasenberg, Jun 04 '20 at 01:21

score 2 · Accepted Answer · answered Jun 05 '20 at 02:05

If the pages have zero view from client, it means that from client, there is no "page view" telemetry data being sent to application insights. Thus, application insights will not collect these zero-viewed page urls.

If you want to add these zero-viewd page to your report, you should hard-code these zero-viewed page urls in the query.

Here is an example, I use the datatable operator and union operator:

//use thie query to add the zero-viewd page url in this datatable
let query1=datatable (url:string,Ocurrences:long)
[
    "https://localhost:44364/home/url1",0,
    "https://localhost:44364/home/url2",0,
    "https://localhost:44364/home/url3",0,
];

//use the query below for non-zero-viewd page
let query2=pageViews 
| summarize Ocurrences=count() by tostring(url);

//union the 2 queries
union withsource=TableName query1,query2 | project url,Ocurrences

Here is the test result:

See Azure web app pages with zero views in Azure Application Insights

1 Answers1