Comments on: Google Analytics vs. SQL: When and why to build your own data tools https://data36.com/build-data-tools-google-analytics-vs-sql/ Learn Data Science the Hard Way! Wed, 11 May 2022 21:59:50 +0000 hourly 1 https://wordpress.org/?v=6.7.4 By: Tomi Mester https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-190893 Sun, 18 Oct 2020 20:21:44 +0000 http://data36.com/?p=690#comment-190893 In reply to Kuda.

Cheers!

]]>
By: Tomi Mester https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-190708 Tue, 06 Oct 2020 13:12:15 +0000 http://data36.com/?p=690#comment-190708 In reply to Malcolm.

Thanks, Malcolm!

]]>
By: Malcolm https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-154487 Sun, 31 May 2020 15:06:42 +0000 http://data36.com/?p=690#comment-154487 Brilliant article. Couldn’t agree more.

]]>
By: Funnel analysis - an easy way to measure conversion step by step https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-71649 Tue, 02 Apr 2019 18:25:04 +0000 http://data36.com/?p=690#comment-71649 […] you are a regular reader of my blog, you know that I prefer tools that you build yourself (in Python or SQL) over using third-party tools (e.g. Google […]

]]>
By: Kuda https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-23670 Sat, 30 Jun 2018 05:20:31 +0000 http://data36.com/?p=690#comment-23670 Insightful and informative article. Thank you.

]]>
By: Data Analytics Basics (intro for aspiring data professionals) https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-7824 Mon, 02 Oct 2017 11:52:15 +0000 http://data36.com/?p=690#comment-7824 […] Note: it’s possible that as a data analyst you are not coding at all, but using smart tools like Google Analytics, Heatmapping tools, A/B testing tools, etc. instead. Still, I strongly recommend to learn coding. In this article I’ve summarized the pros and cons: Data Coding vs. Smart Tools. […]

]]>
By: Data collection, aka. getting the raw data... this is how it works! https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-3515 Mon, 24 Apr 2017 12:43:52 +0000 http://data36.com/?p=690#comment-3515 […] is much profitable than version A. Why? For several reasons, that I’ve already written about in this article. But I am going to list these out here […]

]]>
By: Tomi Mester https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-2895 Thu, 30 Mar 2017 21:25:32 +0000 http://data36.com/?p=690#comment-2895 In reply to Kunal.

hey Kunal,

thanks and to answer the question:
1.) To be honest, I’m not the best person to answer – I usually do data collection in a strong collaboration with (website, app, etc…) developers. They are the people, who are actually implementing the tracking scripts. And from the data side my responsibility is, that to make my data server able to pick up the data, that the developers sending there. I wrote a high-level article about that: https://data36.com/data-collection/
2.) About the exact techniques though the best I can say, that you should use a native solution. Eg. if you have a Java based web-application, most probably your tracking code should be in Java. But I wrote for instance a chatbot not so long ago in Python+Flask – in this case my tracking script was in Python. If you do your website with Django+Python, than you can find some native solution for that as well…
When it comes to a simple HTML, I’m not sure, what’s the fanciest solution today, but I’m almost sure, that on the front-end you should use some JavaScript solution, that communicates with your data server… There’s one old solution called AJAX, back in the days, I’ve used that a few times (a PHP script picked up the data on the data server side).

Hope this helped! 😉

Cheers,
Tomi

]]>
By: Kunal https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-2886 Thu, 30 Mar 2017 11:20:51 +0000 http://data36.com/?p=690#comment-2886 Great article!

You mentioned star schema which is a great data modelling technique. Also, you mentioned R, SQL, Python, and bash which are great data manipulation and analysis tools.
Could you please let us know what techniques can be used to actually capture the data? For example, do we need to create REST API for this task or something else?

]]>
By: Tomi Mester https://data36.com/build-data-tools-google-analytics-vs-sql/#comment-1561 Sun, 05 Feb 2017 15:02:59 +0000 http://data36.com/?p=690#comment-1561 In reply to Jesper Petersson.

Thanks, Jesper!

]]>