[Luke]

The gtag.js command “get” that you are trying is not supported, therefore your callback function will not be called. Instead, once gtag.js sends an event to Google Analytics, you are not able to retrieve it directly from the gtag.js API itself. Instead, you may use the Google Analytics Reporting API to fetch this data. The Google Analytics documentation provides guides for this. From here, you should be able to fetch user interactions in the form of events, and sort them by event label (which should correspond to your ‘offer_id’). You can then count the number of times each offer was viewed. Alternatively, in your Google Analytics dashboard, you can create a new report to display event labels and their counts. Infusing this with programming to make the report automatic would require sever-side programming languages such as Python or Java.

[Luke]

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.