Difference between statistic report on admin page and database table?

GTEK IT DEV Team asked on November 14, 2018 03:53

Hi everyone, now i need to create a custom report for a single page on my website using sql query. But as i see, the data from the Analytics_DayHits table doesn't match with the day report in report page.

Image Text Report page

Query SELECT * FROM Analytics_DayHits dh INNER JOIN Analytics_Statistics st ON dh.HitsStatisticsID=st.StatisticsID where StatisticsObjectID=775

Image Text Data query from Analytics_DayHits table.

What i'm missing or wrong here?

Thanks.

statistic report

Recent Answers

Peter Mogilnitski answered on November 14, 2018 14:23 (last edited on November 14, 2018 21:09)

What you see on the graph is your actual visitors excluding robots/crawlers like google bot, bing, slurp etc. Those come to index your page. Their visits are not counted.

But I think you change your query to

SELECT * 
FROM Analytics_DayHits dh 
INNER JOIN Analytics_Statistics st ON dh.HitsStatisticsID=st.StatisticsID
WHERE StatisticsCode = 'pageviews' and StatisticsObjectID=775

0 votesVote for this answer Mark as a Correct answer