SELECT DATE(created_at) AS date, COUNT(*) AS abandoned_carts FROM klaviyo_data WHERE event = ‘Abandoned Cart’ GROUP BY DATE(created_at) ORDER BY DATE(created_at) ASC;