I recently wrote a detailed guide on how to use Stitch with Google Analytics and Tableau to build a really powerful content analytics dashboard.
I shared this post on Twitter and Lee from Stitch suggested I join the community and post a link to it here. You can find the full post here - https://www.projectbi.net/build-content-analytics-dashboard-google-analytics-tableau/.
Main takeaways from this project:
*Working with GA data is a lot more complicated than I originally thought. I got stuck for hours trying to get my numbers to match the reports in the web interface. In the end the unique user calculations are done badly.
*Once you connect your individual post meta data to your GA data you can do incredible things. Tableau is awesome for this kind of work.
*If you’re working in content marketing then the approach I took should be seriously considered. My dashboard makes it easy to track organic traffic growth trends by post.
I’d love to hear your feedback.