...
Query Definition
Option
Description
Start Date
Specifies the start date associated with the query. The date must be entered in the following format: YYYY-MM-DD.
End Date
Specifies the end date associated with the query. The date must be entered in the following format: YYYY-MM-DD.
Dimensions
Specifies the dimension fields for which you want to query. The Google Analytics API documentation provides you with a list of valid inputs and metrics that can be combined.
Metrics
Specifies the metrics fields you want returned. At least one metric must be provided.
Filters
Specifies the filter (described in the Google Analytics API documentation). Here is an example: 'ga:country==Algeria'.
Sort
Specifies a field on which to sort. Here is an example: 'ga:city'.
Specify a segment for the query
Allows you to specify a segment for the query. A segment is analogous to a database "view."
Use custom segment
Check this option, when you want to specify a custom segment. A segment is analogous to a database "view."
Use predefined segment
Select from the predefined segments. A segment is analogous to a database "view."
Fields
Click Get Fields to retrieve a list of possible fields based on the query you defined.
Click Preview to preview data based on the defined query.Metadata Injection Support
All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.
References
- Google Analytics Query Explorer: This tool lets you play with the Core Reporting API by building queries to get data from your Google Analytics profiles. You can use these queries in the step.
- Reference guides for Google Analytics:, Dimensions & Metrics.