Google is going to hate you! Get (almost) Analytics 360 for (almost) free!

How to use Google Analytics Tasks API and Google Cloud Platform's Cloud Functions to send raw duplicate hits to BigQuery?

Presented at AnalyticsCamp in Zurich on 05.04.2019.

Inspired by Bartosz Klocek's Warsaw Web Analytics Wednesday presentation available here: https://www.slideshare.net/webanalyticswednesday/web-analytics-wednesday-xiv-bartosz-klocek-streaming-danych-do-big-query-z-wykorzystaniem-cloud-functions

Transcript

1. Topic Google is going to hate you! Focus Get (almost) Analytics 360 for (almost) free Client AnalyticsCamp 2019 Author Maciek Stanasiuk Date 05/04/2019
2. Page 2 Maciek Stanasiuk Digital Analytics Consultant @ FELD M stanasiuk.com @stanasiukcom linkedin.com/in/maciekstanasiuk/
3. Page 3 Title of presentation
4. Page 4 BUY OR BUILD?
5. Page 5 Buy Build + short time to market + many reports and other features out of the box + (usually) not a lot of setup required + new features added on a regular basis* + following the latest trends and legislation + (usually) no maintenance required - no real data ownership - limited customization - unclear technical aspects - outsourcing data engineering know- how + full customization + full data ownership + full technical control + keeps and develops know-how in house - takes time - requires forming a separate team - lots of maintenance - can be harder to grasp by end business user
6. Page 6
7. Page 7 + [ ] Cloud Functions BigQuery + =
8. Page 8 Google Analytics task API https://developers.google.com/analytics/devguides/collection/analyticsjs/tasks
9. Page 9 Google Cloud Functions • Endpoint to whatever you want • Serverless • Supports Node.js, Python and Go • $0.40 USD per million invocations after first free 2 millions • $0.000000X USD per 100ms processing time https://cloud.google.com/functions/docs/
10. Page 10 Google BigQuery • Analytics DWH • Relatively quick • Works with its own SQL dialect • $5 USD per 1 TB of queried data after first 1 TB free every month • $0.02 USD per 1 GB of stored data $300 USD yearly free trial! https://cloud.google.com/bigquery/docs/
11. Page 11 How to analyze? And so on…
12. Page 12
13. Questions?
14. Thank you!
15. Marketing input for business output. Telefon +49 (0) 89 / 55 29 756.0 contact@feld-m.de Sandstr.33 80335 München www.feld-m.de © Copyright
    FELD M This FELD M GmbH document is intended for the addressee and/or client only. It remains the property of FELD M GmbH until an explicit transfer of the rights of use. Any adaptation, utilisation, copying and/or distribution of this document for commercial purposes is possible only with the permission of FELD M GmbH. Confidential and Proprietary of FELD M GmbH