No one can deny that new tech products cover the world and penetrate deeper into our mundane life blending tech and reality. IOT products sneak into our homes and cars packed with electronics, self-driving on our streets, seamlessly connecting tools that weren’t relevant before. At the time of ubiquitous network connectivity the emergence of the Google Data Studio seems particularly timely and symbolic.
For those who don't know beans about the tool, here is the gist. Google Data Studio is a reporting tool that allows to represent any data in an attractive and interactive way by connecting it to simple sheets. GDS is closely tied to all Google services, just a few clicks and you can build Analytics and Adwords graphs on a single page. So if you need to impress your boss or you regularly do a number of such reports, you must definitely try Data Studio, for it’s not only free but easy-to-use, too.
Bear in mind that the tool is in Beta mode now, therefore not everything works seamlessly. For instance, build-in PDF download is not available at the moment - you should use that browser print function and merge pages with some open source tool. In any case Google engineers follow up on the frequently asked questions and soon the new version will undoubtedly be delivered.
The reality is that digital marketers often wish to fetch Google Analytics breakdowns, plug it into different data sources or totally automate the processes. For this purpose you should therefore use ad hoc tools that every marketer or analyst can use. These tools give you the opportunity to pull data to Sheet to hook it up in Data Studio later. Let’s review them unless rise of the machines begins any time soon:
The tool that permits to upload Google Analytics data into spreadsheets to make it easier to manipulate. For Data Studio it means that it’s possible to query data from multiple views, compute and display custom calculations before reporting.
The tool is pretty simple to use after installation. Go to "Add-ons" > "Google Analytics" > "Create a New Report" from the menu bar for a start and walk through step-by-step process to get the basic configuration view.
After that you can add extra columns to a new report, take advantage of the filter and segment features and get data that only API allows. It is also super convenient to use scheduling to get auto-updates.
Additional Google Add-ons information https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on
It allows to pull data from various advertising channels into Google Sheets. Supermetrics is an indispensable tool when the task is ROAS channel evaluation. For instance, you can fetch data on ad performance from Facebook or SemRush domain SEO metrics.
Facebook Age performance
Isn’t it just great?
On top of that Supermetics recently announced that using its ad-hoc JSON connector you can easily fetch data from various API. It’s a very powerful solution but demands some programming.
Additional tools that deserve to be mentioned here are Owox that can be utilized to pull paid data to Google Analytics and Script to fetch Google Search Console data http://netpeak.net/blog/how-to-save-and-analyse-data-from-search-console-in-google-sheets/ , because GDS currenly doesn’t allow to pull this data. Unlike Supermetrics, these tools are completely free.
Connect Your Apps and Automate Workflows is a simple tagline that describes the gist of this tool. The tool serves as a process organizer for a marketer which affords to significantly simplify brand monitoring, email list building and social media automation. Basically every integration can be reduced to the record into Google docs or sheets as a result of some action in the main tool. For example, you can automate mentions.
Certainly, after all these manipulations you will inevitably need to use Google Spreadsheets functions to link sheets. To copy data from one sheet to another within a single sheet you can use “=Sheet1!A1” or “='Sheet number two'!B4” syntax. To pull data from other spreadsheets, use the IMPORTRANGE function. https://support.google.com/docs/answer/3093340
Google Data Studio is an amazing tool for reporting, but that’s not all. It helps individual marketing experts and agencies to get insights into campaign management and pushes users to smartly organise their interactions using various tools. Apparently, individual pieces of software are much closer than they have ever been.