I am trying to pull data from Google Analytics by Page. Unfortunately there are over 300K pages with visits per week. Since the data is too much to pull, is there a way to pull the top 100 pages or limit the pull from Google Analytics by page?
1 answer
Hi @John Ahn,
It seems like this might be tough if you're using the Native GA connector from within Tableau, and I'm also not sure how you'd be able to do this. There are a couple other things you could try though!
- If you have the enterprise version of GA and know SQL, try using Google BigQuery to identify the top pages and return data for only those pages
- Export data directly from GA, clean the data in Tableau Prep or another tool, and filter out data that isn't in the top 100 pages
Hope this helps!
-Graham
