JDBC Driver for eBay Analytics

Build 22.0.8462

SellerStandardsProfile

Returns the standards profiles for the associated seller.

Select

The driver 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 driver.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462