offline_user_data_job

Help me build a query

A job containing offline user data of store visitors, or user list members that will be processed asynchronously. The uploaded data isn't readable and the processing results of the job can only be read using OfflineUserDataJobService.GetOfflineUserDataJob.

Attributed resources
customer
user_list

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.

offline_user_data_job.customer_match_user_list_metadata.user_list Field description The resource name of remarketing list to update data. Required for job of CUSTOMER_MATCH_USER_LIST type. Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

offline_user_data_job.external_id Field description Immutable. User specified job ID. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.failure_reason Field description Output only. Reason for the processing failure, if status is FAILED. Category ATTRIBUTE Data Type ENUM INSUFFICIENT_MATCHED_TRANSACTIONS INSUFFICIENT_TRANSACTIONS UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v6.enums.OfflineUserDataJobFailureReasonEnum.OfflineUserDataJobFailureReason Filterable True Selectable True Sortable True Repeated False

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

offline_user_data_job.resource_name Field description Immutable. The resource name of the offline user data job. Offline user data job resource names have the form: `customers/{customer_id}/offlineUserDataJobs/{offline_user_data_job_id}` Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

offline_user_data_job.status Field description Output only. Status of the job. Category ATTRIBUTE Data Type ENUM FAILED PENDING RUNNING SUCCESS UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v6.enums.OfflineUserDataJobStatusEnum.OfflineUserDataJobStatus Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.loyalty_fraction Field description This is the fraction of all transactions that are identifiable (i.e., associated with any form of customer information). Required. The fraction needs to be between 0 and 1 (excluding 0). Category ATTRIBUTE Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.third_party_metadata.advertiser_upload_date_time Field description Time the advertiser uploaded the data to the partner. Required. The format is "YYYY-MM-DD HH:MM:SS". Examples: "2018-03-05 09:15:00" or "2018-02-01 14:34:30" Category ATTRIBUTE Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.third_party_metadata.bridge_map_version_id Field description Version of partner IDs to be used for uploads. Required. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.third_party_metadata.partner_id Field description ID of the third party partner updating the transaction feed. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.third_party_metadata.partner_match_fraction Field description The fraction of valid transactions that are matched to a third party assigned user ID on the partner side. Required. The fraction needs to be between 0 and 1 (excluding 0). Category ATTRIBUTE Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.third_party_metadata.partner_upload_fraction Field description The fraction of valid transactions that are uploaded by the partner to Google. Required. The fraction needs to be between 0 and 1 (excluding 0). Category ATTRIBUTE Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.third_party_metadata.valid_transaction_fraction Field description The fraction of transactions that are valid. Invalid transactions may include invalid formats or values. Required. The fraction needs to be between 0 and 1 (excluding 0). Category ATTRIBUTE Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.store_sales_metadata.transaction_upload_fraction Field description This is the ratio of sales being uploaded compared to the overall sales that can be associated with a customer. Required. The fraction needs to be between 0 and 1 (excluding 0). For example, if you upload half the sales that you are able to associate with a customer, this would be 0.5. Category ATTRIBUTE Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

offline_user_data_job.type Field description Immutable. Type of the job. Category ATTRIBUTE Data Type ENUM CUSTOMER_MATCH_USER_LIST CUSTOMER_MATCH_WITH_ATTRIBUTES STORE_SALES_UPLOAD_FIRST_PARTY STORE_SALES_UPLOAD_THIRD_PARTY UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v6.enums.OfflineUserDataJobTypeEnum.OfflineUserDataJobType Filterable True Selectable True Sortable True Repeated False