Spreadsheet:
https://www.slideruleanalytics.com/bl...
In this video, I discuss the importance of making accurate comparisons between Black Friday Cyber Monday data from different years. I explain the limitations of using universal analytics and highlight the reliability of Shopify data. I provide step-by-step instructions on how to fill in a spreadsheet with key metrics and data from Shopify reports. I emphasize the need for consistency in date ranges and caution against using the built-in BFCM date range in Shopify. This video aims to help viewers analyze their Black Friday Cyber Monday performance and make informed decisions based on the data.
00:00 Introduction
00:38 Universal Analytics vs. GA4 vs. Shopify Data
01:21 Importance of Consistency
02:06 Filling in the Spreadsheet
05:39 Getting Order Data
07:45 Analyzing High-Level Metrics
09:25 Digging Deeper with Source Medium Analysis
16:29 Deeper Analysis with Data Team Service