Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!