CatalogRetailReport
Returns the retail catalog processing report with status, run timestamps, item counts, and error summaries.
Table Specific Information
Select
The 本製品 will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- CatalogId supports the '=' operator.
- CatalogType supports the '=' operator.
- ReportType supports the '=' operator.
- FeedId supports the '=' operator.
- ProcessingResultId supports the '=' operator.
- AdAccountId supports the '=' operator.
Select * from CatalogRetailReport
Select * from CatalogRetailReport where CatalogId='4853306950123'
Select * from CatalogRetailReport where AdAccountId = '549768233165'
Select * from CatalogRetailReport where CatalogType = 'RETAIL'
Select * from CatalogRetailReport where ReportType='DISTRIBUTION_ISSUES'
Columns
| Name | Type | References | Description |
| CatalogId | String | Unique identifier of a catalog. | |
| CatalogName | String | CatalogName. | |
| DataSourceId | String | DataSourceId. | |
| DataSourceName | String | DataSourceName. | |
| ItemId | String | ItemId. | |
| Title | String | Title. | |
| IneligibleForOrganic | String | IneligibleForOrganic. | |
| IneligibleForAds | String | IneligibleForAds. | |
| CodeLabel | String | CodeLabel. | |
| Message | String | Message. | |
| Link | String | Link. | |
| ImageLink | String | ImageLink. | |
| Price | String | Price. | |
| Availability | String | Availability. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| CatalogType | String | Type of the catalog entity.
使用できる値は次のとおりです。RETAIL, HOTEL, CREATIVE_ASSETS | |
| ReportType | String | Report Type.
使用できる値は次のとおりです。FEED_INGESTION_ISSUES, DISTRIBUTION_ISSUES, ALL_ITEMS | |
| FeedId | String | ID of the feed entity. | |
| ProcessingResultId | String | Unique identifier of a feed processing result. | |
| AdAccountId | String | Unique identifier of an ad account. |