CampaignMigrations
Get the migration status.
Table Specific Information
SELECT
The 本製品 will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId is required to make a request and the rest of the filter is executed client-side within the 本製品.
- AccountId supports the '='.
- MigrationJobId supports the '=,IN'.
SELECT * FROM CampaignMigrations WHERE AccountId = '1002504155' SELECT * FROM CampaignMigrations WHERE AccountId = '1002504155' AND MigrationJobId = '12345'
Columns
| Name | Type | References | Description |
| MigrationJobId [KEY] | Int64 | Migration job ID. | |
| AccountId | Int64 |
DisplayAdsAccounts.AccountId | Account ID. |
| FailedCount | Int64 | Number of failed campaigns. | |
| InProgressCount | Int64 | Number of progressing campaigns. | |
| JobStatus | String | Object indicates migration job status.
使用できる値は次のとおりです。NOT_STARTED, IN_PROGRESS, COMPLETED, FILE_FORMAT_ERROR, INVALID_CSV_VALUE_ERROR, UNKNOWN_CSV_FIELD_ERROR, SYSTEM_ERROR, UNKNOWN | |
| MigrationJobEndDate | Date | Migration job end date. | |
| MigrationJobSubmitDate | Date | Migration job submit date. | |
| Scope | String | Campaign scope to be migrated.
使用できる値は次のとおりです。SINGLE_ACCOUNT, ALL_ACCOUNT, UNKNOWN | |
| SucceededCount | Int64 | Number of completed campaigns. | |
| TotalCount | Int64 | Number of total campaigns. |