{"title":"Google Analytics Query","nodeType":"Manipulator","id":"*BkUhsCiz_xuaE_IY","factoryName":"org.knime.google.api.analytics.ga4.node.query.GAQueryFactory","factoryId":"org.knime.google.api.analytics.ga4.node.query.GAQueryFactory","path":["Tools & Services","Google Analytics"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"

This node queries a connected Google Analytics 4 property using the Google Analytics Data API v1 .

\n \n

The node supports building a Report by specifying metrics, dimensions , and date ranges.

\n \n

In order to find available metrics and dimensions, you can use the GA4 Dimensions & Metrics Explorer offered by Google.

\n \n

Note: This node can only be used to connect with Google Analytics 4 properties and is not compatible with Universal Analytics. To migrate a website using Universal Analytics to Google Analytics 4, you can find more information in the official migration guide .

\n \n \n ","shortDescription":"Query a connected Google Analytics 4 property.","keywords":[],"deprecated":false,"streamable":false,"tags":["Tools & Services","Google Analytics"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyhpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMTExIDc5LjE1ODMyNSwgMjAxNS8wOS8xMC0wMToxMDoyMCAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6MUUxQ0M5Q0VFOUZBMTFFNThBQkRBNzhEMDJCMkE2OTEiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6MUUxQ0M5Q0ZFOUZBMTFFNThBQkRBNzhEMDJCMkE2OTEiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDoxRTFDQzlDQ0U5RkExMUU1OEFCREE3OEQwMkIyQTY5MSIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDoxRTFDQzlDREU5RkExMUU1OEFCREE3OEQwMkIyQTY5MSIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PuAN+hUAAAEBSURBVHjaYvz//z8DJYCJgULAAmP8XyL3i+HLY1aidPEq/maMvseG6gJiNYPAv1+s5HuBW5qB0e8AmWEA08yvQsAATnH8ms/sxG0Ao+00BsaQMwwMfMo4Nf/vS8FuAKP1RAYG7UygKDsDo0oExBBsmv/+RmgCJSQwPtf+Hww+vvn/b57X/3/74v////L4//8PtyHip3f8/xcp8/9fmDgYw/QhXGBYwcDw6S3D/6ZgBoad5xkYX3IBbZfBbTN6QoJrfnwD4rINGxgYZZwZGDh4cGoGexuWF/6XOPyHaUbIAh3IxIxVM+PKF4yogfjtE6aq//+w2yws+RfDBQOWGwECDADY6IXVTm4wKAAAAABJRU5ErkJggg==","sinceVersion":"5.1.0","views":[],"inPorts":[{"objectClass":"org.knime.google.api.analytics.ga4.port.GAConnectionPortObject","color":"de5246","dataType":"Google Analytics","optional":false,"name":"Google Analytics Connection","description":"The connection to a Google Analytics 4 property."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Google Analytics data","description":"A table with data according to the query."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Metrics","description":"

Metrics are quantitative measurements of event data for your Google Analytics property.

\n

Specify at least one and up to ten metrics to include in your query. Metrics can be specified by name and either be built-in metrics or custom metrics defined in your property.

\n

Built-in metrics can be seen in the list of metrics under the column "API Name".

\n","optional":false},{"name":"Dimensions","description":"

Dimensions are attributes of the event data and their values are always strings.

\n

Specify up to nine dimensions by name. Available dimension names can be seen in the list of dimensions under the column "API Name".

\n","optional":false},{"name":"Date ranges","description":"

A date range specifies the range of dates for which to request event data from Google Analytics.

\n

Specify at least one and up to four date ranges for which event data will be requested. The custom name given to a date range replaces the date range name which is auto-generated by Google Analytics.

\n","optional":false},{"name":"Include date range name column","description":"

Include a column containing date range names. If a date range is not given a name explicitly, Google Analytics will auto-generate a unique name for each date range.

","optional":false},{"name":"Filter if matched by","description":"Output the event if it is matched by: \n","optional":false},{"name":"Dimension filter","description":"

Data can be filtered by comparing dimension values to strings or based on list inclusion.

\n

Each filter criterion can be negated to invert its results, for example to exclude results whose dimension values are in the specified list. The dimension filter can be configured such that all criteria must match for a result to be returned, or such that any criterion must match.

\n","optional":false},{"name":"Currency code","description":"

Specify the currency code to use for currency returning metrics, to be stated in three letter ISO-4217 format. If it is left empty, the report uses the property's default currency.

","optional":false},{"name":"Keep empty rows","description":"If enabled, rows will also be returned if all their metrics are equal to 0. Otherwise they are omitted from the result.","optional":false},{"name":"Output response metadata as flow variables","description":"

If enabled, outputs response metadata from the Google Analytics API as flow variables. In particular, the following fields are returned: dataLossFromOtherRow , currencyCode , timeZone , emptyReason , subjectToThresholding . The format of the flow variable name follows the pattern analytics.response.$FIELD , where $FIELD specifies the field name.

\n

More information can be obtained from the API documentation .

","optional":false},{"name":"Output property quotas as flow variables","description":"

If enabled, outputs the Google Analytics property quotas as flow variables. Each quota will indicate the "consumed" and "remaining" tokens after the last API request made by the node. The format of the flow variable name follows the pattern analytics.quota.$QUOTA.$TYPE , where $QUOTA specifies the quota and $TYPE is either "consumed" or "remaining". Available quotas can be seen in the API documentation .

\n

Note: Retrieving a lot of data (many rows, many columns, or long date ranges) or specifying complex filter criteria may be responsible for consumption of many tokens per node execution.

","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.4.3.v202503031608","bundleName":"KNIME Google API Nodes","bundleSymbolicName":"org.knime.google.api","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.google.api","featureName":"KNIME Google Connectors","featureVersion":"5.12.0.v202605041104","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*9KacbeCTeoRZrjhi"},"frequentSuccessors":[]}