We are currently trying to look at the traffic to a certain category of pages on our site. The pages number into the 1000s so a manual lookup is not an option. We have managed to get the pages into a spreadsheet including their URLs.
My question is, can we query our Google Analytics data using the URLs to return a pageview metric for each URL (ideally within a given date range)? I have played around with Google Sheets and the Analytics plugin, but didn't get anywhere.
Any help would be much appreciated. Thanks!