Power BI Connector for Google Ads

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062