SellerStandardsProfile
Returns the standards profiles for the associated seller.
Select
The connector will use the eBay Analytics API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
The Program and Cycle columns support server side filtering only when specified at the same time and only for the = operator.
- Supported values for the Program column are: PROGRAM_DE, PROGRAM_UK, PROGRAM_US and PROGRAM_GLOBAL.
- Supported values for the Cycle column are: CURRENT and PROJECTED.
For example, the query below is processed server side and it returns the SellerStandardsProfile report data for the Current cycle based on the US Program standards.
SELECT * FROM SellerStandardsProfile WHERE Cycle = 'CURRENT' AND Program = 'PROGRAM_US'
The other example query below, will return the SellerStandardsProfile for every available program standards region and for both cycles, Current and PROJECTED.
SELECT * FROM SellerStandardsProfile
Columns
| Name | Type | Description |
| Program | String | The program used to generate the profile data. Values can be PROGRAM_DE, PROGRAM_UK, PROGRAM_US, or PROGRAM_GLOBAL. |
| DefaultProgram | Boolean | Boolean indicating if this is the default program for the seller. |
| StandardsLevel | String | The overall standards level of the seller, one of TOP_RATED, ABOVE_STANDARD, or BELOW_STANDARD. |
| EvaluationReason | String | Specifies how the overall seller level was calculated. |
| Cycle | String | The cycle type, either CURRENT or PROJECTED. CURRENT means the profile's metrics values are from the most recent official eBay monthly standards evaluation. PROJECTED means the profile values were determined when the profile was requested. |
| EvaluationDate | Datetime | The date and time at which the standard compliance values were determined for the profile. |
| EvaluationMonth | String | The month in which the currently effective seller level was computed. The value is always formatted as YYYY-MM. If the cycle is CURRENT, this value is the month and year the of the last eBay compliance evaluation. If this is for a PROJECTED cycle, the value is the month and year of the next scheduled evaluation. |
| MinimumDaysOnSite | Integer | Minimum days on site. |
| Transactions | Integer | The total Transactions count. |
| SalesAmount | Decimal | The total Sales amount. |
| TransactionDefectRate | Decimal | Transaction defect rate. |
| CasesClosedWithoutSellerResolution | Decimal | Total cases closed without seller resolution. |
| LateShipmentRate | Decimal | Late shipment rate. |
| TrackingUploadedOnTimeAndValidated | Decimal | Tracking uploaded on time and validated. |
| BusinessSeller | Boolean | Business seller critera met. |
| PowerSeller | Boolean | Power seller criteria met. |
| MinimumDaysOnSiteLevel | String | The seller level for the MinimumDaysOnSite metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| TransactionsLevel | String | The seller level for the Transactions metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| SalesAmountLevel | String | The seller level for the SalesAmount metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| TransactionDefectRateLevel | String | The seller level for the TransactionDefectRate metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| CasesClosedWithoutSellerResolutionLevel | String | The seller level for the CasesClosedWithoutSellerResolution metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| LateShipmentRateLevel | String | The seller level for the LateShipmentRate metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| TrackingUploadedOnTimeAndValidatedLevel | String | The seller level for the TrackingUploadedOnTimeAndValidated metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| BusinessSellerLevel | String | The seller level for the BusinessSeller metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| PowerSellerLevel | String | The seller level for the PowerSeller metric, which indicates how well the seller is doing in meeting eBay's standards for this metric. Possible values are TOP_RATED, ABOVE_STANDARD, and BELOW_STANDARD. |
| MinimumDaysOnSiteThresholdLowerBound | Integer | Specifies the lowest number value for the MinimumDaysOnSite metric can be and still qualify for the currently assigned seller level. |
| TransactionsThresholdLowerBound | Integer | Specifies the lowest number value for the Transactions metric can be and still qualify for the currently assigned seller level. |
| SalesAmountThresholdLowerBound | Decimal | Specifies the lowest number value for the SalesAmount metric can be and still qualify for the currently assigned seller level. |
| TrackingUploadedOnTimeAndValidatedThresholdLowerBound | Decimal | Specifies the lowest number value for the TrackingUploadedOnTimeAndValidated metric can be and still qualify for the currently assigned seller level. |
| BusinessSellerThresholdLowerBound | Boolean | Specifies the lowest number value for the BusinessSeller metric can be and still qualify for the currently assigned seller level. |
| PowerSellerThresholdLowerBound | Boolean | Specifies the lowest number value for the PowerSeller metric can be and still qualify for the currently assigned seller level. |
| TransactionsThresholdUpperBound | Integer | Specifies the highest number value for the Transactions metric can be and still qualify for the currently assigned seller level. |
| SalesAmountThresholdUpperBound | Decimal | Specifies the highest number value for the SalesAmount metric can be and still qualify for the currently assigned seller level. |
| TransactionDefectRateThresholdUpperBound | Decimal | Specifies the highest number value for the TransactionDefectRate metric can be and still qualify for the currently assigned seller level. |
| CasesClosedWithoutSellerResolutionThresholdUpperBound | Decimal | Specifies the highest number value for the CasesClosedWithoutSellerResolution metric can be and still qualify for the currently assigned seller level. |
| LateShipmentRateThresholdUpperBound | Decimal | Specifies the highest number value for the LateShipmentRate metric can be and still qualify for the currently assigned seller level. |
| BusinessSellerThresholdUpperBound | Boolean | Specifies the highest number value for the BusinessSeller metric can be and still qualify for the currently assigned seller level. |
| PowerSellerThresholdUpperBound | Boolean | Specifies the highest number value for the PowerSeller metric can be and still qualify for the currently assigned seller level. |
| MinimumDaysOnSiteThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the MinimumDaysOnSite metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| TransactionsThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the Transactions metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| SalesAmountThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the SalesAmount metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| TransactionDefectRateThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the TransactionDefectRate metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| CasesClosedWithoutSellerResolutionThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the CasesClosedWithoutSellerResolution metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| LateShipmentRateThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the LateShipmentRate metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| TrackingUploadedOnTimeAndValidatedThresholdMetaData | String | An expression that indicates the inclusive and exclusive characteristics of the upper and lower threshold boundaries for the TrackingUploadedOnTimeAndValidated metric. The expression consists of two values separated by a comma, which are bounded by either a parenthesis or a square bracket. The parenthesis excludes the adjacent value, while the square bracket includes it. |
| TransactionsLookbackStartDate | Datetime | The start date and time when the seller was evaluated for the Transactions metric. |
| SalesAmountLookbackStartDate | Datetime | The start date and time when the seller was evaluated for the SalesAmount metric. |
| TransactionDefectRateLookbackStartDate | Datetime | The start date and time when the seller was evaluated for the TransactionDefectRate metric. |
| CasesClosedWithoutSellerResolutionLookbackStartDate | Datetime | The start date and time when the seller was evaluated for the CasesClosedWithoutSellerResolution metric. |
| LateShipmentRateLookbackStartDate | Datetime | The start date and time when the seller was evaluated for the LateShipmentRate metric. |
| TrackingUploadedOnTimeAndValidatedLookbackStartDate | Datetime | The start date and time when the seller was evaluated for the TrackingUploadedOnTimeAndValidated metric. |
| TransactionsLookbackEndDate | Datetime | The end date and time when the seller was evaluated for the Transactions metric. |
| SalesAmountLookbackEndDate | Datetime | The end date and time when the seller was evaluated for the SalesAmount metric. |
| TransactionDefectRateLookbackEndDate | Datetime | The end date and time when the seller was evaluated for the TransactionDefectRate metric. |
| CasesClosedWithoutSellerResolutionLookbackEndDate | Datetime | The end date and time when the seller was evaluated for the CasesClosedWithoutSellerResolution metric. |
| LateShipmentRateLookbackEndDate | Datetime | The end date and time when the seller was evaluated for the LateShipmentRate metric. |
| TrackingUploadedOnTimeAndValidatedLookbackEndDate | Datetime | The end date and time when the seller was evaluated for the TrackingUploadedOnTimeAndValidated metric. |
| SalesAmountCurrency | String | The sales amount currency. |