Can anyone recommend the best way to bring in Google Analytics data? There are a few different recommendations out there, and the tools may have moved on since then.
I would prefer not use use Data Studio (is that a banned phrase here ) since our company is very AWS-centric, thinking about ease of connecting other data sources.
It can be tricky to extract data from Google Analytics because the APIs don’t allow us to extract event-level data. It would be great to just extract page_views or visitors, but that option is available only on the paid tier of Google Analytics, which carries a hefty price tag. Therefore, the data we’ll be working with is rolled up into an aggregated format.
The gateway to your Google Analytics data is the Google Core Reporting API, which lets you make calls to retrieve data.
Easier yet, however, is using a solution that does all that work for you. Products like Stitch were built to move data automatically, making it easy to integrate Google Analytics with Amazon QuickSight. With just a few clicks, Stitch starts extracting your Google Analytics data, structuring it in a way that’s optimized for analysis, and inserting that data into a data warehouse that can be easily accessed and analyzed by Amazon QuickSight.