Panagiotis Tzamtzis - Digital analytics consultant & Web developer

Differences between GA and BigQuery data

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....

5 keys to successful teams

Do you think that high-performing and capable individuals make successful teams? Think again! Google’s People Operations team has identified five key dynamics that make a team effective. These dynamics are: Of these, psychological safety was found to be the most important, as it underpins the other four. Psychological safety enables team members to take risks, admit mistakes, partner with others, and take on new roles without fear of negative consequences. Teams that adopted new group norms, such as sharing risks taken in the previous week, improved their psychological safety and structure and clarity ratings. You can find more details on...

Business Undercover podcast

"Να είσαι θερμοστάτης, όχι θερμόμετρο" είναι μια φράση που άκουσα πριν μερικά χρόνια από έναν guru του χώρου και μου έχει μείνει καρφωμένη στο μυαλό από τότε! Το θερμόμετρο είναι μια συσκευή η οποία μόνο καταγράφει δεδομένα, ενώ ένας θερμοστάτης μετατρέπει τα δεδομένα και σε ενέργειες. Αν καταφέρουμε να έχουμε περισσότερους "έξυπνους θερμοστάτες" στην διάθεση μας όταν αναλύουμε δεδομένα, θα μπορέσουμε να διαχειριστούμε και πολύ μεγαλύτερο όγκο αλλά και να επιταχύνουμε τις αντιδράσεις μας σε αυτά.

Parsing web sitemaps using JavaScript

Recently I came across an interesting project by Sean Thomas Burke called Sitemapper. This is a mini framework, which can be used to parse through sitemap XML files to get all included URLs. Such functionality is necessary when crawling through websites, as the sitemap (usually) holds an up-to-date list of all website URLs. In most cases this list should be enough when designing a crawler and you wouldn’t need to crawl manually the website and create a list of URLs. Sitemap parser: Sitemapper Sitemapper is a well-maintained and well-documented, open-source library offering the following features: Follows redirects Supports gzip sitemaps...