Never miss an update of the Adobe Journey Optimizer Community Lens! Subscribe now to get the latest updates, insights, and highlights delivered straight to your inbox every time a new edition drops.
You can use SQL joins to combine data from different sources, such as CRM data, website interaction data, and purchase history, to create a unified customer profile for more personalized journeys.
Example Join Query:
sql
Copy code
SELECT c.customer_id, c.first_name, c.last_name, o.order_id, o.order_date, o.order_total FROM customers c JOIN orders o ON c.customer_id = o.customer_id WHERE o.order_date >CURRENT_DATE-INTERVAL'90'DAY;
