Overview
We optimized how Vendor Performance data is processed daily. The table was previously being dropped and fully rebuilt every day, which was inefficient and created unnecessary strain on the data pipeline. We've replaced this with a 90-day incremental lookback window, so each daily refresh only reprocesses the last 90 days of data rather than rebuilding from scratch.
What we changed
Full daily rebuild replaced with 90-day incremental refresh. Instead of dropping and recreating the entire Vendor Performance table each day, the system now incrementally updates the last 90 days of data. The 90-day window aligns with the maximum attribution window supported by major ad platforms, ensuring all platform-attributed conversions are captured within each refresh cycle.
Platforms covered
Facebook Ads, Google Ads, Amazon (Sponsored Products, Sponsored Display, Sponsored Brands), TikTok, Pinterest, Snapchat, Bing, AppLovin, Criteo, Criteo Retail, Pepperjam, and marketplace channels including Kohls, Wayfair, Target, and Walmart.
What to expect
You may see slight adjustments in Vendor Performance metrics during the transition as the new incremental approach takes effect. This is expected. No action is required — the update rolls out automatically.