Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

==== Shopify CLV Attribution ====

To model net revenue attribution and CLV attribution with your Shopify data follow these instructions:

  - Connect your Shopify, Google Analytics and media connectors on https://onboard.windsor.ai
  - On 2. Data Destinations select Windsor.ai Cloud database and create two tables
    - shopify_orders \\ Connector URL: <code> 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 </code> \\ Destination table name: shopify_orders \\ Schedule: 12h \\ Click Add New
    - shopify_customers \\ Connector URL: <code> https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_90d&fields=customer_id,date,customer_email,customer_total_spent</code> \\ Destination table name: shopify_customers \\ Schedule: 12h \\ Click Add New
  - Head to [[https://charts.windsor.ai/w/sqllab|SQL Lab]] and run the following statement \\ <code>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,
		REPLACE(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;</code>

Knowledge Base

User Tools

Site Tools

Page Tools