marketinganalytics

GA4 Unassigned Traffic (2025): What It Is & 8 Proven Fixes
google Analytics 4 unassigned

GA4 Unassigned Traffic (2025): What It Is & 8 Proven Fixes

Introduction Even a year after its rollout, Google Analytics 4 still feels like a work in progress for many marketers. Despite its powerful event-based structure and privacy-first approach, GA4 continues to present real usability issues, especially when it comes to navigating reports, customizing dashboards, or decoding traffic sources. If you're a growth marketer working for…

read more
1302 732 Nicola Rubino
Pandas Z-Score for Marketers: Clean Your Data Before Predicting Anything
google Analytics 4 unassigned

Pandas Z-Score for Marketers: Clean Your Data Before Predicting Anything

Introduction   In my 12+ years in digital marketing, I’ve seen that data standardization is often overlooked, but it's a key step in marketing science for building reliable predictive models. In marketing, we often deal with features on completely different scales: ad spend in euros, session duration in seconds, product views as counts. If you…

read more
900 500 Nicola Rubino
How to Build Pivot Table in Pandas. Examples for Marketers.
pandas nico rubino data analysis

How to Build Pivot Table in Pandas. Examples for Marketers.

This blog post covers: Generating pivot tables from a CSV file Renaming columns in pivot tables Visualizing pivot tables with Matplotlib     Introduction In this blog post, we'll explore how to build and manipulate marketing pivot tables using pandas in Python and discover how to incorporate plotting libraries for diverse visualizations. As a data…

read more
2560 1900 Nicola Rubino
Mastering Data Cleaning in Python: A Practical Guide for Growth Marketers
clean data marketing pandas nico rubino

Mastering Data Cleaning in Python: A Practical Guide for Growth Marketers

Are you a growth marketer looking to sharpen your data manipulation skills with Pandas? This guide will walk you through the essential steps to prepare and clean marketing data in a CSV format, ensuring accurate analysis and better decision-making. As a marketer, it is crucial to perform data transformations before conducting analysis, such as adding,…

read more
2048 768 Nicola Rubino
How to import CSV files in pandas?
loading pandas csv

How to import CSV files in pandas?

  Overview In this blog post you will learn the steps required to import CSV files in pandas library using Jupyter notebook. We will also explore what the most popular data types are. Data Sources Type Explained to Growth Marketers You might wonder, why would you need to import CSV files in pandas? Each team…

read more
1366 910 Nicola Rubino