• Luke

    23 June 2023 at 6:54 pm

    The discrepancy you’re observing between Looker and GA4 may be due to the method of counting unique events. GA4 generally counts all instances, including duplicates while SQL queries used in Looker might be extracting distinct counts only. One possibility might be your Looker data model is excluding null or duplicates, which GA4 might be including. If you want to get accurate, unique counts in Looker, consider adjusting your SQL query to account for every instance, like how GA4 works. Remember to include any potential null values or duplicates to ensure your Looker data aligns as closely as possible with your GA4 data. It could be beneficial to consult with a data modeler or someone with expertise in SQL query to assist.