topic Re: Filtering reports with the Qlik Cloud GA4 Connector in Data Movement & Streaming

Filtering reports with the Qlik Cloud GA4 Connector

jg2 — Wed, 19 Mar 2025 23:02:17 GMT

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!

Re: Filtering reports with the Qlik Cloud GA4 Connector

psublue98 — Mon, 24 Jul 2023 19:02:33 GMT

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

Re: Filtering reports with the Qlik Cloud GA4 Connector

LenaE — Tue, 12 Sep 2023 12:07:19 GMT

I am facing the same issue.

Does anyone has an idea? 🙈

Re: Filtering reports with the Qlik Cloud GA4 Connector

AustinWright — Wed, 22 Jan 2025 16:12:15 GMT

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.

Re: Filtering reports with the Qlik Cloud GA4 Connector

TheLazyDevelopr — Fri, 28 Feb 2025 22:33:23 GMT

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

Re: Filtering reports with the Qlik Cloud GA4 Connector

TheLazyDevelopr — Wed, 19 Mar 2025 19:13:47 GMT

They added filtering now:

Re: Filtering reports with the Qlik Cloud GA4 Connector

LenaE — Thu, 20 Mar 2025 08:02:59 GMT

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