Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
This is an old revision of the document!
To model net revenue attribution and CLV attribution with your Shopify data follow these instructions:
https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_90d&fields=order_id,order_current_total_price,order_email,order_updated_at,order_name,date,order_tags
Destination table name: shopify_orders
Schedule: 12h
Click Add New
https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_90d&fields=customer_id,date,customer_email,customer_total_spent
Destination table name: shopify_customers
Schedule: 12h
Click Add New
BEGIN; TRUNCATE TABLE crm_conversions; INSERT INTO crm_conversions(net_revenue,transaction_id,crm_type) SELECT sum(customers.customer_total_spent::REAL) AS net_revenue, orders.order_name as transaction_id, 'shopify - net revenue' AS crm_type FROM shopify_customers AS customers LEFT JOIN shopify_orders AS orders ON orders.order_email = customers.customer_email GROUP BY 2,3; COMMIT;