In Insights I use the following query:
SELECT count(*) FROM PageView WHERE pageUrl like ‘%myurl%’ since this quarter facet websiteID
I get 10 results rows back. One particular row shows a Page Views count of 14.1k
When I change the query in order to see the details of those page views to:
SELECT * FROM PageView WHERE pageUrl like %myurl%’ and websiteID = ‘mywebsite’ since this quarter
I only get 10 results rows … both on-screen and in the CSV export file.
Clearly 10 < 14.1k
I have tried various changes to the second query to try to get more results (like changing date range, adding/removing websiteId, etc) but never get any rows with a timestamp earlier than March 15 … so today’s date.
I don’t really need to see all 73 days worth of data in this quarter, but I would like at least a week or months worth.
Is there a way I can do that?