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');
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}' );
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.
