Merchant Hierarchy
GET
/consumer-spending/eu/v1/merchant-hierarchy
Reference data mapping merchants to parent companies, tickers, sectors, and industries across Fable's European consumer transaction panel. Each row represents a single merchant with its corporate hierarchy and classification metadata. The latest weekly snapshot contains ~3,500 merchants covering ~250 US public companies.
Use lookup_name to join with the name field from the Merchant Aggregates endpoint. Filter by active_from and active_to to perform point-in-time joins against a specific transaction_date (e.g., active_from.lte=2025-06-15&active_to.gte=2025-06-15). An active_from of 0001-01-01 indicates no known start date, and an active_to of 9999-12-31 indicates the mapping is currently active.
Use Cases: Merchant-to-ticker mapping, corporate hierarchy lookups, sector and industry classification, point-in-time historical hierarchy analysis.
Plan Accessloading..
Plan Recencyloading..
Plan Historyloading..
Query Parameters
lookup_name
string
Lowercase merchant tag used for joining with the merchant-aggregates endpoint name field (e.g., 'asda', 'amazon').
ticker
string
Stock ticker associated with the merchant (~250 US public companies mapped). Uses Bloomberg standard.
listing_status
enum (string)
Whether the merchant is a publicly listed company or private. Possible values: public, private.
active_from
string
Date this merchant hierarchy mapping became applicable. A value of 0001-01-01 indicates no known start date. Use with active_to to match against transaction_date from the merchant-aggregates endpoint to perform point-in-time queries. Value must be formatted 'yyyy-mm-dd'.
active_to
string
Date after which this merchant hierarchy mapping is no longer applicable due to a corporate action. A value of 9999-12-31 indicates the mapping is currently active. Value must be formatted 'yyyy-mm-dd'.
limit
integer
Limit the maximum number of results returned. Defaults to '100' if not specified. The maximum allowed limit is '50000'.
sort
string
A comma separated list of sort columns. For each column, append '.asc' or '.desc' to specify the sort direction. The sort column defaults to 'lookup_name' if not specified. The sort order defaults to 'asc' if not specified.
Response Attributes
next_url
string
optional
If present, this value can be used to fetch the next page.
request_id
string
A request id assigned by the server.
results
array (object)
The results for this request.
active_from
string
optional
Date this merchant hierarchy mapping became applicable. A value of 0001-01-01 indicates no known start date. Use with active_to to match against transaction_date from the merchant-aggregates endpoint to perform point-in-time queries.
active_to
string
optional
Date after which this merchant hierarchy mapping is no longer applicable due to a corporate action. A value of 9999-12-31 indicates the mapping is currently active.
category
string
optional
Merchant category assigned by the data provider (Title Case, e.g., 'Groceries', 'General Merchandise', 'Travel'). Values are managed by the data provider and may expand over time.
grandparent_name
string
optional
Merchant's grandparent business name (Title Case).
grandparent_ticker
string
optional
Stock ticker of the merchant's grandparent company. Uses Bloomberg standard.
great_grandparent_name
string
optional
Merchant's great-grandparent business name (Title Case, top-level corporate entity).
great_grandparent_ticker
string
optional
Stock ticker of the merchant's great-grandparent company (top-level corporate entity). Uses Bloomberg standard.
industry
string
optional
Industry classification based on GICS/BICS/ICB standards.
industry_group
string
optional
Industry group classification based on GICS/BICS/ICB standards.
listing_status
string
Whether the merchant is a publicly listed company or private. Possible values: public, private.
lookup_name
string
optional
Lowercase merchant tag used for joining with the merchant-aggregates endpoint name field (e.g., 'asda', 'amazon').
normalized_name
string
optional
Cleaned, standardized merchant display name (Title Case, e.g., 'Asda', 'Amazon').
parent_name
string
optional
Merchant's parent business name (Title Case). Useful for aggregating transactions across subsidiary brands.
parent_ticker
string
optional
Stock ticker of the merchant's parent company. Uses Bloomberg standard.
sector
string
optional
Sector classification based on GICS/BICS/ICB standards.
sub_industry
string
optional
Sub-industry classification based on GICS/BICS/ICB standards.
ticker
string
optional
Stock ticker associated with the merchant (~250 US public companies mapped). Uses Bloomberg standard.
status
enum (OK)
The status of this request's response.
Code Examples
Query URL
GET
loading...Run query unavailable
Create account or sign in to Massive
Scroll to see updated query response
Response Object