This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
shopify_clv_attribution [2021/09/23 15:01] windsor_ai |
shopify_clv_attribution [2021/09/29 14:46] (current) windsor_ai |
||
---|---|---|---|
Line 12: | Line 12: | ||
SELECT | SELECT | ||
sum(customers.customer_total_spent:: | sum(customers.customer_total_spent:: | ||
- | orders.order_name as transaction_id, | + | REPLACE(orders.order_name,'#','' |
' | ' | ||
FROM shopify_customers AS customers | FROM shopify_customers AS customers |