Released: May 27, 2025
Overview
Issue:
Klaviyo UNS tables were experiencing duplicate records due to both the "Klaviyo_v2" and "Klaviyo Summary Statistics" integrations sharing the same source_id in the platform.account_integrations table.Solution:
We updated our SQL JOIN logic to explicitly reference the integration source name, ensuring accurate data alignment and eliminating duplicates:INNER JOIN platform.account_integrations ai
ON p.__source_id = ai.source_id
AND ai.source = 'klaviyorevision'
Support
For any questions or further issues, please reach out via support or comment below.