Fix for Incomplete Historical Data in Marketing Attribution

Released: May 27, 2025.

The Marketing Attribution explore currently returns data for only the most recent 30 days. Historical data outside this window is largely missing (NULL values), with only occasional records populated.

Implement logic to accurately associate orders with a rolling 30-day update list. Update the logic in both dm_stg.mkt_order_revenue_attribution and dm_mkt.fct_vendor_level_performance to support incremental updates, focusing only on the most recent 30-day period.

This will ensure consistent and complete attribution data going forward.