You can use a Google Analytics object as a source in a data loader task.
When you create a data loader task to read data from Google Analytics, specify the Google Analytics source properties.
The following table describes the Google Analytics source properties:
Property
Description
Connection
Name of the source connection.
Select a source connection or create a new connection.
Source Path
Name of the dataset that contains the source data.
Select a Google Analytics report from the ga dataset or select the InfaCustomGroup from the InfaCustom dataset.
To read all objects or exclude some objects from the ga dataset, enter ga.
ViewId
The Google Analytics View ID associated with the Google Analytics project. You can specify multiple view IDs separated by comma.
Note: When you read data from Goal Conversions report, you must specify the same view ID that you specified in the Google Analytics connection.
StartDate
Start date from when you want to read the data from a Google Analytics report.
You can specify a specific date using the YYYY-MM-DD format.
You can also specify relative terms such as today, yesterday, or NdaysAgo.
EndDate
End date till when you want to read the data from a Google Analytics report.
You can specify a specific date using the YYYY-MM-DD format.
You can also specify relative terms such as today, yesterday, or NdaysAgo.
Google Analytics metrics and dimensions
When you read from the Google Analytics report, you can select the objects. The objects represent the metrics and dimensions of the Google Analytics report. To verify if the object is a metric or a dimension, click the following URL:
A task fails if any of the following conditions are true:
•You select more than 10 metrics in the Google Analytics report.
•You select more than 7 dimensions in the Google Analytics report.
•You select only dimensions or only metrics in the Google Analytics report.
Rules and guidelines for primary key fields and watermark fields
When you read data from Google Analytics, the primary key fields and watermark fields are not detected. You can manually define the primary key fields and watermark fields. The default values are Automatically detect from source and Watermark fields not required.