The first time an incremental load job runs to capture change data for a Google Analytics source, the job retrieves and loads only the change records that are created after the date and time specified in the associated ingestion task. You can specify the date and time when you configure the source in the

application ingestion and replication

task wizard. However, when you resume a stopped or aborted job, the job begins propagating change data from where it last left off.

In

Application Ingestion and Replication

ingestion initial load jobs, the Google Analytics report description is the input data. Each report contains a list of dimension and metrics that replicates to the target. There are 535 columns including dimensions and metrics. However, Google Analytics can fetch a maximum of 10 metrics and 9 dimensions in a single report. You can configure multiple reports to view all dimensions & metrics.

Before you configure an

application ingestion and replication

task, you must create the report description document and save it in a location that is accessible by the Secure Agent. You should have read-permission for the file.

Google Analytics fetches data only for days and not for a given interval that is represented as a timestamp.

Consider the following guidelines while updating the reports description document for

Application Ingestion and Replication

:

Don't change the order of the field while renaming it in the report. You must overwrite the new field name.
While adding new fields to the report, add the fields at the end of fields' list of the report.
To delete fields, remove the corresponding field names from the fields' list of the report.