The Prisjakt Insights reports contain data about products, shops, prices and availability. Some reports are very large, containing several thousands of rows of data. This article shows you how to use the data to answer a few basic questions.

To access the reports, use either the Google Data Studio Connector, the Google Sheet Add-Onor the Insights API.

Product popularity is measured with Click Volume. A click is the event that takes place when a user navigates from a product page at Prisjakt to a shop page, possible with a purchase intent. The product with the largest number of clicks in the category is represented with Click Volume of 100. All other products are assigned lower numbers depending on their amount of clicks. This makes it easy to see the variation in the amount of clicks between products. In some categories, a small number of products get most of the clicks.

To spot change in popularity, use Week-on-Week (WOW) which is the percentage change in Click Volume between the previous and current 7 day period.

Product stock status is represented in the Stock Status metric. The values are self explanatory: "in_stock", "not_in_stock" or "unknown". To see the number of shops that carry the product, you count the number of unique shop, the Shop Name or Shop ID dimensions.

This video shows how:

Pricing is represented with the Price metric. The relation between a shop's price and other shops, is represented with the Price Ratio metric. The shop that has the cheapest offer for a product, is represented with a Price Ration of 100. All other shops get the same or higher Price Ratio depending on their price.

This video shows how: