Learn business growth with Google Analytics 4 Forums Google Analytics 4 Discrepancy in Google Analytics 4 Data between Looker Studio and BigQuery Connectors Reply To: Discrepancy in Google Analytics 4 Data between Looker Studio and BigQuery Connectors

  • Oliver

    Member
    23 January 2023 at 4:20 pm

    The difference in session counts between ‘A’ and ‘B’ could be due to a couple of reasons. One possible reason could be the way the session count is calculated in Google Analytics 4 (GA4) and BigQuery. Google Analytics may be counting sessions differently, such as including instances where multiple sessions are counted as one due to a user leaving a website and returning within a short timeframe. Alternatively, how BigQuery processes data might be different. Depending on how the data is collected and processed, it could potentially result in discrepancies. Another potential reason could be the way Looker connects and fetches data from GA4 and BigQuery. Even though you didn’t apply any filters while conducting your analysis, it’s worth checking the data extraction and transformation process. You may want to recheck the configuration settings of both ‘A’ and ‘B’ connectors and make sure there’s no unintended data transformation on the Looker side. It’s advised to thoroughly investigate to know the exact reason. Differences in data can sometimes arise due to very nuanced reasons that require a detailed walk-through of your data processing pipeline.