When I worked as an employee and now working with clients as a consultant, the most important task is always to provide accurate reporting. To prepare reports every month takes time and especially when working on last minute projects, it can be quite inconvenient. So back in 2016 I decided to save time and set up automated reporting via Google Data Studio. (The next post will be: “How to automate via Zapier and Data Studio and Spreadsheets)
The data it pulls is the information from Google sheets, Google Analytics, and other sources. If you are now thinking “no that is not possible as Google Data studio is not able to use other sources” I’m happy to share with you that with Zapier you basically sync all data into Google sheets and that will show you all the information in a very professional way.
Below you will find a sneak peak of how we report an e-commerce shop using Data Studio where basically everything is synced:
To learn more about Data Studio please have a look at the following video: