General Documentation

Description

Based on all acquisition transactions in the Nordics, we've created a data-based service that displays ongoing market trends. Dynamic filters turn analytics into actionable insights, allowing users to view weekly, monthly, quarterly, and yearly developments in card turnover, number of transactions, and number of cards. Users can also compare user-defined time periods with historical figures. Additionally, the correlation between card spending and number of cards is calculated to showcase which industries are affected by factors such as tourism, card area origin, business cards, and e-commerce development. The service also estimates the resident area of the cardholder based on previous transaction patterns, which can be used to identify the distribution of cardholders for a specific industry in a specific merchant area. These insights enable benchmarking with historical and current market trends, information on business expansion possibilities, reduction of consumer survey costs, improved targeted marketing, and more.

 

Verticals & Categories (Industries)

In terms of merchant categorization, we use two methods. First, a merchant is assigned one of four vertical values for high-level categorization. Second, the merchant is assigned a specific category to which they belong.

Strikethrough indicates retired categories.

Category code Category (Industry) Vertical
1 Airlines & Travel Agencies Transportation
2 Amusement & Attractions Hospitality
3 Bakeries Retail
4 Bars & Liquor Stores Hospitality
5 Building Supplies & Hardware Stores Retail
6 Clothing, Bags & Shoes Retail
7 Convenience & Variety Stores Retail
8 Digital Services, Games & Betting Services
9 Eating Places Hospitality
10 Florists Retail
11 Furniture & Home Interior Retail
12 Healthcare Services
13 Hobby, Office & Book Stores Retail
14 Hotels Hospitality
15 IT, Telecom & Electronics Retail
16 Jewelry Retail
17 Miscellaneous Other
18 Other Retail Retail
19 Services (Petrol) Stations Transportation
20 Specialty Stores (Food) Retail
21 Specialty Stores (Non-Food) Retail
22 Supermarkets Retail
23 Transportation Services Transportation
24 Transportation Vehicles & Parts Transportation
25 Wellness, Beauty & Barber Shops Retail
26 Drinking Establishments Hospitality
27 Healthcare Services Services
28 Cosmetics, Glasses & Medical Goods Retail
29 Beauty & Wellness Services Services

 

Group By

The "group_by" filter allows you to define the structure and content of the response, similar to the "group by" functionality when writing SQL queries. The fields specified in this parameter will be used to group data in the response. For example, if you want to examine how much different nationalities spend in each country on a weekly basis, you can provide the "group_by" filter with the following: "transaction_year," "transaction_week," "issuer_country," and "outlet_country." This means that the data will be grouped by the transaction year, transaction week number, issuer country, and merchant/outlet country, and you will then receive the card turnover, number of cards, and number of transactions for each case. The result will have the following format:

{
  "transactions_year": 2020,
  "transactions_week": 4,
  "outlet_country": "Denmark",
  "issuer_country": "Finland",
  "card_turnover": 1000.50,
  "number_of_transactions": 35,
  "number_of_cards": 30
}

 

Dictionary

From API
Description
Country ISO-A3 3-letter country code (Denmark = DNK)
Industry/Category For which a merchant is categorised based on its Merchant Category Code (MCC)
Municipality code The number format of a given municipality
Category code The number format of a given category/Industry
Domestic/International Domestic or International (foreign) cards meaning cards used in the same country as they have been issued
Business/Private Business or Private card spending
Online/Physical E-commerce or Physical (POS) card spending
Vertical The vertical which covers more categories
Hour, date, day of month, week number, month, quarter, year The time options which can be used in filters
Financial Term
Description
Vertical Covers a group of industry categories
Normalised All numbers are divided by the grand total
Merchant The operator of a business
Domestic Card spend in the same country as the card has been issued
International Card spend in a different country as the card has been issued
Business card Cards issued as business cards
Private card Cards issued for private use
E-commerce Online Online transactions
Physical or POS In-store transactions