SSIS Components for Google Analytics

Build 25.0.9434

PropertiesKeyEvents

Returns a list of Key Events in the specified parent property.

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 PropertiesKeyEvents where parent = 'properties/309787233'
	SELECT * FROM PropertiesKeyEvents where name = 'properties/309787233/keyEvents/7710067029'
The rest of the filter is executed client-side in the component.

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Name [KEY] String Resource name of this key event. Format: properties/{property}/keyEvents/{keyEvent}.
Parent String Name of the Key Events's logical parent.
PropertyId Integer Property ID value to be used when querying this table.
EventName String The event name for this key event. Examples: 'click', 'purchase'
CreateTime Datetime Time when this key event was created in the property.
Deletable Boolean Whether this event can be deleted.
Custom Boolean Whether this key event refers to a custom event.
CountingMethod String The method by which Key Events will be counted across multiple events within a session.
DefaultValue String Defines a default value/currency for a key event.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434