Google BigQuery API request (python)

Google BigQuery is a great big-data tool, which let you to store a huge amount of data in cloud, and manipulate it with SQL queries. But there are situations, when you want to get that data to your python environment for more advanced purposes like machine learning, which is possible thanks to numerous python libraries. Read more about Google BigQuery API request (python)[…]

Google Analytics API request (python)

Google Analytics Reporting Api gives you a lot of possibilities like downloading your data without sampling, exporting it to databases or just ability to work with raw data (for example in Jupyter Notebooks). The easiest way I`ve found to make a API request to Google Analytics: 1. Create a Google Cloud Platform project and enable Read more about Google Analytics API request (python)[…]

Parallel Coordinates for Multidimensional Data Visualization

Parallel coordinates were invented in far 1885 by French engineer and mathematician Philbert Maurice d’Ocagne. When I discovered this way of visualization – I was really impressed how it allows to visualize such a complicated thing as multidimensional data in a simple and intuitive way. This is how I visualized few dimensions of Mobile App Read more about Parallel Coordinates for Multidimensional Data Visualization[…]

CASE statements in Google Data Studio

CASE statements let you to create new dimensions in Google Data Studio based on existing ones. Syntax of CASE statement reminds SQL a lot: To create a new calculated field – open your Data Studio report, and click “Create new field”: Give your new dimension a name, write the CASE statement in “Formuła” field and Read more about CASE statements in Google Data Studio[…]

5 Google Spreadsheet formulas which every web-analyst should know

Google Spreadsheet formulas is a powerful tool which can make your life much more easier if you are working with data a lot. There are a lot of interesting extensions that can be very useful for a online marketeer, like Google Ads extension or Google Analytics extension for Google Spreadsheets, but output data which you`ll Read more about 5 Google Spreadsheet formulas which every web-analyst should know[…]

New vs Returning Client-ID variable in Google Tag Manager

Sometimes, while configuring tags in Google Tag Manager, we want to know if the user visiting our site for the first time or not. Variable like that can be very useful if we want to fire some of our tags only for new or returning users, or assign different conversion value of the same conversion Read more about New vs Returning Client-ID variable in Google Tag Manager[…]

Offline campaigns measuring with “Vanity URL”

Vanity URL – is a short version of your site domain, that is easy to remember and enter in the browser. This picture from newspaper should explain you pretty well why publishing of usual links in your offline advertise is not a good idea. Let`s imagine I`m promoting my app – SKAGs Table Creator, which is Read more about Offline campaigns measuring with “Vanity URL”[…]

Multi-Channel Analysis in Google Analytics

As you might know, people often doesn`t buy anything just after they have seen an advertisement. How many people you know, that have bought a car just after they`ve seen for the first time a banner (even very attractive), with that car? Yes, some cheap products can be bought impulsively, but before buying any kind Read more about Multi-Channel Analysis in Google Analytics[…]

How to Create a Data Set in Google Analytics

Data sets in Google Analytics are allow to import external data into your account. An example of such data could be your costs, spend on SEO or Facebook campaign. Keeping all data in one analytical system allows for comprehensive analysis of all your advertising channels. So, that`s how to create a Data Set in Google Read more about How to Create a Data Set in Google Analytics[…]

www.000webhost.com