Go with what makes the most sense for you. While adding Google Analytics as an source in Stitch you'll be asked to select a starting time and replication frequency. After a lot of unnecessary work I ended up focusing only on sessions which is good enough for my needs at this stage. You'd typically have a user or visitor id to work with but Google doesn't provide that level of granularity so you're stuck. This limits you when you need to aggregate on a weekly, monthly or quarterly bases. If you pull the data on a daily bases you will get daily unique users and daily unique pageviews. Why this specific list? There is a crazy limitation in the Google Analytics API when it comes to unique users and pageviews.
#Tableau public google analytics full
You can see a full list of the available dimensions and measures here. The fields I would have pulled in instead include:
#Tableau public google analytics how to
You can read how to add BigQuery as a destination here. Once you've signed up with Stitch you'll want to add BigQuery as a destination. This makes Stitch ideal if you don't have too much data to move around. The best part about Stitch is they have a very generous free plan.
Stitch is an ETL tool which automatically moves data from dozens of different sources into your database of choice.
I've been experimenting with Stitch for a while and even use them with one of my clients to move Shopify and Facebook ads data into their data warehouse. I'm in no way affiliated with Stitch, I just like them as a service. The first step is to connect your Google Analytics account to your BigQuery account via Stitch. Step #1 - Sign up for a free Stitch account and connect Google Analytics to BigQuery You could use the same approach covered in this post to analyze your eCommerce business, SaaS business, or online advertising spend. Once I had the "raw" data in the database I could leverage Tableau's powerful formulas, parameter, filters and visualization options to build a useful dashboard.īefore we dive in I want to mention that it is important for you to understand the concepts covered in this post. My strategy for this project was to try and move my Google Analytics data into a database which I could then plug into Tableau (check out my introduction to Tableau post). How to analyze your content's performance using Google Analytics and Tableau In this post I'm going to share with you how I managed to build this content analytics dashboard and how you can use it to identify key insights about your content's performance, how your SEO efforts are impacting growth, and more.
0 kommentar(er)
