• Dylan

    18 June 2023 at 7:05 pm

    The discrepancy between the GA4 and Looker data might be due to how each platform processes and counts unique events. GA4 counts all instances, including duplicates, while Looker might treat duplicate entries as a single unique event. If you’re keen on getting accurate, unique counts, you might need to consider adjusting your query in Looker to mirror GA4’s counting methodology. This adjustment could include either a change in the logic of your SQL script or the creation of a custom measure in Looker that will consider duplicate entries as unique instances. Another potential cause could be the time of data extraction – as GA4 usually takes 24-48 hours to process data. Hence, you may want to compare data in both platforms after the data in GA4 has been fully processed.