Connect Loop Returns to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Have multiple Loop Returns accounts? Analytics across multiple Loop Returns accounts →
Everything Loop Returns exposes, modeled and queryable.
Provides access to Loop Returns data about e-commerce returns and exchanges. Includes return records with timestamps, order and customer identifiers, currency and financial totals (product, discount, tax, refund, credit), line items with SKUs and return reasons, exchange details, and logistics fields like carrier, tracking number, and label status. Enables analysis of return volumes and trends, reasons for return, refund versus exchange value, product performance, and shipping/label operations.
Tables & streams
Represents individual return records with timestamps, order/customer identifiers, status, and financial totals (product, discount, tax, refund, credit). Supports analysis of return volumes and trends, refund liability, cycle time, and return rates.
Item-level details within a return, including SKUs, quantities, and reason codes. Enables product-level return rates, reason distribution, and identification of high-return items.
Information on exchanges associated with returns, including exchanged items and credited values. Enables measurement of refund vs. exchange mix, retained revenue, and exchange outcomes.
Logistics and labeling details such as carrier, tracking number, and label status. Supports operational KPIs like label utilization, processing timelines, and carrier performance.
Product dimension referenced via SKUs on return line items. Enables analysis of SKU-level performance, return propensity, and product quality or fit issues.
Customers associated with returns via customer identifiers. Supports customer-level analyses such as return propensity, repeat returners, and impact on retention.
Uses an API key from your Loop Returns admin dashboard to authenticate (sent in the X-Authorization header)
Requires a Loop Returns account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate Loop Returns in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Loop Returns data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
