The Refunds table records individual refund transactions with product-level detail. One row per refund transaction. Tied to original orders by order ID.

📋
Table Guide
What You Can Answer With This Table

Which products are being refunded most often, and for how much? — group by products_info.product_name or products_info.product_id with total_refunded_price

What is the COGS impact of refunds? — use total_refunded_cogs

Before You Query

Required field: event_date

event_date refers to the date the refund was processed, not the original order date. To filter by when the order was placed, use order_date.

Key Relationships

Table Join Key Use This Join To
Orders order_id Measure refund impact by original order revenue, customer, products, or fulfillment

When to Use a Different Table

Use Orders table when you need order-level revenue net of refunds for total revenue or profit calculations. The Refunds table is for refund transactions and refund-date analysis.

Use Pixel Joined table when you need refund impact by attributed channel, campaign, ad set, or ad. The Refunds table is for refund records, not attribution-level performance.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Orders	`order_id`	Measure refund impact by original order revenue, customer, products, or fulfillment

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Hour	`event_hour`	string	The hour of the day the refund was processed, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: `07`, `16`, `21`
Event Date	`event_date`	date	The date the refund was processed. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day on which the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Order Date	`order_date`	date	The date the original order was processed. Example value: `2025-02-12`
Order ID	`order_id`	string	The unique ID for the original order that was issued a refund. Assigned by the shop platform. Example value: `6024492815432`
Sales Platform	`platform`	string	The sales platform where the order was processed. Example values: `Shopify`, `BigCommerce`, `WooCommerce`, `Amazon`
Products	`products_info`	record repeated	Details about the products associated with the order (at the level of the variant), including name, product ID, variant ID, type, SKU, etc. Returns the latest product information, not necessarily the data at the time the order was placed.
Product ID	`products_info.product_id`	string	The unique ID of the product as set within the main sales platform. Example value: `3891505496131`
Product Name	`products_info.product_name`	string	The name of the product as set within the main sales platform. Example values: `Green Soft Socks 3-Pack`, `Paring Knife Travel Case`, `Gift Subscription`
Product SKU	`products_info.product_sku`	string	The SKU (Stock Keeping Unit) for the product, as set within the main sales platform. Example values: `GP-BACK-02`, `A02630`, `POP200NAVY`
Product Variant ID	`products_info.variant_id`	string	The unique identifier for a specific variant of a product as set within the main sales platform. Example value: `29275946877001`
Is Gift Card	`products_info.is_gift_card`	boolean	True if the product purchased is a gift card. Possible values: `true`, `false`
Product Properties	`products_info.properties`	record repeated
Product Property Name	`products_info.properties.name`	string	The name or key of the product property.
Product Property Value	`products_info.properties.value`	string	The value assigned to the product property.
Product Duties	`products_info.duties`	record repeated	Import duties or tariffs applied to the product.
Product Duty ID	`products_info.duties.duty_id`	string	The unique identifier of the duty applied to the product.
Product Duty Amount	`products_info.duties.price`	numeric	The monetary amount of duty charged for the product.'
Product Duty Tax Lines	`products_info.duties.tax_lines`	record repeated	Tax lines charged on the product duty.
Product Duty Tax Line Amount	`products_info.duties.tax_lines.price`	numeric	The tax amount charged on the product duty per tax line.
Product Price	`products_info.product_name_price`	numeric	The price of a single product (to the buyer), before discounts. By default shown in the shop's currency. Note: Tax will be included in the product price if the seller has configured the sale to require taxes in the main sales platform.
Total Product Discount	`products_info.discount_amount_for_product`	numeric	The amount discounted from the product price, before taxes. By default shown in the shop's currency.
Product Units Sold	`products_info.product_name_quantity_sold`	numeric	The total number of individual units sold for the product.
Product Cost	`products_info.single_product_cost`	numeric	The cost of a single product (to the seller). By default shown in the shop's currency.
Refund Order Adjustments	`refund_order_adjustment`	record repeated	List of refund order adjustments applied to the order. There may be multiple adjustments per order.
Order Adjustment Type	`refund_order_adjustment.kind`	string	The order adjustment type. Valid values: `shipping_refund`: Refunds related to shipping charges. `refund_discrepancy`: Discrepancies in the refund amount.
Order Adjustment Tax Amount	`refund_order_adjustment.order_adjustment_tax_amount`	numeric	The taxes that are added to the order adjustment amount, such as applicable shipping taxes added to a shipping refund.
Order Adjustment Amount	`refund_order_adjustment.order_adjustment_amount`	numeric	The value of the discrepancy between the calculated refund and the actual refund. If the `kind` property's value is `shipping_refund`, then `amount` returns the value of shipping charges refunded to the customer.
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
Source	`source_name`	string	The origin of the order as designated by the seller on the main sales platform. Example values: `web`, `pos`, `tiktok`
Tags	`tags`	repeated string	Tags associated with the order, assigned by the seller on the main sales platform. Example values: `Upsell`, `Order Credits`, `discount_eligible`
Updated At	`updated_at`	timestamp	The time at which the refund record was last updated. Formatted according to the ISO 8601 international standard. Example value: `2022-06-15T19:26:30.000Z`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Refunded COGS	`total_refunded_cogs`	numeric	Refunded cost of goods (COGS) amount for the selected time period. Calculated based on the refund date.
Refunded Sales	`total_refunded_price`	numeric	Refunded sales amount for the selected time period. Calculated based on the refund date. Note that Triple Whale does not track refunds from third-party return management apps (e.g., Loop), so totals may vary from the sales platform.
Refunded Shipping	`total_refunded_shipping`	numeric	Refunded shipping amount for the selected time period. Calculated based on the refund date.
Refunded Tax	`total_refunded_tax`	numeric	Refunded tax amount for the selected time period. Calculated based on the refund date.