Merchant Aggregates
GET
/consumer-spending/eu/v1/merchant-aggregates
Aggregated European consumer spending data powered by Fable Data. Track daily credit card, debit card, and open banking transaction totals for ~250 US public companies across 6 European countries (UK, Germany, France, Italy, Spain, Austria). Data available from 2016; Spain from 2019.
Raw spend totals must be normalized to accurately measure spending trends. See Normalizing Merchant Aggregates for methodology.
Use Cases: Consumer spending trend analysis, merchant revenue estimation, cross-border spending comparisons, sector and industry benchmarking.
Plan Accessloading..
Plan Recencyloading..
Plan Historyloading..
Query Parameters
transaction_date
string
The calendar date when the consumer transactions occurred. Value must be formatted 'yyyy-mm-dd'.
name
string
The merchant or entity name for this aggregate (lowercase). When type is 'merchant', this value can be used as the lookup_name in the merchant-hierarchy endpoint to retrieve full corporate hierarchy details.
user_country
enum (string)
Country of consumer's residence (ISO codes). Available countries: UK, DE, FR, ES, IT, AT. Values outside these are mapped to 'unknown'.
channel
enum (string)
Transaction channel. Possible values: online, offline, bnpl (buy now pay later platforms such as Scala, Klarna, Zilch).
consumer_type
enum (string)
The panel the account is sourced from. Possible values: consumer_credit, consumer_debit, open_banking.
parent_name
string
Merchant's parent business name (Title Case). Useful for aggregating transactions across subsidiary brands. Also available in the merchant-hierarchy endpoint for full corporate structure.
limit
integer
Limit the maximum number of results returned. Defaults to '100' if not specified. The maximum allowed limit is '5000'.
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 'transaction_date' if not specified. The sort order defaults to 'desc' 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.
channel
string
optional
Transaction channel. Possible values: online, offline, bnpl (buy now pay later platforms such as Scala, Klarna, Zilch).
consumer_type
string
optional
The panel the account is sourced from. Possible values: consumer_credit, consumer_debit, open_banking.
eight_day_rolling_category_accounts
integer
optional
The count of unique consumer accounts active for a given country, consumer type, and that transacted in this merchant category (MCC Group) over the prior 8 days. Used for short-term normalization calculations (e.g., spend per 1000 panelists = (total_spend / eight_day_rolling_category_accounts) * 1000).
eight_day_rolling_total_accounts
integer
optional
The count of unique consumer accounts active for a given country and consumer type that had any transaction activity (across all categories) over the prior 8 days. Provides a baseline for total panel size.
mcc_group
string
optional
Merchant category code group associated with the merchant or payment processor.
merchant_industry
string
optional
Industry name based on GICS/BICS/ICB data classification for the merchant.
merchant_ticker
string
optional
Stock ticker associated with the merchant (~250 US public companies mapped). Uses Bloomberg tickers and they are point in time.
name
string
optional
The merchant or entity name for this aggregate (lowercase). When type is 'merchant', this value can be used as the lookup_name in the merchant-hierarchy endpoint to retrieve full corporate hierarchy details.
parent_name
string
optional
Merchant's parent business name (Title Case). Useful for aggregating transactions across subsidiary brands. Also available in the merchant-hierarchy endpoint for full corporate structure.
published_date
string
optional
The date when this data version was published. For original data, this is approximately 7 days after transaction_date.
spend_in_distinct_account_key_count
integer
optional
The count of distinct account keys (unique consumer accounts) with inbound transactions.
spend_in_spend
number
optional
The total inbound transaction amount (refunds, returns, credits) in the specified currency for this aggregation. Values are positive, representing money flowing back into consumer accounts.
spend_in_transaction_count
integer
optional
The count of inbound transactions (refunds, returns).
spend_out_distinct_account_key_count
integer
optional
The count of distinct account keys (unique consumer accounts) with outbound transactions.
spend_out_spend
number
optional
The total outbound transaction amount (money spent by consumers) in the specified currency for this aggregation. Values are negative, representing money flowing out of consumer accounts.
spend_out_transaction_count
integer
optional
The count of outbound transactions (purchases, payments).
total_accounts
integer
optional
The total count of distinct consumer accounts with any transaction activity for this aggregation.
total_spend
number
optional
Sum of spend_out_spend and spend_in_spend. Typically negative (net outflow). A positive value indicates refunds exceeded new spending for this aggregation.
total_transactions
integer
optional
The total count of all transactions (outbound + inbound).
transaction_currency
string
optional
ISO currency code for the transaction (base card/account currency). Always EUR or GBP in this dataset. All spend amounts are denominated in this currency.
transaction_date
string
optional
The calendar date when the consumer transactions occurred.
twenty_eight_day_rolling_category_accounts
integer
optional
The count of unique consumer accounts active for a given country, consumer type, and that transacted in this merchant category (MCC Group) over the prior 28 days. Used for longer-term normalization calculations.
twenty_eight_day_rolling_total_accounts
integer
optional
The count of unique consumer accounts active for a given country and consumer type that had any transaction activity (across all categories) over the prior 28 days. Provides a longer-term baseline for total panel size.
type
string
optional
The type of aggregation. Can be 'merchant' or 'payment_processor'.
user_country
string
Country of consumer's residence (ISO codes). Available countries: UK, DE, FR, ES, IT, AT. Values outside these are mapped to 'unknown'.
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