Overview
Issue:
Within the Order Attribution data model, second order attribution fields (such as second order date, second order revenue, and related attribution dimensions) were incorrectly displaying data from the customer's most recent order instead of their actual second purchase. This affected repurchase rate calculations and customer segmentation analyses that relied on second order behavior. The issue was limited to the Order Attribution model — customer profile data was not affected.Solution:
We corrected the underlying logic to accurately pull each customer's second chronological order for attribution. The fix has been deployed and validated across both Snowflake and BigQuery environments. Merchants using the Order Attribution data model should review the following areas for expected shifts in data:- Second Order Attribution fields (discount codes, click channels, marketing sources, survey responses) in any of the impacted explores listed below
- Repurchase rate calculations and time-to-second-purchase analyses
- Customer segmentation reports built on second order behavior
Impacted Explores:
Transactional Sales Report, Product Affinity, Order & Order Line Revenue, LTV Time Series, Lifetime Value First Order SKU, Dynamic LTV, Customer Flags & InfoNot affected:
Customer profile data, first order fields, last order fields, and overall customer metrics. Merchants without the Order Attribution data model are not impacted.
