TDV Adapter for Google Ads

Build 22.0.8462

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 Date 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462