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? 🙈

[AustinWright]

Did you end up finding an answer on filtering on a dimension for a specific value using stringFilter or some other syntax? I have been looking everywhere and can't find the proper syntax to filter GA4 dimensions in the load script in Qlik.

[TheLazyDevelopr]

Sadly haven't seen any updates on this yet. Currently just filtering down through preceding load but doesn't technically filter.

[TheLazyDevelopr]

They added filtering now:

[LenaE]

Juhu! Thanks for the information. I'm gonna try it out. 🙂