User Tools

Site Tools


shopify_clv_attribution

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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::REAL) AS net_revenue,  sum(customers.customer_total_spent::REAL) AS net_revenue,
- orders.order_name as transaction_id,+ REPLACE(orders.order_name,'#',''as transaction_id,
  'shopify - net revenue' AS crm_type  'shopify - net revenue' AS crm_type
  FROM shopify_customers AS customers  FROM shopify_customers AS customers
shopify_clv_attribution.1632405698.txt.gz ยท Last modified: 2021/09/23 15:01 by windsor_ai