Let’s join Google Analytics with author data in Google Sheets, to display it nicely in Google Data Studio. Why? I write, so I’m naturally interested in evaluating content heavy websites. Content analysis usually consists of two parts: Looking at the data from the platform on which you distribute your content, e.g. your blog (who reads what, and how often?) Looking at the meta-data of your content (which topic, who wrote this, when, how long is it?) Those two pieces of information are usually stored in different places. (1) is in your web tracking software, e.g. Google Analytics, (2) is somewhere […]