Overview
Two base scripts were producing duplicate records on each refresh, affecting reporting accuracy. The first fix applies to BigQuery merchants using GA4 data. The second applies to all Snowflake and Redshift merchants, as well as BigQuery merchants with the Retail workflow enabled.
Issue
The GA4 shopping stage script had outdated logic that no longer matched its Snowflake/Redshift counterpart, generating duplicate rows on every refresh. Separately, the Omni time period mappings script had an incorrect configuration that caused records to multiply across daily refreshes on both BigQuery and Snowflake/Redshift.
Solution
The GA4 shopping stage script has been corrected to align with the current Snowflake/Redshift logic. The Omni time period mappings scripts have been corrected on both BigQuery and Snowflake/Redshift to eliminate the duplicate records.
What to expect
You may see slight adjustments in reports referencing GA4 shopping data or time period mappings as duplicates are removed — this is expected and reflects accurate data. BigQuery merchants may also see modest efficiency improvements in their workflow runs. No action is required — the update applies automatically.