Skip to main content

Refunds

Description:
The refunds to credit or debit cards issued by a business

See the Merchant Transaction Signals overview page for details about data sources, high-level methodology, and timeliness of this attribute.

Child attributes (and data file structure):

Attribute NameData TypeDescriptionExample
end_datestringThe time index of the features. All features in the row assume this is the final date, inclusive, of the calculation.2020-08-31
refunds_*1m*_start_datestringThe date that the 1-month period begins, inclusive2020-08-01
refunds_*1m*_amountfloatThe total dollar amount of card refunds issued directly from the business in the 1-month period, null if the business had fewer than 30 transactions during that period-180.17
refunds_*1m*_average_transaction_sizefloatThe average size in dollars of a card refund issued directly from the business in the 1-month period, null if the business had fewer than 30 transactions during that period-90.08
refunds_*1m*_revenue_ratiofloatThe ratio of the business's dollar amount of card refunds to the business's card revenue in the 1-month period, null if the business had fewer than 30 transactions during that period.0.0006
refunds_*1m*_revenue_ratio_growth_rate (deprecated, to be removed on 7/31/24)floatThe change in the business's refund-to-revenue ratio in the 1-month period, null if the business had fewer than 30 transactions during that period (new - old / old).null
refunds_*3m*_start_datestringThe date that the 3-month period begins, inclusive.2020-06-01
refunds_*3m*_amountfloatThe total dollar amount of card refunds issued directly from the business in the 3-month period, null if the business had fewer than 30 transactions during that period.-208.89
refunds_*3m*_average_transaction_sizefloatThe average size in dollars of a card refund issued directly from the business in the 3-month period, null if the business had fewer than 30 transactions during that period.-52.22
refunds_*3m*_revenue_ratiofloatThe ratio of the business's dollar amount of card refunds to the business's card revenue in the 3-month period, null if the business had fewer than 30 transactions during that period.0.0004
refunds_*3m*_revenue_ratio_growth_ratefloatThe change in the business's refund-to-revenue ratio in the 3-month period, null if the business had fewer than 30 transactions during that period (new - old / old).9.558
refunds_*12m*_start_datestringThe date that the 12-month period begins, inclusive.2019-09-01
refunds_*12m*_amountfloatThe total dollar amount of card refunds issued directly from the business in the 12-month period, null if the business had fewer than 30 transactions during that period.-783.75
refunds_*12m*_average_transaction_sizefloatThe average size in dollars of a card refund issued directly from the business in the 12-month period, null if the business had fewer than 30 transactions during that period.-130.62
refunds_*12m*_revenue_ratiofloatThe ratio of the business's dollar amount of card refunds to the business's card revenue in the 12-month period, null if the business had fewer than 30 transactions during that period.0.0007
refunds_*12m*_revenue_ratio_growth_ratefloatThe change in the business's refund to revenue ratio in the 12-month period, null if the business had fewer than 30 transactions during that period (new - old / old).-0.257

JSON Sample:

{/* /* /* /* /* /* /* "refunds": [
    {
            "end_date": "2020-08-31"
        "1m": {
                "average_transaction_size": null,
            "average_ratio": 0.0,
            "revenue_ratio_growth_rate": null,
            "start_date": "2020-08-01",
            "amount": 0.0 */ */ */ */ */ */ */},
        "3m": {"average_transaction_size": -23.35,
            "average_ratio": 0.0,
            "revenue_ratio_growth_rate": -0.95,
            "start_date": "2020-06-01",
            "amount": -70.04},
        "12m": {"average_transaction_size": -198.88,
            "average_ratio": 0.0,
            "revenue_ratio_growth_rate": 18.12,
            "start_date": "2019-09-01",
            "amount": -1591.05}
    }
  ]
}

NOTE:

  • Therefunds_*1m*_revenue_ratio_growth_rate field is deprecated. It will always return null.
  • refunds_*3m*_revenue_ratio_growth_rate_sa is not in current API returns.

Other notes and tips:
Enigma uses negative signs in average_transaction_size and amount to indicate the dollar amount is a loss for the business.

If a business issued two refunds in a month, one for $8, the other for $4:

  • The 1m_amount is -12 = (-8+-4)
  • The 1m__average_transaction_size is -6 = (-8 + -4) / 2

The refunds__revenue*ratio = abs(refunds*_amounts) / total card revenue. The card revenue is referring to the card*revenue*_average_monthly_amount attribute. Note that total card revenue here already contains refunds. Therefore, sometimes the revenue_ratio can be >100%

For example: if a business had $8 income and $7 refunds (i.e., refunds amounts is -7) in a month, the card*revenue**1m*_average_monthly_amount would be $1=$8-$7, and the ratio would be 7 = $7/$1

refunds__revenue_ratio doesn't have negative value

The 3m_revenue_ratio_growth*rate compares the refunds**3m*_revenue_ratio of two adjacent 3-month periods

  • Assuming refunds_*3m*_revenue*ratio of 2019-11-01 to 2020-01-31 is 0.8, refunds**3m*_revenue_ratio of 2020-02-01 to 2020-04-30 is 0.5, 3m_rate value of the period ending at 2020-04-30 is -0.375=(0.5-0.8) / 0.8
  • Negative 3m_revenue_ratio_growth_rate means a business has a declining ratio of refunds, which could be a positive signal for financial health
Last updated on