In the article “Bridging the gap between Google Analytics UI and BigQuery export” Minhaz Kazi, a developer advocate for Google Analytics, provides an explanation for why the numbers in BigQuery event export data may not match the standard reporting surfaces in Google Analytics. The article clarifies that while the intended purpose of BigQuery event export data is to provide users with more customized options for data analysis, the standard reporting surfaces use pre-processed database tables, which include Google Analytics’ value additions such as modeling and traffic attribution, and thus these two data sources are not always expected to be reconcilable....
Category: Digital analytics
54 Posts
Google Cloud predicts that artificial intelligence and machine learning will be the primary driver for daily work-life improvements in the next three years. Information systems and apps will be able to speed up our daily tasks and reduce required human effort by providing actionable insights and automating repetitive tasks.
“Hello world: How to be a human in the age of the machine” by Hannah Fry is a great read and the stories presented in the book show how several of the most important challenges we are still facing today are not related to technology challenges.
A list of the best tools for all your CSV-related needs when trying to merge, validate, explore or just convert CSV files.
"Να είσαι θερμοστάτης, όχι θερμόμετρο" είναι μια φράση που άκουσα πριν μερικά χρόνια από έναν guru του χώρου και μου έχει μείνει καρφωμένη στο μυαλό από τότε! Το θερμόμετρο είναι μια συσκευή η οποία μόνο καταγράφει δεδομένα, ενώ ένας θερμοστάτης μετατρέπει τα δεδομένα και σε ενέργειες. Αν καταφέρουμε να έχουμε περισσότερους "έξυπνους θερμοστάτες" στην διάθεση μας όταν αναλύουμε δεδομένα, θα μπορέσουμε να διαχειριστούμε και πολύ μεγαλύτερο όγκο αλλά και να επιταχύνουμε τις αντιδράσεις μας σε αυτά.
A list of time-saving, cost-saving and life-saving SQL query hacks you need to know if you consider yourself an advanced BigQuery user.
I came across an interesting alternative approach from Philip Walton. He explains clearly why all websites cannot work with the default definition of a page view in Analytics and how we someone could start using the page’s visibility state (using the Page visibility API). Unfortunately this post was originally published in 2017 and still until today, even though Single Page Application (SPA) websites are widely used, we reply mostly on complicated implementations to virtually create page views for analytics tracking. Another alternative to this problem is to use an Event Driven Data Layer (EDDL), but I like the simplicity of...
Enterprise websites split across many regions and locales are huge, but every page matters. Keeping track of the website’s quality, across all pages and on different devices, is a complicated and time-consuming process. It requires the constant evaluation of page performance, web analytics implementation accuracy, accessibility, and SEO audits.Baresquare developed an automated solution to keep track of website changes and website quality. This is a scalable solution built on GCP, with cost and resources customized to the website’s size. The solution utilizes a customized version of Lighthouse SDK and a BigQuery database for keeping track of results. Analyzing results is...
A new trend is rising in the analytics and web marketing community! Lists of 50 things you believe about your industry. This list was created based on my experience working in digital analytics projects since 2008 and from numerous conversations I had while organizing the Digital analytics meetup, Thessaloniki since 2017.
In the following article, I shared a few thoughts on the risks and opportunities for the Greek government, the EU and every citizen. It's clear that we will have to face a lot of difficult decisions in the coming years, in the dawn of a new era which relies heavily on data.
