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.
使用できる値は次のとおりです。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'.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。CUSTOMER_MATCH_USER_LIST, CUSTOMER_MATCH_WITH_ATTRIBUTES, STORE_SALES_UPLOAD_FIRST_PARTY, STORE_SALES_UPLOAD_THIRD_PARTY, UNKNOWN, UNSPECIFIED |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
ManagerId | Long | Id of the manager account on behalf of which you are requesting customer data. |