Marshall Sansano RomainDev GeniusDATES, How to Extract Dates from a GA4 table in BigQuery (beginner level)Dates are displayed in raw format in BigQuery. We need to use functions to decipher these values and transform them into readable ones.Jul 4, 2022Jul 4, 2022
Marshall Sansano RomaMulticolor, the Main Enemy of Data Visualization for E-commerce Reports (and all other businesses)Choose a key color to draw the audience’s attention in your reports. Multicolor only brings mental fatigue and confusion.Mar 23, 2022Mar 23, 2022
Marshall Sansano RomainDev GeniusARRAY_AGG(expr), Aggregate Repeated Rows and Get an Easy-to-Read GA4 E-commerce Table with…Nesting repeated values to create an easy-to-read tableMar 22, 2022Mar 22, 2022
Marshall Sansano RomaCommunicate Data Efficiently By Choosing The Right ChartChoosing the right graph will make a big difference when conveying the message to an audience.Mar 18, 2022Mar 18, 2022
Marshall Sansano RomainDev GeniusHow to Create an E-commerce Sales Funnel in BigQuery? (+ tips to increase the add_to_cart rate)Create a Funnel with BigQuery allows you to identify the weak points of your Sales Funnel and take action to improve themMar 8, 2022Mar 8, 2022
Marshall Sansano RomaLEFT JOIN, Supplement Data from Different Sources in BigQuery: GA4 and Shopify (or other CMS)Online Business data is generated from different sources. LEFT JOIN clause allows to combine different tables to get all values into oneMar 4, 2022Mar 4, 2022
Marshall Sansano RomaWITH, Create Permanent Unnested Tables from Temporary Tables in a GA4 E-commerce Project in…By using with clause we can create temporary tables that can be used later on the statementMar 1, 2022Mar 1, 2022
Marshall Sansano RomaUNNEST, the First BigQuery Function for GA4 the E-commerce TrackingThe fist function to domain in BigQuery for a GA4 E-commerce tracking is the UNNEST, which llows us to have access to nested valuesFeb 25, 2022Feb 25, 2022
Marshall Sansano RomaStep-by-step guide on how to implement GA4 Ecommerce with Tag ManagerImplementing GA4 E-commerce with Tag Manager is essential to track the Online Business and optimize any marketing strategyFeb 17, 2022Feb 17, 2022