JDBC Driver for eBay Analytics

Build 22.0.8462

TrafficReportByDay

Returns a report that details the user traffic received by a seller's listings per day.

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.

To query the TrafficReportByDay view, a value for the MarketplaceId and the report date range via the columns ReportStartDate and ReportEndDate should be specified.

  • In case, the MarketplaceId is not specified, the value set in the MarketplaceId connection property will be used instead by default.

    The MarketplaceId is server side filterable and supports the operators: "=" and "IN".

    Supported MarketplaceId values are: EBAY_DE, EBAY_GB, EBAY_AU and EBAY_US.

  • In case, the report range (ReportStartDate and ReportEndDate) is not specified or partly specified, the driver will return the data for the last 90 days or 90 days before or after the partly specified range depending on which date range parameter is missing.

    The ReportStartDate and ReportEndDate columns are server side filterable and support only the operator: =.

  • Additionally the user can limit the report data to a listing or to a group of listings via the ListingId input.

    The ListingId is server side filterable and supports the operators: "=" and "IN".

The example query below will return TrafficReportByDay data for the Marketplace specified in the MarketplaceId connection property and for the last 90 days.

SELECT * FROM TrafficReportByDay

The other example query below, will return TrafficReportByDay data for the specified listings in the US Marketplace within the defined date range.

SELECT * FROM TrafficReportByDay WHERE ListingId IN ('182227914336', '182283742135', '311698881010') AND MarketplaceId = 'EBAY_US' AND ReportStartDate='2019-07-12' AND ReportEndDate = '2019-09-13'

Columns

Name Type Description
Day Date The Day (individual date) by which the metrics are grouped.
ClickThroughRate Double The number of times an item displays on the search results page divided by the number of times buyers clicked through to its View Item page.
ListingImpressionSearchResultsPage Integer The number of times the seller's listings displayed on the search results page. Note, the listing might not have been visible to the buyer due to its position on the page.
ListingImpressionStore Integer The number of times the seller's listings displayed on the seller's store. Note, the listing might not have been visible to the buyer due to its position on the page.
ListingImpressionTotal Integer The total number of times the seller's listings displayed on the search results page OR in the seller's store. The item is counted each time it displays on either page. However, the listing might not have been visible to the buyer due to its position on the page. This is a combination of: ListingImpressionSearchResultsPage + ListingImpressionStore.
ListingViewsSourceDirect Integer The number of times a View Item page was directly accessed, such as when a buyer navigates to the page using a bookmark.
ListingViewsSourceOffEbay Integer The number of times a View Item page was accessed via a site other than eBay, such as when a buyer clicks on a link to the listing from a search engine page.
ListingViewsSourceOtherEbay Integer The number of times a View Item page was accessed from an eBay page that is not either the search results page or the seller's store.
ListingViewsSourceSearchResultsPage Integer The number of times the item displayed on the search results page.
ListingViewsSourceStore Integer The number of times a View Item page was accessed via the seller's store.
ListingViewsTotal Integer Total number of listings viewed. This number sums: ListingViewsSourceDirect, ListingViewsSourceOffEbay, ListingViewsSourceOtherEbay, ListingViewsSourceSearchResultsPage, ListingViewsSourceStore.
SalesConversionRate Double The number of completed transactions divided by the number of View Item page views. Equals: TransactionsCount/ListingViewsTotal.
TransactionsCount Integer The total number of completed transactions.
UsageStartDate Datetime The start date of the actual date range of the report data.
UsageEndDate Datetime The end date of the actual date range of the report data.
LastUpdatedDate Datetime The last time the data returned in the report was updated.
ReportStartDate Date The requested start date of the date range used to calculate the report.
ReportEndDate Date The requested end date of the date range used to calculate the report. If you specify an report end date that is beyond the lastUpdatedDate value, eBay returns a report that contains data only up to the LastUpdateDate. For this reason, the provided ReportStartDate and ReportEndDate values used to request the report might not match with the report's actual date range: ReportStartDate - ReportEndDate.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
MarketplaceId String The eBay marketplace ID of the marketplace upon which the seller report is limited.
ListingId String The Id of the Listing by which the metrics are grouped. You can get your ListingId-s from the TrafficReportByListing view.

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