Statistics Report

Get an overview of how popular your shops products are on the market, and how you rank in price

P
Written by Prisjakt B2B
Updated over a week ago

With the PriceSpy Statistics Report you can get an overview of how popular your shops products are on the market, and how you rank in price. The report is an extra feature that you pay for, if you are interested - contact us for price.

There are two ways to get the feed:

  1. Under Downloads in our Business Center.

  2. Through our API, if you want to automate the fetching of the report.

Generating the files might take a while depending on the system load at the moment of request.

What is the difference between the old and the new Statistics Report?

What

Old statistics feed

New Statistics Report

API-guide

No

Code snippet

No

Format

Uses one product per row and each competitor has a number of columns. This ends up in most customers having 100s of columns, which is hard to scale with new columns and very hard to read for a human. Only contains the cheapest offers from each competitor.

Uses one offer per row with stable columns, making it easy for both machines and humans to read. The report contains all shop offers.

Supports historical downloads

No

Yes, reports are saved for 90 days, and can also be viewed/downloaded from Business Center. -> Downloads

Supports multiple shops/brands

No

Yes

Support different report types

No

Yes, by changing the report type, other reports can be downloaded with the same API.


1. Create a report through Business Center

When you click on the button "Create new report" your report is generated, when it's finished you can download it via the button. The file is a GZIP compressed CSV.

Reports are available to download for 90 days from the date they were created.

Note: If a report is very big, several files are created. These must be downloaded separately.


2. Create a report through our API

First you need an API key, contact us and we will help you with this.

Next we recommend you to take a look at our snippet guide. There you will find a code example that you can copy and test with to get started (just replace the Client key and Client ID with your own).


The report contains a number of fields with information, some of these are: ProductID, GlobalRank, CategoryRank, ShopID, IsClickable.

Below you will find a specification of all fields and what they mean.

Field name

Explanation

Market

Which PriceSpy market the offer belongs to

CategoryId

The number used to identify the category the product belongs to on PriceSpy

CategoryName

The name of the leaf category the product belongs to on PriceSpy

ProductId

The number used to identify the product on PriceSpy

ProductName

The name PriceSpy uses for the product on its product page

BrandId

The number PriceSpy uses to identify the brand for the product

BrandName

The name of the brand

ProductUrl

The link/URL to the product page on PriceSpy price comparison.

RankOnPrisjakt

The popularity rank of the product compared to all products on PriceSpy, based on clicks over the last 30 days. The lower the rank number, the more clicks the product receives.

RankInCategory

The popularity rank of the product compared to all other products in its leaf category on PriceSpy, based on clicks over the last 30 days. The lower the rank number, the more clicks the product receives.

ShopId

The number PriceSpy uses to identify the shop

ShopName

The name of the shop on PriceSpy

ClickableLink

True means that the shop is a paid member on PriceSpy and has active links that allow users to click from PriceSpy to the shop’s product page. False means that PriceSpy displays the shop’s price but users are not able to click from PriceSpy to the shop’s website

Currency

What currency the price is in. Always the local currency for the market

Price

The shop’s price for the product

OriginalPrice

Original price on the offer if there is a sale

PriceIncShipping

The shop’s price for a product including shipping cost

DifferenceToLowestPrice

On offers from your shop, this field will show how much you need to lower your price in order to have the lowest price on PriceSpy

DifferenceToLowestClickablePrice

On offers from your shop, this field will show how much you need to lower your price in order to have the lowest price on PriceSpy among shops that have clickable listings

StockStatus

Shows the shop's stock status for each offer

ShopPosition

Indicates where the shop is ranked on the product’s price comparison page on PriceSpy. The lower the number the higher the rank. If a shop has multiple variants matched with a product, PriceSpy uses the shop’s lowest price for the rank. PriceSpy bases ranking between shops by the following criteria:

  1. Price excluding shipping

  2. Price including shipping

  3. Stock status

  4. Shop rating

  5. Number of shop ratings

  6. Number of products of which the shop has the lowest price

ClickableShopPosition

Indicates where the shop is ranked on the product’s price comparison page on PriceSpy compared to shops that have clickable price listings. The lower the number the higher the rank. In this ranking, shops that are not “Featured Shops” on PriceSpy are excluded.

UpdatedAt

The last time PriceSpy updated the offer/price.

ShopProductNumber

Any other code/number the shop has provided to PriceSpy in order to identify the product. May contain GTIN or SKU codes.

Gtin

The GTIN code the shop has provided to PriceSpy in order to identify the product.

Sku

The SKU code the shop has provided to PriceSpy in order to identify the product.

ShopOfferUrl

The link/URL to the shop’s product page

ProductCondition

New

The product is new.

Used

The product has been previously used.

Refurbished

The product is reconditioned/renovated.

Demo

The product has been used as an exhibition sample and is therefore not in intact packaging, or the product is completely without packaging.

Damaged Packaging

The product is new but the packaging is damaged or missing. May be due to the packaging being damaged in transport.

Almost New

The product is both technically and visually almost like new, condition has been verified by the company and has at least a 1-year warranty.

Did this answer your question?