![]() ![]() The fields I would have pulled in instead include: 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 Comments
Leave a Reply. |