SSIS Components for Google Analytics

Build 23.0.8839

PropertiesDataStreams

Lists all data streams under a property to which the user has access. Attribute Parent (e.g: 'properties/123') or Name (e.g: 'properties/123/webDataStreams/456') is required to query the table.

Select

The component uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:

  • Parent supports the following operator: =
  • Name supports the following operator: =
The Name or Parent is required to make a request. For example, the following queries are processed server-side:
	SELECT * FROM PropertiesDataStreams WHERE Parent = 'properties/123'
	SELECT * FROM PropertiesDataStreams WHERE Name =   'properties/123/webDataStreams/456'
The rest of the filter is executed client-side in the component.

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
CreateTime Datetime Time the stream was created.
DisplayName String Display name for the data stream.
Name String Web data stream name.
Parent String Name of the web data stream's logical parent.
Type String Name of the web data stream's logical parent.
webStreamData String Data specific to web streams.
androidAppStreamData String Data specific to Android app streams.
iosAppStreamData String Data specific to iOS app streams.
UpdateTime Datetime Time the stream was last modified.
PropertyId Integer The Property Id value to be used when querying this table.

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