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 GoogleAdsService.Search/SearchStream.

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 HIGH_AVERAGE_TRANSACTION_VALUE INSUFFICIENT_MATCHED_TRANSACTIONS INSUFFICIENT_TRANSACTIONS LOW_AVERAGE_TRANSACTION_VALUE NEWLY_OBSERVED_CURRENCY_CODE UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v17.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.operation_metadata.match_rate_range Field description Output only. Match rate of the Customer Match user list upload. Describes the estimated match rate when the status of the job is "RUNNING" and final match rate when the final match rate is available after the status of the job is "SUCCESS/FAILED". Category ATTRIBUTE Data Type ENUM MATCH_RANGE_20_TO_30 MATCH_RANGE_31_TO_40 MATCH_RANGE_41_TO_50 MATCH_RANGE_51_TO_60 MATCH_RANGE_61_TO_70 MATCH_RANGE_71_TO_80 MATCH_RANGE_81_TO_90 MATCH_RANGE_91_TO_100 MATCH_RANGE_LESS_THAN_20 UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v17.enums.OfflineUserDataJobMatchRateRangeEnum.OfflineUserDataJobMatchRateRange 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.v17.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 (for example, 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.v17.enums.OfflineUserDataJobTypeEnum.OfflineUserDataJobType Filterable True Selectable True Sortable True Repeated False