Excel Add-In for Google Analytics

Build 25.0.9539

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
AWSWorkloadIdentityConfigConfiguration properties to provide when using Workload Identity Federation via AWS.
AzureWorkloadIdentityConfigConfiguration properties to provide when using Workload Identity Federation via Azure.
DefaultEndDateA default end date to be applied to all queries.
DefaultStartDateA default start date to be applied to all queries.
IgnorePermissionsExceptionWhether to ignore exceptions related to insufficient permissions for a specific profile.
IncludeDeletedSpecifies whether soft-deleted or trashed items should be included in a list request.
IncludeEmptyRowsIf set to false, the provider does not include rows if all the retrieved metrics are equal to zero. The default is true which will include these rows.
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
OtherSpecifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.
PagesizeSpecifies the maximum number of records per page the provider returns when requesting data from Google Analytics.
PropertyIdProperty ID value to be used when querying reports views in V4 schema.
ReportTypeThe type of Reports to get results in case of Events and ActiveUsers view.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
UserDefinedViewsSpecifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file.
WorkloadPoolIdThe ID of your Workload Identity Federation pool.
WorkloadProjectIdThe ID of the Google Cloud project that hosts your Workload Identity Federation pool.
WorkloadProviderIdThe ID of your Workload Identity Federation pool provider.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539