SSIS Components for Google Analytics

Build 23.0.8839

CreateCustomSchema

Creates a custom schema file based on the specified Dimensions and Metrics.

CreateCustomSchema

Creates a custom schema file based on the specified Dimensions and Metrics.

A custom schema may be used for a more tailored approach to your data. Custom options may include comma-separated lists for specific data.

Input

Name Type Required Description
TableName String True The name for the new table.
Description String False An optional description for the table.
WriteToFile String False Whether to write to an output file. Defaults totrue and must be set to false to write to FileStream or FileData.
Dimensions String False A comma-separated list of dimensions to include in the schema file. Here is a list of the possible values: https://ga-dev-tools.web.app/ga4/dimensions-metrics-explorer/
Metrics String False A comma-separated list of metrics to include in the schema file. Here is a list of the possible values: https://ga-dev-tools.web.app/ga4/dimensions-metrics-explorer/
PropertyId String False The Property Id to retrieve data from. If not specified, dimensions and metrics common to all properties will be retrieved.
ReportyType String False The type of report to be created using this custom schema. Available values are: 'RealTime' and 'Standard' (default)

Result Set Columns

Name Type Description
Success String Whether the schema was created successfully.
SchemaFile String The generated schema file.
FileData String The generated schema encoded in base64. Only returned if WriteToFile set to false and FileStream is not set.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839