E-commerce & Retail Analytics Path · Mission 19 of 30Hard

GA4 conversion-value vs Shopify revenue

Date-anchored multi-system join — match GA4 sessions to Shopify orders by (customer_id, date). Surface every converted GA4 session whose conversion_value drifts from the matching Shopify order total_price. The canonical 'GA4 enhanced ecom doesn't tie out' question.

The Brief

You'll practice

Multi-CTEReconciliationTracking gap