OfflineUserDataJob
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.
Columns
| Name | Type | Behavior | Description |
| CustomerId | Long | ATTRIBUTE | Output only. The ID of the customer. |
| OfflineUserDataJobCustomerMatchUserListMetadataUserList | String | ATTRIBUTE | The resource name of remarketing list to update data. Required for job of CUSTOMER_MATCH_USER_LIST type. |
| OfflineUserDataJobExternalId | Long | ATTRIBUTE | Immutable. User specified job ID. |
| OfflineUserDataJobFailureReason | String | ATTRIBUTE | Output only. Reason for the processing failure, if status is FAILED.
The allowed values are HIGH_AVERAGE_TRANSACTION_VALUE, INSUFFICIENT_MATCHED_TRANSACTIONS, INSUFFICIENT_TRANSACTIONS, LOW_AVERAGE_TRANSACTION_VALUE, NEWLY_OBSERVED_CURRENCY_CODE, UNKNOWN, UNSPECIFIED. |
| OfflineUserDataJobId | Long | ATTRIBUTE | Output only. ID of this offline user data job. |
| OfflineUserDataJobOperationMetadataMatchRateRange | String | ATTRIBUTE | 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'.
The allowed values are 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. |
| OfflineUserDataJobResourceName | String | ATTRIBUTE | 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} |
| OfflineUserDataJobStatus | String | ATTRIBUTE | Output only. Status of the job.
The allowed values are FAILED, PENDING, RUNNING, SUCCESS, UNKNOWN, UNSPECIFIED. |
| OfflineUserDataJobStoreSalesMetadataLoyaltyFraction | Double | ATTRIBUTE | 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). |
| OfflineUserDataJobStoreSalesMetadataThirdPartyMetadataAdvertiserUploadDateTime | Datetime | ATTRIBUTE | 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' |
| OfflineUserDataJobStoreSalesMetadataThirdPartyMetadataBridgeMapVersionId | String | ATTRIBUTE | Version of partner IDs to be used for uploads. Required. |
| OfflineUserDataJobStoreSalesMetadataThirdPartyMetadataPartnerId | Long | ATTRIBUTE | ID of the third party partner updating the transaction feed. |
| OfflineUserDataJobStoreSalesMetadataThirdPartyMetadataPartnerMatchFraction | Double | ATTRIBUTE | 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). |
| OfflineUserDataJobStoreSalesMetadataThirdPartyMetadataPartnerUploadFraction | Double | ATTRIBUTE | 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). |
| OfflineUserDataJobStoreSalesMetadataThirdPartyMetadataValidTransactionFraction | Double | ATTRIBUTE | 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). |
| OfflineUserDataJobStoreSalesMetadataTransactionUploadFraction | Double | ATTRIBUTE | 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. |
| OfflineUserDataJobType | String | ATTRIBUTE | Immutable. Type of the job.
The allowed values are CUSTOMER_MATCH_USER_LIST, CUSTOMER_MATCH_WITH_ATTRIBUTES, STORE_SALES_UPLOAD_FIRST_PARTY, STORE_SALES_UPLOAD_THIRD_PARTY, UNKNOWN, UNSPECIFIED. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |