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 | Accepts Input Streams | Description |
| AccountId | Int64 | False | AccountId |
| RetargetingTagId | String | False | Tag ID for site retargeting. |
| AudienceListId | Int64 | False | Audience list ID. |
| UploadType | String | False | AudienceListServiceUploadUserListUploadType displays kind of upload method.
使用できる値は次のとおりです。IDFA, AAID, MAIL_ADDRESS, UNKNOWN |
| CompressType | String | False | Displays kind of compress type of upload file.
使用できる値は次のとおりです。NONE, ZIP, GZIP, UNKNOWN |
| FileName | String | False | Name of the file to be uploaded only when content is given. For example: test.csv |
| FileLocation | String | False | Locatipn of the file to upload. |
| CustomUidKey | String | False | Specifying customUserId is a limited function for some users. |
| CustomEntityId | String | False | When linking from an external service such as DMP of another company, set according to the specifications of the user identifier provider. |
| Content | String | True | The content as InputStream to be uploading when LocalFilePath is not specified. |
Result Set Columns
| Name | Type | Description |
| Status | String | Execution status of the stored procedure |
| UploadJobId | String | Upload job ID. |