Average Spend

Try It

Version: 1.0.0

Contact information:
API Support
datasuite@nexigroup.com

/averageSpend

GET

Summary

Average Spend

Description

The average spend per transaction per card per day for international transactions only, where the transactions are physical rather than online. The summed card turnover, average number of cards and average duration of stay are obtained and calculated based on these values.The duration of stay is calculated by finding the days between the first and last transaction of a single card in a 30 day period. For more information, refer to the documentation.

Parameters
Name Located in Description Required Schema
business_private query Filter transactions by business (0 = business) and private (1 = private). No integer
category_code query Filter by a category code To get all supported category codes, use MCC mapping endpoint under the Mapping tag. Example : 14 No [ integer ]
currency query Set ISO-4217 currency code. Default currency code = EUR). Example: DKK No string
domestic_international query Filter cardholder transactions by domestic (0 = domestic) or international (1 = international). No integer
estimated_residence_country_a3 query Filter by cardholder ISO-A3 country code. Example: DNK No [ string ]
estimated_residence_municipality_code query Filter by customer municipality code. Example: 43 No [ integer ]
estimated_residence_region_code query Filter by cardholder region. Example: 3 No [ integer ]
group_by query Group output by one or more of the following values. Possible values: transaction_year, transaction_quarter, transaction_month, transaction_week, merchant_country, merchant_region, merchant_municipality, vertical, category, issuer_country, business_private. No [ string ]
is_municipality_local query Filter transactions by the cardholder estimated residence being either in the merchant municipality (1) or outside the merchant municipality (0). No integer
is_non_local query Filter transactions by cardholder estimated residence region not in merchant region (1) or cardholder estimated residence region in merchant region (0). No integer
is_regional_local query Filter transactions by cardholder estimated residence region not in merchant region (0) or cardholder estimated residence region in merchant region (1). No integer
issuer_country_a3 query Filter by issuer ISO-A3 country code. Example: DNK No [ string ]
merchant_country_a3 query Filter by a merchant ISO-A3 country code No [ string ]
merchant_municipality_code query Filter by a merchant municipality code To get all supported municipality codes, use Geographical mapping endpoint under the Mapping tag. No [ integer ]
merchant_region_code query Filter by a merchant region code To get all supported region codes, use Geographical mapping endpoint under the Mapping tag. No [ integer ]
month_range_end query End month in a range of months. Example: 10 No integer
month_range_start query Initial month in a range of months Example: 5 No integer
online_physical query Filter transactions by online (0 = e-commerce) and physical store (1 = POS). No integer
quarter_range_end query End quarter in a range of quarters. Example: 3 No integer
quarter_range_start query Initial quarter in a range of quarters Example: 1 No integer
transaction_month query Filter transactions by months(s). Example: 5 No [ integer ]
transaction_quarter query Filter transactions by quarter(s). Example: 1 No [ integer ]
transaction_week query Filter transactions by week(s). Example: 20 No [ integer ]
transaction_year query Filter transactions by year(s). No [ integer ]
vertical query Filter by a vertical To get all supported verticals, use MCC mapping endpoint under the Mapping tag. Example : Transportation No [ string ]
week_number_range_end query End week in a range of weeks. Example: 52 No integer
week_number_range_start query Initial week in a range of weeks Example: 5 No integer
year_range_end query End year in a range of years. Minimum value: Four years earlier than current year Maximum value: Current Year No integer
year_range_start query Initial year in a range of years Minimum value: Four years earlier than current year Maximum value: Current Year No integer
Ocp-Apim-Subscription-Key header Yes string
Responses
Code Description
200 OK
400 Input error

Models

AverageSpendGroupBy

Name Type Description Required
AverageSpendGroupBy string

AverageSpendResponse

Name Type Description Required
values [ object ] No

ValuesAverageSpend

Name Type Description Required
transaction_year integer No
transaction_quarter integer No
transaction_month integer No
transaction_week integer No
merchant_country_a3 string No
merchant_region string No
merchant_municipality string No
vertical string No
category string No
issuer_country_a3 string No
domestic_international string No
business_private string No
online_physical string No
is_non_local string No
is_regional_local string No
is_municipality_local string No
estimated_residence_country_a3 string No
estimated_residence_region string No
estimated_residence_municipality string No
per_transaction number No
per_card number No
per_card_per_day number No