Merchant Insights

August 14, 2023

Summary

The categorisation has been changed, which mean new categories have been created, old ones have retired and some MCCs have been moved to another category. A new vertical has also been created.

Docs

Updated category table with new and retired categories. Table

Changed

Below are the changes which have made to improve the MCC mappings based on customer feedback from the previous year:

Removed contractors and similar MCCs from category "Building Supplies & Hardware Stores" (category_code: 5). This means the following MCCs are moved to the “Miscellaneous” category (category_code: 17):
- 0780 (Landscaping and Horticultural Services)
- 1520 (General contractors-resident)
- 1711 (Heating, Plumbing, and Air Conditioning Contractors)
- 1731 (Electrical contractors)
- 1740 (Masonry, Stonework, Tile Setting, Plastering, and Insulation Contractors)
- 1750 (Carpentry Contractors)
- 1761 (Roofing, Siding, and Sheet Metal Work Contractors)
- 1771 (Concrete Work Contractors)
- 1799 (Special Trade Contractors (Not Elsewhere Classified))
- 2032 (Unknown Contractor)
- 4900 (Utilities - electric, gas, water and sanitary)
- 7692 (Welding Services)
Created the new category “Drinking Establishments” (category_code: 26) which contains MCC 5813 (Drinking Places (Alcoholic Beverages) - Bars, Taverns, Nightclubs, Cocktail Lounges, & Discotheques). This means that the “Liquor Stores” MCCs will be moved from “Bars & Liqour Stores” (now retired - category_code: 4) to “Specialty Stores (Food)” (category_code: 20):
- 0743 (Wine producers)
- 5715 (Alcoholic beverage wholesale)
- 5921 (Package Stores - Beer, Wine, and Liquor)
Moved MCC 5172 (Petroleum & Petroleum Products) from “Service (Petrol) Stations” (category_code: 19) to “Other Retail” (category_code: 18)
Moved MCC 7549 (Towing Services) and 8675 (Automobile Associations) from category “Transportation Vehicles & Parts” (category_code:24) to category “Transportation Services” (category_code: 23).
Moved 5996 (Swimming Pools - Sales & Service) from “Furniture & Home Interior” (category_code: 11) to “Other Retail” (category_code: 18)
Recategorised MCCs in categories “Healthcare” (now retired - category_code: 12) & “Wellness, Beauty & Barber Shops” (now retired - category_code: 25) to distinguish those merchants selling services from those selling physical goods.
- The current mappings are the following two categories:
  - “Healthcare” (now retired - category_code: 12):
    - 5047 (Medical, Dental, Ophthalmic and Hospital Equipment and Supplies)
    - 5912 (Drug Stores and Pharmacies)
    - 5975 (Hearing Aids - Sales, Service, and Supply)
    - 5976 (Orthopedic Goods - Prosthetic Devices)
    - 7280 (Hospital Patient-Personal Funds Withdrawal)
    - 8011 (Doctors and Physicians (Not Elsewhere Classified))
    - 8021 (Dentists and Orthodontists)
    - 8031 (Osteopaths)
    - 8041 (Chiropractors)
    - 8042 (Optometrists and Ophthalmologists)
    - 8043 (Opticians, Optical Goods, and Eyeglasses)
    - 8044 (Optical Goods and Eyeglasses)
    - 8049 (Podiatrists and Chiropodists)
    - 8050 (Nursing and Personal Care Facilities)
    - 8062 (Hospitals)
    - 8071 (Medical and Dental Laboratories)
    - 8099 (Medical Services and Health Practitioners (Not Elsewhere Classified))
  - “Wellness, Beauty & Barber Shops” (now retired - category_code: 25)
    - 5122 (Drugs, Drug Proprietaries And Druggist Sundries)
    - 5977 (Cosmetic stores)
    - 7230 (Beauty shops, barber shops)
    - 7297 (Massage parlors)
    - 7298 (Health and beauty spas)
- The corresponding updated mapping uses the following three categories:
  - “Healthcare Services” (category_code: 27)
    - 7280 (Hospital Patient-Personal Funds Withdrawal)
    - 8011 (Doctors and Physicians (Not Elsewhere Classified))
    - 8021 (Dentists and Orthodontists)
    - 8031 (Osteopaths)
    - 8041 (Chiropractors)
    - 8049 (Podiatrists and Chiropodists)
    - 8050 (Nursing and Personal Care Facilities)
    - 8062 (Hospitals)
    - 8071 (Medical and Dental Laboratories)
    - 8099 (Medical Services and Health Practitioners (Not Elsewhere Classified))
  - “Cosmetics, Glasses & Medical Goods” (category_code: 28)
    - 5047 (Medical, Dental, Ophthalmic and Hospital Equipment and Supplies)
    - 5122 (Drugs, Drug Proprietaries And Druggist Sundries)
    - 5912 (Drug Stores and Pharmacies)
    - 5975 (Hearing Aids - Sales, Service, and Supply)
    - 5976 (Orthopedic Goods - Prosthetic Devices)
    - 5977 (Cosmetic stores)
    - 8042 (Optometrists and Ophthalmologists)
    - 8043 (Opticians, Optical Goods, and Eyeglasses)
    - 8044 (Optical Goods and Eyeglasses)
  - “Beauty & Wellness Services” (category_code: 29)
    - 7230 (Beauty shops, barber shops)
    - 7297 (Massage parlors)
    - 7298 (Health and beauty spas)

Added

Vertical "Services" has been created, to make a more clear distinction between merchants selling physical goods ("Retail")

and merchants selling services ("Services").

August 7, 2023

Summary

Benchmarking "year over year" and "market average" has been changed and improved, so it is more flexible and intuitive for the client. Some group_by inputs has been removed and replaced, and more group_by values has been added. Some filters have been removed and replaced with other filters.

Changed

Breaking: "Year over Year" and "Market Average" renaming of fields in response.
- group_name -> merchant_group_name
- company_name -> merchant_company_name
- vat_code -> merchant_vat_code
- outlet_name -> merchant_outlet_name
- outlet_id -> merchant_outlet_id
Breaking: "Year over Year" and "Market Average" renaming of filters.
- outlet_name -> merchant_outlet_name
- outlet_id -> merchant_outlet_id
- vat_code -> merchant_vat_code
- market_category_code -> market_outlet_category_code
- market_vertical -> market_outlet_vertical
Breaking: "Year over Year" and "Market Average" renaming of group_by inputs.
- group_name -> merchant_group_name
- company_name -> merchant_company_name
- vat_code -> merchant_vat_code
- outlet_id -> merchant_outlet_id
- outlet_name -> merchant_outlet_name

Removed

Breaking: "Year over Year" and "Market Average" response do not

contain global category and vertical field.

Breaking: Removed following filters from "Year over Year" and "Market Average".
- outlet_municipality_code
- outlet_region_code
- outlet_country_a3
Breaking: Removed following group_by inputs from "Year over Year" and "Market Average".
- country
- region
- municipality
- vertical
- category
- outlet_mcc

Added

"Year over Year" and "Market Average" has new possible group_by inputs.
- merchant_outlet_country
- merchant_outlet_region
- merchant_outlet_municipality
- merchant_outlet_vertical
- merchant_outlet_category
- market_outlet_country
- market_outlet_region
- market_outlet_municipality
- market_outlet_vertical
- market_outlet_category
"Year over Year" and "Market Average" new filters.
- merchant_outlet_country_a3
- merchant_outlet_region_code
- merchant_outlet_municipality_code
- merchant_outlet_vertical
- merchant_outlet_category_code
- market_outlet_country_a3
- market_outlet_region_code
- market_outlet_municipality_code
- market_outlet_vertical
- market_outlet_category_code

June 9, 2023

Summary

Benchmarking year over year default response has changed.

Changed

Breaking: Benchmarking year over year default response changed to not include transaction_month.

June 07, 2023

Summary

Recurring customers is now faster and more intuitive for client.

Removed

Breaking: Filters removed from Recurring customers.
- transaction_year
- transaction_quarter
- transaction_month
- transaction_week
- transaction_day
- transaction_date
- year_range_start
- year_range_end
- quarter_range_start
- quarter_range_end
- month_range_start
- month_range_end
- week_range_start
- week_range_end

Changed

Breaking: past_months renamed to past_month_count.
Breaking: date_range_start, date_range_end and past_month_count is required for recurring customers.

May 25, 2023

Summary

The year range validation has been replaced by format validation, and the default responses returns bigger range of data.

Changed

Filter transaction_year is now a list, except in RFM.
The amount of data returned by default has been changed significantly.

March 14, 2023

Summary

To make ranges more clear, the documentation has been changed.

Docs

Add minimum and maximum in documentation for filters e.g.

December 12, 2022

Summary

Tutorials has been improved to make them easier to follow and filters has been renamed and new filters is added.

Changed

Improved documentation for better usability.
Improved 'Tutorials'

Breaking: Filters renamed
- year_analysis -> analysis_year
- year_baseline -> baseline_year

Added

is_non_local as filter and group by option.
New Filters
- Transaction_year
- Transaction_quarter
- Transaction_month
- Transaction_week
- Transaction_day
- Transaction_hour
- Transaction_date

June 16, 2022

Summary

A big change in the filter naming and the client info response is now a list.

Changed

Breaking: Filters naming changed (old -> new)
- bus_pri -> business_private
- date_range_option1 -> date_range_start
- date_range_option2 -> date_range_end
- week_number_range_option1 -> week_number_range_start
- week_number_range_option2 -> week_number_range_end
- month_range_option1 -> month_range_start
- month_range_option2 -> month_range_end
- quarter_range_option1 -> quarter_range_start
- quarter_range_option2 -> quarter_range_end
- year_range_option1 -> year_range_start
- year_range_option2 -> year_range_end
- ecom_pos -> online_physical
- estimated_area_of_cardholder_country -> estimated_residence_country_a3
- estimated_area_of_cardholder_municipality -> estimated_residence_municipality_code
- estimated_area_of_cardholder_region -> estimated_residence_region_code
- estimated_area_of_cardholder_zipcode -> estimated_residence_zipcode
- locality -> is_regional_local, is_municipality_local, is_zipcode_local
- issuer_country -> issuer_country_a3
- outlet_country -> outlet_country_a3
- outlet_municipality -> outlet_municipality_code
- outlet_region -> outlet_region_code
- transaction_type -> is_refund
- dom_int -> domestic_international
Breaking: Client Response
- Client info response now returns a list of objects with no hierarchy

May 10, 2022

Summary

The group by functionality enables custom responses and removes some endpoints. Before and After service now available together with the omni has been refactored. The anonymisation is now introduced, which mean if GDPR threshold is not fulfilled it will merge these in an "Other" category.

Changed

Breaking: Basic metrics only one endpoint with group by function implemented
Breaking: Change of endpoints: basicMetrics/hourly and basicMetricsDaily -> basicMetrics
Breaking: "Before And After" only one endpoint with group by function implemented
Breaking: Change of endpoints: beforeAndAfter/daily, beforeAndAfter/monthly and beforeAndAfter/weekly -> beforeAndAfter

Updated

New calculation for omni refund
Response changed in omni refund (year_month -> trx_year, trx_month)
New calculation for omni distribution
Response changed in omni distribution (year_month -> trx_year, trx_month)

Added

"Before And After" implemented
Added group by function for all endpoints
Added "others" for all response

March 24, 2022

Summary

Locality is the big focus in this release.

Changed

Breaking: Locality filter for benchmarking to only be 3 layers

Removed

Breaking: Remove MCC and zip code filters in benchmarking

Added

MCC filter to all endpoints except benchmarking
Omni distribution - using locality filter will only look at POS transactions

March 23, 2022

Summary

Initial release of Merchant Insights.

Added

Basic Metrics - Daily, Hourly
Omni - Distribution, Refunds
Consumer Segmentation - RFM
Benchmarking - Market Average, YoY
Mapping - World Countries, Geographical, MCC, Merchant Info