batch_job

Help me build a query

A list of mutates being processed asynchronously. The mutates are uploaded by the user. The mutates themselves aren't readable and the results of the job can only be read using BatchJobService.ListBatchJobResults.

Attributed resources
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

batch_job.id Field description Output only. ID of this batch job. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

batch_job.long_running_operation Field description Output only. The resource name of the long-running operation that can be used to poll for completion. Only set when the batch job status is RUNNING or DONE. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.metadata.completion_date_time Field description Output only. The time when this batch job was completed. Formatted as yyyy-MM-dd HH:mm:ss. Example: "2018-03-05 09:16:00" Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

batch_job.metadata.creation_date_time Field description Output only. The time when this batch job was created. Formatted as yyyy-mm-dd hh:mm:ss. Example: "2018-03-05 09:15:00" Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

batch_job.metadata.estimated_completion_ratio Field description Output only. The fraction (between 0.0 and 1.0) of mutates that have been processed. This is empty if the job hasn't started running yet. Category ATTRIBUTE Data Type DOUBLE Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.metadata.executed_operation_count Field description Output only. The number of mutate operations executed by the batch job. Present only if the job has started running. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.metadata.execution_limit_seconds Field description Immutable. The approximate upper bound for how long a batch job can be executed, in seconds. If the job runs more than the given upper bound, the job will be canceled. Category ATTRIBUTE Data Type INT32 Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.metadata.operation_count Field description Output only. The number of mutate operations in the batch job. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.metadata.start_date_time Field description Output only. The time when this batch job started running. Formatted as yyyy-mm-dd hh:mm:ss. Example: "2018-03-05 09:15:30" Category ATTRIBUTE Data Type DATE Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.next_add_sequence_token Field description Output only. The next sequence token to use when adding operations. Only set when the batch job status is PENDING. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable False Selectable True Sortable False Repeated False

batch_job.resource_name Field description Immutable. The resource name of the batch job. Batch job resource names have the form: customers/{customer_id}/batchJobs/{batch_job_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

batch_job.status Field description Output only. Status of this batch job. Category ATTRIBUTE Data Type ENUM DONE PENDING RUNNING UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v17.enums.BatchJobStatusEnum.BatchJobStatus Filterable True Selectable True Sortable True Repeated False