Filtering reports with the Qlik Cloud GA4 Connector

[jg2]

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!

[psublue98]

100%! Would like to know if WITH PROPERTIES() can incorporate someting like the below otherwise the connector is pulling in unnecessary data. Anyone at Qlik have info on this? See dimensionFilter and metricFilter in GA API docs.

WITH PROPERTIES (
propertyName='properties/*',
dimensions='hostName,pageLocation,date',
metrics='sessions,screenPageViews',
dateRange='yesterday,today',
stringFilter='hostName,PARTIAL_REGEXP,{values}'
);

[LenaE]

I am facing the same issue.

Does anyone has an idea? 🙈