Get Return Journeys

How customers come back for their SECOND purchase. For every customer (cross-platform identity, customer_email of the store orders in analytics.fct_transactions: VTEX, Shopify, Tray, WooCommerce and Nuvemshop; won CRM deals and Mercos orders are left out) whose second purchase falls in the period, the second purchase is the first order on a later day than the first purchase (the first purchase may predate the period; an order split on the day of the first purchase is not a return). Second purchases are grouped by the channel, the coupon and the main product of that return order, and the five largest groups by customers are returned. Channel is the order's last-click channel from analytics.fct_order_acquisition_channel (an order the fact does not resolve reads Sem atribuição with isUnattributed: true, as in return-channels); coupon is the code typed on the order, from analytics.fct_order_coupons, normalized like the coupons endpoint (null without a coupon); main product is the product with the largest net sales in the order (analytics.fct_order_sku_sales), named and pictured from analytics.dim_product_catalog. medianDaysToReturn is the median of the days between the first and the second purchase; revenue is the official revenue (SUM(revenue)) of the second purchase only; totalCustomers and totalRevenue cover every second purchase of the period, and customerShare is over totalCustomers. Aggregates only: no customer identifier or personal data is returned. Both dates are required (UTC); the period spans at most 366 days.