Market Insights

October 16, 2023

Summary

Removed merchant destination filter.

Removed

  • Breaking: merchant_destination filter removed.

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").

 

March 14, 2023

Summary

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

Docs

  • Add minimum and maximum in documentaion for filters e.g.

 

December 12, 2022

Summary

The documentation has been improved, new filters is added and some of the Index service filters has been renamed.

Changed

  • Improved documentation for better usability.
  • Improved 'Tutorials'

  • Breaking: Filters renamed

    • year_analysis -> analysis_year
    • year_baseline -> baseline_year
    • quarter_analysis -> analysis_quarter
    • quarter_baseline -> baseline_quarter
    • month_analysis -> analysis_month
    • month_baseline -> baseline_month
    • week_analysis -> analysis_week
    • week_baseline -> baseline_week

  • Response for Index renamed

Added

  • is_non_local as filter and group by option.
  • New Filters
    • Transaction_year
    • Transaction_quarter
    • Transaction_month
    • Transaction_week

 

June 16, 2022

Summary

A big renaming of filters, which mean you as a client need to check the naming, if using some of these.

Changed

  • Breaking: Filters naming changed (old -> new)
    • bus_pri -> business_private
    • dom_int -> domestic_international
    • card_country -> estimated_residence_country_a3
    • card_municipality -> estimated_residence_municipality_code
    • card_region -> estimated_residence_region_code
    • issuer_country -> issuer_country_a3
    • locality -> is_regional_local + is_municipality_local
    • merchant_country -> merchant_country_a3
    • week_option1 -> week_analysis
    • week_option2 -> week_baseline
    • month_option1 -> month_analysis
    • month_option2 -> month_baseline
    • quarter_option1 -> quarter_analysis
    • quarter_option2 -> quarter_baseline
    • year_option1 -> year_analysis
    • year_option2 -> year_baseline
    • ecom_pos -> online_physical
    • category -> category_code

 

March 8, 2022

Summary

A lot of big changes, because of the "group by" functionality has been introduced. Some endpoints are removed because the "group by" enables the functionality of creating custom responses.

Changed

  • Changed source of data extraction.
  • Breaking: Average spend response changed to: per_card_per_day
  • Breaking: Correlations merged two endpoints - now only one endpoint (baseurl/correlation), same info with all filters in one endpoint
  • Breaking: Change URL of "Turnover Share" endpoints: (old -> new)
    • turnoverShare/area -> turnoverShare/cardholder/municipality
    • turnoverShare/region -> turnoverShare/cardholder/region
    • turnoverShare/merchantRegion -> turnoverShare/merchant/region
    • turnoverShare/merchantArea -> turnoverShare/merchant/municipality
    • turnoverShare/nationality/issuerCountry -> turnoverShare/issuerCountry

Removed

  • Breaking: Removed area filtering (Merchant_Area, Card_Area).
  • Changed the order of date inputs for index endpoints to fit dashboard. - Now option1 must be bigger (or equal to depending on the case) than option2
  • Breaking: Geographical Development is removed - the same information can be provided by using the "Historical Comparison"
  • Breaking: Share of turnover - Removed 5 endpoints. Still possible to get the same information, due to change of structure in data.
    • Card area of residence share by vertical
    • Nationality share by area of merchant
    • Nationality share by category
    • Nationality share by region of merchant
    • Nationality share by vertical

Added

  • Added Municipality instead of Area filtering (Merchant_Municipality, Card_Municipality).
  • New filter -> merchant destination
  • Add group by functionality

 

March 8, 2022

Summary

Some big changes of responses and filters, which need action from client.

Changed

  • Breaking: Changed naming of some filters to make it more consistent
  • Breaking: Changed the response of "Historical Comparison"
  • Breaking: Changed response parameter from number_of_cardholders -> number_of_cards
  • Breaking: Mapping endpoint for "Category" returns MCC as well

Added

  • Endpoints added matching "Share of Turnover" in the dashboard

 

August 24, 2021

Summary

Small adjustments for better usability.

Added

  • Basic functionality implemented - ready for using

 

Wednesday, August 4, 2021

Summary

Initial release for Market Insights.

Added

  • Initial release of the solution