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.

ID	Type	Description
event_date	date	The date of the refund. Based on the time zone of the shop at the moment of refund.
event_date.day	date	The day the refund was issued. Derived from event_date.
event_date.week	date	The Sunday of the week during which the refund was issued. Derived from event_date.
event_date.month	date	The month during which the refund was issued. Derived from event_date.
event_date.quarter	date	The first month of the quarter during which the refund was issued. Derived from event_date.
event_date.year	date	The year during which the refund was issued. Derived from event_date.
event_hour	string	The hour of the day the refund was issued, 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
platform	string	The sales platform where the refunded order was processed. Example value: shopify
order_id	string	The unique ID for the original order that was issued a refund. Assigned by the shop platform. Example value: 6024492815432
order_date	date	The date the original order was processed. Based on the time zone of the shop at the moment of purchase.
products_info	record	Information about the product(s) associated with the order. There may be multiple products per order.
products_info.product_id	string	The unique ID of the product in the shop (not order-specific). Assigned by the shop platform. Example value: 3891505496131
products_info.product_name	string	Name of the product in the original order. Example value: all black 3-pack
products_info.product_sku	string	Stock keeping unit of the product in the original order. Example value ALLBLACK3PACKXS
products_info.variant_id	string	The unique ID of the product variant in the shop (not order-specific). Assigned by the shop. Example value: 29275946877001
products_info.is_gift_card	boolean	True if the product purchased in the original order is a gift card.
products_info.product_name_price	numeric	The product's price (before discounts) in the original order. 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 Triple Whale Admin.
products_info.discount_amount_for_product	numeric	The amount discounted from the product price in the original order. By default shown in the shop's currency.
products_info.product_name_quantity_sold	numeric	The quantity of the product sold in the original order.
products_info.single_product_cost	numeric	The cost of goods for the product in the original order. By default shown in the shop's currency. - For Shopify, the single product cost is set in the store and imported directly, or configured in Triple Whale admin under the costs settings tab.
refund_line_item	record	Information about the refund(s) issued. There may be multiple refunds per order.
refund_line_item.refund_line_item_id	string	The unique ID for the refunded line item. Assigned by the shop platform. Example value: 558610612293
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
refund_line_item.gift_card	boolean	True if the line item refunded is a gift card.
refund_line_item.product_id	string	The unique ID of the product in the shop (not order-specific). Assigned by the shop platform. Example value: 3891505496131
refund_line_item.variant_id	string	The unique ID of the product variant in the shop (not order-specific). Assigned by the shop platform. Example value: 29275946877001
refund_line_item.taxes_included	boolean	True if taxes are included in the refunded line item.
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.quantity	numeric	The quantity of the line item that was refunded.
refund_line_item.total_discount	numeric	The total discount amount applied to the refunded line item.
refund_line_item.subtotal	numeric	The subtotal of the refunded line item before taxes and discounts.
refund_line_item.pre_tax_price	numeric	The price of the refunded line item after discounts but before taxes.
refund_line_item.total_tax	numeric	The total tax amount for the refunded line item.
refund_line_item.price	numeric	The price of the refunded line item, after taxes and discounts.
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. 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_adjustment	record	List of order adjustments applied to the refund. There may be multiple adjustments per order.
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.
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.
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.
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.

Name	Type	Description
total_refunded_price	numeric	Total amount refunded, not including cost of goods, tax, and shipping.
total_refunded_cogs	numeric	Total cost of goods refunded.
total_refunded_tax	numeric	Total amount of tax refunded.
total_refunded_shipping	numeric	Total amount of shipping charges refunded.