PinnedJoão ValenteCreate a Realtime PiwikPro Dashboard with its API, Streamlit and PandasPhoto Credit: Stephen Dawson (Unsplash)Mar 21, 2023Mar 21, 2023
João ValenteHow to showcase your Data Analyst Skills with StreamlitThinking on ways to standout your Data Analyst Profile? In today’s competitive job market, simply having a CV is not enough, especially for…Aug 10Aug 10
João ValenteHow to retrieve GA4 daily sessions and conversions by source in Google BigQueryGoogle Analytics 4 (GA4) is a powerful analytics tool that provides valuable insights into website and app performance. BigQuery, Google’s…Mar 29, 2023Mar 29, 2023
João ValenteHow to compare competitors’ Core Vitals using BigQueryIn today’s competitive online marketplace, it’s essential for businesses to stay ahead of the competition. By using a BigQuery script, you…Mar 25, 2023Mar 25, 2023
João ValenteHow to analyze peak web traffic times in GA4 using BigQueryHave you ever wondered when users are most active on your website? Are you curious about which days and times see the most traffic or…Mar 25, 2023Mar 25, 2023
João ValenteTop GDPR friendly Google Analytics Alternatives (Free and Paid)Google Analytics has been under fire with GDPR, and its forced GA4 launch. Here are some alternative solutions your legal team may like.Jul 16, 20223Jul 16, 20223
João ValenteAutomate Search Term Categorization (or any string) using BigQuery, Regex and Google SheetsIf you work with Digital Analytics, SEO or any kind of text related data you might have found out that some field data can often be…Jan 10, 20221Jan 10, 20221
João ValenteGA4: How to filter your ecommerce data with Google BigQueryGoogle Analytics has been the standard for analyzing Web Data , and it grew a lot since its release in 2005. Its latest version Google…Nov 1, 20211Nov 1, 20211