Excel Add-In for Google Analytics

Build 24.0.9060

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.
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.
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.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page 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.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.
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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060