Refunds Table

The Refunds table captures detailed information on each refund transaction, encompassing event dates, the original order details, product information, and refund specifics. By querying this table, you can analyze refund patterns, understand the impact of refunds on inventory, and evaluate the reasons behind product returns or order cancellations.

📘

Note

event_date is a required field for queries on this table, and refers to the date of the refund.

Dimensions

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

Title	ID	Type	Description
Event Date	event_date	date	The date the refund was processed. Based on the time zone of the shop at the moment of refund.
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.
Event Hour	event_hour	string	The hour of the day the refund was processed, according to a 24-hour clock. Based on the time zone of the shop at the time the refund was issued. Example values: 07, 16, 21
Order Date	order_date	date	The date the original order was processed. Based on the time zone of the shop at the moment of purchase.
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.
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 Type	products_info.product_type	string	The product type as set within the main sales platform. Example values: Jackets, Coffee Mugs, Books
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 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.
Product Discount	products_info.discount_amount_for_product	numeric	The amount discounted from the product price. 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 Line Item	refund_line_item	record repeated	Information about the refund(s) issued. There may be multiple refunds per order.
Refund Line Item ID	refund_line_item.refund_line_item_id	string	The unique ID for the refunded line item. Assigned by the shop platform. Example value: 558610612293
Order Line Item ID	refund_line_item.line_item_id	string	The unique ID for the line item in the original order, that is associated with the refunded line item. Assigned by the shop platform. Example value: 14883345367111
Is Gift Card	refund_line_item.gift_card	boolean	True if the line item refunded is a gift card.
Product ID	refund_line_item.product_id	string	The unique ID of the product as set within the main sales platform. Example value: 3891505496131
Variant ID	refund_line_item.variant_id	string	The unique identifier for a specific variant of a product as set within the main sales platform. Example value: 29275946877001
Is Tax-Inclusive	refund_line_item.taxes_included	boolean	True if taxes are included in the refunded line item.
Restock Type	refund_line_item.restock_type	string	How the refund line item affects inventory. Valid values: no_restock: Not restocked. cancel: Canceled and possibly restocked if unfulfilled. return: Returned and restocked if fulfilled. legacy_restock: Deprecated. Used for general restocking.
Refund Line Item Product Quantity	refund_line_item.quantity	numeric	The quantity of products in the refunded line item.
Refund Line Item Discount Amount	refund_line_item.total_discount	numeric	The total discount amount applied to the refunded line item.
Refund Line Item Subtotal	refund_line_item.subtotal	numeric	The subtotal of the refunded line item before taxes and discounts.
Refund Line Item Pre-Tax Price	refund_line_item.pre_tax_price	numeric	The price of the refunded line item after discounts but before taxes.
Refund Line Item Tax Amount	refund_line_item.total_tax	numeric	The total tax amount for the refunded line item.
Refund Line Item Price	refund_line_item.price	numeric	The price of the refunded line item, after taxes and discounts.
Refund Line Item Single Product Cost	refund_line_item.refunded_cogs_per_item	numeric	Cost of goods refunded per item. If refund_line_item.restock_type is no_restock, the cost is 0.
Refund Line Item Cost	refund_line_item. refunded_cogs_per_line_item	numeric	Cost of goods refunded for the entire line item (which may contain multiple units). If refund_line_item.restock_type is no_restock, the cost is 0.
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.
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	Total cost of goods refunded.
Refunded Price	total_refunded_price	numeric	Refund value processed during the selected time period, based on the refund date (not including refunded cost of goods, taxes, and shipping). Note that Triple Whale does not track refunds from third-party return management apps (e.g., Loop), so totals may vary from the main sales platform.
Refunded Shipping	total_refunded_shipping	numeric	Total amount of shipping charges refunded.
Refunded Tax	total_refunded_tax	numeric	Total amount of tax refunded.