Choose a version:

chargebacks

The chargebacks schema captures disputed charges and how they compare to your successful transactions. Use it to report dispute volume, dollar amounts, rates, and the reason and resolution behind each dispute.

Anchor to Use casesUse cases

Dispute volume: Group chargebacks and fraudulent_chargebacks by month to see whether disputes are trending up and how many are fraud-related.
Dispute rate: Show chargeback_rate beside successful_transactions to show the transaction base behind the rate.
Reason breakdown: Break down chargeback_amount by chargeback_reason to see which dispute reasons cost you the most.
Rapid dispute resolution: Group by is_rapid_dispute_resolution to see what share of disputes were resolved early instead of becoming full chargebacks.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

FROM chargebacks

SHOW chargebacks, fraudulent_chargebacks, successful_transactions

WITH PERCENT_CHANGE

DURING last_month

COMPARE TO previous_period

Examples

Description
Summarize last month's disputes, how many were fraudulent, and the successful transactions in the same period. This example uses [`WITH PERCENT_CHANGE`](/docs/api/shopifyql/latest/syntax/with#percent-change-columns) and [`COMPARE TO previous_period`](/docs/api/shopifyql/latest/syntax/compare-to) to show how each figure moved from the month before.
ShopifyQL
```
FROM chargebacks
  SHOW chargebacks, fraudulent_chargebacks, successful_transactions
  WITH PERCENT_CHANGE
  DURING last_month
  COMPARE TO previous_period
```
Description
Compare monthly `chargeback_rate` this year against the same months last year. This example uses [`WITH PERCENT_CHANGE`](/docs/api/shopifyql/latest/syntax/with#percent-change-columns) to add the year-over-year change column, with [`COMPARE TO previous_year`](/docs/api/shopifyql/latest/syntax/compare-to) setting the comparison baseline.
ShopifyQL
```
FROM chargebacks
  SHOW chargebacks, fraudulent_chargebacks, successful_transactions,
    chargeback_rate, fraudulent_chargeback_rate
  TIMESERIES month WITH PERCENT_CHANGE
  DURING this_year
  COMPARE TO previous_year
  ORDER BY month ASC
VISUALIZE chargeback_rate TYPE horizontal_bar
```
Description
Rank chargeback reasons by dollar volume last quarter, split by rapid-dispute-resolution status. This example uses a [`GROUP_TOTALS`](/docs/api/shopifyql/latest/syntax/with#group-total-columns) subtotal per reason to show which dispute types cost the most.
ShopifyQL
```
FROM chargebacks
  SHOW chargebacks, chargeback_amount
  GROUP BY chargeback_reason, is_rapid_dispute_resolution WITH TOTALS,
    GROUP_TOTALS
  DURING last_quarter
  ORDER BY chargeback_amount DESC
  LIMIT 20
VISUALIZE chargebacks TYPE grouped_bar
```
Description
Chart weekly `chargebacks` by `chargeback_reason` over last quarter. This example uses [`TIMESERIES week`](/docs/api/shopifyql/latest/syntax/timeseries) with a [`stacked_bar`](/docs/api/shopifyql/latest/syntax/visualize) chart to show how each reason's share of disputes shifts week to week.
ShopifyQL
```
FROM chargebacks
  SHOW chargebacks, chargeback_amount
  GROUP BY chargeback_reason WITH TOTALS, GROUP_TOTALS
  TIMESERIES week
  DURING last_quarter
  ORDER BY week ASC
  LIMIT 20
VISUALIZE chargebacks TYPE stacked_bar
```

Anchor to MetricsMetrics

Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried.

Metrics you can use when querying FROM chargebacks.

Anchor to chargeback_amount chargeback_amount: The value of disputed charges across all chargeback reasons, reported in your store's currency.
Anchor to chargeback_rate chargeback_rate: Percentage of payments with disputed charges of any kind

Chargeback rate = chargebacks / successful transactions
Anchor to chargebacks chargebacks: Number of payments with disputed charges of any kind
Anchor to fraudulent_chargeback_rate fraudulent_chargeback_rate: Percentage of payments with disputed charges due to reported fraud

Fraudulent chargeback rate = fraudulent chargebacks / successful transactions
Anchor to fraudulent_chargebacks fraudulent_chargebacks: Number of payments with disputed charges due to reported fraud
Anchor to successful_transactions successful_transactions: Number of successful payment transactions

MONEY

A monetary amount representing currency values such as prices, revenue, costs, and discounts.

PERCENT

A percentage value represented as a decimal, where 0.25 represents 25%.

INTEGER

A whole number without decimal places, used for counts, quantities, and other discrete numeric values.

Anchor to DimensionsDimensions

Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns.

Dimensions you can use when querying FROM chargebacks.

Anchor to chargeback_reason chargeback_reason: The reported reason for the disputed charge. General is a catch-all for unspecified reasons, and Unrecognized means the customer doesn't recognize the charge on their statement. Other values include Fraudulent, Duplicate, and Product not received.
Anchor to day day: The day a disputed charge or successful payment transaction happened.
Anchor to day_of_week day_of_week: The day of the week a disputed charge or successful payment transaction happened, with values Monday through Sunday.
Anchor to hour hour: The hour a disputed charge or successful payment transaction happened.
Anchor to hour_of_day hour_of_day: The hour of day a disputed charge or successful payment transaction happened, with values 0 through 23.
Anchor to is_rapid_dispute_resolution is_rapid_dispute_resolution: Was the dispute resolved via Rapid Dispute Resolution service
Anchor to minute minute: The minute a disputed charge or successful payment transaction happened.
Anchor to month month: The month a disputed charge or successful payment transaction happened.
Anchor to month_of_year month_of_year: The month of the year a disputed charge or successful payment transaction happened, with values 1 through 12.
Anchor to quarter quarter: The quarter a disputed charge or successful payment transaction happened.
Anchor to second second: The second a disputed charge or successful payment transaction happened.
Anchor to shop_id shop_id: The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.
Anchor to week week: The week a disputed charge or successful payment transaction happened.
Anchor to week_of_year week_of_year: The week of the year a disputed charge or successful payment transaction happened, with values 1 through 53.
Anchor to year year: The year a disputed charge or successful payment transaction happened.
Anchor to shop_name shop_name: Name of your store

STRING

A sequence of characters representing text data.

DAY_TIMESTAMP

A date value truncated to day precision.

DAY_OF_WEEK

A day within a week, used for weekday-based grouping and filtering.

HOUR_TIMESTAMP

A timestamp truncated to hour precision.

HOUR_OF_DAY

An hour within a day, typically represented as an integer from 0 to 23.

BOOLEAN

A true or false value representing binary states.

MINUTE_TIMESTAMP

A timestamp truncated to minute precision.

MONTH_TIMESTAMP

A date value representing the start of a month.

MONTH_OF_YEAR

A month number within a year.

QUARTER_TIMESTAMP

A date value representing the start of a fiscal quarter.

SECOND_TIMESTAMP

A timestamp truncated to second precision.

IDENTITY

A unique identifier for a Shopify resource such as a customer, product, or order.

WEEK_TIMESTAMP

A date value representing the start of a week.

WEEK_OF_YEAR

A week number within a year.

YEAR_TIMESTAMP

A date value representing the start of a year.

Anchor to Related schemasRelated schemas

payments: Transaction data upstream of these disputes.
payment_attempts: Authorization data when you want to compare attempt-time signals with dispute outcomes.

Was this page helpful?