SSIS Components for Yahoo! Ads

Build 24.0.9062

DisplayAdsUploadUserList

Upload the user list file for audience list (custom) and audience list (customer data).

Stored Procedure Specific Information

Yahoo! Ads allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. The required columns in DisplayAdsUploadUserList are AccountId, RetargetingTagId, TargetListId, UploadType and CompressType. For example:

EXECUTE DisplayAdsUploadUserList AccountId = '8976', RetargetingTagId = '89746', AudienceListId = '56638', UploadType = 'IDFA', CompressType = 'ZIP'

Input

Name Type Description
AccountId Int64 AccountId
AudienceListId Int64 Audience list ID.
UploadType String AudienceListServiceUploadUserListUploadType displays kind of upload method.

使用できる値は次のとおりです。IDFA, AAID, MAIL_ADDRESS_AND_PHONE_NUMBER, UNKNOWN

CompressType String Displays kind of compress type of upload file.

使用できる値は次のとおりです。NONE, ZIP, GZIP, UNKNOWN

FileName String Name of the file to be uploaded only when content is given. For example: test.csv
FileLocation String Locatipn of the file to upload.

Result Set Columns

Name Type Description
Status String Execution status of the stored procedure
UploadJobId String Upload job ID.

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