Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Data Movement & Streaming

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

jg2
Contributor
Contributor

Filtering reports with the Qlik Cloud GA4 Connector

When using the RunReport table, is it possible to incorporate a filter?  For example, could you filter to only the eventName = "downloads". Reading through the API documentation, it appears possible but I am unclear on the syntax. If it is possible, what syntax would be used to filter multiple selections (for example, run the following report for eventName='downloads' and eventName='pageViews').  

The following code was written using the Google Analytics 4 connector in Qliksense:

LOAD eventName as [RunReport.eventName],
pageLocation as [RunReport.pageLocation],
eventCount as [RunReport.eventCount];
SELECT eventName,
pageLocation,
eventCount
FROM RunReport
WITH PROPERTIES (
propertyName='properties/*******',
metrics='eventCount',
dateRange='2daysAgo,today');

Thanks!

Who Me Too'd this topic